Job Description
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 GGN0000XXXXXX
💡 Quick Summary
Seeking a career-building opportunity? The Senior Oracle Database Administrator position is now open for candidates interested in the Database Administrator sector. This role in Gurugram offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.
