Senior Database Administrator — Oracle & PostgreSQL

Job Title: Senior Database Administrator — Oracle & PostgreSQLLocation: Parsippany, NJ (Hybrid). Preference for local resourceJob type: W2Key ResponsibilitiesDatabase AdministrationAdminister, configure, and maintain Oracle (19c+) and PostgreSQL (14+) database environments across development, staging, and productionManage database provisioning, schema design, user access, and lifecycle operationsMaintain and test backup and recovery strategies (RMAN, pg_dump, point-in-time recovery)Performance & Query OptimizationAnalyze 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 managementIdentify and resolve locking, contention, and resource bottleneck issuesConduct regular performance reviews and capacity planning assessmentsMonitoring & AlertingSet up and maintain proactive database monitoring using tools such as OEM (Oracle Enterprise Manager), pgAdmin, Prometheus + Grafana, Datadog, or equivalentDefine and configure threshold-based alerts for CPU, memory, I/O, tablespace usage, replication lag, connection pools, and long-running queriesBuild dashboards for real-time visibility into database health and performance trendsDebugging & Incident ResponseLead triage and root cause analysis (RCA) for database-related incidents including outages, data corruption, replication failures, and performance degradationMaintain detailed incident logs and post-mortem documentationRequired Qualifications8+ years of hands-on DBA experience with Oracle (11g/19c) and PostgreSQL (12+)Deep expertise in query tuning and execution plan analysis for both platformsExperience working in cloud environments — AWS RDS/AuroraProficiency with Oracle tools: SQL*Plus, RMAN, AWR, ADDM, OEMProficiency with PostgreSQL tools: psql, pg_stat_*, pgBadger, pgBouncer, Patroni, pg_activityExperience designing and managing monitoring and alerting pipelinesStrong understanding of HA/DR architectures — Data Guard, RAC, streaming replication, failover clusteringSolid scripting skills in Shell, Python, or PL/SQL / PL/pgSQL for automationPreferred QualificationsOracle OCA/OCP or equivalent certificationExperience with infrastructure-as-code tools (Terraform, Ansible) for database provisioningFamiliarity with containerized databases (PostgreSQL on Kubernetes, CrunchyData, CloudNativePG)Exposure to database observability platforms like Dynatrace, DatadogPrior experience supporting payroll, financial, or regulated-industry applications