What are the responsibilities and job description for the Sr. SQL Database Administrator position at West 4th Strategy?
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.
Apply today!
RESPONSIBILITIES
BACKGROUND/REQUIRED EXPERIENCE
DESIRED SKILLS / EXPERIENCE
LOCATION
CLEARANCE
CLIENT
HOURS
EMPLOYMENT CLASSIFICATION
RELOCATION
COMPENSATION
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.
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.
Apply today!
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.
Salary : $115,000 - $125,000