Remote Teradata & Oracle DBA - DW Performance Lead

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

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.