Senior Database Administrator — Oracle & PostgreSQL

Job Title: Senior Database Administrator — Oracle & PostgreSQL

Location: Parsippany, NJ (Hybrid). Preference for local resource

Job type: W2

Key Responsibilities

Database Administration

Administer, configure, and maintain Oracle (19c+) and PostgreSQL (14+) database environments across development, staging, and production

Manage database provisioning, schema design, user access, and lifecycle operations

Maintain and test backup and recovery strategies (RMAN, pg_dump, point-in-time recovery)

Performance & Query Optimization

Analyze and tune slow-running queries using execution plans, explain plans, and profiling tools (AWR, ADDM, pg_stat_statements, pgBadger)

Design and maintain optimal indexing strategies, partitioning schemes, and statistics management

Identify and resolve locking, contention, and resource bottleneck issues

Conduct regular performance reviews and capacity planning assessments

Monitoring & Alerting

Set up and maintain proactive database monitoring using tools such as OEM (Oracle Enterprise Manager), pgAdmin, Prometheus + Grafana, Datadog, or equivalent

Define and configure threshold-based alerts for CPU, memory, I/O, tablespace usage, replication lag, connection pools, and long-running queries

Build dashboards for real-time visibility into database health and performance trends

Debugging & Incident Response

Lead triage and root cause analysis (RCA) for database-related incidents including outages, data corruption, replication failures, and performance degradation

Maintain detailed incident logs and post-mortem documentation

Required Qualifications

8+ years of hands-on DBA experience with Oracle (11g/19c) and PostgreSQL (12+)

Deep expertise in query tuning and execution plan analysis for both platforms

Experience working in cloud environments — AWS RDS/Aurora

Proficiency with Oracle tools: SQL*Plus, RMAN, AWR, ADDM, OEM

Proficiency with PostgreSQL tools: psql, pg_stat_*, pgBadger, pgBouncer, Patroni, pg_activity

Experience designing and managing monitoring and alerting pipelines

Strong understanding of HA/DR architectures — Data Guard, RAC, streaming replication, failover clustering

Solid scripting skills in Shell, Python, or PL/SQL / PL/pgSQL for automation

Preferred Qualifications

Oracle OCA/OCP or equivalent certification

Experience with infrastructure-as-code tools (Terraform, Ansible) for database provisioning

Familiarity with containerized databases (PostgreSQL on Kubernetes, CrunchyData, CloudNativePG)

Exposure to database observability platforms like Dynatrace, Datadog

Prior experience supporting payroll, financial, or regulated-industry applications