Senior Lead Teradata Database Administrator (DBA)

More Information & Apply

Senior Lead Teradata Database Administrator (DBA)

Hybrid / Onsite Support | Contract

Contract Details

  • Engagement Type: Contract
  • Duration: Long‑term contract (extensions expected based on performance)
  • Work Location: Springfield, IL (candidates must be local or within two hours driving distance)
  • Onsite Expectation: Regular onsite presence as needed, driven by system operations, maintenance, upgrades, audits, and disaster‑recovery activities. This role does not operate on a fixed weekly onsite schedule and requires flexibility based on operational needs.
  • Schedule: May require occasional evening or weekend support for maintenance
  • Benefits Available: Medical, Dental, Vision

Role Overview

We are seeking a Senior Lead Teradata Database Administrator (DBA) to support a large‑scale Enterprise Data Warehouse (EDW) environment within a highly regulated domain. This is a senior, hands‑on role responsible for the stability, performance, security, and ongoing optimization of an on‑prem Teradata platform.
The ideal candidate has deep Teradata expertise, experience supporting mission‑critical data platforms, and the leadership skills needed to guide developers and junior DBAs while ensuring audit‑ready operations.

Key Responsibilities

  • Manage and maintain on‑prem Teradata hardware and software, including patches, upgrades, and break‑fix support
  • Monitor system health, capacity, CPU, I/O, and storage utilization
  • Execute backup and recovery operations using BAR DSA and NetBackup
  • Perform proactive performance tuning and capacity planning
  • Maintain workload management using TASM and Teradata Workload Manager
  • Support Disaster Recovery (DR) builds, testing, annual drills, and maintenance activities
  • Manage access control, DBQL, usage reporting, and security administration
  • Review and approve database objects (tables, views, SQL, stored procedures)
  • Provide day‑to‑day production support for EDW users and system alerts
  • Support internal and external audits, vulnerability remediation, and system hardening
  • Coordinate with vendors and internal teams to meet operational and compliance requirements
  • Produce system status reporting, future roadmap planning, and operational documentation
  • Lead database initiatives and mentor team members
  • Maintain and support OpenText BI‑Query front‑end tools and models

Required Qualifications

  • Bachelor’s degree or equivalent work experience
  • 5+ years as a primary or lead DBA in enterprise environments
  • 7+ years of Teradata DBA experience (v15+, preferably v17+) including major upgrades
  • Experience with Teradata 6800/1800 systems or IntelliFlex
  • Strong expertise writing and tuning complex SQL
  • Experience with Teradata utilities (FastLoad, MultiLoad, FastExport, BTEQ, TPT)
  • Proven success tuning large data warehouse environments (5TB+)
  • Strong communication and stakeholder‑support skills

Preferred Experience

  • Enterprise Data Warehouse (EDW) platforms
  • Healthcare, Medicaid, Medicare, or government data environments
  • Cloud databases such as Snowflake and on‑prem to cloud migrations
  • Logical and physical data modeling (Erwin or similar tools)
  • Experience with OpenText BI‑Query
  • Teradata Vantage Certified Master
  • Metadata management, data governance, and security best practices
  • Application server administration (Windows/Linux)
  • Agile / Scrum environments

Why This Opportunity

  • Senior, high‑visibility DBA role supporting a mission‑critical EDW
  • Long‑term contract stability with enterprise ownership
  • Work in a regulated, audit‑driven environment
  • Opportunity to lead, mentor, and influence platform direction
  • Contract benefits available (medical, dental, vision)


Powered by Avionté