Job Description

Cloud Database Solutions Architect
 
This role requires hands on experience developing high performance, highly scalable SQL Server operational databases supporting web applications.  The suitable candidate should feel at ease refactoring tables and code, with a proven track record of increasing the volume of transactions and scaling web site performance.  This is a great opportunity to architect the next step in database design for an already successful product as it increases its global reach (currently has millions of users and thousands of customers across the world).  Looking for someone with great ideas and the ability to implement them!
Our development team works in an open, agile environment that values innovation and a startup attitude, while enjoying the stability of being part of a leading travel industry company.
Responsibilities:
Experience in leading data strategy initiatives including the architecture of modern cloud-based data platforms with technologies such as Azure SQL Database, Azure Data Factory, Big Data/Data Lakes, ETL/ELT, Modern Data Warehouses and Analytics.
Define enterprise data architecture standards, data models, data platforms and development processes and tools.
Identify and implement performance and scale improvements in our SQL Server databases
Create and/or redesign schema objects such as tables, stored procedures, triggers, and indexes to remove performance bottlenecks
Ability to build logical and physical data models meeting business requirements
Ensure databases are running at peak efficiency by working with DBA’s and other team members
Independently discover barriers to database performance and correct them
Perform database code review with C# developers to ensure functional correctness and performance
Assist technical documentation team with the preparation of required materials
Actively participate in team agile activities including standups, planning, retrospectives, etc.
Knowledge of security best practices and oversight of secure database coding
Maintain SQL Coding standards
Requirements:
8+ years SQL Server database development experience, with at least 5 years performance tuning and database architecture experience
Experience migrating from SQL Server on VM to Azure SQL Database
Experience with Azure Data Factory
Online Transaction Processing schema design and optimization, including table partitioning/normalization/denormalization
Proficiency in modeling data with design tools such as erWin, ER/Studio, etc.
Extensive experience with SQL Server performance tuning tools
Demonstrated proficiency in advanced techniques of stored procedure, trigger, and index performance tuning
Experience scaling SQL Server systems up and out
Building database deployments in Azure DevOps
SQL Server Data Encryption
Background in Power BI, Analytics, Machine Learning, Azure Data Lakes, Azure Functions, Azure Redis Cache, Cognitive Search, Azure Active Directory, Azure Key Vault
Experience in PCI, GDPR, ISO, or other security compliance
SSIS or other ETL experience
C# and MVC exposure
Atlassian suite products such as Jira and Confluence
Benefits Include:
Generous remuneration structure
Travel perks/discounts.
Health & Wellness Programs and Employee Financial Wellness Services
Generous paid-time off policy 
National/International Award Nights and Conferences
Diversity & Inclusion initiatives
Benefits including vision, medical, and dental
Employee Assistance Program
RRSP with matching
Employee Share Plan
Global career opportunities in a network of brands and businesses
Ongoing training and professional development
Fun and flexible work environment
Proud Corporate Social Responsibility platform through the Flight Centre Foundation and Brighter Futures program supporting nominated charities through Workplace Giving, Volunteering and Fundraising.
Employee giving program
Annual Charity Trip
Office Environmental Program
1 Volunteer Day per Calendar Year
#LI-REMOTELocation – Remote, Canada
If this sounds like the opportunity you have been waiting for and you would like to be part of our award winning culture then APPLY NOW.
Travel is booming once again,  and our roles are being filled quicker than a nonstop from London to New York.  We thank all candidates for their interest; however, only those selected to continue in the process will be contacted.
Our promise is to provide an environment with equality of respect, dignity and opportunity for all our employees.  We value an inclusive and supportive workplace which truly reflects the diversification of our society.  Flight Centre Travel Group is committed to providing a barrier-free pathway throughout our recruitment selection process.  If you require accommodation because of a disability at any stage of our hiring process, please let us know in advance by contacting our Recruitment Team at fccareers@flightcentre.ca