Senior Database Administrator — Oracle & PostgreSQL @ Parsippany, New Jersey

Servsys Corporation; Parsippany-Troy Hills (NJ); On-site; USD 120,000 - 140,000; Full time

Job summary

Servsys Corporation is seeking an experienced Database Administrator to manage Oracle (19c+) and PostgreSQL (14+) environments. The role includes optimizing queries, managing database provisioning, and ensuring robust monitoring practices.

The ideal candidate will have over 8 years of experience, strong skills in cloud database environments, and expertise in scripting for automation. This position offers a hybrid working model with a preference for local candidates in Parsippany, NJ.

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 and PostgreSQL tools for database management.

Responsibilities

• Administer, configure, and maintain Oracle and PostgreSQL database environments.
• Analyze and tune slow-running queries and conduct performance reviews.
• Set up and maintain proactive database monitoring and alerting.
• Lead triage and root cause analysis for database-related incidents.

Skills

Database Administration

Query Tuning

Performance Optimization

Scripting in Shell/Python/PL/SQL

Education

8+ years of DBA experience with Oracle and PostgreSQL

Tools

Oracle (11g/19c)

PostgreSQL (12+)

AWS RDS/Aurora

Terraform

Ansible

Job description

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

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)

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