Senior SQL Server DBA

Must be available for in person meetings in Bethesda, MD

Core Hours M-F 7 am - 6 PM EST also some on-call support during non-core hours The Senior SQL Server DBA will manage on-site and remote support for on-prem and cloud database development and maintenance. Support is required to ensure the availability, security, currency, and recoverability of NICHD's Oracle, SQL Server, and MySQL databases. In addition, support is required to develop end-user reports from NICHD and NIH systems.

Key Responsibilities:

Maintain the Production, Test, and Development databases that support the Institute's various applications deployed in both on-prem and cloud environments.

Provide administrative support for SQL Server databases, MySQL databases, and SQL Server Reporting environment.

Ensure that the NICHD user base can access the data residing in the IT systems.

Is responsible for nightly and monthly maintenance on the database servers including evaluating current patches and follow-on patching of database software and security updates, maintaining standby databases, and performing routine maintenance tasks.

Work with other teams for database related support such as refresh data in test, recover data from a table, production release support, set up the communication between COTS & databases, SQL Server & Oracle, resolve system vulnerabilities, etc.

Provide performance tuning.

Conduct database backup and recovery including Oracle export/import, RMAN backup, Cohesity backup, etc.

Maintain accounts, roles, and privileges.

Install, configure, and upgrade database servers.

Check the health of all databases and servers daily including SQL server and MySQL

Execute DDL and DML when needed.

Perform troubleshooting.

Provide database administration and data mart support on prem and in Azure cloud.

uthor and maintain Standard Operating Procedures that provide a framework for planning and performing the maintenance on NICHD's database and report servers.

dd fields/tables to the Datamart as required by applications or report users, to both active and archive, then update new field(s) in archive as necessary.

Keep documentation current for all changes.

Create views of Datamart data to simplify data access by end users and/or developers building Power BI and Qlik Sense reports.

Monitor downloads (and address issues if needed) daily to ensure the data is always up to date.

Evaluate and implement new databases based on business needs.

Write stored procedures, SQL, T SQL for Oracle, SQL Server, and/or MySQL.

Retrieve data from federal enterprise data warehouses. Qualifications

5+ years of experience in conducting SQL Server database administration

Extensive experience in administering SQL Server database in standalone and clustered architecture on Windows on premise and in cloud environments.

Extensive experience in SQL Server backup/recovery, configure failover cluster, setup jobs and monitoring

Strong T SQL, performance tuning, and troubleshooting skills

Experience with SQL Server reporting services, integration services, and analysis services.

Experiences with SQL Server 2016/2019/2022, SQL Server on Windows, and MySQL on Ubuntu are preferred Required Certification Microsoft Certified: Azure Database Administrator Associate