SQL Server DBA (Subject Matter Expert)

• Install, configure, and maintain Microsoft SQL Server instances across environments
• Manage database backups, restores, and disaster recovery strategies
• Monitor database health, performance, and uptime
• Perform patching, upgrades, and migrations with minimal downtime, * Analyze and optimize slow queries, indexing strategies, and execution plans
• Implement performance tuning best practices across databases
• Troubleshoot and resolve blocking, deadlocks, and resource contention issues
• Ensure optimal CPU, memory, and storage utilization, * Develop and maintain automation scripts using T-SQL, PowerShell
• Automate routine DBA tasks such as backups, monitoring, and deployments
• Improve operational efficiency through standardization and automation, * Work closely with developers to optimize database design and queries
• Provide guidance on schema design, indexing, and query optimization
• Conduct code and database reviews
• Mentor junior DBAs and support teams

We are seeking a highly experienced SQL Server DBA (Subject Matter Expert) to manage, optimize, and support mission-critical database environments. The ideal candidate will have deep expertise in SQL Server architecture, performance tuning, high availability, and database security, along with strong problem-solving and leadership skills., Core Database Skills

• Strong expertise in Microsoft SQL Server (2016/2019/2022)
• Advanced knowledge of T-SQL, stored procedures, triggers, and functions
• Strong experience in database design and normalization

Performance & Troubleshooting

• Deep expertise in query tuning, indexing, and execution plans
• Experience with SQL Profiler, Extended Events, and DMVs
• Strong troubleshooting skills for performance bottlenecks

High Availability & DR

• Hands-on experience with:

• Always On Availability Groups
• Failover Clustering
• Backup/Restore strategies

Tools & Monitoring

• Experience with tools like SQL Server Management Studio (SSMS), Redgate, SolarWinds, or SentryOne
• Experience in database monitoring and alerting systems

Scripting & Automation

• Proficiency in PowerShell and T-SQL scripting, * Experience with Azure SQL / AWS RDS for SQL Server
• Knowledge of DevOps practices and CI/CD pipelines
• Exposure to NoSQL databases
• Experience with data warehousing, SSIS, SSRS, SSAS
• Familiarity with containerization (Docker/Kubernetes), * Strong analytical and problem-solving skills
• Excellent communication and stakeholder management
• Ability to handle production-critical environments under pressure
• Experience in mentoring and leading teams
• Strong focus on performance, reliability, and security
• Proven track record of ensuring high availability and zero data loss