Job Family: Operations Engineering
Internal Specialization: Database Administration
Band: B2/B3
Role: Sr. DBA
Experience: 811 Years
Job Location: Vashi Navi Mumbai
Role & Responsibilities
Migration of SQL Servers.
Apply any patches or service packs for SQL Server.
Configure High Availability/Disaster recovery solutions.
Configure replication topologies.
Configure automated alerts to send an email to the team if there are any issues.
Work on incidents change tickets and problem tickets.
Setup Maintenance plans for Backups Database integrity check rebuild index and Update statistics and make sure to run all the jobs without any issues.
Troubleshoot locking issues including deadlocks blocking lock timeouts and fix them.
Join bridge calls to troubleshoot and fix P1(SEV1) and P2 (SEV2) incidents.
Execute all changes of database schema and maintain controlled development database environment.
Work closely with application developers to test configure and optimize servers based on application demands
Table Partitioning handson.
Handle database object deployment to Integration QA UAT and Production
Provide day to day support of high OLTP HA of SQL Server databases Identify root causes of production problems and work with developers to resolve such problems.
Work on performance tuning like creating missing indexes.
Extended Events
We want Immediate Joiners and Localite candidates from Mumbai
Salary max 12 LPA
Regards
Gurpreet Kaur
Asal Jobs
migration law,database schema management,maintenance plans,troubleshooting,table partitioning,automated alerts,replication,sql server,performance tuning,incident management,disaster recovery,sql,developers,high availability