Job Overview

Job details

Job type

• Full-time

 

Location

Gurugram, Haryana

 

Benefits

Pulled from the full job description

• Health insurance

 

Full job description

Achieving our goals starts with supporting yours. Grow your career, access top-tier health and wellness benefits, build lasting connections with your team and our customers, and travel the world using our extensive route network.

Come join us to create what’s next. Let’s define tomorrow, together.

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

United Airlines is seeking talented people to join the Data Engineering team as Sr AWS Redshift DBA. Data Engineering organization is responsible for driving data driven insights & innovation to support the data needs for commercial and operational projects with a digital focus.

As a Redshift DBA, you will engage with Data Engineering and DevOps team (including internal customers) for redshift database administration initiatives.

• You will be involved in Database administration, performance tuning, management and security of AWS Redshift deployment and enterprise data warehouse
• You will provide technical support for all database environments including development/pre-production/production databases for the organization and will responsible for setting up of infrastructure, configuring, maintenance of environment including security to
• support cloud environment working along with DE and Cloud Engineering
• Develop and implement innovative solutions leading to automation
• Mentor and train junior engineers

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.

United Airlines is an equal opportunity employer. United Airlines recruits, employs, trains, compensates, and promotes regardless of race, religion, color, national origin, gender identity, sexual orientation, physical ability, age, veteran status, and other protected status as required by applicable law..

Qualifications

We are seeking Dedicated and skilled Redshift Database Administrator with a proven track record of optimizing database performance, ensuring data security, and implementing scalable solutions. Seeking to leverage expertise in Redshift and AWS to drive efficiency and reliability in a dynamic organization.

Required

• BS/BA, in computer science or related STEM field
• Individuals who have a natural curiosity and desire to solve problems are encouraged to apply.
• 4+ years of IT experience preferably in Redshift Database Administration, SQL & Query optimization.
• Must have experience in performance Tuning & Monitoring.
• 3+ years of experience in scripting (Python, Bash)
• Database Security & Compliance.
• 4+ years in AWS Redshift production environment.
• 3+ years of experience with relational database systems like Oracle, Teradata
• 2+ years’ experience with Cloud migration of existing apps to AWS (on premise)
• Excellent and proven knowledge of Postgres/SQL on Amazon RDS
• Excellent and proven knowledge of SQL
• Must have managed Redshift clusters, including provisioning, monitoring, and performance tuning to ensure optimal query execution.
• Must be legally authorized to work in India for any employer without sponsorship
• Must be fluent in English and Hindi (written and spoken)
• Successful completion of interview required to meet job qualification
• Reliable, punctual attendance is an essential function of the position

Preferred

• Master’s in Computer Science or related STEM field
• Experience with cloud-based systems like AWS, AZURE or Google Cloud
• Certified Developer / Architect on AWS
• Strong experience with continuous integration & delivery using Agile methodologies
• Data engineering experience with transportation/airline industry
• Strong problem-solving skills
• Strong knowledge in Big Data