Senior Microsoft Windows SQL Server DBA
On-siteCairo, Cairo, Egypt
Job Summary
Architect, install, and maintain Microsoft SQL Server instances across complex Windows environments while leading end-to-end application performance engineering through execution plan analysis and query optimization. Proactively monitor system health using Extended Events and DMVs, design robust backup/recovery strategies, and manage High-Availability solutions including Always On Availability Groups. Govern database security, oversee capacity planning, and drive automation of routine tasks via PowerShell and SQL Agent. Serve as the primary escalation point in the on-call rotation for critical incidents and mentor junior DBAs. Requires 7+ years of hands-on SQL Server experience with advanced T-SQL skills.
Required Qualifications
- 7+ years of hands-on SQL Server DBA experience in large-scale, mission-critical production environments
- Expert-level proficiency with Microsoft SQL Server 2019 / 2025 on Windows Server 2019 / 2022
- Advanced T-SQL skills: query optimization, execution plan analysis, index design, partitioning, and performance troubleshooting
- Deep expertise in application performance tuning: collaborating with developers to resolve ORM anti-patterns, N+1 queries, lock contention, and blocking chains
- Proven experience architecting and supporting Always On Availability Groups, WSFC, and DR failover in enterprise environments
- Strong command of Wait Statistics, DMVs, Extended Events, and Query Store for root-cause performance diagnosis
- Solid experience with point in time database restores, High-Availability failover, disaster recovery planning, and hands-on recovery testing
- Windows Server administration and Active Directory / Kerberos authentication for SQL Server
- Demonstrated ability to lead technical projects and mentor junior team members
- Familiarity with ITIL change, incident, and problem management processes
Desired Qualifications
- Microsoft certification: DP-300 (Azure Database Administrator Associate) or legacy MCSE Data Management & Analytics
- Experience with Azure SQL Database or SQL Server on Azure VMs in hybrid configurations
- Exposure to APM tooling (e.g. Dynatrace, AppDynamics, New Relic) and correlating application traces with database-level diagnostics
- Proficiency with Redgate SQL Monitor, SolarWinds DPA, SentryOne, or equivalent database monitoring platforms
- PowerShell scripting for DBA automation, including use of dbatools
- Experience with SSIS in a data warehousing or reporting context
- Knowledge of data governance and compliance frameworks such as GDPR, ISO 27001, or SOC 2
- Exposure to DevOps CI/CD pipelines with database deployments (e.g. Flyway, Liquibase, or Redgate Deployment Manager)
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.