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