Person, Collage, Advertisement, Poster, Sunglasses, Accessories, Accessory, Flyer, Paper

Cloud Database Solutions Architect - Remote, USA

  • Virtual - USA, United States
  • Alabama, United States
  • Alaska, United States
  • Arizona, United States
  • Arkansas, United States
  • California, United States
  • Colorado, United States
  • Connecticut, United States
  • Delaware, United States
  • Washington, D.C., District of Columbia, United States
  • Florida, United States
  • Georgia, United States
  • Idaho, Georgia, United States
  • Hawaii, United States
  • Illinois, United States
  • Indiana, United States
  • Iowa, United States
  • Kansas, United States
  • Kentucky, United States
  • Louisiana, United States
  • Maine, United States
  • Maryland, United States
  • Massachusetts, United States
  • Michigan, United States
  • Minnesota, United States
  • Missouri, United States
  • Montana, United States
  • Nebraska, United States
  • Nevada, United States
  • New Hampshire, United States
  • New Jersey, United States
  • New Mexico, United States
  • New York, United States
  • North Carolina, United States
  • North Dakota, United States
  • Ohio, United States
  • Oklahoma, United States
  • Oregon, United States
  • Pennsylvania, United States
  • Rhode Island, United States
  • South Carolina, United States
  • South Dakota, United States
  • Tennessee, United States
  • Texas, United States
  • Utah, United States
  • Vermont, United States
  • Virginia, United States
  • Washington, United States
  • West Virginia, United States
  • Wisconsin, United States
  • Wyoming, United States
  • Flight Centre Travel Group
  • Full time

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, in-house financial and health services
  • Generous paid-time off policy 
  • National/International Award Nights and Conferences
  • Diversity & Inclusion initiatives
  • Benefits including vision, medical, and dental
  • Employee Assistance Program
  • Contributory 401K program
  • Company Share purchase scheme
  • 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-REMOTE
Location – Remote, USA

This position may be performed remotely anywhere within the United States except the State of Colorado

Any offer of employment in the USA that would require you to attend an office location or company event is contingent upon providing proof of Covid-19 vaccination prior to your start date, subject to approved medical and/or religious exemptions, in accordance with applicable law.

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.

FCTG USA is an affirmative action-equal opportunity employer searching for talented people who have a desire to build a rewarding, fun, and exciting career with a company that loves to celebrate your success! Please contact careers@us.flightcentre.com if you need any assistance. 

 

Apply Now

Not You?

Thank you and hold tight, you will now be directed to our Apply Portal to complete your application

 

Recommended Jobs

Corporate Traveler, Travel Manager - Dallas, TX

514265 Texas Texas United States Texas, United States Corporate Traveler (US) Corporate & Group Travel
Corporate Traveler is one of Flight Centre Travel Group’s (FCTG) most successful brands, globally. Our mission is to be the indisputable leader of the SME market, making the end-to-end travel experience seamless. For decades, we’ve been helping go...

Customer Success Manager - Calgary, Alberta

514261 Alberta Alberta Canada Alberta, Canada Corporate Traveller Corporate & Group Travel
As a Customer Success Manager at Corporate Traveller, you will be an integral element of post implementation revenue generation. While collaboratively working toward the key goals of your customers, you will maintain and grow revenue streams by ma...

Customer Success Manager - Vancouver, BC

514263 British Columbia British Columbia Canada British Columbia, Canada Corporate Traveller Corporate & Group Travel
As a Customer Success Manager at Corporate Traveller, you will be an integral element of post implementation revenue generation. While collaboratively working toward the key goals of your customers, you will maintain and grow revenue streams by ma...

Not right for you?

Sign up to job alerts!

Not You?

Thank you