Uniteds Digital Technology team designs, develops, and maintains massively scaling technology solutions brought to life with innovative architectures, data analytics, and digital solutions.
Find your future at United! We’re reinventing what our industry looks like, and what an airline can be – from the planes we fly to the people who fly them. When you join us, you’re joining a global team of 100,000+ connected by a shared passion with a wide spectrum of experience and skills to lead the way forward.
Achieving our ambitions starts with supporting yours. Evolve your career and find your next opportunity. Get the care you need with industry-leading health plans and best-in-class programs to support your emotional, physical, and financial wellness. Expand your horizons with travel across the world’s biggest route network. Connect outside your team through employee-led Business Resource Groups.
Create what’s next with us. Let’s define tomorrow together.
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.
Off-hours support for all Tier1 – Tier5 SQL 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 SLAs
- 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
Review deployment for all SQL database changes
- Complete pre-deployment code reviews with application teams as requested
- Review and provide feedback on all SQL code updates
- Work with deployment manages on dates and time for releases including assignments
Patching of all SQL Server and some Couchbase
- 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
Project management and engagements for database migration
Database Engineering Performance consultations
- Work with applications teams on current and new features such as partitioning, memory optimized tables, Always-On availability groups etc.
- 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.