Lead Database Administrator

Hiring: Lead Teradata DBALocation: Within 2 hours of Springfield, IL Only candidates with provenlead experiencewill be consideredPrimary ResponsibilitiesLeadership & Data GovernanceLead project work related to Teradata Database and data governanceCoordinate with teams and stakeholders to meet business, security, and reporting needsParticipate in agile development environments and large-scale DDI projectsSystem Administration & MaintenanceManage and maintain OnPrem Teradata systems including patches, upgrades, configurations, and hardware replacementsMonitor system health using Viewpoint and other tools; perform preventive and corrective actionsSupport disaster recovery (DR) planning, testing, and quarterly maintenanceCoordinate with vendors and subcontractors for system hardening and vulnerability remediationDatabase Operations & OptimizationPerform backup and recovery operations using BAR DSA and NetBackupMonitor and tune performance, capacity, and resource usage (CPU, I/O, Spool, Storage)Maintain workload management using TASM and Workload Manager partitionsAdminister access rights, role rights, priority scheduling, and security reportingDevelopment Support & GovernanceGuide developers on design and implementation best practices; review/approve database componentsSupport EDW users with query optimization, job handling, and data integrity issuesMaintain and administer OpenText BI-Query models and front-end toolsLead database-related meetings and deliverables with minimal supervisionReporting & ComplianceGenerate and maintain capacity and performance reportsSupport internal and external audits; address risks and vulnerabilities proactivelyCommunicate system alerts, risks, and status updates to stakeholdersEnsure compliance with security evaluation frameworksFunctional DescriptionThe Sr. Lead DBA is responsible for the overall database delivery of the Enterprise Data Warehouse, including application and system tasks. This role requires expertise in Medicaid data, data governance, security, hardware/software support, Teradata configuration, and performance optimization. The DBA must be capable of both business-level data support and complex technical system upgrades and configurations. Responsibilities include analyzing business practices, identifying opportunities for data leverage, managing vendor relationships, designing schemas, writing SQL, and supporting analytics and applications.Required QualificationsBachelor's degree in related field or equivalent experience7+ years as a lead Teradata DBA (Version 15+) with application and system responsibilitiesExperience with on-premises Teradata 6800/1800 or IntelliFlex systemsExpert in SQL and Teradata utilities (FastLoad, Multiload, FastExport, BTEQ, TPT)Proven performance tuning experience in large databases (>5TB)Data governance and metadata management experienceHealthcare/Medicaid/Government or equivalent project experienceSystem administration knowledge (Windows/Linux)Demonstrated leadership in presentations, capacity planning, and performance managementExperience in large DDI projectsStrong communication, client-facing, and mentoring skillsPreferred QualificationsTeradata Vantage Certified MasterData modeling experience (Erwin or similar)Experience with OpenText BI-Query and metadata managementFamiliarity with Medicaid/Medicare/Healthcare applicationsAgile environment experience (Scrum, DevOps, GitHub)Application server administrationETL development or data analysis experienceCloud migration experience (Snowflake, Azure)Willingness to travel monthly/quarterly or as neededNo visa sponsorship requiredLocated within two hours of Springfield, IL