WeAreDevelopers Logo WeAreDevelopers
Sign in
For You LIVE
Back

Teradata/Oracle DBA

Ibotix Us Inc.
Houston, TX, United States
2 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Job source
www.dice.com

Tech stack

Third Normal Form Bash Shell Big Data Extract Transform Load (ETL) Oracle Exadata Failover Python (Programming Language) Lightweight Directory Access Protocols (LDAP) Oracle Databases Oracle Rac Performance Tuning Role-Based Access Control
+9 more
Standard Sql SQL Databases Teradata SQL User Provisioning Software Scripting Snowflake Concurrency Indexer Sql Tuning

Job description

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

Requirements

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

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…