Database Administrator - MySQL / SQL

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

(ref : hirist.tech)