Job Description

Combine two of the fastest-growing fields on the planet with a culture of performance, collaboration and opportunity and this is what you get. Leading edge technology in an industry that's improving the lives of millions. Here, innovation isn't about another gadget, it's about making health care data available wherever and whenever people need it, safely and reliably. There's no room for error. Join us and start doing your life's best work.(sm)

The successful candidate will be a key supporter of our Normative Health Information Data Warehouse and our Optum Labs Data Warehouse which support unique analytics efforts for research and innovation. Our NHI database, which is in Teradata, houses claims, membership, provider, and ancillary data for over 114 million unique members with data that dates back to 1993. NHI database provides data for research studies, physician rating/quality programs, pharmaceutical marketing, national scale benchmarks and norms. In addition, the successful candidate will support our Optum Labs Database in Netezza. Optum Labs databases support a unique combination of data, research analytics and innovation efforts. This Data Warehouse has evolved into a very visible asset for Optum and OptumInsight. Two major partners include the Mayo Clinic and AARP and 20 additional external partners leverage OptumLabs East (YALE, Harvard Med School, MIT, RPI, TUFTS, Brown, Johns Hopkins, BU School of Public Health).

Position in this functions may include database architecture, engineering, design, optimization, security, and administration; as well as data modeling, big data development, Extract, Transform, and Load (ETL) development, storage engineering, data warehousing, data provisioning and other similar roles. Responsibilities may include Platform-as-a-Service and Cloud solution with a focus on data stores and associated eco systems. Duties may include management of design services, providing sizing and configuration assistance, ensuring strict data quality, and performing needs assessments. Analyzes current business practices, processes and procedures as well as identifying future business opportunities for leveraging data storage and retrieval system capabilities. Manages relationships with software and hardware vendors to understand the potential architectural impact of different vendor strategies and data acquisition. May design schemas, write SQL or other data markup scripting and helps to support development of Analytics and Applications that build on top of data. Selects, develops and evaluates personnel to ensure the efficient operation of the function.

Primary Responsibilities:

• Analyzes and investigates
• Provides explanations and interpretations within area of expertise
• Actively participate in all phases of project development life cycle including database policies, procedures, standards and supporting documentation, database design and build, process flow analysis, development, benchmark analysis, performance/tuning, capacity planning, and production implementation
• Production support responsibilities include maximizing system availability, ensuring swift and complete database recovery, optimizing database and availability through ongoing maintenance, and ensure conformance to audit and operating standards
• Proactively monitor Teradata workload and engage internal/external teams as appropriate to resolve errors/failures/throughput bottleneck
• Execute Change Tasks including but not limited to security provisioning, schema creation, DB role creation, DDL execution, data restoration etc
• Assist Application Developers and testers with reengineering / deploying code from Infrastructure Support standpoint
• Implementation experience in Teradata version upgrade, migrations with hands-on exposure to all DBA functions
• Review workload and provide recommendations for performance optimization and operational efficiency
• Define / manage overall Data standards and specifications for the entire DWH for Teradata
• Create / modify Data Model (Logical & Physical) in place of the current industry standards taking customer predefined Enterprise standards into consideration by following all the best practices
• Implement all necessary performance related aspects in Data Model
• Identify, trouble shoot and resolve issues/backlogs related to slow/failed/abended jobs
• Proactively monitor capacity based on current utilization and upcoming usage guestimate projections working with System DBAs
• Document and advise developers and end-users about best practices and housekeeping
• Be able to identify & resolve performance bottlenecks
• Ensure overall system stability, reliability, and manageability
• Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so

Eligibility
To apply to an internal job, employees must meet the following criteria:

• Minimum duration of 12 months of continuous service in their current grade and position
• Employees may choose to apply for any of the following: Positions within same grade or Positions at one grade higher than their current position
• Performance rating in the last common review cycle of "Meets Expectations" or higher
• Not on any active CAP (Corrective Action Plan) or active disciplinary action

Required Qualifications:

• Undergraduate degree or equivalent experience
• 8+ years in Database modelling & Database technologies
• 7+ years working with Teradata DBMS
• Experience with Performance Tuning and Optimization, monitoring and troubleshooting
• Experience working with Teradata Utilities, also installing patch sets and upgrading Teradata with the latest version
• Expertise in database design
• Ability to write, understand, and optimize complex SQL

Preferred Qualification:

• Knowledge on Netezza, Python/Ansible

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)