1+ months

Senior Teradata DBA - System Database Administrator - Springfield, IL

Springfield, IL 62701
Apply Now
Apply on the Company Site
  • Job Code
    831996

 

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

 

",
Posted: 2019-08-02 Expires: 2019-11-08

UnitedHealth Group is the most diversified health care company in the United States and a leader worldwide in helping people live healthier lives and helping to make the health system work better for everyone.

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Senior Teradata DBA - System Database Administrator - Springfield, IL

UnitedHealth Group
Springfield, IL 62701

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast