Database Engineer I

Posted on 9/27/2023

INACTIVE

1,001-5,000 employees

Low-cost airline linking small cities to leisure destinations.

Company Overview

Allegiant stands out in the airline industry for its unique business model, focusing on connecting small cities to major leisure destinations with low-cost, high-efficiency services. The company's competitive edge lies in its ability to offer bundled vacation packages, including air travel, hotel rooms, and car rentals, making travel both affordable and convenient for customers. With a growth trajectory from a single aircraft and route in 1999 to over 92 aircraft and 350 routes today, Allegiant demonstrates industry leadership and a commitment to expanding access to travel.

Company Stage

IPO

Total Funding

$746M

Founded

1999

Headquarters

Las Vegas, Nevada

Growth & Insights

Headcount

6 month growth

↑ 7%

1 year growth

↑ 11%

2 year growth

↑ 22%

Locations

Las Vegas, NV, USA

Experience Level

Entry

Junior

Mid

Senior

Expert

Desired Skills

AWS

Jenkins

MongoDB

MySQL

Redis

SQL

Terraform

CategoriesNew

Software Engineering

Requirements

Ability to work with people of varied technical backgrounds
Excellent communication skills
Ability and willingness to provide on-call production support (24x7) in rotation with others
AWS Certified Cloud Practitioner or equivalent
Job Duties
Installation, configuration, management, and monitoring of multiple versions of one or more of: MySQL, Microsoft SQL Server, MongoDB and Redis
Maintain and rollout databases via automation such Terraform, Cloud Formation, Jenkins, etc
Database upgrades, scripting, task automation, backups/recovery
Database performance monitoring, tuning diagnostic tools
Ensure best practices and standard operating procedures are adhered to
Manage VLDBs 5TB+
Support development teams with database requests as needed (including bug fixes, production data manipulation and feature testing)
Support business users and BI team with data access, troubleshooting and ad-hoc queries
Other duties as assigned

Summary

Allegiant Travel provides our customers a lot more than air transportation. From vacation packages to NFL bundles we offer a wide variety of services. Our backend support systems are diverse, scalable and complexed, comprising of MySQL, DB2, MSSQL, MongoDB, Redis and PostGres mixed between on-prem, AWS and Azure.

The Database Engineer I is responsible for the Installation, configuration, management, and monitoring of Allegiant’s databases. The Database Engineer I is also responsible for Database upgrades, scripting, task automation, backups/recovery.

Visa Sponsorship Available

Minimum Requirements

Combination of Education and Experience will be considered. Must be authorized to work in the US as defined by the Immigration Act of 1986. Must pass a Criminal Background Check.

Education: Associate’s Degree/ A technical degree in computer science, software engineering or related field.

Years of Experience: Minimum two (2) years of related experience.

•Ability to work with people of varied technical backgrounds.

•Excellent communication skills.

•Ability and willingness to provide on-call production support (24x7) in rotation with others.

Preferred Requirements

•AWS Certified Cloud Practitioner or equivalent.

Job Duties

•Installation, configuration, management, and monitoring of multiple versions of one or more of: MySQL, Microsoft SQL Server, MongoDB and Redis.

•Maintain and rollout databases via automation such Terraform, Cloud Formation, Jenkins, etc.

•Database upgrades, scripting, task automation, backups/recovery.

•Database performance monitoring, tuning diagnostic tools.

•Ensure best practices and standard operating procedures are adhered to.

•Manage VLDBs 5TB+.

•Support development teams with database requests as needed (including bug fixes, production data manipulation and feature testing).

•Support business users and BI team with data access, troubleshooting and ad-hoc queries.

•Other duties as assigned.

Physical Requirements

The Physical Demands and Work Environment described here are a representative of those that must be met by a Team Member to successfully perform the essential functions of the role. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the role.

Office/IT - While performing the duties of this job, the Team Member is regularly required to stand, sit, talk, hear, see, reach, stoop, kneel, and use hands and fingers to operate a computer, key board, printer, and phone. May be required to lift, push, pull, or carry up to 50 lbs. May be required to work various shifts/days in a 24 hour situation. Regular attendance is a requirement of the role. Exposure to moderate noise (i.e. business office with computers, phones, printers, and foot traffic), temperature and light fluctuations. Ability to work in a confined area as well as the ability to sit at a computer terminal for an extended period of time. Some travel may be a requirement of the role.

Essential Services Provider

Allegiant as a national air carrier is deemed an essential service provider during declared national and state emergencies. Team Members will be required to report to their assigned trip or work location during national and state emergencies unless prohibited by local, state or federal order.

EEO Statement

Equal Opportunity Employer: Disability/Veteran

For more information, see https://allegiantair.jobs

People of color, women, LGBTQIA+, immigrants, veterans and persons with disabilities are encouraged to apply.

Full Time Benefits:

Profit Sharing

Medical/Dental/Vision/Life/ Disability Insurance

Medical Travel Reimbursement

Legal, Identity and Pet Insurance

401K with an employer match

Employee Stock Purchase Plan

Employee Assistance Program

Tuition Reimbursement

Flight Benefits

Paid vacation, holidays, and sick time

Part Time Benefits: