Oracle DBA

About Client :-

Our client is a French multinational information technology (IT) services and consulting company, headquartered in Paris, France. Founded in 1967, It has been a leader in business transformation for over 50 years, leveraging technology to address a wide range of business needs, from strategy and design to managing operations.

The company is committed to unleashing human energy through technology for an inclusive and sustainable future, helping organizations accelerate their transition to a digital and sustainable world.

They provide a variety of services, including consulting, technology, professional, and outsourcing services.

Job Details:-

location : Chennai

Mode Of Work : Hybrid

Notice Period : Immediate Joiners

Experience : 10-15yrs

Type Of Hire : Contract to Hire

Database Administration

• Install, configure, and maintain Oracle Database (12c/19c or higher) and PostgreSQL in enterprise environments.

• Manage Oracle RAC for high availability and scalability.

• Perform database upgrades, patches, migrations, and cluster maintenance.

Replication & Data Integration

• Design, configure, and manage Oracle GoldenGate for real-time replication across heterogeneous platforms.

• Implement logical/physical replication in PostgreSQL (e.g., Streaming Replication, Logical Replication).

• Ensure replication integrity, monitor latency, and troubleshoot replication issues.

Performance & Optimization

• Perform SQL and PL/SQL performance tuning, query optimization, and database parameter tuning.

• Optimize RAC cluster performance and troubleshoot interconnect issues.

• Tune PostgreSQL configuration for high performance in OLTP and analytical workloads.

Backup & Recovery

• Implement and manage RMAN for Oracle and native tools for PostgreSQL (pg_dump, PITR).

• Create and maintain disaster recovery strategies for both Oracle and PostgreSQL.

Security & Compliance

• Manage roles, privileges, auditing, and encryption for both database platforms.

• Ensure compliance with data governance, audit, and regulatory standards.

Monitoring & Troubleshooting

• Use tools like Oracle Enterprise Manager (OEM), pgAdmin, and monitoring platforms (Prometheus, Grafana, etc.).

• Proactively monitor databases for performance, availability, and reliability.

Required Skills & Qualifications

• Education: Bachelor’s degree in Computer Science, IT, or related field.

• Experience: 7 – 10 years in database administration with both Oracle and PostgreSQL.

• Strong expertise in Oracle RAC administration and troubleshooting.

• Hands-on experience with Oracle GoldenGate for real-time replication.

• Practical knowledge of PostgreSQL high availability, replication, and performance tuning.

• Strong skills in SQL, PL/SQL, and query optimization.

• Proficiency with RMAN, pg_dump, PITR backups, and restores.

• Good Linux/Unix system administration skills.

• Scripting in Shell, Python, or Perl.