Application & Database System Specialist

Job Title:

Application & Database System Specialist

Position

Reports To:

Head of Architecture & Technology

Job Location:

Ottawa
- Hybrid

The Application & Database System Specialist serves as a technical subject matter expert (SME) for application platforms and underlying database systems. This role is responsible for the installation, configuration, optimization, and Tier 3 support of business-critical systems, ensuring they operate securely, reliably and efficiently across all environments.

This role collaborates closely with internal and external stakeholders to ensure operational performance and compliance requirements are met. This role also supports user enablement and continuous improvement through the development of documentation, training materials and best practice guidance that enhance system adoption and stability.

• Administer, maintain, and support enterprise business applications and associated database platforms, including installation, configuration, patching, upgrades, automation, and decommission activities.
• Manage application and database environments across development, testing, staging, and production to ensure stability, performance, and availability.
• Perform database administration activities such as backup and recovery, performance tuning, capacity monitoring, indexing, and query optimization.
• Serve as the Tier 3 escalation point for complex application, integration, and database issues, diagnosing root causes, and implementing effective resolutions.
• Investigate and resolve performance degradation, data integrity issues, configuration errors, and system failures impacting application services.
• Collaborate with internal and external stakeholders to ensure systems operate as designed and align with approved technical standards.
• Provide operational support system integrations, APIs, and data flows between enterprise applications and databases.
• Ensure applications and databases are securely configured and operated in compliance with organizational policies, accreditation requirements, and Government of Canada standards.
• Participate in change management activities related to application and database updates, releases, and enhancements.
• Management activities related to application and database updates, releases, and enhancements.
• Develop and maintain technical documentation, including system configurations, operational procedures, runbooks, and troubleshooting guides.
• Create user-focused enablement of instructional documents and materials to support effective system use.
• Assist with audits, compliance reviews, and accreditation activities by providing technical input and evidence as required.
• Identify and recommend incremental improvements to application reliability, database performance, and operational processes.
• Provide clear technical guidance and explanations to internal teams and business users regarding application functionality and system behavior.
• Automate recurring operational activities such as deployments, configuration validation, data processing, environmental health checks, and reporting.
• Responsible for database queries, reports, and dashboards to support operational monitoring, performance analysis, audit readiness, and business reporting needs.
• Support data extraction, transformation, and reporting workflows across enterprise applications and database platforms.
• Improve operational efficiency and reliability by identifying opportunities to replace manual processes with scripted or automated solutions.
• Other duties as assigned.

• Post-secondary degree or diploma in Computer Science, Information Technology, Software Engineering, or a related field.
• Minimum of 5+ years of experience administering enterprise applications and databases (SQL Server, Postgre
  
  SQL, Oracle, or equivalent).
• Proven experience and ability to diagnose complex issues at Tier 3.
• Experience with Dev Ops pipelines, scripting, and automation (Power Shell, Bash, Python), Power BI, cybersecurity principles and secure system configuration would be strong assets.
• Strong troubleshooting and analytical skills.
• Familiarity with Windows and/or Linux server environments.
• Excellent communication skills with the ability to explain technical concepts to non-technical audiences.
• Experience in the Defence and Aerospace industries would be an asset.
• Be able to hold a Government of Canada Security Clearance (Secret level) and Controlled Goods Clearance.
• Eligible to work in Canada.
• Strong oral and written English language capabilities.
• Fluency in French would be an asset.

• A competitive compensation mode.
• Extended health and dental benefits.
• Short and long-term disability coverage.
• Paid vacation.
• Employee and family assistance program.

At Sky Alyne, we are dedicated to building a team that reflects the rich tapestry of our society. Diversity is not just a goal; it's our strength. We welcome candidates of all genders, races, ethnicities, sexual orientations, religions,…