As THE leader in transit technology, Clever Devices' vision is to make meaningful contributions to worldwide mobility. Our goal is to be the leading provider of exciting technology that improves the quality of mobility in communities around the world.

As a Database Engineer, you will be responsible for designing, implementing (which includes writing code), testing, and documenting software systems with an emphasis on the administration and development of database management systems such as SQL Server. This includes developing new features, enhancing existing features, and maintaining the existing code including performing bug fixes.

Primary Responsibilities:

• Write maintainable, clean, re-usable, object-oriented, and efficient code in compliance with department standards and templates.
• Investigate the root cause of issues and provide resolution.
• Work with source control; utilizing proper check-in procedures, branching, merging, and passing continuous builds to ensure that the software is always releasable.
• Practice Test Driven Development (TDD) and ensure that unit tests are created prior to writing code and that code is structured in such a way to maximize testability.
• Resolve software bugs in the programming code and modify unit tests to prevent future recurrence.
• Perform various types of testing including black box, white box, integration, functional, systems, sanity, smoke, regression, acceptance, stress, load, performance, usability, installation, recovery, security, compatibility, and more on software systems.
• Work within the context of department processes and procedures.
• Peer review programming code and participate in code reviews.
• Learn and understand the technical details of all relevant products and have hands-on familiarity of the system as required.
• Work with management to define and establish processes, templates, and standards related to software development and to continually improve the quality of the process.
• Contribute fresh, new ideas during developer meetings demonstrating a commitment knowledge sharing and on-going learning.
• Utilize tools to improve code quality.
• Mentor and assist in the on-boarding and training of other team members.
• Raise concerns to management and team members.
• Handle other tasks as directed by management.

Skills Required:

• A minimum of six (6) years of demonstrated prior work experience conducting the primary responsibilities outlined in this job description.
• Proficient English written and verbal communication skills.
• Exceptional knowledge and skill with SQL Server is essential.
• Exceptional knowledge of the administrative areas of SQL Server, including database clustering, security, logs, backups and restoration of backups, mirroring, replication, Always-On, file grouping and file allocation.
• Exceptional knowledge of the various tools provided by SQL Server and Windows, including SQL Server Profiler, Index Tuning Wizard, client statistics, query execution plans, optimization, statistics, etc.
• Exceptional skill writing high-performance T-SQL for stored procedures.
• Exception skill writing T-SQL Data Manipulation Language (DML) statements and Data Definition Language (DDL) statements.
• Experience with advanced debugging techniques, such as breakpoints, stepping through T-SQL code.
• Demonstrated experience developing large-scale, high-availability databases.
• Experience with Git or SVN (Subversion), source control, branching and merging, is an asset.
• Ability to quickly and independently learn new technologies, business and technical terms and concepts is essential.
• Ability to discern between value-added and frivolous work.
• Dedicated to continuous education by obtaining industry-related certifications and training.
• Ability to collaborate with multiple departments and teams, demonstrating high-quality interpersonal skills, including good listening skills, respectful treatment of others, and professional behavior contributing to a positive and enjoyable working environment.
• Ability to work as part of a team as well as independently having a self-starter ("can do") attitude.
• Comfortable speaking and interacting with technical and non-technical people.
• Excellent research, analytical, and organization skills with an exceptional eye for detail.
• Ability to perform work activities according to set priorities and delivery timelines.
• Ability to take constructive criticism.
• Desire to participate in speaking engagements and to be involved within user or other community groups and other events attended by the department.
• Diploma or degree in Computer Science or Engineering is required.
• Experience working in an Agile development environment is an asset.

PLEASE NOTE: Clever Devices mandates that all of its employees are vaccinated against SARS-CoV-2 virus (COVID-19), unless a medical or religious exemption applies.