Database engineer Jobs in Toronto, ON

Senior Database Engineer

Bangalore, India

Shell Recharge Solutions is a leader in delivering the new electric mobility future through innovative software, infrastructure, and professional services that empower utilities, cities, fleets, transit agencies, and automakers to deploy EV charging infrastructure at scale. Our technology is connecting EV infrastructure solutions with public and private charging needs in a safer, cleaner, and smarter way. Headquartered in Los Angeles, CA, the company’s global footprint spans across three continents with deployments in 13 different countries. At Shell Recharge Solutions, we are looking for candidates who want to be a part of something bigger than themselves – passionate, purpose-driven individuals who believe having a career means making a meaningful impact on our business and the world. We believe in creating and doing ‘the right thing’ through responsible and sustainable EV deployment. We are looking for the innovative, driven to find a solution in a complex and dynamically evolving marketplace and look at “no” as just a challenge to find the next “yes”.

Shell Recharge Solutions is seeking a

Senior Database Engineer!

The ideal candidate is an integral part of a fast-paced development team that builds an integrated product suite of Enterprise applications in the EV Charging network domain. The Candidate will participate in the technical design of database SQL queries for new products, as well as review and tuning database queries in existing products. This candidate works closely with rest of cross-functional team to produce design documents, implement database optimizations, and provide benchmarks. If you find passion in the Company’s mission, your qualifications and interest align with the expectations below, we would love to talk to you about this position.

What you’ll do :

The ideal candidate will be an integral part of a fast-paced development team that builds an integrated product suite of Enterprise applications in the EV Charging network domain

Candidate will participate in the technical design of database / SQL queries for new products, as well as review and tuning database queries in existing solutions

This candidate will work closely with rest of cross-functional team to produce design documents, implement database optimizations, and provide benchmark metrics

Design and contribute SQL aspects for web and microservice APIs based applications

Support Production Database

Implement DB partitioning, compression and indexing strategies for performance optimization

Define and execute data archival and deletion activity as per business and legal requirements.

Collaborate with cross functional teams including our Global Engineering teams in an Agile development environment

Proven experience successfully optimizing databases for performance & scalability

Provide queries for ad hoc data requirements.

Perform or help dev team in DB data migration activities.

Utilize problem solving skills to implement creative solutions to tough problems

Advocate for best-in-class database and storage solutions for large scale enterprise applications

What We’re Looking For :

Basic Qualifications

Bachelor’s degree in computer science / engineering or equivalent experience required

7+ years of software development experience.

Creating database views, functions, and stored procedures

Writing optimized SQL queries for integration with other applications

Creating database triggers for use in automation

Maintaining data quality and overseeing database security

Designing database tables and structures

Experience with GitHub / Bitbucket, Jira, Scrum, SonarCloud and CI / CD processes.

Experience working on software-as-a-service (SaaS), large scale distributed systems and relational / No-SQL databases

Experience working in a small team setting along with onshore development team

Strong verbal and written communication skills : proven ability to lead both vertically and horizontally to achieve results; thrives in a dynamic, fast-paced, environment and do what it takes to deliver results

Committed to security practices in policy and delivery

Willing to be a model citizen / mentor in security practices for Shell Recharge Solutions

Preferred Qualifications

Strong proficiency in MySQL database management

Hands on experience with recent versions of MySQL (Prefer AWS RDS MySQL)

Understanding of MySQL's underlying storage engines, such as InnoDB

Experience with replication configuration in MySQL

Knowledge of de-facto standards and best practices in MySQL

Understanding and experience with AWS RDS, what are the limitations and benefits of RDS in general

Experience with optimizing indexes and queries

Understanding the Query Execution Plan

Experience using MySQL Performance tool like MySQLTuner

Nice to have - Knowledge of Elastic search and other NoSQL DB like MongoDB etc.

What We Offer :

A work environment that allows you to work with and learn from some of the best and brightest in this emerging industry

The ability to make a difference in a world that needs our technology to help reduce carbon emissions and enable a more sustainable energy future through the use of electric vehicle charging software, services and infrastructure

The freedom to learn, suggest, and implement innovative new ideas applied to our systems, processes, programs and technologies

Daily ownership of your role in a challenging, high-growth environment.

A casual work environment and culture that support work life ‘fit’, enabling you to fit life into your work and work into your life, i.e. flexible scheduling, virtualization options, and a generous holiday package

Competitive pay and benefits programs designed to enable you to thrive inside and outside of work

Participation in Shell Recharge Solutions’ performance and rewards bonus program

Best in class medical benefits for employees

Innovative Paid Time Off Program

9 / 80 Flex Work schedule

#J-18808-Ljbffr