Remote Senior DBA: Teradata/Oracle Exadata & RAC Expert

ZealHire Inc.

United States

Hybrid

USD 120,000 - 170,000

Full time

39 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Publicis Sapient is seeking a Sr. Associate DBA with Teradata, Oracle Exadata, and SQL expertise to manage and optimize large-scale data warehouses.

You will configure, patch, and upgrade the environment across DEV/QA/UAT/PROD, tune performance, and ensure robust backup and DR strategies. The role requires strong scripting skills and Linux/Unix experience, with the ability to work with cross-functional teams and participate in security and compliance efforts.

Qualifications

  • Strong Teradata DBA experience (Vantage, utilities, workload/performance tuning).
  • Strong Oracle DBA experience with Exadata and Oracle RAC administration.
  • Expertise in SQL tuning, indexing/partitioning, stats management, and large-volume DW optimization.
  • Hands-on backup/recovery, HA/DR architecture, and enterprise compliance support.
  • Scripting/automation proficiency (Shell, Python, SQL).
  • Strong Linux/Unix platform administration exposure.

Responsibilities

  • Install, configure, patch, and upgrade Teradata, Oracle Exadata, and Oracle RAC across DEV/QA/UAT/PROD.
  • Administer and optimize large-scale data warehouse schemas (3NF, star/snowflake) for BI and analytics workloads.
  • Tune SQL and system performance using EXPLAIN plans, AWR/ASH, DBQL, stats strategy, indexing, and partitioning.
  • Manage Teradata workload governance (TASM/Viewpoint), spool/perm/temp, AMP skew, locking, and concurrency.
  • Manage Oracle RAC services, Clusterware, ASM, instance balancing, and high-availability failover operations.
  • Operate Exadata-specific features: Smart Scan, Storage Indexes, HCC, IORM, and cell/server performance tuning.
  • Build and maintain robust ETL/load frameworks (TPT/FastLoad/TPump, SQL*Loader, external tables) with strict load-window SLAs.
  • Own backup, recovery, and DR strategy (RTO/RPO), including restore drills, failover testing, and runbook validation.
  • Implement security controls: RBAC, profiles, encryption, LDAP/SSO integration, audit policies, and least-privilege access.
  • Automate DBA tasks (health checks, stats jobs, user provisioning, housekeeping) via Shell/Python/SQL scripting.
  • Support release/change management with pre/post deployment validation, rollback plans, and zero/low outage execution.
  • Provide L2/L3 production support, incident RCA, trend reporting, and preventive action planning.
  • Create operational documentation (SOPs, architecture, recovery guides) and train junior DBAs/engineers.
  • Partner with ETL, BI, infra, and security teams to resolve integration/performance issues and maintain SLA compliance.

Skills

Teradata DBA
Oracle DBA
SQL tuning
Backup/Recovery
HA/DR
Scripting
Linux/Unix

Tools

Exadata
RAC

Job description

Publicis Sapient is seeking a Sr. Associate DBA with Teradata, Oracle Exadata, and SQL expertise to manage and optimize large-scale data warehouses.

You will configure, patch, and upgrade the environment across DEV/QA/UAT/PROD, tune performance, and ensure robust backup and DR strategies. The role requires strong scripting skills and Linux/Unix experience, with the ability to work with cross-functional teams and participate in security and compliance efforts.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr. Associate DBA role (Teradata DBA, Oracle DBA and SQL)
Sr. Associate DBA role (Teradata DBA, Oracle DBA and SQL)

ZealHire Inc. • United States

Hybrid
USD 120,000 - 170,000
Senior Oracle DBA — Remote, Exadata & RAC
Senior Oracle DBA — Remote, Exadata & RAC

Ethereum Technologies • Minnesota

Remote
USD 88,000 - 125,000
Sr.Oracle Database Administrator
Sr.Oracle Database Administrator

Cognisol Global Solutions LLC • St. Louis (MO)

On-site
USD 95,000 - 120,000
Senior Oracle DBA - Data Warehouse & Exadata (Remote)
Senior Oracle DBA - Data Warehouse & Exadata (Remote)

Valiant Technologies LLC • Minnesota

Remote
USD 88,000 - 125,000
Senior Oracle DBA – Exadata Cloud@Customer, Hybrid
Senior Oracle DBA – Exadata Cloud@Customer, Hybrid

Horizontal Talent • Houston (TX)

Hybrid
USD 140,000 - 190,000
Hybrid work environment
Senior Oracle Database Administrator
Senior Oracle Database Administrator

Cognisol Global Solutions LLC • St. Louis (MO)

On-site
USD 120,000 - 150,000
Senior Oracle DBA - Exadata/RAC & Data Guard | Hybrid
Senior Oracle DBA - Exadata/RAC & Data Guard | Hybrid

Global Business Ser. 4u Inc. • Dallas (TX)

Hybrid
USD 96,000 - 152,000
Senior Oracle Data Warehouse Architect: Exadata & RAC
Senior Oracle Data Warehouse Architect: Exadata & RAC

Quantum Technologies. LLC • Minnesota

Remote
USD 96,000 - 124,000
Senior Oracle DBA for PeopleSoft & Exadata (Remote)
Senior Oracle DBA for PeopleSoft & Exadata (Remote)

Experis Technology Group • City of Albany (NY)

Remote
USD 152,000 - 165,000
Teradata DBA
Teradata DBA

Teamware Solutions • Charlotte (NC)

Hybrid
USD 120,000 - 180,000