SQL DBA

Key Responsibilities

• Install, configure, administer, and maintain Microsoft SQL Server databases across Production and non-Production environments.
  
• Monitor database health, performance, availability, and capacity to ensure optimal system reliability.
  
• Perform database performance tuning, query optimization, index management, and troubleshooting of production issues.
  
• Manage High Availability (HA) and Disaster Recovery (DR) solutions, including Always On Availability Groups, Transactional Replication, Log Shipping, and Backup & Recovery.
  
• Plan and execute SQL Server upgrades, migrations, patching, and maintenance activities with minimal downtime.
  
• Collaborate with development teams to optimize database design, SQL queries, and application performance.
  
• Automate routine DBA activities using T-SQL and PowerShell to improve operational efficiency.
  
• Implement database security, manage user access, and maintain operational documentation and standards.
  
• Participate in production incident management, Root Cause Analysis (RCA), and a on-call rotational to provide 24x7 support for business-critical production systems.
  

• 5–8 years of hands-on experience in Microsoft SQL Server Database Administration supporting large production environments.
  
• Strong experience with SQL Server 2016/2019/2022 administration, installation, configuration, upgrades, and migrations.
  
• Hands-on experience managing large OLTP databases (5 TB+ preferred) with expertise in performance tuning, query optimization, execution plan analysis, indexing, and statistics.
  
• Strong knowledge of High Availability (HA) and Disaster Recovery (DR) technologies, including Always On Availability Groups, Transactional Replication, Log Shipping, and Backup & Recovery.
  
• Good understanding of SQL Server internals, including storage engine, query optimizer, locking, blocking, transactions, indexing, partitioning, and data compression.
  
• Experience monitoring and troubleshooting CPU, memory, I/O, TempDB, blocking, deadlocks, and other production performance issues.
  
• Proficiency in T-SQL, SQL Server Agent, Extended Events, Query Store, DMVs, and PowerShell scripting for database administration and automation.
  
• Experience implementing SQL Server security, including logins, permissions, roles, auditing, and encryption.
  
• Exposure to enterprise monitoring tools (SQL Sentry, Redgate SQL Monitor, Grafana, SolarWinds, etc.) and cloud platforms such as AWS RDS or Azure SQL is an added advantage.
  
• Experience with PostgreSQL database administration is an added advantage.
  
• Strong analytical, troubleshooting, communication, and documentation skills with the ability to support business-critical 24x7 production systems.