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

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

Sr. Associate DBA role (Teradata DBA, Oracle DBA and SQL) | JPC-9132

USC/GC- W2need LinkedIn, VISA DLNote: This is a remote role and candidate should be local to one of Sapient office locations. Candidate will be required to do onsite interview, go to office location to pick up the laptop and for validation as needed after starting the project. Sapient has offices in San Francisco, CA or Arlington, VA or Westminster, CO or Chicago, IL or Boston, MA or Birmingham, MI or Houston, TX or Atlanta, GA or Miami, FL or New York, NY or Minneapolis, MN or Los Angeles, CA or Seattle, WA or Dallas/Irving, TX or Irvine, CA.

Duration: 6-month contract to start

Location: This role does not require candidates to be onsite daily. However, candidates must reside within a reasonable distance of a Publicis Sapient office. This requirement is necessary to accommodate in-person interview requests and, if hired, candidates must be able to visit a Publicis Sapient office to collect their company laptop and complete government-issued ID verification. Additionally, candidates must be able to go onsite when requested for security purposes.

Interview Process: 1 internal video interview & 1 client round

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.

Required Skills:

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

$000,000 – $000,000 Salary range is not shown on the candidate portal

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Remote Senior DBA: Teradata/Oracle Exadata & RAC Expert
Remote Senior DBA: Teradata/Oracle Exadata & RAC Expert

ZealHire Inc. • United States

Hybrid
USD 120,000 - 170,000
Teradata DBA
Teradata DBA

Teamware Solutions • Charlotte (NC)

Hybrid
USD 120,000 - 180,000
Teradata DBA @ NJ
Teradata DBA @ NJ

Reliable Software Resources Inc • Hoboken (NJ)

On-site
USD 100,000 - 120,000
Sr.Oracle Database Administrator
Sr.Oracle Database Administrator

Cognisol Global Solutions LLC • St. Louis (MO)

On-site
USD 95,000 - 120,000
Data Management/sdi Cloud
Data Management/sdi Cloud

Tata Consultancy Services Limited • Chandler (AZ)

On-site
USD 100,000 - 120,000
Discretionary Annual Incentive
Comprehensive Medical Coverage
Maternal & Parental Leaves
+4
Senior Terradata Developer
Senior Terradata Developer

Programmers • Charlotte (NC)

Hybrid
USD 90,000 - 130,000
Teradata DBA
Teradata DBA

Ktek Resourcing LLC • Phoenix (AZ)

On-site
USD 90,000 - 120,000
Senior PeopleSoft/Oracle DBA
Senior PeopleSoft/Oracle DBA

Experis Technology Group • City of Albany (NY)

Remote
USD 152,000 - 165,000
Senior Oracle Database Administrator
Senior Oracle Database Administrator

Verra Mobility • Mesa (AZ)

Hybrid
USD 90,000 - 120,000
Teradata DBA
Teradata DBA

Next Level Business Services, Inc. • San Francisco (CA)

On-site
USD 130,000 - 160,000