Senior Teradata DBA - System Database Administrator - Springfield, IL

company banner
UnitedHealth Group
Data Warehouse, Teradata, Manager, DBA, Disaster Recovery, SQL, Database, Linux, Application, Hardware, Software, Windows, IBM, Tivoli
Full Time
Work from home not available Travel not required

Job Description

Primary Responsibilities:

  • Developing and analyzing highly complex system standards, thresholds, and recommendations to maximize system performance
  • Evaluating products and upgrades for appropriateness and lead the implementation and upgrade strategies
  • Creating / Modifying the database tables, views, or other database objects to support the projects and change requests that impact the Data Warehouse
  • Supporting Teradata patch and upgrades collaborating with Teradata team and interfacing with the application sub vendors
  • Supporting backup and restore/retrieval process - using the BAR DSA and NetBackup. Create, implement, and maintain BAR strategy for the Teradata (TD) application and system databases
  • Maintaining rules set in TASM and supporting workload management. Maintaining the Teradata Workload Manager with the proper partitions and workloads based on Service Levels
  • Maintaining Teradata Query manager to automate many of the DBA tasks such as collection of statistics, monitoring spool space, candidate tables for purge, etc
  • Supporting the database system and application server support for the Disaster Recovery (DR) build/test, annual drill, and quarterly maintenance as needed
  • Performing Teradata SQL troubleshooting and fine tuning of scripts
  • Supporting database or system issues reported by Helpdesk or business users
  • Actively monitoring the health of the Teradata system and Teradata Managed Servers (TMS) using Viewpoint and other tools and application servers and make preventive or corrective actions as needed
  • Maintaining access rights, role rights, priority scheduling, and reporting using dynamic workload manager, Database Query Log (DBQL), usage collections and reporting of ResUsage, AmpUsage, security administration etc.
  • Supporting remote logging process and maintaining the logs
  • Supporting data needs using QueryGrid 2.0
  • Coordinating with the team and customers in supporting database needs and make necessary changes to meet the business, contractual, security, performance, and reporting needs
  • Supporting internal or external audit process and address vulnerabilities or risk proactively. Prepare and support IRS audit
  • Coordinating with Teradata to perform Teradata system hardening and delivery SCSEM Reports as needed addressing issues in the hardening and vulnerability scan report
  • Generating and maintaining capacity management, Space, and CPU reports on analyzing the Spool, CPU, I/O, Usage, and Storage resources and proactive monitoring to meet performance and growth requirements
  • Reviewing and resolving Teradata alerts and communicate any risk / issues or impact to the management, team, and business users through appropriate communication strategy
  • Creating Teradata incident on issues, tracking using TAYS, setting appropriate priorities, monitoring and controlling, and work with Teradata to resolve the issues promptly
  • Providing weekly status update and update the weekly status report with the summary of database related activities including maintenance and issues
  • Analyzing project requirements and develop detailed specifications for new and existing data warehouse database related requirements
  • Reviewing and validating the database related test scenarios and results and incorporating extensive knowledge of the Agency's business rules
  • Developing or acquiring test data and initiate tests to determine the accuracy of database logic to produce desired results
  • Communicating effectively, verbally and in writing, with programmers, analysts, immediate supervisor, management, system users, operations, other State agencies and the private sector
  • Meeting with users for clarification and elaboration as may be necessary to clearly define a problem and conceptualize a development plan. Recognize, gather, correlate, and analyze facts, draw conclusions, define problems, and devise solutions and alternatives and make appropriate recommendations
  • Working with the team and data modelers, facilitate modification of the logical design to create a physical design most suited to the business needs of the customer
  • Working with developers and Enterprise Data Warehouse (EDW) team to create and maintain database standards

Required Qualifications:

  • Bachelor's degree or equivalent work experience
  • 5+ years of experience as a Teradata DBA on Version 14+
  • 5+ years of SQL experience
  • 3+ years ETL using Teradata Utilities in a Unix/Linux environment
  • 3+ years performance tuning in a large database (>5TB) or data warehouse environment, using advanced SQL, DBQL and Explain plans
  • 3+ years analyzing project requirements and developing detailed database specifications
  • 3+ years identifying and initiating resolutions to customer problems and concerns associated with a Data Warehouse or equivalent system

Preferred Qualfications:

  • 5+ years logical and physical data modeling experience
  • 5+ years with Erwin or other data modeling software
  • 3+ years working with end users/customers to understand requirements for technical solutions to meet business needs
  • 3+ years working with technical developers to strategize solutions to align with business requirements
  • 3+ years defining standards and best practices and conducting code reviews
  • Experience in Application Server Hardware/Software Administration (Windows/Linux)
  • Experience with State Medicaid / Medicare / Healthcare applications
  • Experience in SharePoint
  • Knowledge in ETL process, Unix, and Windows Scripting
  • Knowledge/Experience in Agile
  • Excellent verbal/written communication, end client facing, team collaboration, and mentoring skills
  • Ability to proactively learn and support overall system administration, support hardware/software maintenance, and leading data management activities
  • Training developers in how best to design queries for a specific database
  • Working with lead / management, business users, SMEs/BA, developers, application administrators, architect/modelers, and coordinating with hardware / software sub vendors
  • Installing, configuring and administering Microsoft SQL Server on Windows Server
  • Performing application servers backups and recovery using Veritas Backup Exec 2012/above
  • Analyzing IBM Tivoli logs and responds to alerts and errors
  • Monitoring of SAN storage with the knowledge and ability to react to alerts and errors
  • Configuring and managing HP MSA Storage arrays
  • Installing, configuring and administering Windows Server 2008 R2 or higher platforms on HP DLT Servers

Careers with Optum. Here's the idea. We built an entire organization around one giant objective; make health care work better for everyone. So when it comes to how we use the world?s large accumulation of health-related information, or guide health and lifestyle choices or manage pharmacy benefits for millions, our first goal is to leap beyond the status quo and uncover new ways to serve. Optum, part of the UnitedHealth Group family of businesses, brings together some of the greatest minds and most advanced ideas on where health care has to go in order to reach its fullest potential. For you, that means working on high performance teams against sophisticated challenges that matter. Optum, incredible ideas in one incredible company and a singular opportunity to do your life's best work.(sm)

Diversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.

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

Job Keywords: Teradata, DBA, SQL, Springfield, IL, Illinois

Company Information

We have modest goals: Improve the lives of others. Change the landscape of health care forever. Leave the world a better place than we found it. Such aspirations tend to attract a certain type of person. Crazy talented. Compassionate. Driven. To these individuals, we offer the global reach, resources and can-do culture of a Fortune 14 company. We provide an environment where you’re empowered to be your best. We encourage you to take risks and in return, offer a world of rewards and benefits for performance. Exceeding your limits is an exceptional start to your life's best work.(SM) Just like you, we are driven by a set of fundamental principles that are guiding our way forward. Our values of integrity, compassion, relationships, innovation, and performance serve as a foundation to transform health care. Are you in? Learn more about your future at UnitedHealth Group at
Dice Id : uhgbot
Position Id : 831996
Originally Posted : 7 months ago

Similar Positions at UnitedHealth Group

SQL Server DBA - San Antonio, TX
  • San Antonio, TX
  • 11 hours ago
Sr. DevOps System Engineer
  • Chicago, IL
  • 11 hours ago
Sr. DevOps System Engineer
  • San Francisco, CA
  • 11 hours ago
Sr. DevOps System Engineer
  • Washington, DC
  • 11 hours ago