The National Renewable Energy Laboratory (NREL), located in beautiful Golden, Colorado, is a leader in the U.S. Department of Energy's effort to secure an energy future for the nation that is environmentally and economically sustainable.
Senior SQL Server Database Administrator
Job Req R2956
NREL is currently seeking a Senior Database Administrator. This candidate will have full life cycle responsibilities for SQL Server and other database technologies that are used to support the laboratory's operations and mission processes.
Analyzes and responds to a variety of complex issues that require in-depth theoretical, technical and functional knowledge. Evaluates and configure complex application system components and the supporting database and operating system functions.
Participates in both daily and off-hours administration and support, monitoring database system performance, and assisting with critical or emergency failures as a primary technical subject matter expert.
Concentrated efforts towards query and system performance tuning, data backups & recovery, index support, table creation, and stored procedure maintenance.
Responsible for updates, patches, service packs, cumulative updates, hot fixes, continuity plans and on-going maintenance for databases, application servers and third-party software packages.
Contributes to production support and project teams and provides clear and updated project task status to stakeholders, management and team members.
Contributes to design and architecture of platform and functional solutions, change and release processes, developer support, and security and compliance auditing.
Understands business requirements and determines database and configuration requirements for implementing applications using industry standard best practices.
Functions as primary liaison for SQL Server Microsoft support and related third party vendor support.
Responsible for change and release management for code and configuration deployments (both custom/in house developed and third party).
Contributes to the design, implementation, and continuous improvement of DBA and Information Technology processes and standards that meet compliance, quality assurance, and auditing needs.
Frequently is a liaison between vendors, developers, clients, infrastructure engineers and management. Enhances customer service and relationships between clients, management, and technical staff.
Maintains a high level of understanding of the Laboratory's application environments and technical infrastructure.
Maintains data integrity and security (manage roles and permissions of database users).
Evaluates new hardware, software, systems tools and applications.
EEO Policy / E-Verify
NREL's policy is to provide equal employment opportunities to all qualified persons without regard to race, age, color, sex, religion, national origin, marital or veteran status, or any other legally protected status.
NREL validates right to work using E-Verify. NREL will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee's Form I-9 to confirm work authorization. For additional information, please click here https://www.nrel.gov/careers/employment-policies.html.
Pre-employment drug testing required.
Submit Your Resume
Please apply online at: www.nrel.gov/careers and search for Req R2956
Please note that in order to be considered an applicant for any position at NREL you must submit an application form for each position for which you believe you are qualified. Applications are not kept on file for future positions. Please include a cover letter and resume with each position application.
Technical resource with extremely strong Microsoft SQL Server Architecture / DBA / programming skills. Preferably 10 years or more experience in designing SQL Server based application architectures. 2008 through current version.
Knowledge of SQL Server Tools (Profiler, Query Analyzer, SSRS, SSAS, etc.)
Skilled in backups & disaster recovery.
Proficient in Powershell scripting.
Excellent analytical and problem-solving skills, anticipates issues and deals with them proactively (Critical Thinking).
Security compliance and requirements for moderate level financial and business data, including HIPPA, encryption keys and support for content and transport encryption using SSL, SSH, PGP, SFTP, and other related tools.
In-depth administration knowledge of operating systems and system support functions on a cross platform environment including Linux and Microsoft Windows Server, shell scripting and automation.
Administration, deployment, and support of client and server side installations, including security, patching, and integration testing.
Experience utilizing source code change control tools such as subversion/GIT and knowledge of best practices of software configuration and schema change management.
Strong experience working with third party support infrastructure and working issues through third party technical support organization.
Required Education, Experience, and Skills
Relevant Bachelor's Degree and 14 or more years of experience or equivalent relevant education/experience. Or, relevant Master's Degree and 12 or more years of experience or equivalent relevant education/experience. Or, relevant PhD and 9 or more years of experience or equivalent relevant education/experience. Applies extensive IS expertise and has full knowledge of related disciplines. Contributes to the development of new principles and concepts. Superior leadership and project management skills. Skilled in analytical techniques, practices and problem solving. Extensive architecture and design for various computer software programs and information systems.
Knowledge of PostgreSQL, Aurora, Vertica, Mongo and/or SQL.
Microsoft SQL Server and Reporting Server Administration and support.
Knowledge of SharePoint and Project Server Farm System Services including Service Application configuration, support Health Monitoring, Diagnostic Logging, ULS logs analysis, User Profile Service Application and User Profile management, and synchronization with the AD/Exchange.
Knowledge of other databases like MySQL, No SQL databases and In-memory databases and MCTIP certification will be an advantage.
Experience working in an environment with Informatica and/or API architecture and related data formats (XML/XML tables, JSON, REST, and other transformations).
ETL and database migration experience.
Familiarity with unstructured data management solutions (Document Management, Mongo, Cassandra, etc.).