Senior SQL DBA Hybrid (DC) for Federal Enterprise

West 4th Strategy; Washington; Hybrid; USD 115.000 - 125.000; Vollzeit

Benefits dieser Stelle

Health insurance

Dental insurance

Vision insurance

401k matching

Zusammenfassung

West 4th Strategy seeks a Senior SQL Database Administrator to support the US Capitol Police’s Enterprise Applications Management Division. You will manage enterprise SQL Server databases to ensure reliability, security and performance across development, test and production environments.

Responsibilities include backup and recovery, patching, high availability (Always On), query tuning, and collaboration with project teams.

Qualifikationen

• 7+ years of database administration experience required.
• 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 per change-management procedures.
• Design, implement and test backup, recovery and disaster recovery strategies; perform regular 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 per federal requirements.
• Review and deploy database changes and scripts from development teams; advise 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 and SOPs; provide limited cross-training.

Kenntnisse

SQL Server administration

Performance tuning

Backup and recovery

High availability

Security/compliance

Ausbildung

Bachelor's degree in Computer Science/Engineering

Tools

Microsoft SQL Server

Azure SQL Managed Instance

Always On Availability Groups

Jobbeschreibung

West 4th Strategy seeks a Senior SQL Database Administrator to support the US Capitol Police’s Enterprise Applications Management Division. You will manage enterprise SQL Server databases to ensure reliability, security and performance across development, test and production environments.

Responsibilities include backup and recovery, patching, high availability (Always On), query tuning, and collaboration with project teams.