Intermediate Analyst – Database Administrator

WestJet Group•Calgary, AB

9d•CA$84,793 - CA$114,720•Onsite

About The Position

WestJet is seeking an Intermediate Analyst – Database Administrator to join their Database Services team. This role requires a high standard of excellence, a results-driven approach, and a strong capacity for self-learning. The incumbent will work alongside Database Engineers and MSP DBA resources, administering, maintaining, and optimizing enterprise database platforms including Microsoft SQL Server, Oracle Database, IBM Db2, and Azure SQL Database. The position supports daily operations, ensures database availability and performance, and contributes to modernization and cloud migration efforts. A solid hands-on experience, strong troubleshooting skills, and a commitment to operational excellence are essential. This role also participates in an On-Call rotation.

Requirements

Hands-on experience administering Microsoft SQL Server and / or Oracle Databases is required
Proven experience with daily database operations including backup, restore, patching, monitoring database health and uptime as well as routine database maintenance processes including indexing and statistics is required
Experience diagnosing and resolving query performance issues, blocking, deadlocks, and resource contention is required
Experience in implementing and supporting High Availability & Disaster Recovery (HA/DR) database technologies is required
Experience in managing user accounts, roles, permissions and role-based access control (RBAC) is required
Understanding of networking basics relevant to database connectivity is required
Understanding of operating systems, Windows and/or Linux, is required
Adherence to Change Management and IT Service Management practices
Attention to detail and operational discipline
Ability to prioritize and manage multiple tasks
Effective communication with technical and non-technical teams
Proactive mindset focused on reliability and performance
Commitment to continuous learning and improvement

Nice To Haves

Experience administering IBM Db2, Azure SQL Database, or Azure SQL Managed Instance is preferred
Experience administering other database systems is nice to have
Ability to optimize SQL queries and stored procedures considered an asset
Familiarity with monitoring tools such as Redgate Monitor, Solarwinds DPA, Oracle Enterprise Manager, and IBM Db2 Genius Hub is preferred
Exposure to automation scripting languages such as PowerShell, Bash, and Python is preferred

Responsibilities

Provide Database Administration and Operational Support to enterprise databases including monitoring, routine maintenance, high availability and disaster recovery configuration and testing, and performance troubleshooting, ensuring the health and availability of databases that support various business needs, minimizing downtime, preventing data loss, and maintaining performance and responsiveness
Administer database user accounts, roles, and permissions following principals of least privilege
Deploy security patches to protect sensitive data, reduce the risk of unauthorized access and protect against vulnerabilities and emerging threats
Monitor and optimize database solutions using monitoring tools to track performance, capacity, and system health to enable proactive issue detection and capacity planning along with recommending and implementing improvements to database configuration, indexing strategies, and resource utilization to ensure systems run efficiently and can scale with business growth
Collaborate with application teams to implement efficient database structures, stored procedures, and queries, supporting release deployments, schema changes, and data migrations to ensure new features and applications are built on scalable, high performing data foundations and new functionality is delivered smoothly with reduced deployment risks
In the event there is an incident involving database performance, availability or data integrity, assist with root cause analysis to prevent recurring issues and improve system reliability
Support hybrid and cloud-based database workloads, including, but not limited to, Azure SQL Database and SQL Managed Instance to help WestJet leverage cloud scalability, cost optimization, and modern data capabilities.
Participate in database modernization initiatives, including cloud migration, automation, and infrastructure as code practices to reduce manual effort, increase consistency, and align with long term technology strategies