Talent.com
Senior Lead Teradata Database Administrator - DBA

Senior Lead Teradata Database Administrator - DBA

OptumSpringfield, IL, United States
job_description.job_card.variable_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.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.

    serp_jobs.job_alerts.create_a_job

    Database Administrator • Springfield, IL, United States

    Job_description.internal_linking.related_jobs
    • serp_jobs.job_card.promoted
    Senior Lead Teradata Database Administrator - DBA (Springfield)

    Senior Lead Teradata Database Administrator - DBA (Springfield)

    OptumSpringfield, IL, US
    serp_jobs.job_card.full_time +1
    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 connect...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    IT Manager / Engagement Lead for Enterprise Data

    IT Manager / Engagement Lead for Enterprise Data

    Horace MannSpringfield, IL, US
    serp_jobs.job_card.full_time
    IT Manager / Engagement Lead for Enterprise Data.Horace Mann is seeking an experienced and strategic IT manager / engagement lead for enterprise data to assist with coordinating across multiple teams.T...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Project Manager (Data Analytics)

    Project Manager (Data Analytics)

    DATAMAXISSpringfield, IL, US
    serp_jobs.job_card.full_time
    Data Analytics Project Manager.As a Project Manager in Data Analytics, you'll lead strategic initiatives including implementation and operations that make healthcare data accessible, secure, and ac...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    Microsoft Dynamics 365 Senior Solution Architect

    Microsoft Dynamics 365 Senior Solution Architect

    Stellent IT LLCSpringfield, IL, United States
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Title : Dynamics 365 Consultant (solutions architect or senior developer with architecture experience.Duration : 12+ months Location : Hybrid in Springfield, Illinois <...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    Crypto-Native UX Researcher (Remote - Global - Non-US)

    Crypto-Native UX Researcher (Remote - Global - Non-US)

    Token MetricsAthens, Illinois, United States, 62613
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time
    Crypto-Native UX Researcher (Remote - Global - Non-US).At Token Metrics, were revolutionizing crypto investing by providing data-driven insights, analytics, and tools to empower traders, investors,...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    UAT Test Lead (Consulting)

    UAT Test Lead (Consulting)

    Edwards Lifesciences BelgiumSpringfield, IL, United States
    serp_jobs.job_card.full_time
    SolomonEdwardsGroup, LLC (SolomonEdwards) is a full-service professional services firm offering financial, operational, and technology consulting and operations support. We work with some of the wor...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    DB2 / SQL Analyst - Information Systems Technician I

    DB2 / SQL Analyst - Information Systems Technician I

    Illinois Secretary of StateSpringfield, IL, US
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.quick_apply
    Office of the Illinois Secretary of State Alexi Giannoulias Job Title : .Information Systems Technician I – DB2 / SQL Analyst Division : Data Center Services Union : &#...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Chief Data Officer (Data Systems Administrator)

    Chief Data Officer (Data Systems Administrator)

    Illinois Secretary of StateSpringfield, IL, US
    serp_jobs.job_card.full_time
    Chief Data Officer (Data Systems Administrator).Office of the Illinois Secretary of State, Alexi Giannoulias.Springfield, IL - Sangamon County. Salary : Range $6,904 to $13,522 monthly commensurate ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior IT Director, Data Management and Architecture

    Senior IT Director, Data Management and Architecture

    ZenithSpringfield, IL, US
    serp_jobs.job_card.full_time
    Senior IT Director, Data Management and Architecture.Under broad, general supervision provides vision, strategy, leadership, planning and management for Zenith's data architecture.The position will...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    Mainframe Senior z\OS Administrator ISA II

    Mainframe Senior z\OS Administrator ISA II

    Illinois Secretary of StateSpringfield, IL, US
    serp_jobs.job_card.full_time
    serp_jobs.filters_job_card.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 : &...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Solution Architect

    Solution Architect

    TradeJobsWorkForce62515 Buffalo, IL, US
    serp_jobs.job_card.full_time
    Solution Architect Job Duties : Responsible for assisting in the establishment of an IT Architect...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Analyst - Earn Up to $37 / hr

    Analyst - Earn Up to $37 / hr

    TradeJobsWorkforce62515 Buffalo, IL, US
    serp_jobs.job_card.full_time
    ESSENTIAL JOB FUNCTIONS Analyzes global markets for IT Services, servers, storage, backup, IT security, productivity software, remote monitoring services, hyperconvergence and IoT.Studies SMB and m...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    PayPal Risk Operations Associate

    PayPal Risk Operations Associate

    TradeJobsWorkforce62515 Buffalo, IL, US
    serp_jobs.job_card.full_time
    Bring your energy to the role of PayPal Risk Operations Associate to perform responsibilities as a Risk Operations Associate. Deliver outstanding service to customers and colleagues.Deliver outstand...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Data Systems Manager - Project Management

    Data Systems Manager - Project Management

    Illinois Secretary of StateSpringfield, IL, US
    serp_jobs.job_card.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...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Netflix Data Analyst

    Netflix Data Analyst

    TradeJobsWorkforce62515 Buffalo, IL, US
    serp_jobs.job_card.full_time
    Make an impact in the role of Netflix Data Analyst to analyze viewer data to guide content decisions.Ensure all safety and quality standards are met. Work closely with your team to maintain high per...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Lead Data Analyst

    Lead Data Analyst

    Robert HalfSherman, IL, US
    serp_jobs.job_card.full_time
    We are looking for a highly skilled Lead Data Analyst.In this long-term contract position, you will play a pivotal role in driving data analytics initiatives, translating complex business requireme...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    PayPal Fraud Analyst

    PayPal Fraud Analyst

    TradeJobsWorkforce62515 Buffalo, IL, US
    serp_jobs.job_card.full_time
    Be part of our success story as a PayPal Fraud Analyst to review transactions and identify suspicious activity.Work with your team to maintain efficiency and high standards.Stay adaptable to changi...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    MULTI-UNIT LEADER

    MULTI-UNIT LEADER

    SonicTaylorville, IL, US
    serp_jobs.job_card.full_time
    Work closely with the restaurant level managers, crew, as well as the Director of Operations to ensure overall goals and standards are being met in the areas of customer service, financial results,...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30