Senior Oracle DBA with PostgreSQL

Cintra; Chandigarh; On-site; INR 1,400,000 - 2,300,000; Full time

Benefits offered by this job

Competitive salary

Healthcare benefits

Professional development

Enterprise cloud exposure

Job summary

Cintra in Chandigarh, India is seeking a Senior Oracle DBA with PostgreSQL to manage mission-critical databases across on‑prem and cloud environments. You will ensure performance, availability and security, while supporting multi-cloud strategies and DR planning.

The role involves leading architecture and migration efforts, tuning, and automation, with collaboration across production and project teams in a fast-paced setting.

Qualifications

• 7–10 years of hands-on experience in Oracle Database Administration with Data Guard, GoldenGate, and RAC.
• Proven experience in Oracle performance tuning, troubleshooting, production support, and patching (CPU/PSU/RU) with strong SQL/PL‑SQL and Unix/Linux skills.
• Working knowledge of PostgreSQL administration including backup/recovery and basic HA/replication setups; familiarity with pgAdmin, pgBackRest, Patroni, pg_stat_statements is a plus.
• Excellent analytical, problem-solving, and communication skills for a team‑oriented, fast-paced environment.
• Experience in ITIL/change-management and database monitoring/reporting tools (e.g., OEM).
• Bachelor's degree in computer science, IT, or related discipline.

Responsibilities

• Lead enterprise database architecture projects including Oracle infrastructure design, upgrades, migrations, performance tuning and ongoing support.
• Manage production support and project delivery across environments; own incidents and SLAs.
• Review backups, maintenance, and monitoring health reports to proactively resolve issues.
• Design, implement, and maintain HA and DR solutions using Data Guard, GoldenGate, and RAC.
• Install, configure, upgrade, and manage Oracle server software across on‑prem and cloud; apply patches.
• Lead cloud migration and modernization to OCI and AWS.
• Monitor performance; implement proactive tuning and root cause analysis.
• Develop and maintain database replication strategies and automated processes.
• Design and implement database security best practices.
• Define architecture, server sizing, and storage strategies.
• Build automation for routine tasks using OEM 13c+ and scripting.
• Support PostgreSQL across on‑prem and cloud (AWS RDS/Aurora, OCI, Azure) with pgAdmin/psql.
• Assist with PostgreSQL backup/recovery and basic HA/replication (streaming/logical) using pgBackRest/Patroni.
• Perform health checks, vacuum tuning, query performance, and monitoring with pg_stat_statements, PgBouncer, pgBadger.
• Coordinate with broader database and application support teams on incidents.

Skills

Oracle DBA

Data Guard

GoldenGate

RAC

Performance Tuning

PL/SQL

Unix/Linux

PostgreSQL DBA

pgAdmin

pgBackRest

Patroni

pg_stat_statements

PgBouncer

pgBadger

SQL

Education

Bachelor's degree in computer science/IT or related

Tools

OEM 13c+

pgAdmin

pgBackRest

Patroni

pg_stat_statements

Job description

About Cintra

At Cintra, we are a global leader in multi-cloud consulting and managed services, helping organizations modernize, migrate, and manage complex enterprise applications and database workloads across both private and public cloud platforms.

We partner with some of the world’s leading technology providers, including Oracle, AWS, Microsoft Azure, and Google Cloud, delivering innovative, scalable, and secure solutions that drive business transformation.

With a strong international presence across the UK, USA, Brazil, and India, we combine deep technical expertise with a customer-focused approach to support organizations on their cloud transformation journey.

The Role

We are seeking an experienced and highly motivated Senior Oracle Database Administrator (DBA), with Postgres experience, to join our growing team. In this role, you will be responsible for managing mission-critical database environments, ensuring optimal performance, availability, reliability, and security across enterprise systems.

You will play a key role in supporting business continuity initiatives and delivering high-impact solutions for client environments within a fast-paced, multi-cloud focused ecosystem.

Key Responsibilities

• Lead the delivery of enterprise database architecture projects, including Oracle database infrastructure design, implementation, upgrades, migrations, performance tuning, and ongoing support.


• Manage a combination of production support and project delivery activities across multiple environments, taking ownership of database incidents and service requests to ensure resolution within defined SLAs.


• Review and maintain operational health reports related to backups, maintenance, and monitoring to proactively identify and resolve service issues.


• Design, implement, and maintain High Availability (HA) and Disaster Recovery (DR) solutions using Oracle Data Guard, GoldenGate, and RAC, including backup, recovery, and data integrity processes to ensure business continuity.


• Install, configure, upgrade, and manage the lifecycle of Oracle database server software and associated tools across on-premises and cloud environments, including patching (Oracle 19c and newer).


• Lead cloud migration and modernization initiatives, transitioning databases to Oracle Cloud Infrastructure (OCI) and AWS platforms.


• Monitor database performance, implement proactive tuning and optimization strategies, and conduct root cause analysis for production issues, driving long-term corrective actions.


• Develop and maintain database replication strategies and automated operational processes.


• Design and implement database security solutions and best practices.


• Define optimal database architecture, server sizing, and storage strategies.


• Build and maintain automation solutions for routine administrative tasks, reporting, monitoring, alerts, and notifications using Oracle Enterprise Manager (OEM) 13c+ and custom scripting.


• Support PostgreSQL database administration, including installation, configuration, and routine maintenance across on-premises and cloud environments (AWS RDS/Aurora, OCI, or Azure Flexible Server), using tools such as pgAdmin and psql.


• Assist with PostgreSQL backup and recovery processes using pg_dump, pg_basebackup, and WAL archiving, and support basic HA/replication setups (streaming or logical replication) using tools such as pgBackRest and Patroni.


• Perform routine PostgreSQL health checks, monitoring, and performance troubleshooting (vacuum/autovacuum tuning, query performance, connection pooling) using tools such as pg_stat_statements, PgBouncer, and pgBadger.


• Respond to and resolve PostgreSQL-related service requests and incidents in coordination with the broader database and application support teams.

Skills & Experience

We are looking for a proactive, collaborative professional with strong technical expertise and a passion for delivering excellence.

• 7–10 years of hands‑on experience in Oracle Database Administration, with a strong understanding of database architecture, principles, best practices, and Oracle technologies (including Data Guard, GoldenGate, and RAC).


• Proven experience in Oracle performance tuning, troubleshooting, production support, and database patching (CPU/PSU/RU), along with strong SQL, PL/SQL, and Unix/Linux skills.


• Working knowledge of PostgreSQL administration, including installation, configuration, backup/recovery (pg_dump, pg_basebackup, WAL archiving), and basic HA/replication setups; familiarity with tools such as pgAdmin, pgBackRest, Patroni, and pg_stat_statements is a plus.


• Excellent analytical, problem‑solving, and communication skills, with the ability to work effectively in a team‑oriented, fast‑paced environment.


• Experience working in production environments with ITIL/change‑management processes, along with familiarity with database monitoring and reporting tools (e.g., Oracle Enterprise Manager).

Qualifications

• Bachelor's degree in computer science, Information Technology, or related discipline.

Benefits

We offer a competitive compensation and benefits package, including:

• Competitive salary package


• Comprehensive healthcare benefits


• Continuous learning and professional development opportunities


• Exposure to enterprise‑scale cloud and database transformation projects

Diversity & Inclusion

Cintra Software & Services is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, nationality, sexual orientation, gender identity, disability or any other characteristic protected by law.

Job Title: Senior Oracle DBA with PostgreSQL

Location: Chandigarh India (Onsite)

Shift: Rotational

#LI-RG1