MUMBAI · FULLTIME
Ms Sql Database Administrator
Visara Human Capital Services
Mumbai · onsite · Posted 71d ago
About a minute. You'll make an account on the way through.
agent · working
- Read this posting0.7s
- Found the form on Naukri · 8 questions to answer1.8s
- Decided the answers for all of them3.2s
- Tailor your résumé to this role
- Waiting for you
Section · 01
About this role
Role Purpose
We are seeking an experienced MS 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, and patching in day-to-day operations.
JOB RESPONSIBILITIES
1) Monitor generated log and event files indicating errors that will result in an incident
2) DR Database availability Monitoring
3) Monitor database log replication
4) Report Status of Log Replications as per agreed schedules
5) Session/Query/Log/Latch monitoring
6) Monitor the DB for failures and logged system events that indicate an imminent failure
7) Purging database Logs and trace files
8) Periodic config review to maintain consistent configurations
9) Review and recommendation to maintain availability
10) Monthly report on database availability
11) Monitor the DB for failures and logged system events that indicate imminent failure.
12) Reinstall Database software
13) Reconfigure log Shipping
14) Transaction replication Configuration
15) Link Servers configuration
16) Failover clustering
17) Always ON
18) Responding to database related incidents and driving corrective action
19) Tuning DB parameters
20) Correlate related incidents together into a problem ticket and manage through the problem management process
21) Use trend analysis to identify, detail, categorize, prioritize and create Problems Management Records.
22) Restoration of database
23) Creating jobs/job schedule for routine/Maintenance jobs & Rebuilding of indexes
24) Purging database Logs and trace files & Performance Management
25) Defragmentation of Database and performance tuning
26) Manage all Service requests through the change management process
27) Automate administration tasks where possible
28) Manage and update all Database environment documentation
Technical Skills/Knowledge Requirement
1) Database Installation and troubleshooting (Must)
2) Always ON Cluster configuration and Management (Must)
3) Failover Cluster Management (Must)
4) patching and Failover cluster and Always ON (Must)
5) Replication and Link Server configuration (Must)
6) Database Patching and Hardening (Must)
7) Job Scheduling and Maintenance plan
8) Database Migration (Must)
9) Troubleshooting on DB performance issue
Sourced from naukri
Section · 02
Skills
Section · Company
About Visara Human Capital Services
Visara Human Capital Services
₹8.5L – ₹9.5L PA
This role
About
iIlumifin provides third party administration and technology services to individual and group insurers. illumifin was founded by Abry Partners, a leading Boston-based private equity firm, and Hoplon Capital, an asset manager focused on digital disruption, after the acquisition of Concentrix Corporations insurance third-party administration and software platform. The company, launched in 2021, blends insurance industry knowledge, technology leadership and operational execution to prepare insurers for the digital future. illumifin is a diverse, passionate and empowered team of insurance specialists committed to the growth and success of its customers. With illumifin, there's a brighter future. illumifin completed its acquisition of LTCG to create one of the largest insurance service providers in the North American long-term care, life, health, and annuity markets. illumifin is led by its President & Chief Executive Officer Peter Goldstein. Peter Goldstein has almost 30 years’ experience in the life, health, long-term care, and annuity insurance industry and was CEO and co-founder of LTCG, Inc. Manoj Kallangad Puthankalam, a senior business leader in Insurance outsourcing is the Head of illumfin India.
Employee ratings
2 reviews
Culture
1.5
Career growth
1.5
Work-life
1.5
Find them on