MS SQL Database Administrator (L3)

Position: MS SQL Database Administrator (L3)

Location: Mumbai (Fort Road)

Experience: 8+ Years with Relevant experience

Work Mode: Work from office

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