SQL Database Administrator

We are seeking an experienced SQL Database Administrator to join our team. The ideal candidate will have strong technical skills and experience in managing and supporting MS SQL Database including Failover Cluster, Always ON Setup and new server provisioning, Transaction replication, Link Servers, Hardening, patching in day-to-day operations. Experience on 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 Record.
• 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.

Technical Skills & Knowledge

• Team Management experience (Must)
• Handling Major Incident and RCA
• Database Installation and troubleshooting (Must)
• Always ON Cluster configuration and Management (Must)
• Failover Cluster Management (Must)
• patching and Failover cluster and Always ON (Must)
• Replication and Link Server configuration (Must)
• Database Patching and Hardening (Must)
• Job Scheduling and Maintenance plan
• Prepared POA and rollback plan on Database Migration (Must)
• Planning and execution on new project related to Database.
• Troubleshooting on DB performance issue.