Sr. Database Admin (Oracle + PostgreSQL)

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, * 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

• 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, * 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