Senior Oracle Database Administrator

Full–time
Description

United's Digital Technology team designs, develops, and maintains massively scaling technology solutions brought to life with innovative architectures, data analytics, and digital solutions.

Our Values: At United Airlines, we believe that inclusion propels innovation and is the foundation of all that we do. Our Shared Purpose: "Connecting people. Uniting the world." drives us to be the best airline for our employees, customers, and everyone we serve, and we can only do that with a truly diverse and inclusive workforce. Our team spans the globe and is made up of diverse individuals all working together with cutting-edge technology to build the best airline in the history of aviation.

With multiple employee-run "Business Resource Group" communities and world-class benefits like health insurance, parental leave, and space available travel, United is truly a one-of-a-kind place to work that will make you feel welcome and accepted. Come join our team and help us make a positive impact on the world.

Job Overview And Responsibilities

This position manages the engineering and administration of all on-prem Oracle instances and databases including the security, availability, performance, and data protection for those databases. This position manages the off-hours patching and deployments for all Tier 1 thru Tier 5 Oracle databases. Additionally, this position is responsible for AWS cloud migrations, support, and deployments.

1- Off-hours support for all Tier1 – Tier5 Oracle Databases and Instances
• Create physical database structures based on physical design for development, test, and production environments.
• Coordinate with systems engineers to configure servers for DBMS product installation and database creation.
• Install, configure, and maintain DBMS product software on database and application servers.
• Assist in the consultation to application development teams on DBMS product technical issues and techniques.
• Implement monitoring procedures to maximize availability and performance of the database, while meeting defined SLA's.
• Investigate, troubleshoot, and resolve database problems.
• Communicate the required downtime with the application development teams and systems engineers to implement approved changes.
• Identify, define and implement database backup / recovery and security strategies
• Install and support of DBMS (Database Management Systems) software and tools.
• Perform various database activities which include monitoring, tuning, and troubleshooting, with appropriate supervision, if required.

2- Review deployment for all Oracle database changes
• Complete pre-deployment code reviews with application teams as requested
• Review and provide feedback on all Oracle code updates
• Work with deployment managers on dates and time for releases including assignments

3- Patching of all Oracle databases
• Work with application teams to create schedule
• Send advanced and timely notifications for database instances to be patched
• Conduct database patching including any troubleshooting and validation post patching

4- Project management and engagements for database migration

5- Database Engineering Performance consultations
• Work with applications teams on current and new features such as partitioning, RAC and DG features
• Provide diagnoses for performance issues
• Tables and index reviews
• Data Purging and job scheduling

This position is offered on local terms and conditions. Expatriate assignments and sponsorship for employment visas, even on a time-limited visa status, will not be awarded.

Qualifications

Required
• Master’s degree or 6 years of relevant work experience
• Computer Science, Engineering, or related discipline
• 10 years of related work experience
• Oracle Certification
• Proficient in PL/SQL development and administration disciplines with current hands-on experience with the latest Oracle databases
• Strong background and experience with Oracle databases including RAC and Data Guard
• Leverage metrics to drive capacity planning and trending to proactively identify potential problems and mitigate before they result in customer impact.
• Understand the place of automation and standardization when delivering stable, maintainable, and performant database services at scale.
• Perform platform, database, and query optimization
• English

Preferred
• Master’s degree or 6 years of relevant work experience
• Computer Science, Engineering, or related discipline
• 12 Years of related work experience
• Oracle and AWS certification
• Hands-On experience with AWS native databases, compute, storage, monitoring technologies, and continuous integration pipelines.
• Experience implementing automation using Shell Scripts and maintenance, and support activities preferred.
• Collaborate both vertically and horizontally to evolve overall database services and technology strategies.
• Very large Database (10+ TB) experience preferred
• Experience with PCI, SOX, and GDPR a plus

Equal Opportunity Employer - Minorities/Women/Veterans/Disabled/LGBT GGN00001038