Talent.com
Senior Lead Teradata Database Administrator - DBA
Senior Lead Teradata Database Administrator - DBAOptum • Springfield, IL, US
No longer accepting applications
Senior Lead Teradata Database Administrator - DBA

Senior Lead Teradata Database Administrator - DBA

Optum • Springfield, IL, US
23 days ago
Job type
  • Full-time
Job description

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best.

Location : Remote in the Springfield, Illinois area

The Database Administrator (DBA) is responsible for the delivery, performance, and maintenance of the Enterprise Data Warehouse (EDW) supporting the Medicaid agency. This role requires deep expertise in large healthcare data, Teradata systems, and database operations, including hardware / software support, security, and performance optimization.

Key Responsibilities

  • Manage and maintain on-prem Teradata systems, including patches, upgrades, and hardware replacements.
  • Perform database backup and recovery using BAR DSA and NetBackup.
  • Monitor system health and performance using Viewpoint and other tools; take proactive or corrective actions as needed.
  • Support Teradata workload management (TASM), access rights, and security administration.
  • Lead and support disaster recovery (DR) testing and maintenance.
  • Coordinate with Teradata and subcontractors for system hardening and SCSEM reporting.
  • Generate and maintain reports on capacity, CPU, I / O, and storage usage.
  • Review and resolve system alerts; communicate risks and issues to stakeholders.
  • Provide guidance to developers on database design, SQL optimization, and implementation best practices.
  • Support EDW users with issue resolution (e.g., job slowdowns, RI constraints, PPIs).
  • Maintain front-end tool (OpenText BI-Query) and associated models.
  • Participate in audits (IRS / internal) and address vulnerabilities.
  • Lead database-related meetings and projects; mentor team members.

Data Engineering Scope

  • Database architecture, design, optimization, and administration.
  • Data modeling, ETL development, and big data engineering.
  • Cloud and Platform-as-a-Service (PaaS) solutions focused on data ecosystems.
  • Ensure data quality, security, and compliance with business and contractual requirements.
  • Required Qualifications :

  • 7+ years of experience as a Teradata DBA on Version 15+ (preferably 17+) and experience leading Teradata major upgrade / floor sweep
  • 5+ years of experience as primary / lead DBA with solid leadership and presentation skills
  • 5+ years of experience writing complex SQL using SQL Assistant / Teradata Studio
  • 3+ years of experience with Teradata 6800 / 1800 system or IntelliFlex
  • 3+ years of experience extracting, loading, and transforming structured / unstructured data using Teradata Utilities (FastLoad, Multiload, FastExport, BTEQ, TPT) in a Unix / Linux environment
  • 3+ years of experience performance tuning in a large database (>
  • 5TB) or data warehouse environment, using advanced SQL, DBQL and Explain plans

  • 3+ years of experience analyzing project requirements and developing detailed database specifications, tasks, dependencies, and estimates
  • 3+ years of experience identifying and initiating resolutions to customer facing problems and concerns associated with a query or database related business need
  • Data warehouse or equivalent system experience
  • Demonstrated excellent verbal / written communication, end client facing, team collaboration, mentoring skills, and solid work ethics
  • Demonstrated solid culture fit through integrity, compassion, inclusion, relationships, innovation, and performance
  • Preferred Qualifications :

  • Certifications & Tools
  • Teradata Vantage Certified Master; experience with Erwin, OpenText BI-Query, and cloud platforms like Snowflake.

  • Technical Skills
  • Strong in data modeling, Teradata upgrades, application / server administration (Windows / Linux), and cloud migrations.

  • Project Experience
  • Background in large DDI projects, agile environments (Scrum, DevOps, GitHub), and healthcare systems (Medicaid / Medicare).

  • Collaboration & Governance
  • Skilled in resolving data issues, aligning technical solutions with business needs, and supporting governance, security, and audit processes.

  • All employees working remotely will be required to adhere to UnitedHealth Group's Telecommuter Policy
  • Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. In addition to your salary, we offer benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with us, you'll find a far-reaching choice of benefits and incentives. The salary for this role will range from $110,200 to $188,800 annually based on full-time employment. We comply with all minimum wage laws as applicable.

    UnitedHealth Group is an Equal Employment Opportunity employer under applicable law and qualified applicants will receive consideration for employment without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, or protected veteran status, or any other characteristic protected by local, state, or federal laws, rules, or regulations.

    UnitedHealth Group is a drug - free workplace. Candidates are required to pass a drug test before beginning employment.

    Create a job alert for this search

    Senior Database Administrator • Springfield, IL, US

    Related jobs
    Senior Cloud Engineer - Azure (ISAI)

    Senior Cloud Engineer - Azure (ISAI)

    Illinois Secretary of State • Springfield, IL, US
    Full-time
    Office of the Illinois Secretary of State.Senior Cloud Engineer (Azure) - Information Systems Advisor I.Union : .Dirksen Pkwy, Springfield, IL – S...Show more
    Last updated: 30+ days ago • Promoted
    Lead Maintenance Technician

    Lead Maintenance Technician

    Curaleaf • Litchfield, IL, US
    Full-time
    At Curaleaf, we're redefining the cannabis industry with a strong commitment to quality, expertise, and innovation.As a leading global cannabis provider, our brands—including Curaleaf, Se...Show more
    Last updated: 19 days ago • Promoted
    Mainframe CICS Senior Administrator (ISA II)

    Mainframe CICS Senior Administrator (ISA II)

    Illinois Secretary of State • Springfield, IL, US
    Full-time
    Quick Apply
    Office of the Illinois Secretary of State Alexi Giannoulias Job Title : .Information Systems Advisor II - Mainframe CICS Senior Administrator Division : Data Center Services Union : ...Show more
    Last updated: 30+ days ago
    Mainframe CICS Administrator (ISA I)

    Mainframe CICS Administrator (ISA I)

    Illinois Secretary of State • Springfield, IL, US
    Full-time
    Quick Apply
    Office of the Illinois Secretary of State Alexi Giannoulias Job Title : .Mainframe CICS Administrator (ISA I) Division : Data Center Services Union : &#...Show more
    Last updated: 30+ days ago
    Data Specialist / Product Information Management Processor

    Data Specialist / Product Information Management Processor

    United Community Bank • Auburn, IL, US
    Full-time
    United Community Bank is looking for a Data Specialist.Under the supervision of the Data Manager, the Data Specialist / PIM Processor is directly responsible for processing cash management files as w...Show more
    Last updated: 30+ days ago • Promoted
    Optometrist - Litchfield IL

    Optometrist - Litchfield IL

    MRG Exams • Irving, IL, US
    Full-time +1
    Veterans as part of the VA’s SHA process.This is a rewarding non-treating, non-determination role focused solely on assessments. Veterans' medical records through a secure web portal.Make a differen...Show more
    Last updated: 17 hours ago • Promoted • New!
    Chief Data Officer (Data Systems Administrator)

    Chief Data Officer (Data Systems Administrator)

    Illinois Secretary of State • Springfield, IL, US
    Full-time
    Quick Apply
    Office of the Illinois Secretary of State Alexi Giannoulias Job Title : .Chief Data Officer (Data Systems Administrator) Division : Administration Union : ...Show more
    Last updated: 30+ days ago
    Mainframe Senior z\OS Administrator ISA II

    Mainframe Senior z\OS Administrator ISA II

    Illinois Secretary of State • Springfield, IL, US
    Full-time
    Quick Apply
    Office of the Illinois Secretary of State Alexi Giannoulias Job Title : .Mainframe Senior z / OS Administrator (ISA II) Division : Systems and Programming Union : &...Show more
    Last updated: 30+ days ago
    Senior Manager, Data Center Construction

    Senior Manager, Data Center Construction

    Illinois Staffing • Springfield, IL, US
    Full-time
    Data Center Infrastructure Construction.The Data Center Infrastructure Construction team at Oracle Cloud Infrastructure is a dynamic group of professionals dedicated to delivering state-of-the-art ...Show more
    Last updated: 4 days ago • Promoted
    Information Systems Technician I - Data Center Services

    Information Systems Technician I - Data Center Services

    Illinois Secretary of State • Springfield, IL, US
    Full-time
    Office of the Illinois Secretary of State.Job Title : .Information Systems Technician I.Union : .Lo...Show more
    Last updated: 2 days ago • Promoted
    Mental Health Therapist

    Mental Health Therapist

    SonderMind Careers • Middletown, IL, US
    Full-time
    SonderMind is a leading mental health care platform revolutionizing therapy services by empowering licensed mental health therapists to deliver exceptional care with cutting-edge, AI-powered tools....Show more
    Last updated: 17 days ago • Promoted
    VP Enterprise Data Ecosystem

    VP Enterprise Data Ecosystem

    Illinois Staffing • Springfield, IL, US
    Full-time
    The VP Enterprise Data Platform will own the platform strategy for the core portfolio of enterprise data platforms.This will ensure the smooth delivery of data operations and consistent improvement...Show more
    Last updated: 4 days ago • Promoted
    Data Systems Manager - Project Management

    Data Systems Manager - Project Management

    Illinois Secretary of State • Springfield, IL, US
    Full-time
    Data Systems Manager Project Management.Division : Governance and Business Management.Location : 501 S Second St, Springfield, IL Sangamon County. Salary : Range $7,743 to $13,616 monthly commensura...Show more
    Last updated: 30+ days ago • Promoted
    Lab Services Alliance Director

    Lab Services Alliance Director

    Illinois Staffing • Springfield, IL, US
    Full-time
    Lab Services Alliance Director.Full Spectrum Lab Services from CBRE offers a professional suite of services to a variety of clients in the life sciences industry, including those in pharmaceuticals...Show more
    Last updated: 4 days ago • Promoted
    Hybrid BCBA (Board Certified Behavior Analyst)

    Hybrid BCBA (Board Certified Behavior Analyst)

    Lighthouse Autism Center • Springfield, IL, US
    Full-time
    At Lighthouse, we believe in ongoing progression in the field of ABA! We emphasize the importance of individualized, comprehensive treatment packages, and accomplish this through our collaborative ...Show more
    Last updated: 13 hours ago • Promoted • New!
    Data collector / Driver

    Data collector / Driver

    TSMG • Springfield, IL, US
    Full-time
    Terry Soot Management Group (TSMG) is a field data collection company founded in 2017 in Europe.We collect data where automation is not possible. We count features, take pictures, make videos, recor...Show more
    Last updated: 16 days ago • Promoted
    BSA / AML Analyst

    BSA / AML Analyst

    United Community Bank • Chatham, IL, US
    Full-time
    United Community Bank is looking for a BSA / AML Analyst.This position will monitor and / or investigate all potential suspicious activities as they relate to BSA / AML guidelines and regulations.This in...Show more
    Last updated: 29 days ago • Promoted
    Senior Director Colocation Infrastructure Construction Delivery-Data Centers

    Senior Director Colocation Infrastructure Construction Delivery-Data Centers

    Illinois Staffing • Springfield, IL, US
    Full-time
    Senior Director Of Colocation Infrastructure Construction Delivery.The Data Center Infrastructure Construction team at Oracle Cloud Infrastructure is a dynamic group of professionals dedicated to d...Show more
    Last updated: 4 days ago • Promoted