Sr. Database Admin (Oracle + PostgreSQL)
Location: 99 Jefferson Rd, Parsippany, NJ 07054 only Locals NJ
Exp Level: 10
+
About the R
oleWe are looking for an experienced Database Administrator with strong expertise in both Oracle and AWS PostgreSQL to join our engineering team. In this role, you will be responsible for the stability, performance, security, and availability of enterprise databases supporting mission-critical applications. You will work closely with application, infrastructure, and security teams to proactively manage database health and drive continuous improveme
nt.Key Responsibilit
iesDatabase Administrat
- ionAdminister, configure, and maintain Oracle (19c+) and PostgreSQL (14+) database environments across development, staging, and product
- ionManage database provisioning, schema design, user access, and lifecycle operati
- onsPerform version upgrades, patch management, and migrations with minimal downt
- imeMaintain and test backup and recovery strategies (RMAN, pg_dump, point-in-time recove
ry)
Performance & Query Optimiza
- tionAnalyze and tune slow-running queries using execution plans, explain plans, and profiling tools (AWR, ADDM, pg_stat_statements, pgBad
- ger)Design and maintain optimal indexing strategies, partitioning schemes, and statistics manage
- mentIdentify and resolve locking, contention, and resource bottleneck is
- suesConduct regular performance reviews and capacity planning assessm
ents
Monitoring & Ale
- rtingSet up and maintain proactive database monitoring using tools such as OEM (Oracle Enterprise Manager), pgAdmin, Prometheus + Grafana, Datadog, or equiv
- alentDefine and configure threshold-based alerts for CPU, memory, I/O, tablespace usage, replication lag, connection pools, and long-running qu
- eriesBuild dashboards for real-time visibility into database health and performance t
- rendsEnsure 24/7 observability with appropriate on-call escalation run
books
Debugging & Incident Re
- sponseLead triage and root cause analysis (RCA) for database-related incidents including outages, data corruption, replication failures, and performance degra
- dationMaintain detailed incident logs and post-mortem documen
- tationCollaborate with application teams to debug data-layer issues and provide resolution gu
idance
Proactive Support & Reli
- abilityConduct regular health checks, audit reviews, and preventive main
- tenanceIdentify risks before they become incidents, proactively address fragile configurations, aging objects, and growing technical debt in database infrast
- ructureMaintain and improve DR (Disaster Recovery) and HA (High Availability) setups, Oracle Data Guard, RAC, PostgreSQL Streaming Replication, pgBouncer,
- PatroniDocument runbooks, SOPs, and knowledge base articles for recurring operationa
l tasks
Security & Co
- mplianceEnsure databases meet compliance requirements (SOC 2, HIPAA, PCI-DSS, GDPR) including data masking, encryption at rest and in transit, and audi
- t trailsConduct periodic access reviews and vulnerability ass
- essmentsEnforce role-based access control (RBAC), least-privilege principles, and audit
loggingRequired Qualif
- ications8+ years of hands-on DBA experience with Oracle (11g/19c) and PostgreS
- QL (12+)Deep expertise in query tuning and execution plan analysis for both p
- latformsExperience working in cloud environments — AWS RD
- S/AuroraProficiency with Oracle tools: SQL*Plus, RMAN, AWR, A
- DDM, OEMProficiency with PostgreSQL tools: psql, pg_stat_*, pgBadger, pgBouncer, Patroni, pg_
- activityExperience designing and managing monitoring and alerting p
- ipelinesStrong understanding of HA/DR architectures — Data Guard, RAC, streaming replication, failover cl
- usteringSolid scripting skills in Shell, Python, or PL/SQL / PL/pgSQL for au
tomation
Preferred Quali
- ficationsOracle OCA/OCP or equivalent cert
- ificationExperience with infrastructure-as-code tools (Terraform, Ansible) for database pro
- visioningFamiliarity with containerized databases (PostgreSQL on Kubernetes, CrunchyData, Cloud
- NativePG)Exposure to database observability platforms like Dynatrace
- , DatadogPrior experience supporting payroll, financial, or regulated-industry app
lications
S
- oft SkillsStrong analytical and problem-solving mindset with a bias toward prevention ove
- r reactionAbility to communicate technical issues clearly to non-technical st
- akeholdersSelf-driven, able to manage multiple priorities in a fast-paced e
- nvironmentCollaborative team player with a strong documentation
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
Similar jobs
Show more