Search Jobs | Dice.com

Job Details

Skills

Summary

We are looking for a Senior Data Architect/Database Administrator

We 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.

Responsibilities:

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.
Perform version upgrades, patch management, and migrations with minimal downtime.
Maintain and test backup and recovery strategies (RMAN, pg_dump, point-in-time recovery).
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.
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.
Ensure 24/7 observability with appropriate on-call escalation runbooks.
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.
Collaborate with application teams to debug data-layer issues and provide resolution guidance.
Conduct regular health checks, audit reviews, and preventive maintenance.
Identify risks before they become incidents, proactively address fragile configurations, aging objects, and growing technical debt in database infrastructure.
Maintain and improve DR (Disaster Recovery) and HA (High Availability) setups, Oracle Data Guard, RAC, PostgreSQL Streaming Replication, pgBouncer, Patroni.
Document runbooks, SOPs, and knowledge base articles for recurring operational tasks.
Ensure databases meet compliance requirements (SOC 2, HIPAA, PCI-DSS, GDPR) including data masking, encryption at rest and in transit, and audit trails.
Conduct periodic access reviews and vulnerability assessments.
Enforce role-based access control (RBAC), least-privilege principles, and audit logging.

Requirements:

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.
Hands-on experience with Oracle E-Business Suite (R12.2.x) administration, including ADOP, AutoConfig, Rapid Clone, Concurrent Manager, and WebLogic.
Experience administering Oracle and PostgreSQL databases on AWS, including Amazon RDS, Aurora PostgreSQL, CloudWatch, Performance Insights, AWS Backup, and Multi-AZ deployments.
Experience with AWS Database Migration Service (DMS), AWS Schema Conversion Tool (SCT), and automation using Shell, Python, Ansible, or Terraform.
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 Skills:

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.

Required Skills:

Strong analytical and problem-solving mindset with a bias toward prevention over reaction.
Ability to communicate technical issues clearly to non-technical stakeholders.
Self-driven, able to manage multiple priorities in a fast-paced environment.
Collaborative team player with a strong documentation discipline.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 91132164
Position Id: 26-00205
Posted 10 hours ago

Fitment

Dice Job Match Score™

👾 Reticulating splines...

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Database Administrator

Berkeley Heights, New Jersey

•

Today

Location: Berkeley Heights, NJ Salary: $65.00 USD Hourly - $70.00 USD Hourly Description: Job Title: Database Administrator Location: Berkeley Heights, NJ / Frisco, TX / Marietta, GA / Omaha, NE (Onsite 5 Days) Duration: Contract To Hire Job Description: Responsible for maintaining existing databases with high-availability solutions, replication, backup, restore, encryption, and disaster recovery solutions. Strong database migration experience Expertise and experience monitoring Azure worksp

Contract

USD 65.00 - 70.00 per hour

Sr. Oracle APPS DBA with PostgreSQL

No location provided

•

Today

About the Role We are looking for an experienced Administrator with strong expertise in both Oracle APPS DBA 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. Notes: We are seeking an experi

Easy Apply

Contract

Cloud Architect - 21540

New York, New York

•

17d ago

Job Title: ON-SITE - Cloud Architect- 21540 Location:2 Broadway, New York, NY 10004 Duration: 12 Months Job Description: Extensive experience with cloud servers and environments with configuration, patching, network and VLAN configuration, backups, system monitoring and alerts. Cloud Platforms, Oracle Cloud (OCI), AWS, Azure, Google Cloud Platform Database Technologies: Oracle RAC, ASM, Data Guard, Golden Gate, RMAN, Database licensing Product Architecture and roadmap, its assessment Lin

Easy Apply

Contract, Third Party

Depends on Experience

Senior Database Administrator

New York, New York

•

Today

Description Position at MTA Headquarters JOB TITLE: Senior Database Administrator SALARY RANGE: $126,745 - $149,600 DEPT/DIV: Information Technology SUPERVISOR: Manager, Product Development LOCATION: 2 Broadway HOURS OF WORK: 9:00 am - 5:30 pm (7.5 hours/day) or as required This position is eligible for teleworking, which is currently 2 days per week. New hires are eligible to apply 30 days after their effective date of hire. Opening The Metropolitan Transportation Authority is North Am

Full-time

USD 126,745.00 - 149,600.00 per year

Filter Results

Job post features

Posted date

Work settings

Employment type

Distance

Employer type

Work authorization

Senior Data Architect/Database Administrator

Skills

Summary

Dice Job Match Score™

Similar Jobs

Senior Data Architect/Database Administrator

Job Details

Skills

Summary

Dice Job Match Score™

Similar Jobs