Onsite Mid-Senior SQL Server DBA/Developer

Posted 4 hours ago

Apply now

About the role

  • Mid to Senior SQL Server DBA/Developer for federal civilian agency in Washington D.C. area. Hands-on role optimizing and supporting critical SQL Server environments.

Responsibilities

  • Administering, optimizing, modernizing, and supporting mission-critical SQL Server environments
  • Install, configure, patch, and upgrade SQL Server instances
  • 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
  • Perform advanced performance tuning, indexing strategy design, and execution plan analysis
  • Identify and resolve blocking, deadlocks, parameter sniffing, and other performance bottlenecks
  • Design, develop, and optimize advanced T-SQL (stored procedures, functions, triggers, views)
  • Peer-review SQL code and enforce development best practices
  • Design and maintain SSIS packages and SSRS reports
  • Automate tasks using T-SQL, PowerShell, CMD, batch scripting, and dbatools
  • Support Infrastructure-as-Code and DevOps collaboration practices

Requirements

  • 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

Benefits

  • WFH Flexible

Job title

Mid-Senior SQL Server DBA/Developer

Job type

Experience level

Senior

Salary

Not specified

Degree requirement

Bachelor's Degree

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job