Database Administrator

Pyramid It Consulting; Bengaluru; Hybrid; INR 1,500,000 - 2,200,000; Full time

Job summary

Pyramid It Consulting is seeking an Exp-8+ yrs Oracle/PostgreSQL DBA for Bangalore on-site support. The role involves setting up and maintaining Oracle GoldenGate replication, Exadata hardware across TD environments, and Oracle Cloud OCI configurations.

You will manage DR with Data Guard, ensure high availability with RAC, and handle backups using EFM/Barman for EDB PostgreSQL databases, while addressing security remediation post-KEDGE vulnerabilities.

Qualifications

• 8+ years of Oracle and PostgreSQL DBA experience.
• Hands-on with Oracle GoldenGate, RAC, Exadata, and Oracle Cloud OCI.
• Experience with DR setups using Data Guard and backups with Barman/EFM.

Responsibilities

• Manage replication from source to target.
• Maintain high availability and disaster recovery across Oracle and PostgreSQL instances.
• Monitor Exadata environments and Oracle Cloud resources.
• Address security remediation for Oracle and EDB databases.

Skills

Oracle DBA

PostgreSQL

Oracle GoldenGate

Exadata

Oracle RAC

Oracle OCI

Data Guard

EDB PostgreSQL EFM

Tools

Oracle GoldenGate

Exadata

Oracle OCI

EDB PostgreSQL Barman

EDB PostgreSQL EFM

Oracle RAC

Job description

Exp-8+ yrs

Notice: Only Immediate

Oracle + POSTGRES

ONLY BANGALORE

Details

• Oracle Golden gate, replication from source to target. There is also hub and spoke architecture which is also introduced at TD to handle the replication from Oracle to MZ-Azure Data lakes.


• Oracle Exadata support. Support of X10, X11M hardware. Our Oracle Cloud is on X9, X10 and X11 hardware so looking for a DBA with good understanding of Exadata system and architecture.


• Oracle OCI Oracle Cloud Interface, we use this to create VMs, CDB and PDBs in Oracle Cloud on Prem. This tool is also used to increase/decrease the system resources such as CPUs and Memory on Oracle Cloud


• Oracle data guard for Oracle replication to maintain DR (Disaster Recovery) sites.


• Oracle RAC (Real application Cluster) to maintain HA (High availability at the same site)


• Oracle ZDLRA – Zero Data Loss Recovery Appliance). We use this advance and niche tool for oracle DB backups management and DB backup immutability


• Oracle/PostgreSQL Security: Due to recently KEDGE vulnerability remediation it was deemed very important that our staff should have a solid understanding of system security and vulnerabilities remediation.


• EDB PostgreSQL Barman – for taking db backups of EDB PostgreSQL Databases.


• EDB PostgreSQL EFM (Failover Manager) – This tool is used to maintain HA (High Availability) at the same site.


• Oracle and EDB new AI features in the latest version of Oracle 26AI and EDB PostgreSQL version 17.