Mind Over Machines

Mid-Senior SQL Server DBA/Developer

Mind Over Machines

full-time

Posted on:

Location Type: Office

Location: Washington D.C. • District of Columbia • Washington • United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AzureCloudPythonSQLSSIS

About the role

  • 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 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQL ServerT-SQLSSISSSRSPowerShellCMDbatch scriptingHA/DRAlways OnFailover Clustering