SQL Server DBA

Ascendion Engineering; Hyderabad, Bengaluru; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Ascendion Engineering in Hyderabad, India, is seeking an experienced SQL Server DBA to manage SQL Server 2012/2016/2019 environments, including Azure SQL MI and Azure VMs. The role involves performance tuning, HA implementation, and production support.

You will handle migrations, backups, security, and 24/7 on-call rotations, collaborating with enterprise teams to ensure data integrity and high availability.

Qualifications

• Strong hands-on experience with MS SQL Server 2012/2016/2019.
• Experience with Azure SQL MI, Azure VMs, and on-prem SQL Servers.
• Proficient in Windows Server, PowerShell, and batch scripting.
• Knowledge of Always On, backups, recovery, and performance tuning.
• Experience with migrations.
• SSIS/SSRS experience.

Responsibilities

• Install, configure, patch, upgrade, and maintain SQL Server environments.
• Provide DBA support for SQL Server 2012/2016/2019, Azure SQL MI, Azure VMs, and on-premises SQL Servers.
• Perform database migrations, especially Azure SQL MI to SQL Server on Azure VM, including assessment, planning, execution, cutover, and validation.
• Manage backup, recovery, storage, security, user access, and database objects.
• Monitor and improve SQL Server performance, including query and database tuning.
• Implement and maintain SQL Server Always On and high-availability solutions.
• Plan and execute maintenance, patching, upgrades, and configuration changes following change-management procedures.
• Troubleshoot database performance, connectivity, backup, and other production issues.
• Perform RCA for major incidents and implement corrective actions.
• Automate repetitive DBA tasks and improve operational efficiency.
• Maintain database standards, procedures, security, data integrity, and documentation.
• Provide proactive support and technical guidance to users and DBA team members.
• Work with Azure infrastructure and support enterprise-level database environments.
• Participate in 24/7 production support, including approximately 2 weeks of night shift per month.

Skills

SQL Server 2012/2016/2019

Azure SQL MI

Azure VMs

Windows Server

PowerShell

Backup & Recovery

Always On

Performance Tuning

Migration

SSIS/SSRS

Incident/Change/Problem Mgmt

Scripting/Batch

Communication Skills

NetBackup

SQL Server Management Studio

Tools

NetBackup

SSMS

Job description

Role - SQL Server DBA

Client – Carnival Cruise Line.

Key Responsibilities

• Install, configure, patch, upgrade, and maintain Microsoft SQL Server environments.
• Provide DBA support for SQL Server 2012/2016/2019, Azure SQL Managed Instance (MI), Azure VMs, and on-premises SQL Servers.
• Perform database migrations, especially Azure SQL MI to SQL Server on Azure VM, including assessment, planning, execution, cutover, and validation.
• Manage backup, recovery, storage, security, user access, and database objects.
• Monitor and improve SQL Server performance, including query and database tuning.
• Implement and maintain SQL Server Always On and high-availability solutions.
• Plan and execute maintenance, patching, upgrades, and configuration changes following change-management procedures.
• Troubleshoot database performance, connectivity, backup, and other production issues.
• Perform RCA for major incidents and implement corrective actions.
• Automate repetitive DBA tasks and improve operational efficiency.
• Maintain database standards, procedures, security, data integrity, and documentation.
• Provide proactive support and technical guidance to users and DBA team members.
• Work with Azure infrastructure and support enterprise-level database environments.
• Participate in 24/7 production support, including approximately 2 weeks of night shift per month.

Required Skills

• Strong hands-on experience with MS SQL Server 2012, 2016, and 2019.
• Strong experience with Azure SQL Managed Instance (MI) and Azure VMs.
• Good knowledge of Windows Server, PowerShell, and Batch scripting.
• Experience with SQL Server installation, patching, upgrades, backup and recovery.
• Strong knowledge of SQL Server performance tuning and troubleshooting.
• Experience with database migrations and schema/object migration.
• Experience implementing and supporting SQL Server Always On.
• Good understanding of Azure infrastructure.
• Knowledge of Incident, Change, and Problem Management processes.
• Experience with SSIS and SSRS.
• Good communication and troubleshooting skills.

Good to Have

• Experience with NetBackup and SQL Server backup troubleshooting.
• Experience in database automation.
• Experience working in large-scale enterprise DBA environments.
• Knowledge of advanced SQL Server performance and recovery techniques.

Support Model

• 24/7 production support
• Approximately 2 weeks of night shift per month
• Participation in incident, change, maintenance, and on-call activities