Senior Database Engineer

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.

Overview
As a Senior Database Engineer/Developer, 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.

Technology Stack
Microsoft SQL Server, PostGreSQL, NoSQL

Primary Responsibilities

• Writes SQL queries and stored procedures to support the development of new features.
• Reviews execution plans and adds/modifies indexes to ensure efficient execution of queries.
• Creates, modifies, and sequences maintenance jobs to ensure seamless execution without impact to end users of the system.
• 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.
• Adheres to documented secure Software Development lifecycle including addition of unit tests for newly added code.
• 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 latest versions of 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.
• Exceptional 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 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.

Clever Devices is an Affirmative Action/Equal Opportunity Employer

The compensation range posted for this position represents the anticipated minimum and maximum compensation for this position based upon a good faith and reasonable estimate. The exact compensation offered will depend on several factors such as the candidate’s experience, skills, training, education and/or physical location; internal equity; and, budget.

In addition, Clever Devices Ltd. offers a variety of benefits to eligible employees, including health insurance coverage, wellness and family support programs, life and disability insurance, retirement savings plans, paid leave programs, education-related programs, paid holidays and time off, and many others, depending on the level and position offered. Many of these benefits are subsidized or fully paid for by the company.

This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Duties, responsibilities, and activities may change, or new ones may be assigned at any time with or without notice based on business need.