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
