PostgreSQL DBA

Advance Career Solutions; Dadri, Kolkata District, Bengaluru; Remote; INR 1,200,000 - 2,400,000; Full time

Job summary

Advance Career Solutions seeks an Oracle/PostgreSQL DBA to deliver 24x7 production support, act as SME for the team, and drive HA/DR strategies across Oracle RAC and PostgreSQL environments.

You will troubleshoot performance, implement automation, and guide complex setups while ensuring reliable backups and disaster recovery readiness.

Qualifications

• Strong technical knowledge of Oracle concepts like RAC Dataguard OGG.
• Expertise in 12c/19c versions OEM.
• Build and Deploy Implement Solutions Perform Capacity Planning and DR Planning.
• Expertise in Troubleshooting Performance Issues and providing solutions.
• Expertise in RMAN Backup/Restore/Recovery.
• Expertise in Role swap Failover planning and implementation.
• Strong technical knowledge of database space management.
• Implementing releases service requests.
• Expertise in GoldenGate.
• Expertise in Database upgrades and migrations.

Responsibilities

• Technical delivery of 24x7 production support for Oracle and Postgres databases.
• Lead production support team as SME during incidents and crisis calls.
• Expertise in Oracle RAC and Database maintenance.
• Troubleshoot performance issues and provide permanent fixes.
• Identify automation and self-healing opportunities; reduce manual work.
• Consult on complex setups and disaster recovery planning.
• Knowledge of WAL, archiving, and basic backup concepts.
• Familiarity with replication and high availability architectures.
• Hands-on with autovacuum and PostgreSQL maintenance tasks.

Skills

DATAGUARD

Oracle DB Admin

Oracle RAC

RMAN

PostgreSQL

GoldenGate

Database upgrades

Migrations

Oracle Cloud

UNIX OS

Automation

DevOps

Tools

OEM

Job description

Role & responsibilities

Job description

Role Name Oracle Postgres DBA

Location PAN India

Principal responsibilities

The job holder is responsible for technical delivery of 24x7 production support to Oracle and Postgrespreferred databases and work as a Subject Matter Expert for the production support team

Expertise in Oracle RAC and Database

Perform troubleshooting Root Cause Analysis and provide permanent fixes

EXPERT knowledge in Investigate and provide solutions to database performance related issues in Oracle Database

Lead Database team in crisis calls participate in MIR and PIR calls also mentor team members

Experience and expertise in maintaining complex High Availability Replication setups

Provide consultancy for complex setups and Disaster Recovery

Identify automation and SelfHealing opportunities and develop automation to reduce manual efforts and standardize processes

Knowledge on PostgreSQL architecture background processes and storage structure

Knowledge of database objects such as schemas tables indexes constraints and partitioning

Awareness of replication concepts and high availability architecture

Hands on experience of WAL mechanism archiving and basic backup recovery concepts

Knowledge of transaction management locking and concurrency control

In Postgres Basic performance monitoring concepts including query behaviour and database growth management

Experience on autovacuum process and database maintenance activities

Knowledge of rolebased access control authentication methods and security best practices

Familiarity with production support processes and incident handling in PostgreSQL environments

Required Skill

Strong technical knowledge of Oracle concepts like RAC Dataguard OGG

Expertise in 12c19c versions OEM

Build and DeployImplement Solutions Perform Capacity Planning and DR Planning

Expertise in Troubleshooting Performance Issues and providing solutions

Expertise in RMAN BackupRestoreRecovery

Expertise in Role swap Failover planning and implementation

Strong technical knowledge of database space management

Implementing releases service requests

Expertise in GoldenGate

Expertise in Database upgrades and migrations

Additional Skill

Knowledge on Oracle Cloud

Knowledge on UNIX based OS

Knowledge of MongoDB Db2 LUW technology

knowledge of automation tool like Ansible Puppet Tanium

Knowledge about Agile practices and DevOps tools

Soft skills Behavioural Qualities

Efficiently manage all tasks

Taking ownership of tasks assigned tasks

Proactive approach in taking tasks

Active listening skills

Clear Precise and Timely communication with CustomerTeam MembersManagement

Ready to work in 365 days 24 x 7 environment as per BusinessProject requirements

Mandatory Skills : DATAGUARD, Oracle DB Administration, Oracle RAC, ORACLE RMAN, PostgreSQL

Preferred candidate profile will have

DATAGUARD, Oracle DB Administration, Oracle RAC, ORACLE RMAN, PostgreSQL