Teradata/Oracle DBA
Full Time
Able to Sponsor
Remote
Depends on Experience
Fitment
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- TERADATA
- exadata
- Rac
Summary
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.
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: 91135807
- Position Id: 9141789
- Posted 1 hour ago
Company Info
About IBOTIX US Inc.
We make Next-Gen Agentic AI Products that help enterprises move from manual operations to intelligent, autonomous workflows. As a product-led AI business, we focus on driving real business outcomes like efficiency, cost savings, and faster decision-making.
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.