Senior Data Engineering Consultant – Oracle or SQL

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. Here, you will find a culture guided by diversity and inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health equity on a global scale. Join us to start Caring. Connecting. Growing together

Functional Description: 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 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. 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.

General Profile:

• Impact of work is most often at the operational or local business unit or market level. 
• Owns end-to-end processes 
• Develops functional, market level, and/or site strategy, plans, production and/or organizational priorities 
• Identifies and resolves technical, operational and organizational problems outside own team
• Product, service or process decisions are most likely to impact entire functions and/or customer accounts (internal or external) 

Primary Responsibilities:

• Work as a team member of 4-6 DBA’s, including focus on Oracle and MS SQL 
• Uphold enterprise policy guidelines and implement new/improved guidelines for the DBA team 
• Partner with project teams and interact with developers and customers to find solutions for projects and operational issues for existing and proposed databases 
• Act as data liaison serving as primary point of contact between application business segments 
• Ability to detect and troubleshoot database server related CPU, memory, I/O, disk space and other resource contention 
• SQL Development – ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints) 
• Responsible to document, implement, and execute disaster recovery plans as needed 
• 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:

• Minimum educational background/experience to include undergraduate degree or equivalent experience Job
• 7+ years of experience as DBA on one or more database platform (MS SQL, Oracle) 
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, and security issues 
• Experience in Performance Tuning using platform specific tools 
• Expert experience in implementing operational automation 
• Demonstrates advanced level of understanding and application of database concepts and their integration with business problem solving skills 
• Expert knowledge of backups, restores, recovery models, database storage operations, Clustering, Database mirroring, Replication 
• Expert knowledge of how to use indexes, index management, integrity checks, configuration, patching, how indexes are stored, how they can be created and managed effectively 
• Solid acquaintance with windows and UNIX server, security delegation, storage components 
  Documentation skills for processes and procedures (creating KBs, runbooks, topology)

Preferred Qualifications:

• Healthcare related experience 
• High volume, transaction processing background with claims, billing, EDI, or Healthcare Insurance systems development experience 
• Experience with planning, organizing and leading database projects and initiative on multiple platform types of Microsoft SQL and/or Oracle 
• Broad understanding of company business issues and their integration with broad and complex information systems applications

At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone – of every race, gender, sexuality, age, location and income – deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes – an enterprise priority reflected in our mission.