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/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
