Aircraft Performance Group Inc
Senior Applications Database Administrator
Aircraft Performance Group Inc, Littleton, Colorado, United States, 80130
Senior Applications Database Administrator
The Opportunity
This position plays a critical role in the development, management, and administration of APG databases. The Senior Application Database Administrator will be responsible for designing and implementing new data structures, managing existing databases, securing all data, and administering all Microsoft SQL Server database instances on Linux, Windows, and Amazon RDS.
Primary Responsibilities
Ensure 24/7 availability, security, and performance of mission-critical application databases across multiple platforms (SQL Server, MySQL, Amazon RDS).Design, implement, and optimize high-quality data structures and schemas to meet business needs and support specific applications.Architect and consolidate data from multiple sources into cohesive, accessible structures.Monitor, troubleshoot, and resolve complex database issues, implementing performance improvements as needed.Manage database security, access control, and data distribution to appropriate users.Collaborate with software developers and application teams to integrate efficient database requests into applications.Support and optimize complex SQL Server processes and SQLite database generation for mobile applications.Ad hoc reporting requiring advanced query skills.Document existing data models and transform raw data into actionable business intelligence.Become the resident expert on the data, how it is stored and used.Design, implement, and test backup, recovery, and disaster recovery procedures with minimal downtime.Lead database-related projects for application upgrades, migrations, and patch management.Manage and refresh test data for application development teams.Empower business users through SQL training, report generation, and transition of routine tasks.Job Type
Full-time, based in Castle Rock.Required education
Bachelor of Science degree in a computer discipline or relevant certifications.Required experience and job qualifications
10+ years' experience in Microsoft SQL Server database administration.Experience as a standalone DBA. Willing to work independently, drive critical efforts, and plan and manage work.Excellent knowledge of Microsoft SQL Server data backup, recovery, security, and integrity.Experience implementing complex stored procedures, reports, and queries.Experience with database design and development.Experience administering SQL Server on Linux a plus.Experience administering SQL Server on Amazon RDS a plus.Experience with third party tools such as Redgate SQL Compare and SQL Data Compare.Strong analytical and problem-solving skills.
The ideal candidate can take the 20 and figure out the 80, has situational awareness and understands the chain of command as they represent others before they represent themselves. The ideal candidate is output-oriented, knows when to yield and when not to yield, has a relentless willingness to raise the bar, hold themselves and others accountable, and excels in a diverse international environment across different nationalities, geographies and cultures. Be prepared to be unprepared when you apply!
If you are interested in the position, please send your Resume / CV with a cover letter enclosed and salary expectations indicated to recruiting@apgdata.com.
About us
Aircraft Performance Group
Aircraft Performance Group, LLC (APG) is a flight operations performance engineering firm, established in 1999, that specializes in Runway Analysis, Weight and Balance, and Flight Planning solutions for the airline and corporate flight operations industry. The aircraft we provide data for range from airline operated small turbo-prop aircraft (regional airline market) and wide body aircraft (international carrier) to corporate turbo-prop aircraft and large cabin ultra-long haul business aircraft. We maintain a current worldwide database of airport information (over 7000+ airports) and have experience in digitizing Approved Flight Manuals for use within our own performance programs, as well as using aircraft manufacturer provided programs. We have experience in providing data based upon FAR, EASA and CASA requirements. APG is headquartered in Castle Rock, Colorado. flyapg.com
RocketRoute, an APG company
RocketRoute is the fastest, easiest and most effective way pilots can access the essential support they need to get airborne. From online flight planning, support, flight board, concierge services to direct access to ever expanding aviation services marketplace. Liberating in its simplicity users connect via one easy-to-use digital portal. Our Team of professionals make it possible for Flight Planning to be easy and straightforward for our clients all around the world. We provide services to Private, Business, Airlines, HEMS & SAR, Education and Military. Rocket Route is headquartered in the UK with a substantial development team in Lviv. rocketroute.com
Seattle Avionics, an APG company
Seattle Avionics creates compelling pre-flight and in-flight user experiences with its cloud-based solutions providing direct user access to flight planning, weather, fuel prices and group document management for the general aviation market. Their FAA-certified and geo-referenced charts and flight data are proven and used in the leading in-panel avionics systems globally. Seattle Avionics is headquartered in Seattle, Washington. seattleavionics.com
The Opportunity
This position plays a critical role in the development, management, and administration of APG databases. The Senior Application Database Administrator will be responsible for designing and implementing new data structures, managing existing databases, securing all data, and administering all Microsoft SQL Server database instances on Linux, Windows, and Amazon RDS.
Primary Responsibilities
Ensure 24/7 availability, security, and performance of mission-critical application databases across multiple platforms (SQL Server, MySQL, Amazon RDS).Design, implement, and optimize high-quality data structures and schemas to meet business needs and support specific applications.Architect and consolidate data from multiple sources into cohesive, accessible structures.Monitor, troubleshoot, and resolve complex database issues, implementing performance improvements as needed.Manage database security, access control, and data distribution to appropriate users.Collaborate with software developers and application teams to integrate efficient database requests into applications.Support and optimize complex SQL Server processes and SQLite database generation for mobile applications.Ad hoc reporting requiring advanced query skills.Document existing data models and transform raw data into actionable business intelligence.Become the resident expert on the data, how it is stored and used.Design, implement, and test backup, recovery, and disaster recovery procedures with minimal downtime.Lead database-related projects for application upgrades, migrations, and patch management.Manage and refresh test data for application development teams.Empower business users through SQL training, report generation, and transition of routine tasks.Job Type
Full-time, based in Castle Rock.Required education
Bachelor of Science degree in a computer discipline or relevant certifications.Required experience and job qualifications
10+ years' experience in Microsoft SQL Server database administration.Experience as a standalone DBA. Willing to work independently, drive critical efforts, and plan and manage work.Excellent knowledge of Microsoft SQL Server data backup, recovery, security, and integrity.Experience implementing complex stored procedures, reports, and queries.Experience with database design and development.Experience administering SQL Server on Linux a plus.Experience administering SQL Server on Amazon RDS a plus.Experience with third party tools such as Redgate SQL Compare and SQL Data Compare.Strong analytical and problem-solving skills.
The ideal candidate can take the 20 and figure out the 80, has situational awareness and understands the chain of command as they represent others before they represent themselves. The ideal candidate is output-oriented, knows when to yield and when not to yield, has a relentless willingness to raise the bar, hold themselves and others accountable, and excels in a diverse international environment across different nationalities, geographies and cultures. Be prepared to be unprepared when you apply!
If you are interested in the position, please send your Resume / CV with a cover letter enclosed and salary expectations indicated to recruiting@apgdata.com.
About us
Aircraft Performance Group
Aircraft Performance Group, LLC (APG) is a flight operations performance engineering firm, established in 1999, that specializes in Runway Analysis, Weight and Balance, and Flight Planning solutions for the airline and corporate flight operations industry. The aircraft we provide data for range from airline operated small turbo-prop aircraft (regional airline market) and wide body aircraft (international carrier) to corporate turbo-prop aircraft and large cabin ultra-long haul business aircraft. We maintain a current worldwide database of airport information (over 7000+ airports) and have experience in digitizing Approved Flight Manuals for use within our own performance programs, as well as using aircraft manufacturer provided programs. We have experience in providing data based upon FAR, EASA and CASA requirements. APG is headquartered in Castle Rock, Colorado. flyapg.com
RocketRoute, an APG company
RocketRoute is the fastest, easiest and most effective way pilots can access the essential support they need to get airborne. From online flight planning, support, flight board, concierge services to direct access to ever expanding aviation services marketplace. Liberating in its simplicity users connect via one easy-to-use digital portal. Our Team of professionals make it possible for Flight Planning to be easy and straightforward for our clients all around the world. We provide services to Private, Business, Airlines, HEMS & SAR, Education and Military. Rocket Route is headquartered in the UK with a substantial development team in Lviv. rocketroute.com
Seattle Avionics, an APG company
Seattle Avionics creates compelling pre-flight and in-flight user experiences with its cloud-based solutions providing direct user access to flight planning, weather, fuel prices and group document management for the general aviation market. Their FAA-certified and geo-referenced charts and flight data are proven and used in the leading in-panel avionics systems globally. Seattle Avionics is headquartered in Seattle, Washington. seattleavionics.com