Position: MS SQL Database Administrator (L3)
Budget: 20 LPA
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.