02 Aug
|
Inspirisys
|
Kochi
Role & responsibilities
We are seeking a skilled Level II Database Administrator to manage, maintain, and optimize our enterprise database workplace 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
📌 Ms Sql Server Database Administrator (Kochi)
🏢 Inspirisys
📍 Kochi