Lead Consultant - SQL DBA

Job Title: Lead Consultant - SQL DBA

Experience : 4- 7 Years

Location: Hyderabad

Job Type: 6 months contract + ext

Need Immediate joiners only

Good Communication is a must.

Responsibilities:

• Diagnose and resolve problems around database performance, capacity, replication, T-SQL, etc.
• Proactively monitor databases for errors and respond quickly and effectively to troubleshoot and resolve DB ongoing issues on all CAI environments: DEV/QA/PROD.
• Maintain/Monitor systems On-Prem or in AWS/Azure.
• Coordinate and schedule DB downtimes to perform DB maintenance procedures. i.e. DB patching, upgrades, etc.
• Define Backup and Recovery strategies using technologies used at CAI: Netapp Snapshots, SnapCenter/Snap Manager for SQL, Idera SQLSafe or Native SQL Server Backup/recovery Tools.
• Perform advanced database administration activities, including but not limited to: DB Performance Tuning, T-SQL tuning, Backup and recover,y and DB disaster recovery solutions.
• Create/update CAI’s database documentation about standard procedures, DB technology features, or production issue troubleshooting.
• Stay current with changes in the technical area of expertise.
• Support highly available production systems using the following technologies: Database Mirroring, Log Shipping, Windows/SQL clustering, and Availability Groups.
• Work with development teams to deploy code in production when needed.
• Participate in on-call rotations.

Minimum Qualifications / Skills

• Bachelor’s degree or equivalent work experience. Hands-on experience in Microsoft Windows/ SQL Server Technologies, .NET development.
• Experience working in 24x7 environments oriented towards a zero-downtime target.
• Working knowledge or previous administration of SQL 2016-SQL 2022 and Windows Server 2019+.
• Experience with ETL, DTS, T-SQL, and SSRS, SSIS.
• Ability to work with minimal direction in a team environment.
• Performance tuning for SQL Server, queries, stored procedures, views, etc.
• Hands-on experience with configuring and administering Log Shipping and SQL Availability Groups.
• Experience with SQL in virtual, physical, and cloud-based environments.
• Proven ability to quickly learn and implement new technologies. Experience with Sentry One a plus.
• Ability to code PowerShell commands.

Preferred Qualifications/ Skills

• Excellent problem-solving and analytical skills.
• Strong communication and collaboration abilities.
• Ability to work independently and as part of a team.

Job Type: Contractual / Temporary
Contract length: 6 months

Pay: ₹1,400,000.00 - ₹2,200,000.00 per year

Work Location: In person