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.
- Off-hours and meetings support for all Tier1 – Tier5 SQL Databases and Instances.
- Create and deploy database servers and databases in DEV/TEST/PROD environments.
- Work with cross-teams of Server and storage teams to build database platforms.
- Install, configure, and maintain DBMS product software on the database.
- Assist in the consultation of application development teams on DBMS product technical issues and techniques.
- Implement monitoring procedures to maximize the availability and performance of the database, while meeting defined SLAs.
- Investigate, troubleshoot, and resolve database problems.
- 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 and follow the change management process.
- Review and provide feedback on all SQL code updates.
- Patching of all SQL Server and upgrade database to latest version on SQL and AWS
- Conduct database patching including any troubleshooting and validation post patching
- Project management and engagements for database migration
- Provide diagnoses for performance issues
- Tables and index reviews
- Data Purging and job scheduling
- Data migrations between on prem to cloud
- AWS cloud DB production support and deployments
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
- Bachelor's degree or 4 years of relevant work experience in Computer Science, Engineering, or related discipline
- 1-year AWS hands-on experience with Aroura MySQL/PostgreSQL RDS
- 4 years of Database Administration experience in SQL Server
- Proficient in SQL development and administration disciplines with current hands-on experience with the latest SQL Server releases including SQL 2022/2019.
- Strong background and experience with all HA and DR capabilities of Microsoft SQL Server including Always-On, Mirroring, Log Shipping, and Clustering with a practical understanding of other Infrastructure HA/DC capabilities
- 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
- Use of tools like Dynatrace, IDERA, RedGate, AppD, Service Now
- Independent thinker and Team player with the willingness to learn and work on stretch responsibilities.
- PowerShell and scripting skills required.
- Must be legally authorized to work in India for any employer without sponsorship
- Must be fluent in English (written and spoken).
- Successful completion of interview required to meet job qualification.
- Reliable, punctual attendance is an essential function of the position.
Preferred
- Bachelor's degree or 4 years of relevant work experience in Computer Science, Engineering, or related discipline / Masters Degree preferred.
- Microsoft SQL Server or AWS certification.
- 7 years DBA with SQL and AWS.
- Hands-on experience with AWS native databases, computing, storage, monitoring technologies, and continuous integration pipelines.
- Experience implementing automation of Microsoft SQL Server deployment and maintenance, and support activities preferred
- Collaborate both vertically and horizontally to evolve overall database services and technology strategies.
- Experience supporting SSAS, SSIS, and SSRS.
- Very large Database (10+ TB) experience preferred.
- Experience with PowerShell or other scripting languages a plus.
- Experience with PCI, SOX, and SQL Auditing a plus.
Equal Opportunity Employer - Minorities/Women/Veterans/Disabled/LGBT
GGN00001415
