SENIOR DATABASE ENGINEER | Cox Automotive Canada

  • Cox Automotive Canada
  • 277 Lawson Rd, Milton, ON, Canada
  • Jan 23, 2021
Full time Administration General Information Technology (IT)

Job Description

Primary Location: 8277 Lawson RdMiltonON, CA

Division: Cox Automotive

Job Level: Intern/Co-op

Travel: No

Schedule: Full-time

Shift: Day Job

Requisition Number: 210618

 

 

This position will join our growing team of database experts for Cox Automotive Canada. You will be responsible for expanding and optimizing our database platform, as well as migrate databases on-prem to cloud. You will be responsible for the AWS database migration, replication, management, performance, integrity, and security of the Cox Canada databases, provides technical expertise in the planning design, implementation, and maintenance of database management systems that support Cox applications across all environments. As part of production support, the candidate will participate in an on-call rotation which will be scheduled in advance.

 

 

ESSENTIAL RESPONSIBILITIES:

Application

  • Designing schema, modeling, access patterns, SQL development, and tuning
  • Advance knowledge of data access patterns and data normalization
  • Evolution Database Design to support Datasets, data migration and automation
  • Optimizing application and end-user queries
  • Proactive performance tuning
  • Design and implement optimize data store
  • In-depth knowledge of CICD and database deployments

Database Operationalization

  • Database deployment automation
  • Evaluate and monitor databases to resolve performance issues, minimize data redundancy and support capacity planning.
  • Monitor and optimize the performance of on-prem and cloud databases
  • Version & Patch Management On-prem and Cloud
  • Multiple environment cloning
  • Data recovery and Database recovery
  • Data Migration, Replication and ETL

Security

  • Enrolling users and maintaining system security
  • Controlling user access to the database 
  • Compliance & Audit

Qualifications:

REQUIRED EXPERIENCE & SPECIALIZED KNOWLEDGE AND SKILLS:

  • Graduate degree in Computer Science, Computer Engineering or a related field
  • Advance knowledge of AWS cloud automation and database performance and recovery
  • Extensive experience with database technologies (PostgreSQL, MySQL, MS SQL, Oracle)
  • Advance knowledge of NOSQL DB (Mongo, DynamoDB, DocumentDB)
  • Expertise in microservice architecture and distributed database architecture
  • Experience in AWS database cloud migration
  • Knowledge of ‘relational database management systems’ (RDBMS), ‘object-oriented database management systems’ (OODBMS) and XML database management systems
  • Experience of programming and scripting language python, shell
  • Experience working with application development teams
  • Perform technical analysis and troubleshooting on complex database problems
  • Provide proactive monitoring and alert notification for system outages
  • Advanced knowledge of SQL schema modeling and evolution
  • Excellent troubleshooting, documentation, and communication skills
  • Provides troubleshooting and support including after-hours support

Who We Are

About Cox Automotive

There’s nothing ordinary about Cox Automotive. We are people of every background driven by our passion for mobility, innovation, client success and community outreach. We make buying, selling and owning (or simply using) cars easier for everyone. Touching more than 40,000 clients across five continents, we bring together the best brands and the best teams to propel the automotive industry forward. Some of those team members work for our iconic consumer brands like Autotrader and Kelley Blue Book, while others are creating the future of automotive at industry-facing brands like Dealer.com, Manheim and vAuto.

 

About Cox 

We are the Cox family of businesses. We’ve been making our mark since 1898 by building and evolving world-class businesses, staying true to our values, and encouraging top talent to always look for growth and impact while building a career with us.  Our primary divisions – Cox Communications and Cox Automotive – are driving a new wave of innovation, powering smart cities with powerhouse broadband communications and pioneering greener, more progressive transportation alternatives for individuals and fleet operators.  We’re also expanding into new spaces like cleantech and healthcare to rev up our momentum toward building a better future for the next generation.  We’re looking for the talent today who will be our leaders tomorrow. Sound intriguing? Learn more about where we are today, where we hope you’ll be going with us, and the common purpose that unites us at coxenterprises.com.   

Cox is an Equal Employment Opportunity employer – All qualified applicants/employees will receive consideration for employment without regard to that individual’s age, race, color, religion or creed, national origin or ancestry, sex (including pregnancy), sexual orientation, gender, gender identity, physical or mental disability, veteran status, genetic information, ethnicity, citizenship, or any other characteristic protected by law.

Job ID: 210618