MS SQL Database Administrator

Position: MS SQL Database Administrator (L3)Budget: 20 LPALocation: Mumbai (Fort Road)Experience: 8+ Years with Relevant experienceWork Mode: Work from officeNotice Period : Immediate / 15 Days only (Mandatory)Education Qualification:B.E./Diploma/BSC/BTech (No education gap, Full time)1. B.E. / Diploma [ In Computers Science, IT , Electronics & Telecommunication ] [ Civil and Mechanical not preferred]2. B.Sc. -IT 3. BCA or MCA [ Full time course from reputed University]4. No gap in education [ Passing year for S.S. C , H.S.C. and Degree/Diploma to be mentioned]JOB RESPONSIBILITIES:- 8+ years relevant experience and minimum 2+ years team lead experience is mandatory - Database troubleshooting and Failover cluster, Always ON working experience is Mandatory plus team management - Monitor generated log and event files indicating errors that will result in an incident - DR Database availability Monitoring - Monitor database log replication - Report Status of Log Replications as per agreed schedules - Session/Query/Log/Latch monitoring - Monitor the DB for failures and logged system events that indicate an imminent failure - Purging database Logs and trace files - Periodic config review to maintain consistent configurations - Review and recommendation to maintain availability - Monthly report on database availability - Monitor the DB for failures and logged system events that indicate imminent failure. - Reconfigure log Shipping - Transaction replication Configuration - Link Servers configuration - Failover clustering - Always ON - Responding to database related incidents and driving corrective action - Tuning DB parameters - Correlate related incidents together into a problem ticket and manage through the problem management process - Use trend analysis to identify, detail, categorize, prioritize and create Problems Management Records. - Restoration of database - Support SQL DB L2 team for handling critical issues. - Handle DB performance related issues. - Handle end to end Major incidents and communicate to customers on production issue. - Creating jobs/job schedule for routine/Maintenance jobs & Rebuilding of indexes - Purging database Logs and trace files & Performance Management - Defragmentation of Database and performance tuning - Manage all Service requests through the change management process - Automate administration tasks where possible - Manage and update all Database environment documentation - SQL patch compliance and hardening compliance. - Ensure DB server availability for business application.

Apply Now