DBA - MSSQL server

Genzeon; Hyderabad; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Genzeon in Hyderabad is seeking an experienced MS SQL Server Database Administrator to join the support team. The role requires 7+ years of hands-on experience managing SQL Server environments in production, ensuring high availability, performance, and data integrity across critical systems.

The candidate will provide L2/L3 production support, perform installations and upgrades, manage backups and DR, and tune performance. Rotational shifts may apply.

Qualifications

• Bachelor's degree in CS/IT or related field required.
• 7+ years as a SQL Server DBA in production support.
• Strong installation, configuration, and administration skills (2014–2022).
• Hands-on with Always On, Clustering, Replication, and Log Shipping.
• Proficient in backup/recovery and disaster recovery planning.
• Proficient in T-SQL, performance tuning, and query optimization.
• Experience with SQL Server Agent, SSIS, SSRS preferred.
• Familiar with monitoring tools (SCOM/DMVs) and Windows Server networking basics.
• PowerShell scripting for automation; good communication skills.
• Willingness to work in rotational/on-call shifts, including weekends if required.

Responsibilities

• Provide L2/L3 production support for SQL Server databases across versions 2016–2022.
• Monitor health, performance, availability; proactively resolve issues.
• Install, configure, upgrade, and patch SQL Server instances.
• Manage backup and recovery strategies; perform restores and DR drills.
• Configure High Availability/DR solutions (Always On, Failover Clustering, Log Shipping).
• Perform performance tuning and query optimization; manage indexes and statistics.
• Troubleshoot deadlocks, blocking, and connectivity issues.
• Manage security, roles, and permissions; ensure data security compliance.
• Handle SQL Server Agent jobs and maintenance plans; investigate failures.
• Capacity planning, storage management, and growth monitoring.
• Document runbooks and knowledge base articles; assist cross-functional teams.
• Support migrations (on-prem to on-prem, or on-prem to cloud where applicable).
• Respond to incidents/tickets within SLAs using ITSM tools (ServiceNow/JIRA).

Skills

SQL Server administration

T-SQL

Performance tuning

Backup & DR strategies

Always On Availability Groups

Windows Server administration

On-call / rotational shifts

Monitoring & incident response

PowerShell scripting

Communication & collaboration

Education

Bachelor's degree in Computer Science, IT, or related field

Tools

Always On Availability Groups

Failover Clustering

Replication

Log Shipping

SSIS

SSRS

SQL Server Agent

PowerShell

Monitoring tools (SCOM/DMVs)

Job description

Job Summary

We are looking for an experienced MS SQL Server Database Administrator to join our support team. The ideal candidate will have 7+ years of hands‑on experience managing, maintaining, and troubleshooting SQL Server environments in a production support capacity, ensuring high availability, performance, and data integrity across critical business systems.

Requirements

Key Responsibilities

• Provide L2/L3 production support for MS SQL Server databases (2016/2017/2019/2022), including on-call/rotational shift support
• Monitor database health, performance, and availability; proactively identify and resolve issues before they impact business operations
• Perform database installation, configuration, upgrades, and patching (service packs/cumulative updates)
• Manage backup and recovery strategies; perform database restores and disaster recovery drills
• Configure and maintain High Availability/Disaster Recovery solutions (Always On Availability Groups, Failover Clustering, Log Shipping, Replication, Mirroring)
• Perform performance tuning and query optimization (index management, execution plan analysis, statistics updates)
• Troubleshoot database‑related incidents, deadlocks, blocking sessions, and connectivity issues
• Manage user access, security, roles, and permissions; ensure compliance with data security policies
• Handle SQL Server Agent jobs, maintenance plans, and job failures
• Perform capacity planning, storage management, and database growth monitoring
• Document runbooks, SOPs, and knowledge base articles for recurring issues
• Coordinate with application, infrastructure, and development teams to resolve cross‑functional issues
• Support migration and upgrade projects (on‑prem to on‑prem, or on‑prem to cloud - Azure SQL/AWS RDS, if applicable)
• Respond to and manage incidents/tickets within defined SLAs using ITSM tools (ServiceNow, JIRA, Remedy, etc.)

Required Skills & Qualifications

• Bachelor's degree in Computer Science, IT, or related field
• 7+ years of experience as a SQL Server DBA in a production support environment
• Strong expertise in SQL Server installation, configuration, and administration (2014 through 2022)
• Hands‑on experience with Always On Availability Groups, Clustering, Replication, and Log Shipping
• Strong knowledge of backup/recovery models and DR strategies
• Proficiency in T‑SQL, performance tuning, and query optimization
• Experience with SQL Server Agent, SSIS, SSRS (preferred)
• Familiarity with monitoring tools (SCOM, Redgate, SolarWinds, Idera, or native DMVs)
• Understanding of Windows Server administration and networking basics
• Experience with cloud database platforms (Azure SQL Database/Managed Instance, AWS RDS) is a plus
• Knowledge of PowerShell scripting for automation is a plus
• Strong analytical, troubleshooting, and communication skills
• Willingness to work in rotational shifts/on-call support, including weekends if required

Preferred Certifications

• Microsoft Certified: Azure Database Administrator Associate
• MCSA/MCSE: SQL Server (legacy, if applicable)
• ITIL Foundation (preferred for support roles)