Senior Data Engineer, Optum Insight Technology - Franklin, TN or Telecommute at Optum (Hampton Roads, VA or Remote)

| Hampton Roads, VA +25 more | Remote
Sorry, this job was removed at 3:17 p.m. (CST) on Friday, August 19, 2022
Find out who's hiring in Hampton Roads, VA.
See all Data + Analytics jobs in Hampton Roads, VA
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
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.
Read Full Job Description
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Candidate Location Eligibility:
Ann Arbor, MI
Atlanta, GA
Austin, TX
Baltimore, MD
Boston, MA
Chicago, IL
Dallas-Fort Worth, TX
Detroit, MI
Hartford, CT
Houston, TX
Jacksonville, FL
Las Vegas, NV
Los Angeles, CA
Louisville, KY
Madison, WI
Minneapolis–Saint Paul, MN
Nashville, TN
New York City, NY
Philadelphia, PA
Phoenix – Mesa – Scottsdale, AZ
Raleigh-Durham, NC
San Diego, CA
San Francisco, CA
Seattle, WA
Washington DC

Technology we use

  • Engineering
  • Product
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • ScalaLanguages
    • SqlLanguages
    • JenkinsLanguages
    • HadoopFrameworks
    • SparkFrameworks
    • SpringFrameworks
    • KafkaFrameworks
    • LinuxFrameworks
    • KubernetesFrameworks
    • DockerFrameworks
    • SnowflakeDatabases
    • Google AnalyticsAnalytics
    • SmartsheetManagement

An Insider's view of Optum

How would you describe the company’s work-life balance?

Many companies have a standard 8-hour day, but we don’t. Optum is a global company, so we recognize that working hours are different for everyone depending on their situation. Optum has implemented flexible working policies that allow employees to work from home in addition to the traditional office setting with virtual tools to support everyone.

Rachel

Chief of Staff

What projects are you most excited about?

My teams work on Digital Benefits where our mission is to deliver benefit clarity, cost transparency, and guidance towards increasing healthy outcomes for our members! One exciting project that we just finished was the Mental Health Hub, where we worked to spotlight member's mental health benefits offered by their United Healthcare health plans.

Tim

Senior Software Engineering Manager

How does the company support your career growth?

At Optum the ideal of helping people live healthier lives transcends the healthcare industry and applies to our employee experience. Through meaningful mentorships and participation in holistic leadership development programs, I have been empowered to show up as the best version of my authentic self at home and at work to pursue my life’s purpose.

Kat

Technology Product Director

How does the company support your career growth?

I started with the company 12 years ago and have been promoted 5 times. As an analyst, I provided leaders with meaningful analytics needed for decision-making. Now as a Director, I’m the one making the decisions. I’m responsible for creating effective business strategy, executing tactical plans, and helping drive patent culture transformation.

Komal

Director, UHG Invention Program

What are Optum Perks + Benefits

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Diversity
Dedicated Diversity/Inclusion Staff
Unconscious bias training
Diversity Employee Resource Groups
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Onsite Gym
Team workouts
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Employee Stock Purchase Plan
Performance Bonus
Match charitable contributions
Child Care & Parental Leave Benefits
Child Care Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Family Medical Leave
Adoption Assistance
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Perks & Discounts
Casual Dress
Parking
Relocation Assistance
Fitness Subsidies
Home Office Stipend for Remote Employees
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
Lunch and learns
Cross functional training encouraged
Promote from within
Mentorship program
Continuing Education stipend
Online course subscriptions available

More Jobs at Optum

Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Optum's full profileSee more Optum jobs