Job Title: Senior Database Administrator — Oracle & PostgreSQL
Location: Parsippany, NJ (Hybrid). Preference for local resource
Job type: C2C and W2
Interview type: Face to Face
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