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).

Primary Responsibilities:

• 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

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)

#Netezza,Python/Ansible #DataEngineering #DataEngineeringConsultant