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 SQL 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 SQL and Couchbase 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. This position is for United Airlines Business Services Pvt. Ltd - a wholly owned subsidiary of United Airlines Inc.
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
- Must be fluent in English (written and spoken)
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
GGN00001593 
