Senior SQL DBA – Enterprise Data & HA (Hybrid)

West 4th Strategy; Washington (District of Columbia); Hybrid; USD 115.000 - 125.000; Vollzeit

Benefits dieser Stelle

Health insurance

401k

Zusammenfassung

West 4th Strategy seeks a Senior SQL Database Administrator to manage and optimize mission-critical SQL Server databases for the US Capitol Police environment. You will oversee installation, configuration, backup and recovery, performance tuning, and security in a hybrid on-site setting.

The role requires strong experience with Always On, disaster recovery, and integration with Azure SQL Managed Instance, plus collaboration with project teams to meet database requirements.

Qualifikationen

• 7+ years of database administration experience.
• 5+ years with SQL Server in enterprise production environments.
• Bachelor's degree in Computer Science, Computer Engineering, or a related technical discipline.

Aufgaben

• Administer, maintain and support enterprise SQL Server databases across development, test and production environments.
• Install, configure, upgrade and patch SQL Server instances in line with change-management procedures.
• Design, implement and test backup, recovery and disaster recovery strategies; perform restore validation.
• Configure and support high-availability solutions such as Always On Availability Groups and failover clustering.
• Monitor database health, capacity and performance; tune queries, indexes and server settings to resolve bottlenecks.
• Manage database security: logins, roles, permissions, encryption and auditing aligned with federal security requirements.
• Review and deploy database changes and scripts from development teams; advise developers on schema design and T‑SQL best practices.
• Support SSIS/SSRS workloads, scheduled jobs and data integrations; troubleshoot failures and data issues.
• Support migration and integration with Azure SQL Managed Instance as the environment evolves.
• Maintain database documentation, configuration baselines and standard operating procedures; provide limited cross‑training.
• Participate in transition period and knowledge transfer with incumbent staff; shadowing and review of documents.

Kenntnisse

7+ years database administration

5+ years SQL Server in enterprise

Backup, recovery & HA design

Ausbildung

Bachelor's degree in Computer Science, Computer Engineering, or related technical discipline

Tools

Microsoft SQL Server certification

Azure SQL Managed Instance

Jobbeschreibung

West 4th Strategy seeks a Senior SQL Database Administrator to manage and optimize mission-critical SQL Server databases for the US Capitol Police environment. You will oversee installation, configuration, backup and recovery, performance tuning, and security in a hybrid on-site setting.

The role requires strong experience with Always On, disaster recovery, and integration with Azure SQL Managed Instance, plus collaboration with project teams to meet database requirements.