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

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 #J-18808-Ljbffr Servsys Corporation