Quick overview
Job description
Job Title: Teradata/Oracle DBA
Work Location: San Francisco, CA/ Arlington, VA/Denver, CO/Chicago,IL/ Boston,MA/ NYC,NY/ Houston,TX/ Miami,FL/ Los Angeles,CA/ Seattle,WA/ Dallas,TX Minneapolis, MN/Atlanta, GA/Birmingham, MI or Irvine, CA(Hybrid)
Duration :: Long Term Contract
NOTE :: Candidates must attend an in-person interview or pick up their laptop at one of the client's offices.
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.
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- OP

Data Scientist, IntegrityRecently posted Auto Apply
Openai · San Francisco · Hybrid · Posted 20 Nov 2026 🇺🇸
SQLBackground ChecksCompliance+3Technology$265k - $380k/yr - AC

Sr CAD/GIS TechnicianRecently posted Auto Apply
Apex Companies · Phoenix · Hybrid · Posted 20 Nov 2026 🇺🇸
CADCivil 3DGISTechnologySalary not listed - AN

Staff+ Software Engineer, Capacity EngineeringRecently posted Auto Apply
Anthropic · San Francisco · Hybrid · Posted 20 Nov 2026 🇺🇸
SQLBigQueryCapacity Planning+12Technology$320k - $485k/yr - AN

Principal Engineer Capacity/ComputeRecently posted Auto Apply
Anthropic · Seattle · Hybrid · Posted 20 Nov 2026 🇺🇸
SQLBigQueryCapacity Planning+12Technology$320k - $485k/yr - AN

Principal Engineer Capacity/ComputeRecently posted Auto Apply
Anthropic · New York City · Hybrid · Posted 20 Nov 2026 🇺🇸
SQLBigQueryCapacity Planning+12Technology$320k - $485k/yr - AN

Principal Engineer Capacity/ComputeRecently posted Auto Apply
Anthropic · San Francisco · Hybrid · Posted 20 Nov 2026 🇺🇸
SQLBigQueryCapacity Planning+12Technology$320k - $485k/yr - AL

Flight Software EngineerRecently posted Auto Apply
Albedo · Broomfield · Hybrid · Posted 19 Nov 2026 🇺🇸
RecruitingLuaRust+7Technology$116k - $135k/yr - AI

Forward Deployed Software Engineer, Connected Warfare (Active Clearance)Recently posted Auto Apply
Anduril Industries · Washington · Hybrid · Posted 20 Nov 2026 🇺🇸
Talent AcquisitionRustAWS+12Technology$166k - $253k/yr - AI

Senior EMC Systems Engineer, Air Dominance and StrikeRecently posted Auto Apply
Anduril Industries · Costa Mesa · Hybrid · Posted 20 Nov 2026 🇺🇸
Talent AcquisitionAssemblyCompliance+6TechnologySalary not listed - AI

EMC Systems Engineer, Air Dominance and StrikeRecently posted Auto Apply
Anduril Industries · Costa Mesa · Hybrid · Posted 20 Nov 2026 🇺🇸
Talent AcquisitionAssemblyCompliance+6Technology$132k - $175k/yr - AI

Senior Electrical System Test Engineer EMC, Air Dominance and StrikeRecently posted Auto Apply
Anduril Industries · Costa Mesa · Hybrid · Posted 20 Nov 2026 🇺🇸
Talent AcquisitionMATLABMicrosoft Office+10TechnologySalary not listed - AI

Radar Systems Engineer, Early CareerRecently posted Auto Apply
Anduril Industries · Costa Mesa · Hybrid · Posted 20 Nov 2026 🇺🇸
Talent AcquisitionComplianceComputer Vision+5TechnologySalary not listed
