Ms Sql Server Database Administrator

Inspirisys; Ernakulam; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Inspirisys is seeking a skilled Level II Database Administrator to manage an enterprise SQL Server environment with ~150 instances. You will ensure availability, security, disaster recovery, and DR readiness across multiple data center sites.

Responsibilities include installation, backups, performance tuning, security enforcement, and incident management, with focus on maintaining robust operations and comprehensive SOPs for production support.

Qualifications

• Strong hands-on experience in MS SQL Server administration across multi-server production environments.
• Operational knowledge of MySQL, PostgreSQL, MongoDB, and IBM DB2.
• Familiarity with GoldenGate or Qlik replication utilities.
• Experience with capacity planning and integrating databases with centralized IT monitoring solutions.

Responsibilities

• Manage full lifecycle of MS SQL Server instances: installation, configuration, upgrades, patching, space management, startup/shutdown.
• Backup and recovery: perform native backups, exports, archives, and rapid recovery.
• Configure and monitor high availability and disaster recovery across multiple sites; participate in DR drills.
• Monitor performance, optimize memory usage, and distribute data across drives; implement tuning plans.
• Implement security features: encryption, masking, redaction; manage access control and audits.
• Support data replication workflows using GoldenGate or Qlik.
• Conduct RCA for major incidents and develop risk mitigation plans.
• Maintain daily checklists, action plans, and SOPs to ensure smooth operations.

Skills

MS SQL Server DBA

Database administration

Performance tuning

HA/DR planning

Security & compliance

Replication tools

Incident management

Documentation & SOPs

Analytical thinking

Education

Bachelor's degree in Computer Science or related

Microsoft Certified: Azure Database Administrator Associate

Tools

GoldenGate

Qlik

IT monitoring solutions

Hardware evaluation

Job description

Role & responsibilities

We are seeking a skilled Level II Database Administrator to manage, maintain, and optimize our enterprise database environment consisting of approximately 150 Microsoft SQL Server instances. This role supports critical core and non-core production applications within our data center. The ideal candidate will ensure continuous database availability, robust security, and seamless disaster recovery management.

Key Roles & ResponsibilitiesCore Administration:

Manage the full lifecycle of MS SQL Server instances, including installation, configuration, upgrades, patching, space management, and orderly startups/shutdowns.

Backup & Recovery: Execute native database backups, exports, archives, and recovery operations. Provide rapid resolution for database crashes, hung instances, or unexpected terminations.

High Availability & DR: Configure, maintain, and monitor database replication, log shipping, and disaster recovery (DR) setups across multiple sites. Active participation in regular DR drills is required.

Performance Tuning: Monitor system performance, memory structures, and network connectivity. Identify bottlenecks, distribute data/log files across drives, and execute performance tuning plans.

Security & Compliance: Implement advanced database security features such as encryption, masking, and redaction. Manage user access control, permissions, and session-level audits while closing audit findings on time.

Replication Tools: Support and monitor data replication workflows utilizing tools like GoldenGate or Qlik.

Incident Management: Perform root cause analysis (RCA) for major incidents, analyze trend patterns of repeat alerts, and build risk mitigation plans.

Documentation & Operations: Maintain rigorous daily checklists, draft database action plans, record activity logs, and create/update standard operating procedures (SOPs).

Desired Profile & Technical S

Preferred candidate profile

Strong hands-on experience in Microsoft SQL Server Database Administration across multi-server production environments.

Secondary Databases: Basic operational knowledge of open-source databases (MySQL, PostgreSQL, MongoDB) and IBM DB2.

Replication Tools: Familiarity with GoldenGate or Qlik replication utilities.

Infrastructure Familiarity: Experience with capacity planning, hardware evaluation, and integrating databases with centralized IT monitoring solutions.

Soft Skills: Strong troubleshooting capabilities, analytical thinking for risk management, and the ability to transfer knowledge to internal technical teams.

Preferred Certifications:Microsoft Certified: Azure Database Administrator Associate or equivalent legacy SQL Server certifications (e.g., MCSA/MCSE: SQL Server).

Immediate joiners or candidates with 30 days NP are preferred