Senior Lead Teradata Database Administrator - DBA Job at Optum, Springfield, IL

a2tMcys3NVRuUysyRThxUW1FdWZlbFc1Z3c9PQ==
  • Optum
  • Springfield, IL

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.

Job Tags

Minimum wage, Full time, Work experience placement, For subcontractor, Local area, Remote work,

Similar Jobs

Roessel Joy

Marketing Coordinator Job at Roessel Joy

 ...Marketing / Content Coordinator: A well-established, growing company in the home improvement space is looking to add a Marketing / Content...  ...telling the companys story through visual content, blogs, and digital marketing efforts. What Youll Be Doing Create and... 

SIU Consultant Group

Data Entry Specialist Job at SIU Consultant Group

 ...This position is fully remote and suitable for individuals who can work independently and meet deadlines. Responsibilities...  ...experience required (training provided) Benefits Work from home / fully remote position Flexible working hours Easy and... 

Onward Search Education

School Nurse [80820] Job at Onward Search Education

 ...find top jobs with the nation's top schools. Were partnering with a school district in Essex County, MA to hire a dedicated School Nurse (RN or LPN). This role is a full-time assignment starting ASAP and involves supporting K-8 students in the school setting. The School... 

Guthrie

LPN Licensed Practical Nurse - RCF (Resident Care Facility) - Per Diem Job at Guthrie

 ...Practical Nurse required - Current BLSCPR Certification required Experience: - Entry level graduate of licensed practical nursing program...  ...contributing to resident status reports ie. Participating in shift report. 5. Documents on all resident care activities in an... 

PTR Global

UX Content Writer Job at PTR Global

Principle duties and responsibilities Provide content strategy to ensure relevant content is delivered contextually Collaborate on a content roadmap and conduct content audits Establish and maintain operational processes and procedures for managing content requests...