Talent.com
Senior Lead Teradata Database Administrator - DBA

Senior Lead Teradata Database Administrator - DBA

OptumSpringfield, IL, United States
2 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

    Database Administrator • Springfield, IL, United States