Senior Database Administrator Oracle & PostgreSQLServsys Corporation • Parsippany, New Jersey, United States
Senior Database Administrator Oracle & PostgreSQL
Servsys Corporation
- Parsippany, New Jersey, United States
- Parsippany, New Jersey, United States
Über
Job type: W2
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
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)
Prior experience supporting payroll, financial, or regulated-industry applications
#J-18808-Ljbffr
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot stammt von einer Partnerplattform von TieTalent. Klick auf „Jetzt Bewerben”, um deine Bewerbung direkt auf deren Website einzureichen.