Sr. Database Admin (Oracle + PostgreSQL)

Sr. Database Admin (Oracle + PostgreSQL) Location: 99 Jefferson Rd, Parsippany, NJ 07054 only Locals NJExp Level: 10+About the RoleWe 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 improvement.Key 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 operationsPerform version upgrades, patch management, and migrations with minimal downtimeMaintain 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 trendsEnsure 24/7 observability with appropriate on-call escalation runbooksDebugging & 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 documentationCollaborate with application teams to debug data-layer issues and provide resolution guidanceProactive Support & ReliabilityConduct regular health checks, audit reviews, and preventive maintenanceIdentify risks before they become incidents, proactively address fragile configurations, aging objects, and growing technical debt in database infrastructureMaintain 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 operational tasksSecurity & ComplianceEnsure databases meet compliance requirements (SOC 2, HIPAA, PCI-DSS, GDPR) including data masking, encryption at rest and in transit, and audit trailsConduct periodic access reviews and vulnerability assessmentsEnforce role-based access control (RBAC), least-privilege principles, and audit loggingRequired 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 applicationsSoft SkillsStrong analytical and problem-solving mindset with a bias toward prevention over reactionAbility to communicate technical issues clearly to non-technical stakeholdersSelf-driven, able to manage multiple priorities in a fast-paced environmentCollaborative team player with a strong documentation discipline