Database Administrator

Join to apply for the Database Administrator role at Sunwing

About Us

Sunwing Vacations Group is home to North America’s largest vacation brands, comprised of the leading Canadian leisure tour operators Sunwing Vacations and WestJet Vacations, along with the growing United States based tour operator Vacation Express, together with the Group’s own travel retail businesses SellOffVacations.com and Luxe Destination Weddings. Our culture is driven by our EPIC Values (entrepreneurial, passionate, innovative, and customer‑centric) and our teams work together to deliver our purpose “passionate people making vacation dreams come true”.

The Opportunity

As the Database Administrator, you are responsible for the installation, configuration, upgrade, administration, monitoring, maintenance and security of the databases installed at Sunwing Travel Group in MS Azure on IaaS and PaaS solutions. The role includes the development and design of database strategies, system monitoring and improving database performance and capacity, and planning for future expansion requirements as well as plan, coordinate and implement security measures to safeguard the databases.

What You’ll Do

• Manage SQL Server and Snowflake databases through multiple product lifecycle environments, from development to mission‑critical production systems.
• Assist in migration of SQL Server instances to Azure PaaS from Azure IaaS solutions.
• Investigate and resolve Database issues.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO).
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end, including after‑hours and weekends.
• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Upgrade MS SQL Server environment to the latest versions and patches.
• Deploy database change scripts provided by third party vendors.
• When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index / query changes.
• Document the company’s database environment as well as operational procedures and processes.
• Design and write complex SQL Server scripts to automate database management tasks where possible.
• Provide after‑hours On Call Support as required as you will be the person the company would call if the SQL Server service stopped working.
• Ensure that new database code meets company standards for readability, reliability, and performance.
• Maintain, implement and develop reports showing usage, metrics and consumption of DBA resources and suggest ways to improve performance on each.
• Design indexes for existing applications, choosing when to add or remove indexes.
• Assist developers with complex query tuning and schema refinement.
• Conduct SQL Server lunch‑and‑learn sessions for developers.
• Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc).

What You’ll Need

Tuning T‑SQL queries to improve performance.

What We Offer

We thank all who apply; however only those who meet the qualifications will be contacted.

Diversity, equity, and inclusion

Diversity makes us EPIC; we strive to foster a culture where employees feel uniquely themselves and part of a team. Violence and harassment prevention and response – We partnered with White Ribbon to help us create a survivor‑centric, trauma‑informed policy and educational programs used by all our divisions. Total wellbeing – Our approach is for holistic opportunities to help employees Be EPIC and Be Well. Learning and development – Our offerings are focused on the development of competencies, personal leadership, and leadership in groups and teams.

Employment Equity & Accommodations

We are also committed to employment equity and to fostering an inclusive, accessible environment. We welcome applications from everyone. We will accommodate all applicants throughout the hiring process. If you are an individual who requires accommodation to apply to this position, please email recruiting@sunwing.ca.

Seniority level

Mid‑Senior level

Employment type

Full‑time

Job function

Information Technology

Industries

Travel Arrangements

#J-18808-Ljbffr