Associate Consultant - Database
HCL Technologies Lanka (Private) LimitedAssociate Consultant - Database Detailed Responsibilities Database Administration: Administer, maintain, install, configure, upgrade, and patch Oracle, PostgreSQL, MySQL, and MS SQL database servers. Manage database instances, schemas, tablespaces, and storage allocations to ensure optimal availability and reliability. Backup, Recovery & Restoration: Configure, monitor, and validate database backups. Execute point-in-time recovery (PITR) and disaster recovery (DR) procedures. Support restores requests and conducts regular recovery testing and DR drills. Database Performance Management: Monitor database health and performance metrics. Troubleshoot and optimize slow-running queries, indexes, and execution plans. Perform capacity planning and storage optimization. High Availability & Disaster Recovery: Manage Oracle Data Guard, SQL Server Always on Availability Groups (AOAG), PostgreSQL and MySQL replication and clustering solutions. Conduct failover testing and ensure compliance with RPO/RTO objectives. Incident & Problem Management: Serve as the Level 3 (L3) escalation point for critical database incidents. Troubleshoot and resolve outages, replication failures, backup issues, performance degradations, and connectivity problems. Perform root cause analysis (RCA) for recurring incidents. Security & Compliance: Manage and enforce database security policies and role-based access controls (RBAC). Monitor privileged access, audit logs, and ensure adherence to security standards. Change & Release Management: Plan and implement database upgrades, security patches, schema modifications, and migrations. Participate in Change Advisory Board (CAB) reviews and execute maintenance activities during approved windows. Migration & Upgrade Activities: Conduct migrations between database versions, platforms, and support cloud migration initiatives. Lead database consolidation and modernization projects; validate post-migration application connectivity. Automation & Scripting: Develop scripts for monitoring, backup validation, health checks, reporting, and automation of routine DBA tasks using PowerShell, Shell Script, SQL, or Python. Documentation & Knowledge Management: Maintain comprehensive runbooks, SOPs, HLD/LLD documents, and recovery procedures. Provide technical mentoring and knowledge transfer sessions to L1/L2 support teams. Skill Requirements Technical Skills Database Platforms: Oracle Database Administration (including RMAN, RAC, Data Guard, ASM, OEM Cloud Control) Microsoft SQL Server (2016/2019/2022, AOAG, SSMS, performance tuning, backup & restore) PostgreSQL (replication, streaming replication, PITR, pgAdmin, performance tuning) MySQL (replication, clustering, backup & recovery, performance optimization) Operating Systems: Proficiency in Linux and Windows Administration Backup Solutions: Experience with PPDM, Veeam, NetBackup or similar platforms Scripting & Automation: Strong skills in PowerShell, Shell scripting, SQL scripts, and Python Frameworks & Best Practices: Familiarity with ITIL processes for Incident, Problem, and Change Management Educational Background & Certifications 8 - 10 Years of relevant Experience Bachelor’s degree in computer science, Information Technology, or related field (or equivalent experience) Oracle Certified Professional (OCP) Microsoft SQL Server Certifications PostgreSQL Professional Certification MySQL Database Administrator Certification ITIL Foundation Certification PLEASE CLICK THE APPLY BUTTON TO SEND YOUR CV VIA XPRESSJOBS
