Ms Sql Server Database Administrator

Inspirisys; Ernakulam; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Inspirisys is seeking a skilled Level II Database Administrator to manage an enterprise SQL Server environment with ~150 instances, ensuring high availability and robust security.

You will oversee full lifecycle management, backups, DR drills, performance tuning, and compliance. The role demands strong troubleshooting and the ability to document SOPs and share knowledge with IT teams.

Qualifications

• Strong hands-on experience in Microsoft SQL Server Database Administration across multi-server production environments.
• Basic operational knowledge of MySQL, PostgreSQL, MongoDB and IBM DB2.
• Familiarity with GoldenGate or Qlik replication utilities.
• Experience with capacity planning, hardware evaluation, and IT monitoring integration.
• Strong troubleshooting, analytical mindset for risk management, and knowledge transfer.
• Preferred Microsoft Certified: Azure Database Administrator Associate or equivalent legacy SQL Server certifications (e.g., MCSA/MCSE).
• Immediate joiners or candidates with 30 days NP preferred.

Responsibilities

• Manage the full lifecycle of MS SQL Server instances, including installation, configuration, upgrades, patching, space management, and orderly startups/shutdowns.
• Backup & Recovery: execute native backups, exports, archives, and recovery operations; rapid resolution for crashes or terminations.
• High Availability & DR: configure and monitor replication, log shipping, and DR setups across sites; participate in DR drills.
• Performance Tuning: monitor performance, memory, network; optimize data/log file placement and tuning plans.
• Security & Compliance: implement encryption, masking, and redaction; manage access control and audits; close findings timely.
• Replication Tools: support data replication workflows with GoldenGate or Qlik.
• Documentation & Operations: maintain daily checklists, action plans, logs, and SOPs.

Skills

SQL Server

High Availability

Disaster Recovery

Performance Tuning

Security & Compliance

Backup & Recovery

Replication Tools

Open-source DBs

Monitoring Integration

Azure DB Admin

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