Senior Database Administrator
On-siteCarmel, Indiana, United States
Job Summary
Deploy and configure SQL Server instances across clustered, standalone, and Azure environments while monitoring health, analyzing query execution plans, and optimizing indexes for OLTP and analytical workloads. Write, review, and optimize complex T-SQL scripts, manage backup strategies and restore tests, and implement high availability solutions including Always On Availability Groups and failover clustering. Enforce security standards, maintain runbooks, and provide 24/7 on-call support for critical production systems. Lead cloud modernization initiatives by consolidating legacy instances, evaluating workloads for Azure Synapse and Microsoft Fabric, and standardizing alerting and disaster recovery plans. Partner with data engineering and BI teams to drive infrastructure-as-code adoption and knowledge transfer.
Required Qualifications
- Bachelor's degree in Computer Science, Information Systems, or a related field preferred; equivalent hands-on experience will be considered in lieu of a degree
- 8 years of experience as a SQL Server DBA in enterprise environments
- Expert-level T-SQL skills for query development, optimization, and troubleshooting
- Experience with monitoring tools and dashboards for observing database health, query performance, and resource utilization
- Proven ability to upgrade and migrate legacy SQL Server versions (2012/2016) to currently supported releases
- Hands-on expertise in HA/DR, performance tuning, and security hardening
- Strong knowledge of patching, upgrades, and lifecycle management
- Working knowledge of Azure SQL and Azure Synapse Analytics
- Experience with incident and alerting platforms (PagerDuty, Opsgenie, or similar)
- Proven ability to lead cross-functional projects and communicate effectively with both technical and non-technical stakeholders
- Travel up to 5% of the time, primarily for offsite visits
Desired Qualifications
- Multi-engine exposure: Hands-on experience with Amazon DynamoDB (data modeling, capacity/throughput management, application integration) and/or PostgreSQL or other relational/NoSQL platforms in production
- Automation and DevOps: Experience with infrastructure-as-code and configuration management using Ansible and Terraform (PowerShell, SSIS, dbatools, CI/CD for databases)
- Synapse MPP: Experience including distribution strategy, partitioning, and workload management
- Microsoft Fabric: Administration and row-level security implementation
- Monitoring platforms: Datadog alerting and dashboarding familiarity
- Governance: Microsoft Purview or comparable data governance experience
- Compliance: Knowledge of compliance frameworks and audit-readiness practices
- Multi-engine exposure: Hands-on experience with Amazon DynamoDB (data modeling, capacity/throughput management, application integration) and/or PostgreSQL or other relational/NoSQL platforms in production
- Automation and DevOps: Experience with infrastructure-as-code and configuration management using Ansible and Terraform (PowerShell, SSIS, dbatools, CI/CD for databases)
- Synapse MPP: Experience including distribution strategy, partitioning, and workload management
- Microsoft Fabric: Administration and row-level security implementation
- Monitoring platforms: Datadog alerting and dashboarding familiarity
- Governance: Microsoft Purview or comparable data governance experience
- Compliance: Knowledge of compliance frameworks and audit-readiness practices
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.