Job Description

Job Description

Job Description

Sr. Lead Teradata DBA

• Remote (Must reside within two hours of Springfield, IL)
• Contract Type: 12-month contract, possibly open to contract-to-hire (CFH)
• Benefits included

We are seeking a Senior Lead Teradata DBA to support a large-scale Medicaid Enterprise Data Warehouse (EDW) initiative. This hybrid role combines systems administration and application-level DBA responsibilities, requiring deep expertise in Teradata environments, performance tuning, data governance, and Medicaid data operations.

The ideal candidate is a hands-on technical leader who can manage infrastructure, optimize database performance, and guide development teams on best practices. This is a mission-critical role supporting Medicaid data infrastructure, analytics, and compliance.

Key Responsibilities

Database Leadership & Governance

• Lead Teradata database initiatives, including upgrades, configuration, and data governance
• Collaborate with cross-functional teams to meet business, security, and reporting needs
• Participate in agile development cycles and large-scale DDI implementations

Systems Administration & Infrastructure Support

• Administer and maintain OnPrem Teradata systems (6800/1800 or IntelliFlex)
• Apply patches, upgrades, and hardware replacements; resolve vulnerabilities
• Monitor system health using Viewpoint and other tools; support DR planning and testing
• Coordinate with vendors and subcontractors for system hardening and compliance

Database Operations & Optimization

• Perform backup/recovery using BAR DSA and NetBackup
• Tune performance across CPU, I/O, Spool, and Storage
• Manage workload using TASM and Workload Manager partitions
• Administer access controls, role rights, and security protocols

Development Support & Application DBA Tasks

• Guide developers on schema design, query optimization, and job handling
• Review and approve database components for EDW applications
• Support OpenText BI-Query models and front-end tools
• Lead technical meetings and deliverables with minimal supervision

Reporting, Compliance & Audits

• Generate capacity and performance reports
• Support internal and IRS audits; proactively address risks
• Ensure compliance with SCSEM and other security frameworks
• Communicate system alerts and status updates to stakeholders

Required Qualifications

• Bachelor’s degree in a related field or equivalent experience
• 7+ years as a lead Teradata DBA (Version 15+) with both system and application responsibilities
• Experience with OnPrem Teradata systems (6800/1800 or IntelliFlex)
• Advanced SQL and Teradata utilities (FastLoad, Multiload, FastExport, BTEQ, TPT)
• Proven performance tuning in large databases (>5TB)
• Experience in data governance and metadata management
• Medicaid, healthcare, or government project experience
• Strong system administration skills (Windows/Linux)
• Demonstrated leadership in capacity planning, performance management, and client presentations
• Experience with large-scale DDI projects and issue resolution
• Excellent communication and mentoring skills

Preferred Qualifications

• Teradata Vantage Certified Master
• Data modeling experience (Erwin or similar)
• Experience with OpenText BI-Query and metadata tools
• Familiarity with Medicaid/Medicare applications
• Agile development experience (Scrum, DevOps, GitHub)
• ETL development or data analysis experience
• Cloud migration experience (Snowflake, Azure)
• Willingness to travel quarterly or as needed
• U.S. work authorization required
• Must reside within two hours of Springfield, IL

Job Tags

Similar Jobs