

Bourntec Solutions Inc
Sr. Lead Teradata Applications & Database Administration (DBA)
β - Featured Role | Apply direct with Data Freelance Hub
This role is for a Sr. Lead Teradata DBA, offering a 12-month remote contract (occasional onsite in Springfield, IL) at $60.00/hour. Requires 7+ years in Teradata, advanced SQL, healthcare experience, and leadership skills. Teradata Vantage certification preferred.
π - Country
United States
π± - Currency
$ USD
-
π° - Day rate
480
-
ποΈ - Date
October 16, 2025
π - Duration
More than 6 months
-
ποΈ - Location
Remote
-
π - Contract
1099 Contractor
-
π - Security
Unknown
-
π - Location detailed
Remote
-
π§ - Skills detailed
#GitHub #Linux #Migration #Data Warehouse #Compliance #FastLoad #Data Governance #BTEQ #Data Management #Data Modeling #Metadata #Cloud #Leadership #Scrum #Databases #Snowflake #BI (Business Intelligence) #ERWin #Server Administration #FastExport #Disaster Recovery #Database Administration #DevOps #"ETL (Extract #Transform #Load)" #Storage #Security #Data Access #Azure #SQL (Structured Query Language) #Data Analysis #MLOAD (MultiLoad) #Agile #DBA (Database Administrator) #EDW (Enterprise Data Warehouse) #Data Integrity #Teradata
Role description
Title: Sr. Lead Teradata DBALocation: Remote (occasional onsite in Springfield, IL)Duration: 12 months (extendable)
US citizens or GC holders only (no visa sponsorship) - Preferred.
Primary Responsibilities
Leadership & Data Governance
Lead projects involving Teradata Database administration and data governance.
Coordinate with internal teams and stakeholders to meet business, security, and reporting needs.
Participate in agile development and large-scale DDI projects.
System Administration & Maintenance
Manage and maintain on-premises Teradata systems (6800/1800 or IntelliFlex).
Perform patching, upgrades, configuration, and vulnerability resolution.
Monitor system health via Viewpoint and other tools; perform preventive/corrective actions.
Support disaster recovery planning, testing, and quarterly maintenance cycles.
Partner with Teradata and subcontractors for system hardening and remediation.
Database Operations & Optimization
Manage backup and recovery (BAR DSA, NetBackup).
Optimize system performance, capacity, and resource utilization (CPU, I/O, Spool, Storage).
Maintain workload management using TASM and Workload Manager partitions.
Administer access rights, roles, and security compliance.
Development Support & Governance
Guide developers on best practices in design and database implementation.
Support EDW users with query optimization, job performance, and data integrity.
Maintain OpenText BI-Query models and front-end tools.
Lead database-related meetings and ensure timely delivery of technical solutions.
Reporting & Compliance
Generate capacity and performance reports.
Support internal and IRS audits; proactively address risks and vulnerabilities.
Communicate system alerts, risks, and updates to business and technical stakeholders.
Ensure compliance with SCSEM and other security frameworks.
Functional Summary
The Sr. Lead Teradata DBA is a key leadership role responsible for the end-to-end database delivery and performance of the Enterprise Data Warehouse (EDW) for a Medicaid agency. The position combines technical depth in Teradata administration with a strong understanding of data governance, security, and performance optimization.
This role involves both strategic and hands-on responsibilities β from supporting business users with data access to leading major Teradata upgrades and configurations.
Required Qualifications
Bachelorβs degree in a related field or equivalent experience.
7+ years as a Lead Teradata DBA (v15+) handling both application and system-level responsibilities.
Experience with on-prem Teradata 6800/1800 or IntelliFlex systems.
Advanced SQL skills and proficiency in FastLoad, MultiLoad, FastExport, BTEQ, TPT utilities.
Proven experience with performance tuning in large databases (5TB+).
Strong background in data governance and metadata management.
Prior experience in Healthcare/Medicaid/Government projects.
Demonstrated leadership experience in capacity planning, client presentations, and performance management.
Experience in Large DDI projects, issue resolution, and specification development.
Excellent communication, mentoring, and client-facing skills.
Preferred Qualifications
Teradata Vantage Certified Master
Experience with Erwin or similar data modeling tools.
Proficiency with OpenText BI-Query, metadata management, and data governance.
Familiarity with Medicaid/Medicare/Healthcare applications.
Experience in Agile (Scrum, DevOps, GitHub) environments.
Application server administration (Windows/Linux).
ETL development or data analysis experience.
Cloud migration experience (e.g., Snowflake, Azure).
Based in or within 2 hours of Springfield, IL (preferred).
Job Type: Contract
Pay: From $60.00 per hour
Expected hours: 40 per week
Benefits:
401(k)
Dental insurance
Health insurance
Paid time off
Vision insurance
Work Location: Remote
Title: Sr. Lead Teradata DBALocation: Remote (occasional onsite in Springfield, IL)Duration: 12 months (extendable)
US citizens or GC holders only (no visa sponsorship) - Preferred.
Primary Responsibilities
Leadership & Data Governance
Lead projects involving Teradata Database administration and data governance.
Coordinate with internal teams and stakeholders to meet business, security, and reporting needs.
Participate in agile development and large-scale DDI projects.
System Administration & Maintenance
Manage and maintain on-premises Teradata systems (6800/1800 or IntelliFlex).
Perform patching, upgrades, configuration, and vulnerability resolution.
Monitor system health via Viewpoint and other tools; perform preventive/corrective actions.
Support disaster recovery planning, testing, and quarterly maintenance cycles.
Partner with Teradata and subcontractors for system hardening and remediation.
Database Operations & Optimization
Manage backup and recovery (BAR DSA, NetBackup).
Optimize system performance, capacity, and resource utilization (CPU, I/O, Spool, Storage).
Maintain workload management using TASM and Workload Manager partitions.
Administer access rights, roles, and security compliance.
Development Support & Governance
Guide developers on best practices in design and database implementation.
Support EDW users with query optimization, job performance, and data integrity.
Maintain OpenText BI-Query models and front-end tools.
Lead database-related meetings and ensure timely delivery of technical solutions.
Reporting & Compliance
Generate capacity and performance reports.
Support internal and IRS audits; proactively address risks and vulnerabilities.
Communicate system alerts, risks, and updates to business and technical stakeholders.
Ensure compliance with SCSEM and other security frameworks.
Functional Summary
The Sr. Lead Teradata DBA is a key leadership role responsible for the end-to-end database delivery and performance of the Enterprise Data Warehouse (EDW) for a Medicaid agency. The position combines technical depth in Teradata administration with a strong understanding of data governance, security, and performance optimization.
This role involves both strategic and hands-on responsibilities β from supporting business users with data access to leading major Teradata upgrades and configurations.
Required Qualifications
Bachelorβs degree in a related field or equivalent experience.
7+ years as a Lead Teradata DBA (v15+) handling both application and system-level responsibilities.
Experience with on-prem Teradata 6800/1800 or IntelliFlex systems.
Advanced SQL skills and proficiency in FastLoad, MultiLoad, FastExport, BTEQ, TPT utilities.
Proven experience with performance tuning in large databases (5TB+).
Strong background in data governance and metadata management.
Prior experience in Healthcare/Medicaid/Government projects.
Demonstrated leadership experience in capacity planning, client presentations, and performance management.
Experience in Large DDI projects, issue resolution, and specification development.
Excellent communication, mentoring, and client-facing skills.
Preferred Qualifications
Teradata Vantage Certified Master
Experience with Erwin or similar data modeling tools.
Proficiency with OpenText BI-Query, metadata management, and data governance.
Familiarity with Medicaid/Medicare/Healthcare applications.
Experience in Agile (Scrum, DevOps, GitHub) environments.
Application server administration (Windows/Linux).
ETL development or data analysis experience.
Cloud migration experience (e.g., Snowflake, Azure).
Based in or within 2 hours of Springfield, IL (preferred).
Job Type: Contract
Pay: From $60.00 per hour
Expected hours: 40 per week
Benefits:
401(k)
Dental insurance
Health insurance
Paid time off
Vision insurance
Work Location: Remote