Ms Sql Database Administrator

TechBerry Infotech Pvt. Ltd.; Navi Mumbai; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

TechBerry Infotech Pvt. Ltd. is seeking an experienced MS SQL Server DBA to install, configure, and manage SQL Server in standalone and clustered environments, ensuring high availability and robust disaster recovery.

The role covers maintenance, backups, upgrades, security, and performance tuning, with 24x7 production support and close collaboration with application teams.

Qualifications

• 46 years of hands-on experience as an MS SQL Server DBA in production environments.
• Strong knowledge of SQL Server High Availability & Disaster Recovery Log Shipping, Always On, and Clustering.
• Proficient in database maintenance, backup/recovery, and performance tuning.
• Experience with database upgrades, migrations, and patch management.
• Sound understanding of database security, roles, and permissions management.
• Familiar with monitoring tools and SQL performance analysis.
• Good communication and coordination skills across technical and business teams.
• Ability to work under pressure in a 24x7 production support environment.

Responsibilities

• Install, configure, and administer MS SQL Server in standalone and clustered environments.
• Manage database maintenance, backups, restores, DBCC checks, and shrink operations.
• Implement HA/DR solutions including Log Shipping, Always On, and Failover Clustering.
• Perform DC-DR Cutover/Cutback activities and participate in DR drills.
• Monitor and troubleshoot Log Shipping, Always On sync, SQL Agent jobs, and maintenance plans.
• Conduct health checks, monitor error logs, blocking, job failures, and backup status.
• Ensure backups complete successfully and verified for production systems.
• Manage database security: logins, users, roles, access policies.
• Perform upgrades, migrations, patching, and service packs.
• Document installation, configuration, upgrade, and maintenance for knowledge sharing and audit.
• Collaborate with application/development teams to deliver DB solutions.
• Perform failover/failback in Always On and clustered setups.
• Monitor and respond to SQL Server alerts and performance issues.
• Provide L2 production support (24x7), escalating to L3 when necessary.

Skills

MS SQL Server

High Availability

Backup/Recovery

Performance Tuning

Upgrades/Migrations

Security Management

Monitoring Tools

Communication

24x7 Production Support

Tools

Always On Availability Groups

Log Shipping

Failover Clustering

DBCC

Job description

Key Responsibilities:

• Install, configure, and administer MS SQL Server in standalone and clustered environments.
• Manage database maintenance, including backups, restores, DBCC checks, and shrink operations.
• Implement and support High Availability (HA) and Disaster Recovery (DR) solutions such as Log Shipping, Always On Availability Groups, and Failover Clustering.
• Perform Cutover/Cutback (DC-DR) activities and participate in DR Drills.
• Monitor and troubleshoot issues related to Log Shipping, Always On synchronization, SQL Agent jobs, and maintenance plans.
• Conduct database health checks monitor error logs, blocking, job failures, and backup status.
• Ensure all database backups are successfully completed and verified for production systems.
• Manage database security create and manage logins, users, roles, and enforce access control policies.
• Perform database upgrades, migrations, patching, and apply service packs/cumulative updates.
• Document installation, configuration, upgrade, and maintenance processes for knowledge sharing and audit purposes.
• Collaborate with application and development teams to understand requirements and deliver database solutions.
• Perform failover and failback operations in Always On and clustered setups.
• Monitor and respond to SQL Server alerts and performance issues proactively.
• Provide L2-level production support (24x7), escalating critical issues to L3 when necessary.

Required Skills and Qualifications:

• 46 years of hands-on experience as an MS SQL Server DBA in production environments.
• Strong knowledge of SQL Server High Availability &Disaster Recovery Log Shipping, Always On, and Clustering.
• Proficient in database maintenance, backup/recovery, and performance tuning.
• Experience with database upgrades, migrations, and patch management.
• Sound understanding of database security, roles, and permissions management.
• Familiar with monitoring tools and SQL performance analysis.
• Good communication and coordination skills across technical and business teams.
• Ability to work under pressure in a 24x7 production support environment.

Preferred Qualifications:

• Microsoft Certified: Azure Database Administrator Associate or SQL Server Database Certification.
• Exposure to cloud-based SQL (Azure SQL, AWS RDS) environments.