Subject Matter Expert (Support&Ops;)

Experience: Not Available to Not Available years

Location: Chennai, India

Skills: Database operations, Database administration, Oracle, SQL Server, PostgreSQL, MongoDB, Dremio, SQL, Backup and Restore, Performance tuning, Technical support, Infrastructure support, Security audits, Compliance initiatives

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.

Key Responsibilities
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.

Skill Requirements
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 setting is fully compliant with IFC security policies and internal controls.

Other Requirements
Provide 24/7 incident response for IFC’s production environment 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.

📌 Subject Matter Expert (Support&Ops) (Chennai)
🏢 HCL Technologies
📍 Chennai