SQL DBA/Azure Cloud Engineer

SQL DBA/Azure Cloud Engineer

Description

CARFAX Canada is looking for an experienced DB Operations/Cloud Engineer to help manage MS SQL/Azure SQL Databases and Azure Cloud in our Technical Operations team! If you have a passion for cloud-based software, experience managing production databases and love a challenge, we want to hear from you!

About Us

CARFAX’s mission is to help millions of people shop, buy, own or sell used cars with more confidence. As a leader in vehicle history and valuation, CARFAX provides impartial and comprehensive information for consumers and the automotive industry. CARFAX‘s Canadian headquarters supports North American product development, drawing on billions of data records from thousands of sources, CARFAX products enable used vehicle buyers and sellers to make informed decisions.  CARFAX is consistently recognized as a top employer and business. CARFAX is a part of IHS Markit, (NYSE: INFO), a world leader in critical information, analytics and solutions. Find out more at www.carfax.ca and connect with CARFAX on Instagram, Facebook and LinkedIn.

Working Here

At CARFAX Canada, you’re not just another employee. You’re a critical contributor to the big picture and rely on data when making important decisions. You have a future mindset and are motivated to grow with us. You have a thirst for learning new things and building your skillset. You dream big and chart your own career path. You don’t settle for what’s quick and easy because you value quality. You know that the best teams are built on trust, so you use your voice to collaborate and create real change. You believe in taking the time to celebrate wins and have fun. You know leading a balanced lifestyle in a supportive work environment is important. You’re not just another employee. You are a CARFAX Canadian!

Job Details

CARFAX Canada is excited to announce the position of SQL DBA/Azure Cloud Engineer, reporting to our Manager of Cloud and DevOps. This role will be part of a dynamic operations team that is excited to promote and adopt a Database DevOps mindset. In this role, you will work closely with engineering/architecture, data management and IT support to ensure our production systems are deployed, managed, and monitored. You will be asked to lead, manage, assess, and implement structure, process, and monitor database systems. Providing feedback to all teams will be key to your team’s continuous improvement. You will be required to learn, research, pilot and recommend new tools and technologies that can be leveraged to improve the way we work.

Position Responsibilities

• Support database workloads in Azure Cloud and SQL expertise as a shared resource to Agile projects
• Pro-active and reactive performance analysis, monitoring, troubleshooting and resolution of difficult SQL issues
• Administrative support of MS SQL Server versions 2016, 2019 and Azure SQL including: Database Engine, Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS)
• Configure Azure SQL database/elastic pools for scale and performance
• Implement data security, Transparent Data Encryption (TDE), object-level encryption, Dynamic Data Masking, Azure Key Vault, and disk encryption for Azure VMs
• Prepare operational performance baseline, assess database performance by using Intelligent Insights for Azure SQL Database and Managed Instances
• Migration of database objects from development through production following documented standards, policies and procedures (Change Management Process)
• Extensive experience with MS SQL production environments
• Reviewing all artifacts planned for production release including but not limited to: Store Procedures, SSIS packages, SSRS, database designs, extract value from its data by creating and managing ETL jobs
• Participation in after-hours and weekend support of production implementations, infrastructure activities, and various disaster recovery exercises
• Advise on, and implement best practices for monitoring, logging and alerting
• Maintain compliance with our backup policies/strategies and help refine disaster recovery plans

Education and Experience Required

• 8+ years of experience as a database administrator or engineer
• College diploma or University degree in Computer Sciences or a similar field of study
• Experience managing/ supporting MS SQL database servers used by .Net, C# applications, and CI/CD
• Experience monitoring tools such Applications Insights, Azure Monitor, log analytics, Kusto Query Language, alerting, dashboards, workbooks, KPIs Master-level scripting and automation abilities (PowerShell, ARM Templates, Runbooks, Cloud Shell, T-SQL stored procedures and functions to support internal processes and improve system performance)
• Previous experience working in an Agile environment
• Database and Cloud certification, preferably Microsoft Certified: MSCA, Azure DBA, Azure Administrator

CARFAX’s Canadian headquarters are located in London, Ontario at the historical landmark 100 Kellogg Lane. We’re proud to offer competitive pay, benefits and bonus, RRSP matching, maternity leave top-up, health and wellness initiatives, social events and a 4-day work week in the summer.

If you are interested in applying for this position, please visit our website: carfax.ca/careers. Applications will be accepted until April 23, 2021. We’re committed to providing accommodations for people with disabilities. If you require an accommodation during the application or selection processes, please advise in your cover letter.

We thank all applicants for their interest; however only those selected for an interview will be contacted.

Not exactly the position you were looking for, but still want to join our awesome team? Visit our careers page to learn more about us and to see our other job openings!