Job description

About JSSI

For more than 35 years, Jet Support Services, Inc. (JSSI) has been the leading independent provider of maintenance support, advisory services, software, and financial tools to the business aviation industry. With 6,000+ aircraft supported by maintenance programs and software platforms, JSSI leverages this wealth of data, scale, and innovation to drive cost savings and provide custom solutions that align to the interests of each client, regardless of make or model. Learn more at jetsupport.com.

JSSI products and services include:

Maintenance Programs. Hourly Cost Maintenance Programs to stabilize maintenance budgets, maximize aircraft availability and enhance residual value.

Parts & Leasing. Experienced product line specialized team who leverages our All-OEM inventory and global vendor relationships and go beyond parts sourcing to find optimal customer solutions.

Software: Traxxall and Conklin & de Decker. Powerful data platforms to help you make more informed decisions, from choosing the right aircraft to tracking your maintenance, inventory, and MRO projects.

Advisory Services. Objective insights and independent technical advice from a global team of technical advisors and ASA-accredited appraisers for virtually any business jet, turboprop or helicopter.

Aviation Capital. Customized asset-based finance solutions for business aviation.

Job Summary:

The mission of the Database Engineer on the DB team is to develop and optimize complex SQL queries, stored procedures, functions, and views. The Database Engineer demonstrates resourcefulness, takes direction, provides direction, and learns new technologies to support the business. The responsibilities of this position include designing, implementing, and maintaining our SQL Server databases, in a dynamic team environment.

Duties/Responsibilities:

Collaborates with clients and/or internal teams to understand user needs; collaborates on initial proposal and design of software to meet these needs.

Design, implement, and maintain robust SQL Server database systems.

Develop and optimize complex SQL queries, stored procedures, functions, and views.

Develops ETL, Data Warehouse, Data Vault, Data Modeling, Big Data, and Data Migration tasks.

Collaborate with development teams to design efficient data models and ensure seamless integration with applications

Participate in architectural and design discussions to ensure APIs align with business goals.

Monitor and optimize database performance by fine-tuning queries, indexing strategies, and resource allocation.

Work with cross-functional teams to plan and execute database upgrades, migrations, and integrations.

Provide technical support and troubleshooting for database-related incidents and queries

Diagnose and resolve database-related issues, ensuring minimal downtime and high availability.

mplement performance monitoring and alerting systems to proactively manage potential issues.

Designs data models and database schemas for specific application areas.

Collaborates with systems analysts, engineers, and programmers to design systems to support required applications.

Document database architectures, configurations, and processes to ensure maintainability and compliance.

Performs other related duties as assigned.

Able to work 2nd-shift (3PM to 12 midnight), Mondays to Fridays

Effective verbal and written English communication skills

Desired Qualifications:

Bachelor’s degree in computer science, engineering, or related field required.

At least five years of experience as a software developer or database engineer required.

Experience with Azure cloud services and platform is preferred.

Strong proficiency in SQL and experience with database performance tuning, query optimization, and index management.

In-depth knowledge of backup and recovery strategies, high availability, and disaster recovery solutions for SQL Server.

Familiarity with scripting languages (e.g., PowerShell) for automating database tasks.

Experience working with SQL and writing queries for relational databases.

Familiarity with relational databases (SQL Server, etc.) and designing efficient queries.

Experience with cloud-based database services (e.g., Azure SQL Database) is a plus.

Experience with data warehousing, ETL processes, or big data technologies

Knowledge of additional database platforms and modern data architecture patterns.

Excellent time management skills with the proven ability to meet deadlines.

Ability to participate in Agile sprinting and ceremonies.

JSSI is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected veteran status, or other characteristic protected by law.

JSSI does not accept unsolicited resumes from individual recruiters or third-party recruiting agencies in response to job postings. No fee will be paid to third parties who submit unsolicited candidates directly to our hiring managers or Recruiting Team.

Required profile