MUMBAI · FULLTIME
MS SQL Database Administrator
Softenger
Mumbai · onsite · Posted 64d ago
Sourced from
Undisclosed3–10 yrsfulltimeMumbai
About a minute. You'll make an account on the way through.
agent · working
- Read this posting0.8s
- Found the form on Naukri · 6 questions to answer1.2s
- Decided the answers for all of them2.9s
- Tailor your résumé to this role
- Waiting for you
Section · 01
About this role
Roles and 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
Desired Skill:
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. Strong knowledge of SQL Server architecture, backup/restore, index management, job monitoring. Exposure to Always On AGs, Log Shipping, and Replication, failover cluster. Understanding of SQL security fundamentals. Working knowledge of T-SQL and familiarity with Basic PowerShell.
Sourced from naukri
Section · 02
Skills
Database Migrationreplicationhigh availabilityAlways OnFailover Cluster
Section · Company
About Softenger
Softenger
IT Services & Consulting
927
employees
1999
27 years old
Pune, Maharashtra
India
₹6.1L PA avg
Avg at Softenger
About
Softenger is an ISO 27001:2022 and ISO 9001:2015 Certified and RBA-compliant IT Service Provider with a presence in India, Singapore, and Malaysia.
Industries
IT Services & ConsultingSoftware Product
Employee ratings
10 reviews
4.0/ 5
Culture
3.4
Career growth
2.7
Work-life
3.2
Employees rate it well for
Overall Company40Company Culture39
Find them on