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:
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.
...Siemens and the UA National Plumbers and Pipefitters Union operate under a Master Agreement regarding HVAC mechanical work, ensuring competitive wages, benefits, and pension. All candidates will either need to be a Union Member or if they have valid Trade experience,...
...: Howmet Aerospace , headquartered in Pittsburgh, Pennsylvania, is a leading global provider of advanced engineered solutions for the aerospace and transportation industries. The Company's primary businesses focus on jet engine components, aerospace fastening systems...
...information and services to our clients. As a Pricing Coordinator , you will be responsible for working with carriers to negotiate and set new rates, update... ...~ Hybrid work schedule (1-day a week working from home); laptop provided by OEC Group ~10-days PTO (Paid...
...Job Description Dakota Digital, Inc., a leading digital automotive gauge manufacturer, is looking for Wire and Cable Tester in our wires and cables production area. The ideal candidate is someone who likes to work with their hands, has exceptional attention to detail...
...Purpose: Greet and assist guests arriving and departing from the Hotel. Assist with loading and unloading of luggage into and from... ...# Reports suspicious people, behavior, and vehicles to Security # Ensures adherence to Code of Ethics SPECIFIC JOB KNOWLEDGE...