Senior SQL Server Database Administrator

CAE is a high‑technology company at the forefront of digital immersion, providing innovative solutions that help make the world a safer place. Our Flight Services business delivers software solutions to more than 150 airline customers worldwide.

Join the engine driving CAE’s next horizon of growth through digital innovation while supporting our global aviation customers.

Why CAE?

• Meaningful work that supports professional development
• Opportunity to enter and grow within the technology industry
• Collaborative and high‑performance work environment
• Global customer impact across airlines and business aviation operators

Product Overview
CAE Civil Flight Services provides a comprehensive suite of digital solutions that help airlines and business aircraft operators efficiently plan operations, deploy personnel, and optimize performance, compliance, and customer satisfaction. Our ecosystem brings together CAE, Merlot, RB Group, and Airline Operations Portfolio solutions, addressing three major markets: Commercial Aviation, Business Aviation, and Crew Engagement.

Main Responsibilities

• Monitor system health and address raised alerts
• Provide on‑call support during scheduled time windows
• Administer MSSQL instances and databases, including backups, maintenance tasks, mirroring, Availability Groups, replication, Failover Clusters, and TDE
• Profile system performance and troubleshoot functional and non‑functional issues
• Deliver high‑quality technical solutions
• Write documentation for database setup, architecture, and implemented changes
• Manage database security
• Support database environment migrations
• Stay current with industry technologies, trends, and best practices
• Apply sound judgment in selecting tools, methods, and techniques to develop solutions

Minimum Qualifications

• This role is a combination of SQL Administration and SQL Development
• Strong T‑SQL skills are mandatory
• Minimum 5 years of commercial experience in SQL Server administration
• Knowledge and experience with Microsoft SQL Server 2019 or above
• Knowledge and experience with Microsoft Windows Server 2022 or above
• Knowledge and experience in Cloud technologies (AWS RDS is a plus)
• Strong understanding of relational databases, T‑SQL, query execution plans, concurrency issues, and deadlock resolution
• Experience using database monitoring tools (SQL Sentry is a plus)
• Ability to understand complex application workflows
• Strong analytical and problem‑solving skills
• Experience in performance profiling
• Experience collaborating with global, distributed teams
• Proficient in communicative English

Preferred Qualifications

• Previous experience with desktop applications and database development
• Knowledge of software development processes from requirements definition to production release
• Knowledge of Change Management processes (SNOW)
• Experience with Oracle
• Experience with MongoDB
• Experience writing and debugging advanced PowerShell scripts
• Knowledge of source control systems (e.g., TFS, Git)

#LI-SA2 #OneCAE  

At CAE, our mission is clear: to help make the world a safer place. For nearly 80 years, we’ve driven innovation in simulation, training, and mission readiness to support critical operations worldwide. By leveraging advanced technologies, we empower our customers to operate smarter, faster, and more sustainably. Join a purpose-driven organization where bold ideas are encouraged, collaboration drives progress, and your growth fuels our shared success.

CAE is committed to providing equal opportunities to all applicants, regardless of race, nationality, color, religion, sex, gender identity or expression, sexual orientation, disability, neurodiversity, veteran status, age, or other characteristics protected by law. We encourage applicants who may not meet every qualification to apply. Reasonable accommodations are available—contact your recruiter or email CAECarrieres-Careers@cae.com if needed.

Privacy Statement | CAE

CAE thanks all applicants for their interest. However, only those whose background and experience match the requirements of the role will be contacted.