Intermediate Analyst – Database Administrator
WestJet
Get more replies from employers
Send a job-specific resume in minutes.
Benefits offered by this job
Job summary
WestJet is seeking an Intermediate DBA to administer, optimize, and support enterprise databases across Microsoft SQL Server, Oracle, IBM Db2, and Azure SQL. You will ensure availability, performance, and security while contributing to cloud migration efforts.
As part of a team with Senior DBAs and MSP resources, you will handle day-to-day operations, backups, patching, and performance tuning. You’ll participate in on-call rotations and strive for operational excellence in a fast-paced
Qualifications
- Bachelor’s degree or technical diploma in a related field with 3–5 years of experience preferred
- Hands-on experience administering Microsoft SQL Server and/or Oracle Databases is required
- Experience with IBM Db2, Azure SQL Database, or Azure SQL Managed Instance is preferred
- Experience with daily database operations: backup/restore, patching, monitoring, and maintenance
- Experience diagnosing query performance issues including blocking and deadlocks
- Experience in HA/DR technologies and RBAC user management
- Familiarity with monitoring tools: Redgate Monitor, SolarWinds DPA, OEM, Db2 Genius Hub
- Scripting in PowerShell, Bash, or Python is a plus
- Understanding networking basics for database connectivity is required
- Understanding Windows/Linux operating systems is required
- Adherence to Change Management and ITSM practices
- Attention to detail and ability to prioritize tasks
- Good communication with technical and non-technical teams
- Proactive mindset for reliability and performance
- Commitment to continuous learning and improvement
Responsibilities
- Provide Database Administration and Operational Support for enterprise databases including monitoring, maintenance, HA/DR configurations, and troubleshooting
- Administer database users, roles, and permissions following least-privilege principles
- Deploy security patches to protect data and reduce vulnerabilities
- Monitor and optimize database solutions using tools to track performance and capacity planning
- Collaborate with application teams on scalable database structures, procedures, and migrations
- Assist with root-cause analysis during incidents affecting performance or data integrity
- Support hybrid and cloud workloads (Azure SQL Database/Managed Instance)
- Participate in database modernization, cloud migration, automation, and IaC initiatives
Skills
Education
Tools
Job description
This position requires in-person collaboration up to five days a week. This arrangement is subject to change based on business requirements.
Since our story took off in 1996, WestJet has strived to enrich the lives of everyone in our world; a career with us is no exception. We’re proud to be one of Canada’s most admired and respected corporate cultures and continuously aim for the highest standards of service and success.
WestJet is seeking an Intermediate Analyst – Database Administrator reporting into our Database Services team. This individual will demonstrate a high standard of excellence, enjoys challenges, and is results driven. The incumbent must be highly motivated and enjoy self-learning.
The Intermediate Analyst – Database Administrator (DBA) works with a team comprised of Database Engineers (Senior Database Administrators) and MSP DBA resources. The DBA is responsible for administering, maintaining, and optimizing enterprise database platforms across Microsoft SQL Server, Oracle Database, IBM Db2, and Azure SQL Database. This role supports day-to-day operations, ensures database availability and performance, and contributes to ongoing modernization and cloud migration initiatives. The DBA has solid hands-on experience, strong troubleshooting skills, and a commitment to operational excellence.
NOTE: This role participates in an On-Call rotation.- 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
- Bachelor’s degree or technical diploma in Computer Science, Information Technology, Software Engineering, Database Administration or related field and 3-5 years of experience is preferred, or an equivalent combination of training and experience
- Hands-on experience administering Microsoft SQL Server and / or Oracle Databases is required
- Experience administering IBM Db2, Azure SQL Database, or Azure SQL Managed Instance is preferred
- Experience administering other database systems is nice to have
- 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 requiredExperience 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
- 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
- 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
WestJet provides all WestJetters with a competitive total rewards package. On top of that, we offer:
- A fun and friendly culture with colleagues who work together to win
- Travel privileges for you and your family, effective from your start date
- Savings and Benefit programs that are flexible to meet your specific needs
WestJet took to the skies in 1996 with just over 200 employees and three aircraft operating service to five destinations. Since then, WestJet has pioneered low-cost travel in Canada, cutting airfares in half, and increasing the flying population in Canada by more than 50 per cent. Since the Sunwing Airlines integration in 2025, more than 15,000 WestJetters support nearly 200 aircraft and connect guests to our global network of more than 100 destinations across North America, Central America, the Caribbean, Europe and Asia. The WestJet Group is a major Canadian employer and includes WestJet Airlines, WestJet Encore and Sunwing Vacations Group. We’re Canada’s leading value airline and largest vacation provider, with a united purpose of providing affordable and accessible air and vacation travel to Canadians.
At WestJet, the safety and security of our people and our guests is a core value and at the heart of what we do. Safety and security are shared responsibilities all team members are expected to use safe work practices to ensure their well-being and the safety of others. WestJet recognizes that the use of Alcohol and Drugs can adversely impact a safe work environment and the well-being of others including guests, suppliers and the public, as well as place WestJet's operations at risk. All roles that are identified as Safey-Sensitive are required to pass a Pre-Employment Alcohol and Drug Test as per WestJet'sAlcohol and Drug Policy.
We embrace what makes each of us unique, and what makes us uniquely WestJet. We welcome diverse skills, experiences and backgrounds so if you're passionate about this role, we encourage you to apply – even if you don't meet every qualification listed. WestJet is committed to inclusiveness, equity and accessibility throughout the selection process. If you require accommodation at any stage, please contact our Talent Acquisition team at talent@westjet.com.
We value the time and effort you put into your application. Our recruitment process is highly competitive and while every applicant will receive communication regarding their application status, only those selected to move forward will be contacted with next steps. If this role isn’t the right fit, we encourage you to explore future opportunities with us.
For more information about everything WestJet, please westjet.com/aboutus.
If you wish to withdraw your application or request that your personal information be deleted, please contact us at talent@westjet.com.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
