Sr. SQL Database Administrator

West 4th Strategy; Washington; Hybrid; USD 115,000 - 125,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

401k matching

Job summary

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.

Qualifications

• 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

Responsibilities

• 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.

Skills

SQL Server administration

Performance tuning

Backup and recovery

High availability

Security/compliance

Education

Bachelor's degree in Computer Science/Engineering

Tools

Microsoft SQL Server

Azure SQL Managed Instance

Always On Availability Groups

Job description

Sr. SQL Database Administrator

ROLE

We need an experienced Senior SQL Database Administrator to support a contract with the United States Capitol Police’s (USCP) Enterprise Applications Management Division (EAMD) where the design, building, and maintenance of mission critical applications that support that law enforcement mission reside. In this role, you will manage and support SQL Server databases to ensure reliability, performance, and security, perform installation, configuration, backup and recovery, and performance tuning, and work with project teams to meet database requirements. This is a full‑time opportunity. We can offer a competitive salary, and a comprehensive benefits package.

RESPONSIBILITIES

• 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 USCP 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 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 the 4-week transition and knowledge-transfer overlap with incumbent staff, including shadowing and review of existing documentation and procedures.
• Provide off-hours and weekend support for scheduled deployments and USCP special events (e.g., Presidential Inauguration, State of the Union) with advance notice.
• Contribute accomplishments, issues and planned work to the monthly progress report delivered to the COR.
• Protect sensitive USCP, House and Senate information and follow USCP standards of conduct, IT policies and badge requirements.

BACKGROUND/REQUIRED EXPERIENCE

• 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

DESIRED SKILLS / EXPERIENCE

• Microsoft SQL Server certification
• Azure SQL Managed Instance experience
• Experience in a federal or law enforcement environment

LOCATION

• Washington, DC – USCP Facility
• Hybrid - 100% on-site for first 2 months, then 2 days on-site / 3 days telework (USCP may increase on-site days)

CLEARANCE

• Must be a US Citizen
• Ability to pass a USCP criminal history check and fingerprinting for badge access.

CLIENT

• United States Capitol Police (USCP), Enterprise Applications Management Division (EAMD)

HOURS

• 40 hours per week
• 8 hours per day

EMPLOYMENT CLASSIFICATION

• Employment Classification Eligibility – W2

RELOCATION

• Not eligible for relocation benefits

COMPENSATION

• Salary range: $115,000 - $125,000
• Benefits: Benefits package includes options for health, dental, and vision insurance coverage; 401k contribution options. Full benefits brochure available for review.

West 4th Strategy is an Equal Opportunity (EEO) employer. All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, gender, sexual orientation, ancestry, national origin, age, marital status, mental disability, physical disability, medical condition, pregnancy, political affiliation, military or veteran status, or any other basis prohibited by federal or state law.

Other Considerations:

This position is W-2 only; no Corp-to-Corp or 1099 candidates.Relocation will not be offered. This position requires access to Department of Justice facilities and systems. As a condition of employment, selected candidates must complete and receive favorable adjudication from a federal government background investigation as required by the U.S. Department of Justice. Individual’s primary workstation is located in an office area. The noise level in this environment is low to moderate. Regularly required to sit for extended periods up to 80% of the time; frequently required to move about to access file cabinets and use office equipment such as PC, copier, fax, telephone, cell phone, etc. Occasionally required to reach overhead, bend, and lift objects of up to 10 lbs. Specific vision abilities required by this job include the use of computer monitor screens up to 80% of the time.