Teradata/Oracle DBA Job at Akaasa Technologies, Remote

  • Akaasa Technologies
  • Remote

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.

Job Tags

Permanent employment, Temporary work, Work at office, Local area, Remote work

Similar Jobs

International SOS Government Medical Services

Paramedic Job at International SOS Government Medical Services

 ...environments while collaborating with multidisciplinary healthcare teams. Qualifications Requirements Current unrestricted Paramedic license. Current BLS and ACLS certifications; advanced trauma certification such as PHTLS, ITLS, or TCCC required. Graduate... 

Tru by Hilton Port St. Lucie

Hotel Housekeeper Job at Tru by Hilton Port St. Lucie

Housekeeper Tru by Hilton Port St. Lucie, FL Do you love making spaces sparkle? Are you detail-oriented, reliable, and take pride...  ...tasks and walkthroughs with management Helping keep the hotel looking its best for every guest What Were Looking For... 

The Cigna Group

Remote Part Time Inpatient Telephonic Staff Pharmacist (Evenings / Overnight) Job at The Cigna Group

 ...The remote, work from home part-time staff pharmacist provides telepharmacy services to multiple hospital clients across various states. This role enhances clinical team performance, supports quality patient care, and ensures safe and compliant medication practices. This... 

Ross Stores

Area Loss Prevention Manager (ALPM) - Nationwide Job at Ross Stores

 ...learning opportunities and development for our teams. GENERAL PURPOSE Ross is always looking for qualified talent for our Area Loss Prevention Manager roles across the Nation, to express your interest please apply to this Evergreen Requisition. An Evergreen Requisition... 

United Methodist Communications

Faculty Position in Ethics (Open Rank) Job at United Methodist Communications

Candler School of Theology, Emory UniversityAtlanta, Georgia 30322Full Time , On-SiteEmory Universitys Candler School of Theology invites applications and nominations for a tenured or tenure-track faculty position in Ethics. Rank is open. The successful candidate...