MS SQL Database Administrator (DBA)

Job Summary Key Roles Responsibilities Database Administration

• Administer and manage Microsoft SQL Server databases across development, test, staging, and production environments.
• Perform database installation, configuration, maintenance, patching, and ongoing administration.
• Manage SQL Server environments throughout the complete database product lifecycle.
• Monitor database health, availability, capacity, and overall system performance.
• Ensure databases meet organizational standards for reliability, security, and performance.

Performance Tuning Optimization

• Perform SQL Server Performance Tuning and Optimization (PTO).
• Identify and resolve database performance bottlenecks involving queries, indexes, CPU, memory, I/O, and database configuration.
• Analyze execution plans and optimize complex SQL queries, stored procedures, and database objects.
• Use native SQL Server monitoring and troubleshooting tools to proactively identify performance issues.
• Establish and maintain performance-monitoring processes and best practices.

Backup, Recovery Data Protection

• Design, implement, maintain, and regularly test database backup and recovery strategies.
• Perform database backup, restore, and recovery operations.
• Manage appropriate SQL Server recovery models based on application and business requirements.
• Ensure data integrity and minimize downtime in the event of database failures.
• Exposure to Commvault for database backup and recovery is an added advantage.

High Availability Disaster Recovery

• Configure and manage SQL Server Always On Availability Groups.
• Administer Failover Cluster Instances (FCI) and SQL Server replication.
• Support the design, implementation, testing, and maintenance of High Availability (HA) and Disaster Recovery (DR) solutions.
• Participate in DR exercises and ensure recovery procedures meet defined business requirements.
• Troubleshoot failover, synchronization, replication, and availability-related issues.

Database Security

• Implement and manage SQL Server security controls.
• Create and administer database users, logins, roles, and permissions.
• Ensure appropriate access controls and adherence to security policies.
• Support database encryption and other security mechanisms as required.
• Maintain compliance with organizational security standards and industry best practices.

Troubleshooting Production Support

• Independently analyze, troubleshoot, and resolve complex database issues.
• Provide end-to-end problem resolution for production and business-critical database incidents.
• Perform root cause analysis and implement permanent corrective actions.
• Work closely with application, infrastructure, development, and support teams to resolve cross-functional issues.
• Participate in incident, problem, and change-management activities.

Automation Scripting

• Automate routine DBA activities using PowerShell and T-SQL.
• Develop and maintain scripts for database monitoring, maintenance, health checks, backups, and administrative tasks.
• Identify opportunities to improve operational efficiency through automation.

Upgrades, Migrations Patching

• Plan and execute SQL Server upgrades, migrations, and patching activities.
• Support database version upgrades while minimizing application downtime and business impact.
• Perform migration assessments, planning, testing, execution, and post-migration validation.
• Maintain SQL Server environments in accordance with organizational lifecycle and patch-management requirements.

MSBI / Reporting

• Hands-on experience with SQL Server Integration Services (SSIS) for ETL job development, execution, monitoring, and troubleshooting.
• Experience with SQL Server Reporting Services (SSRS) for reporting solutions and dashboards.
• Support database and reporting requirements for business applications.

Required Skills Qualifications

• Bachelors degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent practical experience.
• 10+ years of hands-on experience in Database Administration with Microsoft SQL Server.
• Strong hands-on experience with SQL Server 2019, 2022, and/or newer versions.
• Strong proficiency in T-SQL, including:
  • Complex queries
  • Stored procedures
  • Triggers
  • Views
  • Query optimization
• Strong experience in SQL Server Performance Tuning and Optimization (PTO).
• Hands-on experience with database monitoring and troubleshooting tools.
• Strong knowledge of backup, restore, and recovery models.
• Experience implementing and managing Always On Availability Groups.
• Knowledge of Failover Cluster Instances (FCI) and SQL Server replication.
• Strong understanding of HA/DR concepts and implementation.
• Experience with SQL Server security, including users, logins, roles, permissions, and encryption.
• Strong troubleshooting and production-support experience.
• Hands-on experience with PowerShell and/or T-SQL scripting for automation.
• Experience with database upgrades, migrations, and patch management.
• Hands-on experience with SSIS and SSRS.
• Strong analytical and problem-solving skills.
• Excellent attention to detail and ability to work effectively in a production environment.

Additional Database Technologies - Value Added

• MySQL
• PostgreSQL
• MongoDB
• Other NoSQL database environments

Preferred / Good-to-Have Skills

• Microsoft Certified: Azure Database Administrator Associate or equivalent database certification.
• Experience with cloud database platforms such as:
  • Azure SQL Database
  • AWS RDS for SQL Server
• Strong proficiency in PowerShell scripting and automation.
• Experience with database DevOps practices.
• Familiarity with CI/CD pipelines and database deployment automation.
• Experience with Commvault or similar enterprise backup solutions.
• Experience supporting large-scale or mission-critical database environments.
• Exposure to cloud migration and modernization initiatives.

Key Technical Competencies

• Microsoft SQL Server Administration
• SQL Server 2019 / 2022 / Newer Versions
• T-SQL
• Performance Tuning Optimization
• Query Optimization
• Database Monitoring
• Backup Restore
• Recovery Models
• Always On Availability Groups
• Failover Cluster Instances
• SQL Server Replication
• High Availability Disaster Recovery
• Database Security
• PowerShell
• Database Automation
• SQL Server Upgrades Migrations
• Patch Management
• SSIS / ETL
• SSRS / Reporting
• Azure SQL Database
• AWS RDS for SQL Server
• MySQL / PostgreSQL / MongoDB
• CI/CD Database DevOps

Soft Skills

• Strong analytical and problem-solving abilities.
• Excellent written and verbal communication skills.
• Ability to troubleshoot complex issues independently.
• Strong ownership and accountability for production database environments.
• Ability to work effectively with application, development, infrastructure, and business teams.
• Strong attention to detail and commitment to data accuracy.
• Ability to prioritize multiple critical tasks in a fast-paced environment.
• Strong documentation and knowledge-sharing skills.
• Proactive approach to identifying risks, performance issues, and opportunities for automation.