Senior Teradata Database Administrator / Remote

AB2 Consulting, Inc.
Springfield, IL

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.

Collaboration & Leadership

  • Coordinate with teams and customers to meet business, security, and reporting needs.
  • Mentor team members and share knowledge on backup and database operations.
  • Participate in agile development environments and large-scale DDI projects.

Required Qualifications:

  • Bachelor's degree or equivalent experience.
  • 7+ years as a lead Teradata DBA (Version 15+).
  • 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).
  • Experience in database specification development and issue resolution.
  • Excellent communication, client-facing, and mentoring skills.

Preferred Qualifications:

  • Teradata Vantage Certified Master.
  • Experience upgrading to IntelliFlex.
  • 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).
Posted 2025-09-16

Recommended Jobs

Maintenance Technician III (10:00pm to 6:30am) 3rd Shift

G&W Electric
Bolingbrook, IL

Maintenance Technician III In this role you will perform maintenance tasks of advanced complexity in support of production and facilities, coach and train others in performance of maint…

View Details
Posted 2025-08-06

Senior Commercial Real Estate Advisor

Sands Investment Group
Chicago, IL

Senior Commercial Real Estate Advisor Sands Investment Group (SIG), is officially accepting applications for an experienced and highly motivated Senior Commercial Real Estate Sales Advisor to join…

View Details
Posted 2025-09-01

Salesforce Technical Lead

Gallagher
Rolling Meadows, IL

Indulge your passion for problem-solving and embrace the thrill of addressing risk head-on at Gallagher's global brokerage team. Join a family of diverse minds, united by a relentless pursuit of …

View Details
Posted 2025-09-16

3rd Shift (10:30p-7:00a) Production Worker

Radiac Abrasives, Inc.
Salem, IL

Job Description Job Description For more than 100 years, Radiac has delivered industry leading technology and quality products and service to the metal finishing industry. Radiac is a TYROLIT Com…

View Details
Posted 2025-07-28

PCB Designer II

Grayhill Inc.
La Grange, IL

Job Description Job Description Grayhill designs and manufactures intuitive human interface solutions that make life simpler, safer and more efficient. Standard products include optical encoders…

View Details
Posted 2025-08-09

Produce Coordinator

Fresh Thyme Farmers Markets
Geneva, IL

If you’re someone who has a genuine desire to help people live better and healthier lives, join us as we work to be a trusted resource in our communities, offering real people, real food at real affo…

View Details
Posted 2025-08-19

Auto Claims Adjuster Trainee

First Chicago Insurance Company (FCIC)
Chicago, IL

Job Description Job Description Attention Recent and Upcoming College Grads! Are you ready to rev up your career? Join First Chicago Insurance Company as a Full-Time Auto Claims Adjuster Traine…

View Details
Posted 2025-08-30

Strategy& Pharma and Life Sciences Manager Save for Later Remove job

PwC
Chicago, IL

Job Title Strategy& Pharma and Life Sciences Manager Job Category Strategy Consulting Level Manager Specialty/Competency Corporate and Business Strategy Industry/Sector Pharma and Life Scien…

View Details
Posted 2025-08-15

Event Content Developer

C-Vision International Ltd.
Chicago, IL

Who Are We: C-Vision is a global company dedicated to helping the world's largest enterprises meet the challenges posed by a fast-moving, digital disruptive business environment. We are committed to …

View Details
Posted 2025-08-06

Full-Time Private Resort Housekeeper- Weekends

Urbana Country Club
Urbana, IL

Job Description Job Description Join Our Tradition of Excellence at Urbana Country Club At Urbana Country Club, hospitality is more than a service—it’s a legacy. We are currently seeking ded…

View Details
Posted 2025-07-30