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.
Top Skills
What We Do
For more than 30 years, Jet Support Services, Inc. (JSSI), has been the leading independent provider of maintenance support and financial services to the business aviation industry. JSSI is responsible for maintaining in excess of 2,000 business jets, regional jets and helicopters across the globe and serves customers through an infrastructure of certified technical advisors.
JSSI leverages this technical knowledge, experience, buying power and data to provide support at every stage of the aircraft life cycle; from aircraft acquisition to aircraft teardown and part out.
GTCR, a leading private equity firm, is a majority investor in JSSI.