Oracle /Terradata DBA

Yoh,-A-Day-; Dallas (TX); On-site; USD 63,000 - 90,000; Full time

Benefits offered by this job

Medical benefits

Retirement savings plan

Job summary

Yoh, a Day & Zimmermann company, seeks an Oracle/Terradata DBA for a Dallas-based on-site W2 role. Responsibilities cover Teradata Exadata and Oracle RAC upgrades, performance tuning, and DR planning.

You will tune SQL, manage RAC/ Teradata governance, automate tasks with Shell/Python/SQL, and work with ETL/BI teams to meet strict SLAs. Local candidates only; no agency involvement.

Qualifications

• Teradata DBA experience (Vantage, workload tuning).
• Oracle DBA experience with Exadata and RAC.
• SQL tuning, indexing and partitioning for large DW.
• Backup/HA/DR architecture and compliance support.
• Scripting: Shell, Python, SQL.
• Linux/Unix administration exposure.

Responsibilities

• Install, configure, patch, and upgrade Teradata, Exadata, and 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/Recovery

Scripting

Linux/Unix

Job description

Oracle/Terradata DBA

Dallas Locals only

W2 role, No Agency candidates allowed

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.

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.

Estimated Min Rate: $45.50

Estimated Max Rate: $65.00

What’s In It for You?

We welcome you to be a part of the largest and legendary global staffing companies to meet your career aspirations. Yoh’s network of client companies has been employing professionals like you for over 65 years in the U.S., UK and Canada. Join Yoh’s extensive talent community that will provide you with access to Yoh’s vast network of opportunities and gain access to this exclusive opportunity available to you. Benefit eligibility is in accordance with applicable laws and client requirements. Benefits include:

• Medical, Prescription, Dental & Vision Benefits (for employees working 20+ hours per week)
• Health Savings Account (HSA) (for employees working 20+ hours per week)
• Life & Disability Insurance (for employees working 20+ hours per week)
• MetLife Voluntary Benefits
• Employee Assistance Program (EAP)
• 401K Retirement Savings Plan
• Direct Deposit & weekly epayroll
• Referral Bonus Programs
• Certification and training opportunities

Note: Any pay ranges displayed are estimations. Actual pay is determined by an applicant's experience, technical expertise, and other qualifications as listed in the job description. All qualified applicants are welcome to apply.

Yoh, a Day & Zimmermann company, is an Equal Opportunity Employer.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Visit https://www.yoh.com/applicants-with-disabilities to contact us if you are an individual with a disability and require accommodation in the application process.

For California applicants, qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. All of the material job duties described in this posting are job duties for which a criminal history may have a direct, adverse, and negative relationship potentially resulting in the withdrawal of a conditional offer of employment.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Stay Safe During Your Job Search

Fraudulent recruiting communications have become increasingly common. Emails from Yoh recruiters will only come from an @yoh.com email address. Yoh will never ask candidates to pay fees, purchase equipment, send gift cards, or transfer funds as part of the recruiting or hiring process. If you receive a communication that appears suspicious or requests payment, contact Yoh directly before responding or sharing personal information.