Principal Data Engineer

Gurgaon, Haryana
Permanent
Full-time

2 days ago

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

Designing, implementing and maintaining all functions of database systems according to business needs
Managing Oracle 11g and 12c, 19c databases on HP UNIX and LINUX environments
Performing all forms of database maintenance and administrative activities; installing, configuring, patching and upgrading Oracle server software, applications and related products
Design and implement database backups using Oracle Recovery Manager
Automating routine maintenance tasks as appropriate utilizing OEM, Shell scripting and PL/SQL batch processing
Support the production environment on 11g,12c, 19c databases on HP UNIX and Linux
Backup and restore using RMAN utilities, Disaster Recovery testing, recovery Catalog and refreshing databases on multiple environment
Manage, troubleshoot and resolve oracle database and applications issues
Perform database and application tuning through the use of AWR and ADDM
Assist the application development team with tuning and optimization of long running SQL and PL/SQL queries for better performance
Perform and develop the PL/SQL code for automation process
Manage /support Oracle Golden gate
Manage and troubleshoot and resolve Oracle database and Performance its issues
Manage and troubleshoot and resolve MySQL Issues
Managing Oracle databases on HP-UX and Linux environments
Production Support of Large (VLDB) and Complex Databases
Upgrade/Migration/conversion from non CDB o PDB of the databases from Oracle 12c/19c
Support the production environment on 12c, 19c databases on HP UNIX and Linux
Automating routine maintenance tasks as appropriate utilizing OEM, SQL Loader, Shell scripting and PL/SQL batch processing
Backup and restore using RMAN utilities, Disaster Recovery testing, recovery Catalog and refreshing databases on multiple environment
Manage, troubleshoot and resolve oracle database and applications issues
Reviews the work of others
Develops innovative approaches
Sought out as expert
Serves as a leader/ mentor
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
Oracle Certified DBA, Oracle 19c, experience in Exadata Machines
Experience with Oracle enterprise manager 13c
Experience in RAC and Multi-tenant (CDB-PDB) environments and performance tuning as well
Experience in RAC environments, patchin and performance tuning as well
Knowledge of MySQL database administration
Knowledge of Oracle products (Oracle Database 19c )
Knowledge of Operating System: HP Unix, Red Hat Linux,AIX
Knowledge of Oracle Database solutions (ASM and Recovery Manager)
Knowledge of Oracle tools (13cOEM, SQL Loader, Quest TOAD, AWR and ADDM)
Knowledge of Oracle PL/SQL stored procedures and Unix Shell Scripting
Working knowledge of Exadata
Working knowledge of percona/Proxy clustering with MySQL
MySQL working knowledge of MySQL
Familiar with Cloud platform (prefered Azure)

Preferred Qualifications:

Knowledge of PostgreSQL and Cassandra
Knowledge of Cassandra

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.

UnitedHealth Group

Apply Now