Notice Period: Immediate to 90 days
Only Male candidates. Ready for 24*7 Support.
L1- 4.5 LPA
L2- 12 LPA
Location: Mumbai
L1 Roles: MSSQL
➼Check to make sure the SQL Server is online and connectivity is working fine.
➼Check error logs and if found any critical errors then escalate to L2 DBA
➼Ensure all (Full,differential and log)backups are running fine.
➼Check open tickets/issues and be sure issues/requests are addressed whitin SLA.
➼Ensure that no SQL Server job has failed and follow the SOPs if any job is failing.
➼Check the general health of the server (space, CPU utilization, memory) to confirm there are no
issues.
➼Acknowledge every mail within SLA and if required escalte to L2 DBA.
➼Join bridge calls for P1(SEV1) and P2 (SEV2) incidents along with L2/L3 DBAs.
➼Make sure to respond to all the SQL DB alerts and take proper action.
➼Work on DB Refresh activity
L2 Roles:MSSQL
➼Installation/Upgradation/Migration of SQL Servers.
➼Apply any patches or service packs for SQL Server.
➼Configure High Availability/Disaster recovery solutions.
➼Configure automated alerts to send a mail to team if any issues.
➼Work on incidents ,change tickets and problem tickets.
➼Setup Maintenance plans for Backups , Database intigrity 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 db schema and maintain controlled development database environment.
➼Work closely with application developers to test, configure, and optimize servers based on application
demands
➼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.
L3 Roles:MSSQL
➼Responsible for physical database architecture and design,capacity planning, development,
performance tuning, implementation, and support of the applications from a database perspective.
➼Conduct T- SQL Code Reviews to ensure coding standards, best practices and avoid potential
performance issues.
➼Attend CAB ( Change Advisory Board) meeting and get proper approvals from product owners to
implement DB changes.
➼Document operational or newly engineered solutions properly to educate and inform the clients and
DBAs from the various levels of the organization.
➼Work on Writing custom stored procedures, t-sql queries , powershell scripts , views, and triggers
based on requiremens for DB maintenance and automate tasks.
➼Work on writing technical and RCA(Root Cause Analysis) documentation.
➼Join bridge calls to troubleshoot and fix P1(SEV1) and P2 (SEV2) incidents.
➼work on performance tuning like provide suggestions to crete indexes and tune stored procedures.
➼Troubleshoot recurring problems and fix them permanantly.
➼Conduct DB DR Drill activity , ensure to bring the DR site online if any outage at Primary site.