Job Description
We are seeking a highly skilled Mid - to Senior SQL Server DBA/Developer. This is a hands-on, technical role responsible for administering, optimizing, modernizing, and supporting mission-critical SQL Server environments for a federal civilian agency in the Washington D.C. area. The ideal candidate has deep expertise in SQL Server internals, strong T-SQL development skills, takes ownership of work, collaborates effectively across teams, and thrives in a high-performance, data-driven environment.
Salary range: $109K - $129K
Key Responsibilities
- Database Administration & Operations
- Install, configure, patch, and upgrade SQL Server instances (2016, 2019, 2022)
- Manage Development, QA, Staging, and Production environments
- Configure and support Windows Server Failover Clustering (WSFC)
- Implement and maintain backup/recovery strategies and disaster recovery testing
- Create and maintain SQL Server Agent Jobs, Maintenance Plans, and Windows Task Scheduler jobs
- Configure and test Database Mail (DBMail)
- Monitor and optimize system health using DMVs, Extended Events, SQL Trace, Query Store, and wait statistics
- Performance Tuning & SQL Server Internals
- Perform advanced performance tuning, indexing strategy design, and execution plan analysis
- Deep understanding of SQL Server engine internals including MAXDOP, cardinality estimator behavior, compatibility levels, memory and tempdb configuration
- Identify and resolve blocking, deadlocks, parameter sniffing, and other performance bottlenecks
- Use diagnostic tools such as sp_whoisactive, Idera, and Plan Explorer
- T-SQL Development & Code Quality
- Design, develop, and optimize advanced T-SQL (stored procedures, functions, triggers, views)
- Peer-review SQL code and enforce development best practices
- Refactor existing stored procedures for performance and maintainability
- Identify and fix database code bugs; implement workarounds when necessary
- Troubleshoot application-related data issues and collaborate with software developers to resolve defects
- Data Integration, Automation & Modernization
- Design and maintain SSIS packages and SSRS reports
- Import and export data across diverse source and destination systems
- Automate tasks using T-SQL, PowerShell, CMD, batch scripting, and dbatools
- Participate in SQL Server upgrades and modernization initiatives
- Support Infrastructure-as-Code and DevOps collaboration practices
- Required Qualifications
- 7+ years of hands-on SQL Server DBA and development experience in production environments
- Strong expertise in HA/DR, Always On, and Failover Clustering
- Advanced T-SQL coding, troubleshooting, and performance tuning skills
- Extensive experience with SSIS and SSRS
- Experience creating SQL Agent Jobs, Maintenance Plans, Task Scheduler jobs, and DBMail configuration
- Strong knowledge of SQL Trace, Extended Events, DMVs, and system tables
- Experience with PowerShell, CMD, and batch scripting
- Experience patching and upgrading SQL Server instances
- Strong understanding of database security, encryption, masking, and access control
- Hands-on experience with Azure SQL and/or cloud-based database environments
- Working knowledge of Python for automation and data-related tasks is highly desirable
- Core Competencies
- Excellent verbal and written communication skills
- Strong critical thinking and analytical problem-solving abilities
- Detail-oriented with strong documentation discipline
- Ability to work independently and collaboratively across cross-functional teams
- Accountable, proactive, and committed to continuous improvement
- Not Required, but Strongly Preferred:
- Current Public Trust Clearance
- Previous experience in Federal space
Apply tot his job
Apply To this Job