Logo
Datamaxis

Lead Teradata Database Administrator

Datamaxis, Springfield, Illinois, us, 62777

Save Job

Leadership & Data Governance

Lead project work related to Teradata Database and data governance

Coordinate with teams and customers to meet business, security, and reporting needs

Participate in agile development environments and large‑scale DDI projects

System Administration & Maintenance

Manage and maintain OnPrem Teradata systems including patches, upgrades, and hardware replacements

Monitor system health using Viewpoint and other tools; perform preventive and corrective actions

Support disaster recovery (DR) planning, testing, and quarterly maintenance

Coordinate with Teradata and subcontractors for system hardening and vulnerability remediation

Database Operations & Optimization

Perform backup and recovery operations using BAR DSA and NetBackup

Monitor and tune performance, capacity, and resource usage (CPU, I/O, spool, storage)

Maintain workload management using TASM and Workload Manager partitions

Administer access rights, role rights, priority scheduling, and security reporting

Development Support & Governance

Guide developers on design and implementation best practices; review and approve database components

Support EDW users with query optimization, job handling, and data integrity issues

Maintain and administer OpenText BI‑Query models and front‑end tools

Lead database‑related meetings and deliverables with minimal supervision

Reporting & Compliance

Generate and maintain capacity and performance reports

Support internal and IRS audits; address risks and vulnerabilities proactively

Communicate system alerts, risks, and status updates to stakeholders

Ensure compliance with SCSEM and other security evaluation frameworks

Required Qualifications

7+ years as a lead Teradata DBA (Version 15+) with application and system responsibilities

Experience with on premises Teradata 6800/1800 or IntelliFlex systems

Expert in SQL skills and Teradata utilities (FastLoad, Multiload, FastExport, BTEQ, TPT)

Proven performance tuning experience in large databases (>5TB)

Data governance experience and supporting metadata management

Healthcare/Medicaid/Government or equivalent project experience

System administration knowledge/experience (in addition to application DBA and SQL expertise)

Lead experience with clear demonstration of leadership tasks like presentation to customers, capacity planning, and performance management

Large Design Development and Implementation (DDI) project experience

Experience in database specification development and issue resolution

Excellent communication, client‑facing, and mentoring skills

Preferred Qualifications

Teradata Vantage Certified Master

Data modeling experience (Erwin or similar)

Experience with OpenText BI‑Query, metadata management, and data governance

Familiarity with Medicaid/Medicare/Healthcare applications

Experience in agile environments (Scrum, DevOps, GitHub)

Application server administration (Windows/Linux)

Open Text BI Query admin

Data modeling experience

ETL development knowledge/experience or data analysis experience

Cloud migration experience (especially related to Snowflake, Azure)

Central region or willingness to travel monthly/quarterly or on an as‑needed basis

No visa sponsorship required

Located within two hours of Springfield, IL

#J-18808-Ljbffr