Track Lead - Oracle Administration,PostgreSQL

Experience: 1 to Not Available years

Location: Chennai, India

Skills: Oracle 11g, Oracle 12c, Oracle 18c, Oracle 19c, Red Hat Linux, ASM storage, ext3 file systems, PostgreSQL, SQL Server, Unix Shell Scripting, Oracle Transparent Data encryption, Oracle Cloud Infrastructure (OCI), Oracle Exadata, Azure Data Lake, Azure Data Factory, Azure Fabric, RMAN, ITIL processes, SOX/ICFR compliance, Dremio

Job Summary
Perform all aspects of Database operations and administration services in accordance with established processes and guidelines. These include, but are not limited to:
• Install, configure, and maintain database instances / servers with the versions required by IFC.
• Enhance database performance by query and process optimization.
• Maintain integrity of database by having proper backup and recovery processes.
• Apply database changes according to change management procedures.
• Carry out regular capacity planning activities.
• Perform database refresh and cloning as required by the respective application teams.
• Support the version upgrade and patching activities along with oracle platinum support as planned by IFC.
• Maintain operational documentation, technical diagrams, and business continuity/disaster recovery procedures.
• Participate actively in all aspects of infrastructure projects and technical upgrades.
• Provide database provisioning and technical support services to application development projects.
• Perform supporting services for IFC’s Reporting and batch process control platform.
• Perform Database Backup and Restore activities in close coordination with WBG ITS teams.
• Participate in security audits and compliance initiatives.



Ensure the database environment is fully compliant with IFC security policies and internal controls.
• Provide 24/7 incident response for IFC’s production workplace along with CIT’s core database team in HQ and Chennai thru established escalation processes. (Weekdays through shift coverage, for weekends and WBG holidays through on-call support).
• Provide periodic and ad-hoc status reports including KPIs as requested by IFC’s delivery lead.
• Perform periodic performance tuning of applications and capacity planning.
• Participate in coding of stored procedure and triggers, using SQL as needed for the operations.
• Provide infrastructure support for Oracle, SQL Server, PostgreSQL, MongoDB, Dremio etc., database environments.
• Provide support of the Dremio infrastructure for data engineering needs of IFC.
• Provide support for DevOps migrations in Azure ecosystem, including Azure Databricks.
• Provide support of IT operations using an onsite/offshore delivery model along with the
Key Responsibilities
Overall 12+ years of IT industry experience
• 7+ years of experience as DBA in Oracle 11g/12c/18c/19c in Red Hat Linux using ASM storage and ext3 file systems.
• Experience in PostgreSQL and SQL Server is also mandatory (at least 1 year).
• Unix Shell Scripting experience is required (at least 1 year).
Skill Requirements
• Experience in Oracle Transparent Data encryption.
• Experience in operating Oracle in the Cloud (OCI) is a plus.
• Experience with Oracle Exadata is required.
• Experience with Azure services (Azure Data Lake, Azure Data Factory, Azure Fabric)
• Relevant experience with RMAN for backup and recovery.
Other Requirements
• Relevant experience in use of ITIL processes.
• Relevant experience for SOX/ICFR compliance of critical financial systems.
• Knowledge of Dremio, data lake accelerator solution is a plus.

📌 Track Lead Oracle Administration,PostgreSQL (Chennai)
🏢 HCL Technologies
📍 Chennai