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)
Information is the lifeblood of the healthcare industry-everything depends on it. At Optum Insight Technology, you'll help us work on streamlining the flow of information between payers, healthcare providers and various other stakeholders to deliver the right insights to the right places at the right times, driving better outcomes for patients, reducing friction in the health system and lowering costs. Every day our work directly impacts the world for the better, in meaningful and profound ways.
We live in a time of unprecedented technical capability and possibility. Health care is at a pivotal point in this journey where even small gains can lead to major transformation. You could be a part of that - you have tremendous skill and the potential to make a lasting impact. Optum Insight Technology is uniquely positioned to bring your skills to bear on these pressing and life-changing technical challenges. The health care industry has an immediate need for your drive, innovation, passion and technical insight. Help us help the millions of people we serve each day. #OptumInsightTech
You'll enjoy the flexibility to telecommute* from anywhere within the U.S. as you take on some tough challenges.
Primary Responsibilities:

• All aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery
• Proficiency with network troubleshooting tools and techniques
• Responsible for evaluating patch releases from Postgres and patching requests from development, and communicating constraints, issues, and timelines for deployment
• Change management including maintenance of multiple development, test, QA, and production environments. Responsible for deploying approved changes to production
• 24x7 rotational on-call support, including driving Root Cause Analysis (RCA), preventative action follow-through, and participation in weekly operations reviews
• Proactive database monitoring and issue resolution
• Database and PL/SQL and PL/pgSQL optimization including performance tuning, query optimization and supportability; experience with Oracle 11g/12c and Postgres 11
• Actively participate and contribute to projects involving enterprise systems enhancements
• Participate in project design and Oracle database design decisions. Refine and troubleshoot the design
• Create and maintain appropriate documentation about the database and the data architecture
• Regular proactive capacity planning and tending reviews of all oracle databases. Producing weekly, monthly management reports
• Project Estimation process - including attending project kick-offs and design reviews as necessary to appropriately size new environments, recommend infrastructure solutions and deliver associated cost and resource effort estimates
• Develop and implement Database security policies and procedures, in line with corporate objectives

You'll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.
Required Qualifications:

• Undergraduate degree or equivalent experience
• 7+ years of Oracle and Postgres DBA working experience supporting databases used for data warehousing and OLAP/Analytics, direct data warehouse experience with Postgres preferred (Oracle data warehouse experience is helpful)
• ETL experience in a data warehouse
• Upgrade experience between major versions
• Experienced with tuning and efficient use of transactions
• Understanding of Postgres 11 new features and their impact on analytic queries and/or ETL processing
• Knowledgeable on best practices for set based processing, etc.
• Well versed on Data warehouse vs. OLTP loading
• JIT Compilation
• Parallel hash joins
• Expert knowledge on creating/debugging/tuning PL/SQL and PL/pgSQL Procedures
• Parallel query functionality and tuning
• Partitioning and inheritance
• Deep understanding of Postgres specific transaction and commit processing of tuples, how transactions affect dead rows and bloats, and the usage of vacuums
• Postgres server config, OS (kernel parameters, etc.), storage tuning and troubleshooting
• FDWs (oracle, postgres specifically, including troubleshooting)
• Solid understanding of PL/pgSQL programming language
• Understanding of indexing options in Postgres and when to use which type
• Database backups of large volume databases
• Ability to work on many tasks simultaneously in a high-pressure environment.
• Solid organizational and analytical skills. Understanding of High Availability and Disaster Recovery requirements and solutions

Preferred Qualifications:

• Experience in data modeling
• Understanding of or experience supporting J2EE application
• Understanding of or experience with virtual environments
• Desire to learn and support other platforms
• Goldengate, SQL Server 2008/2012/2014, MongoDB

What are the reasons to consider working for UnitedHealth Group? Put it all together - competitive base pay, a full and comprehensive benefit program, performance rewards, and a management team who demonstrates their commitment to your success. Some of our offerings include:

• Paid Time Off which you start to accrue with your first pay period
• 8 Paid Holidays
• Medical Plan options along with participation in a Health Spending Account or a Health Saving account
• Dental, Vision, Life& AD&D Insurance along with Short-term disability and Long-Term Disability coverage
• 401(k) Savings Plan with a company match
• Employee Stock Purchase Plan
• Education Reimbursement
• Employee Discounts
• Employee Assistance Program
• Employee Referral Bonus Program
• Voluntary Benefits (pet insurance, legal insurance, LTC Insurance, etc.)

To protect the health and safety of our workforce, patients and communities we serve, UnitedHealth Group and its affiliate companies require all employees to disclose COVID-19 vaccination status prior to beginning employment. In addition, some roles and locations require full COVID-19 vaccination, including boosters, as an essential job function. UnitedHealth Group adheres to all federal, state and local COVID-19 vaccination regulations as well as all client COVID-19 vaccination requirements and will obtain the necessary information from candidates prior to employment to ensure compliance. Candidates must be able to perform all essential job functions with or without reasonable accommodation. Failure to meet the vaccination requirement may result in rescission of an employment offer or termination of employment.
Technology Careers with Optum. Information and technology have amazing power to transform the health care industry and improve people's lives. This is where it's happening. This is where you'll help solve the problems that have never been solved. We're freeing information so it can be used safely and securely wherever it's needed. We're creating the very best ideas that can most easily be put into action to help our clients improve the quality of care and lower costs for millions. This is where the best and the brightest work together to make positive change a reality. This is the place to do your life's best work.(sm)
*All Telecommuters will be required to adhere to UnitedHealth Group's Telecommuter Policy.
Colorado, Connecticut or Nevada Residents Only: The salary/hourly range for Colorado residents is $82,100 to $146,900. The salary range for Connecticut/Nevada residents is $90,500 to $161,600. Pay is based on several factors including but not limited to education, work experience, certifications, etc. In addition to your salary, UnitedHealth Group offers benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with UnitedHealth Group, you'll find a far-reaching choice of benefits and incentives.
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.