Description

You will own the production database environment, ensuring high availability and performance across all SQL Server instances.

This role is on-site.

Responsibilities

• Administer standalone and clustered SQL Server installations, handling service pack updates and security patching.
• Manage Azure server environments, focusing on backups, security, connectivity, and performance tuning.
• Monitor server configuration parameters, disk I/O, processor, memory, and network usage to maintain stability.
• Execute database migrations, in-place upgrades, and side-by-side upgrades with minimal downtime.
• Automate administration tasks using T-SQL and custom monitoring scripts.

Required Skills

• 5 to 10 years of experience in SQL Server administration.
• Expertise in Always On Availability Groups, replication, log shipping, and mirroring.
• Hands-on experience with MSSQL clustering and database migration strategies.
• Proficiency in T-SQL for automation and complex task management.
• Experience managing Azure server backups, security protocols, and connectivity.
• Strong knowledge of database backups, recovery procedures, and disaster recovery planning.
• Ability to manage database access, users, and object permissions via roles and groups.
• Capability to troubleshoot SQL Server and MySQL Server issues effectively.

Preferred Skills

• Previous experience as a production support analyst.
• Experience with capacity planning and generating monthly summary reports.

Key Skills

Education

B.E/B. Tech/MCA