SQL Database Administrator

We are hiring a Lead Consultant - SQL DBA for one of our clients' MNCs.

Exp : 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 CAIs 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.

Qualifications we seek in you!

Minimum Qualifications / Skills :

- Bachelors 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.