Senior Database Administrator — Oracle & PostgreSQL @ Parsippany

Location:

Parsippany, NJ (Hybrid). Preference for local resource

Job type: W2

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, , point-in-time recovery)

Analyze and tune slow-running queries using execution plans, explain plans, and profiling tools (AWR, ADDM, _statements, pg Badger)

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

Set up and maintain proactive database monitoring using tools such as OEM (Oracle Enterprise Manager), pg Admin, 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

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

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 Badger, pg Bouncer, Patroni,

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

Oracle OCA/OCP or equivalent certification

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

Familiarity with containerized databases (PostgreSQL on Kubernetes, Crunchy Data, CloudNative PG)

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