Application DBA
Read straight from Cae's careers page, verified 1d ago.Seekless can tailor your résumé to it.
Seekless can write your résumé for this posting first.
Before you apply
LocationHalifax
Work modeon-site
SeniorityMid
EquityIncluded
Company size10,000+ people
PostedOct 21, 2026 · 2w ago
Verified live1d ago
At a glanceSummarised by Seekless from the posting.
University degree or college diploma in Computer Science, Information Technology, or a related field, or an equivalent combination of education and relevant experience
Practical experience administering relational databases in enterprise environments
Strong experience with either Oracle or Microsoft SQL Server
Demonstrated SQL skills and experience troubleshooting database availability, performance, capacity, connectivity, or data-quality issues
Experience with database installation, patching, backup and recovery, migrations, monitoring, and performance tuning
Experience working within formal change, release, incident, and problem-management processes
Ability to understand applications from both technical and operational perspectives and collaborate effectively with application developers, infrastructure specialists, testers, and business users
Strong analytical judgment and attention to detail, with the ability to work methodically during outages and time-sensitive maintenance activities
Clear written and verbal communication skills, including the ability to prepare implementation plans, support notes, and durable technical documentation
Ability to contribute effectively to peer review, knowledge transfer, and shared operational ownership
Hands-on experience with Oracle Database 19c or later, including Enterprise Manager, multitenant architecture, patching, and performance diagnostics
Experience with Microsoft SQL Server 2019 or later, including SQL Server Management Studio (SSMS), clustering or standalone migrations, SQL Server Agent, SSIS, SSRS, or SQL Server Express
Experience supporting databases for IFS Maintenix, IFS Cloud for Aviation Maintenance, or another complex commercial enterprise application
Experience supporting secure, disconnected, on-premises, or deployed environments where cloud services or direct vendor access may be constrained
Experience with Windows Server, virtualization, scripting or automation, certificates, service accounts, Kerberos, and Active Directory integration
Familiarity with JIRA or similar work-management tools and experience producing evidence for technical reviews, audits, or customer change-control boards
Experience supporting defence, aerospace, aviation maintenance, or other highly regulated operational systems
Eligibility to work in Canada
Ability to obtain and maintain the security and Controlled Goods clearances required for the assignment
Ability to work outside normal business hours occasionally for production releases, maintenance windows, and urgent operational support
Ability to travel occasionally to customer or partner locations
Ability to work from Halifax, Nova Scotia, with regular access to the Halifax office and secure customer environments as required
Skills
Oracle
Microsoft SQL Server
SQL
Windows Server
Oracle Enterprise Manager
SQL Server Management Studio
SQL Server Agent
SSIS
SSRS
SQL Server Express
JIRA
Oracle multitenant
Active Directory
Kerberos
certificates
service accounts
virtualization
scripting
automation
Benefits
Flexible group benefits
Pension plan
Employee stock purchase plan
Health wellness programs
⠀
Duties & Responsibilities
•
Administer and support Oracle and Microsoft SQL Server databases used by commercial off-the-shelf and custom applications on Windows-based infrastructure.
•
Monitor database health, capacity, availability, and performance; investigate abnormal conditions and take preventive or corrective action before service is affected.
•
Plan and execute database patching, upgrades, migrations, and technical refresh activities in coordination with application, infrastructure, testing, and operations teams.
•
Install and configure database software, listeners, instances, and related components, including support for Oracle multitenant container and pluggable database environments as they are introduced.
•
Perform and validate backup, restore, recovery, data migration, and environment refresh activities, with particular attention to operational continuity and data integrity.
•
Diagnose complex database and application-data issues using SQL, logs, traces, and vendor guidance. Document findings, decisions, and repeatable resolution procedures.
•
Support application queries, stored procedures, integrations, reporting workloads, and data movement, including performance tuning and troubleshooting across Oracle and SQL Server components.
•
Prepare implementation plans, change records, rollback approaches, outage estimates, and post-change evidence for controlled releases and maintenance windows.
•
Provide database support during planned releases and, when required, outside normal working hours. Participate in the program’s on-call support arrangements.
•
Coordinate with vendors and technical support organizations by providing diagnostic information and assessing recommendations for applicability within a controlled defence environment.
•
Maintain accurate architecture, build, configuration, credential-location, lifecycle, and support documentation in approved repositories.
•
Collaborate with team members to provide coverage, peer review, cross-training, and a consistent operating approach across database platforms and environments.
•
Contribute database expertise to security, service-account, certificate, audit, and compliance-related changes while respecting information-handling and Controlled Goods requirements.
•
Participate in technical planning related to platform lifecycle, licensing, obsolescence, and future application transitions.
•
Work primarily from Halifax, Nova Scotia, with regular access to the Halifax office and secure customer environments as required.
•
Work outside normal business hours occasionally to support production releases, maintenance windows, and urgent operational requirements.
•
Travel occasionally to customer or partner locations as required.
•
Handle sensitive technical information in accordance with applicable program security, export-control, and information-management requirements.
Minimum Qualifications
•
University degree or college diploma in Computer Science, Information Technology, or a related field, or an equivalent combination of education and relevant experience.
•
Practical experience administering relational databases in enterprise environments.
•
Strong experience with either Oracle or Microsoft SQL Server, with the aptitude and willingness to develop capability on the other platform.
•
Demonstrated SQL skills and experience troubleshooting database availability, performance, capacity, connectivity, or data-quality issues.
•
Experience with database installation, patching, backup and recovery, migrations, monitoring, and performance tuning.
•
Experience working within formal change, release, incident, and problem-management processes.
•
Ability to understand applications from both technical and operational perspectives and collaborate effectively with application developers, infrastructure specialists, testers, and business users.
•
Strong analytical judgment and attention to detail, with the ability to work methodically during outages and time-sensitive maintenance activities.
•
Clear written and verbal communication skills, including the ability to prepare implementation plans, support notes, and durable technical documentation.
•
Ability to contribute effectively to peer review, knowledge transfer, and shared operational ownership.
•
Eligibility to work in Canada.
•
Ability to obtain and maintain the security and Controlled Goods clearances required for the assignment.
•
Ability to work outside normal business hours occasionally for production releases, maintenance windows, and urgent operational support, including participation in on-call arrangements as required.
•
Ability to travel occasionally to customer or partner locations.
•
Ability to work from Halifax, Nova Scotia, with regular access to the Halifax office and secure customer environments as required.
Preferred Qualifications
•
Hands-on experience with Oracle Database 19c or later, including Enterprise Manager, multitenant architecture, patching, and performance diagnostics.
•
Experience with Microsoft SQL Server 2019 or later, including SQL Server Management Studio (SSMS), clustering or standalone migrations, SQL Server Agent, SSIS, SSRS, or SQL Server Express.
•
Experience supporting databases for IFS Maintenix, IFS Cloud for Aviation Maintenance, or another complex commercial enterprise application.
•
Experience supporting secure, disconnected, on-premises, or deployed environments where cloud services or direct vendor access may be constrained.
•
Experience with Windows Server, virtualization, scripting or automation, certificates, service accounts, Kerberos, and Active Directory integration.
•
Familiarity with JIRA or similar work-management tools and experience producing evidence for technical reviews, audits, or customer change-control boards.
•
Experience supporting defence, aerospace, aviation maintenance, or other highly regulated operational systems.
Benefits
We’ve designed flexible policies to promote well-being and growth, based on role-specific eligibility and requirements:
•
Flexible Group Benefits
•
Pension plan
•
Employee stock purchase plan
•
Comprehensive health and wellness programs
•
Supportive team and collaborative corporate culture
About CAE
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.
Position Type
Regular
Equal Opportunity & Accommodations
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 [email protected] if needed.
Data Privacy
Privacy Statement | CAE
Hiring process
As part of our process, we may use AI‑supported tools to help review applications, with human decision‑making at every step. CAE thanks all applicants for their interest. However, only those whose background and experience match the requirements of the role will be contacted.