Microsoft SQL Server DBA

Zettamine Labs; Chennai District, Coimbatore District, Bengaluru; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Zettamine Labs in Chennai, India is seeking a skilled SQL Server DBA to manage databases across production and nonproduction environments. You will administer cloud databases on Amazon RDS, monitor performance, and optimize queries using TransactSQL.

Responsibilities include backup and disaster recovery, high availability with Always On Availability Groups, and migrations from on-premises to Amazon RDS. You’ll collaborate with developers to improve database design and performance and maintain

Qualifications

• Oracle Linux Administration (Linux OS)
• RedHat Linux Administration (RHEL)
• SQL Server installation, configuration, upgrades
• Performance tuning and query optimization (TransactSQL)
• Backup, restore, and disaster recovery strategies
• High availability (Always On Availability Groups)
• Database migrations (onpremises to Amazon RDS)
• Database security (logins, roles, permissions)
• Monitoring and troubleshooting database performance issues

Responsibilities

• Manage and maintain SQL Server databases across production and nonproduction environments
• Administer and support cloud databases on Amazon RDS
• Monitor performance and optimize queries using TransactSQL
• Implement backup, restore, and disaster recovery strategies
• Ensure high availability using Always On Availability Groups
• Perform migrations from onpremises to cloud (Amazon RDS)
• Troubleshoot performance bottlenecks and resolve issues
• Configure and maintain replication and clustering where required
• Automate administrative tasks using scripts or SQL jobs
• Support deployments and upgrades across environments
• Maintain documentation for database architecture and procedures
• Provide production support during outages and critical issues
• Collaborate with development teams for database design and performance improvements

Skills

Oracle Linux Administration

RedHat Linux Administration

SQL Server installation, configuration

Performance tuning

Backup and DR strategies

Always On Availability Groups

Migrations to Amazon RDS

Database security

Monitoring and troubleshooting

Tools

Ansible

Job description

Role & responsibilities

• Manage and maintain SQL Server databases across production and nonproduction environments
• Administer and support cloud databases on Amazon RDS
• Monitor performance and optimize queries using TransactSQL
• Implement backup, restore, and disaster recovery strategies
• Ensure high availability using Always On Availability Groups
• Perform migrations from onpremises to cloud (Amazon RDS)
• Troubleshoot performance bottlenecks and resolve issues
• Configure and maintain replication and clustering where required
• Automate administrative tasks using scripts or SQL jobs
• Support deployments and upgrades across environments
• Maintain documentation for database architecture and procedures
• Provide production support during outages and critical issues
• Collaborate with development teams for database design and performance improvements

Mandatory Skills

• Oracle Linux Administration
• RedHat Linux Administration
• SQL Server installation, configuration, upgrades
• Performance tuning and query optimization (TransactSQL)
• Backup, restore, and disaster recovery strategies
• High availability (Always On Availability Groups)
• Database migrations (onpremises to Amazon RDS)
• Database security (logins, roles, permissions)
• Monitoring and troubleshooting database performance issues

Secondary Skills

• Bash/Shell scripting for automation
• Ubuntu Linux Administration
• Ansible for configuration management (advantageous)
• Database replication and clustering
• Index rebuilds and statistics updates
• Cloud monitoring tools for SQL Server and RDS
• Documentation of database architecture and procedures