Teradata/Oracle DBA

Akaasa Technologies; United States; Remote; USD 120,000 - 190,000; Full time

Job summary

Akaasa Technologies is seeking a seasoned Teradata/Oracle DBA to support a remote, US-wide project. The role emphasizes data warehouse administration, performance tuning, security, and enterprise compliance in a complex BI environment.

You will install, configure, patch, and upgrade Teradata and Oracle Exadata/RAC components, tune SQL, manage backups, DR and HA, and collaborate with ETL/BI teams to deliver reliable analytics across DEV/QA/UAT/PROD with strict load-window SLAs.

Qualifications

• Strong Teradata DBA experience with Vantage, utilities, and 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).
• 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/DR

Scripting

Linux/Unix

Tools

Exadata

RAC

DBQL

AWR/ASH

Job description

Teradata/Oracle DBA

Location: Remote (San Francisco, CA; Arlington, VA; Denver, CO; Chicago, IL; Boston, MA; New York, NY; Houston, TX; Miami, FL; Los Angeles, CA; Seattle, WA; Dallas, TX; Minneapolis, MN; Birmingham, MI; Atlanta, GA; or Irvine, CA)
Duration: 6 10 months
Interview: In-person

Note:

• Must be local with DL copy
• Role is primarily remote, but candidates may be required to report to a local client office for ID verification during the project.
• LinkedIn with location and photo (before 2023)

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.

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.