SQL Server Database Administrator
Job Description
Key Skills Required
Master these to land this role
Want to know if you're a match for this job?
We are seeking an experienced and highly skilled SQL Server Database Administrator to manage, optimize, and secure enterprise SQL Server environments. This role requires strong hands-on expertise in performance tuning, high availability and disaster recovery (HA/DR), automation, Azure SQL platforms, and production support.
Key Responsibilities
- Manage and support SQL Server environments (2012–2022) across production and non-production systems
- Perform advanced performance tuning using execution plans, Query Store, DMVs, and wait statistics
- Troubleshoot complex database issues including locking, blocking, deadlocks, memory grants, TempDB, and I/O bottlenecks
- Design and maintain robust backup and recovery strategies, including point-in-time recovery and disaster recovery drills
- Implement and support HA/DR solutions (Always On Availability Groups, Failover Clusters, Log Shipping, Replication, CDC)
- Execute SQL Server upgrades, patching, and version migrations with minimal downtime
- Implement and maintain SQL Server security features including TDE, encryption, auditing, and role-based access control
- Automate routine maintenance and monitoring tasks using T-SQL, SQL Agent, and PowerShell
- Support Azure SQL workloads (Azure SQL Database, Managed Instance, SQL on Azure VM)
- Drive incident resolution, root cause analysis (RCA), and long-term preventive improvements
- Collaborate with development, infrastructure, and security teams for controlled production deployments and CI/CD initiatives
- Focus on proactive monitoring, capacity planning, and regular performance health checks
Requirements
- 7+ years of hands-on SQL Server DBA experience in production environments
- Strong expertise in SQL Server architecture and internals (Buffer Pool, Plan Cache, Transaction Log, TempDB)
- Advanced query and server-level performance tuning skills
- Deep understanding of Always On AGs, FCI, Replication, CDC, and Log Shipping
- Strong experience with backup, restore, and disaster recovery scenarios
- Solid knowledge of SQL Server security and compliance controls
- Experience with automation and scripting (T-SQL, PowerShell)
- Working knowledge of Azure SQL and monitoring tools
- Bachelor’s degree in Computer Science, IT, or related field (or equivalent experience)
- Strong troubleshooting ability, communication skills, and ownership mindset
How would you rate this job post?
See what other professionals think about this role.
Similar Opportunities
More Openings at ProArch
Explore Top Companies in this Space
Twilio
Cloud Communications
Cobalt Service Partners
Business Services
Zscaler
Cloud Security
Rubrik
Cloud Data Management
ProArch
View Company ProfileProArch is a global technology consulting firm dedicated to helping businesses modernize their operations and accelerate growth. Specializing in Data & AI, Cloud & Infrastructure, Cybersecurity, and Custom Software Development, ProArch empowers organizations to undergo successful digital transformation. As a long-standing Microsoft Solutions Partner, they possess deep expertise in leveraging the Microsoft ecosystem (Azure, Microsoft 365) to drive business value. They go beyond traditional IT support by acting as strategic advisors, ensuring that technology investments directly contribute to scalable and secure business outcomes.
Safety First
- Never pay for a job application.
- Do not share sensitive bank info.
- Verify the client before starting work.