Mssql Db L3

• Monitor generated log and event files indicating errors that may result in incidents
• Perform DR database availability monitoring
• Monitor database log replication
• Report the status of log replications as per agreed schedules
• Conduct session/query/log/latch monitoring
• Monitor the database for failures and logged system events that indicate imminent failure
• Purge database logs and trace files
• Perform periodic configuration reviews to maintain consistent configurations
• Review and provide recommendations to maintain database availability
• Prepare monthly reports on database availability
• Reconfigure log shipping as required
• Configure transaction replication
• Configure linked servers
• Manage failover clustering
• Configure and maintain Always ON availability groups
• Respond to database-related incidents and drive corrective actions
• Tune database parameters for performance optimization
• Correlate related incidents into problem tickets and manage through the problem management process
• Use trend analysis to identify, categorize, prioritize, and create Problem Management Records
• Restore databases as needed
• Support the SQL Database L2 team in handling critical issues
• Handle database performance-related issues
• Manage end-to-end major incidents and communicate with customers on production issues
• Create jobs/job schedules for routine or maintenance tasks and rebuild indexes
• Purge database logs and trace files and manage performance
• Perform database defragmentation and performance tuning
• Manage all service requests through the change management process
• Automate administrative tasks where possible
• Manage and update all database environment documentation
• Ensure SQL patch and hardening compliance
• Ensure database server availability for business applications

• 8-10 Years relevant experience
• B.E./Diploma/BSC/BTech (No education gap, Full time) B.E. / Diploma [ In Computers Science, IT , Electronics & Telecommunication] [ Civil and Mechanical not preferred]
• B.Sc. -IT, BCA or MCA [Full time course from a reputed University] No gap in education [Passing year for S.S.C, H.S.C. and Degree/Diploma to be mentioned] (Relevant Certification (Preference) )
• Database troubleshooting and Failover cluster, Always ON working experience is Mandatory plus team management
• Team management experience (Must)
• Handling major incidents and preparing RCA reports
• Database installation and troubleshooting (Must)
• Always ON cluster configuration and management (Must)
• Failover cluster management (Must)
• Patching in Failover Cluster and Always ON environments (Must)
• Replication and linked server configuration (Must)
• Database patching and hardening (Must)
• Job scheduling and maintenance planning
• Prepare POA and rollback plans for database migration (Must)
• Plan and execute new database-related projects
• Troubleshoot database performance issues

Accountability, Accountability, Active Learning, Active Listening, Bias, Business Growth, Change Management, Client Expectations Management, Coaching, Creativity, Critical Thinking, Cross-Functional Teamwork, Customer Centric Solutions, Customer Experience (CX), Customer Feedback, Customer Lifetime Value, Customer Relationship Management (CRM), Design Thinking, Empathy, Follow-Through, Growth Mindset, Infrastructure as a Service (IaaS), Intellectual Curiosity (Inactive), Long Term Planning, Managing Ambiguity {+ 5 more}

• Health & Wellbeing
• Personal & Professional Development
• Unconditional Inclusion