Principal Database Engineer

Clever Devices Ltd.•Woodbury, NY

About The Position

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 Principal 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. The primary technologies used in this position are Microsoft SQL Server, PostGreSQL, NoSQL

Requirements

Diploma or degree in Computer Science or Engineering is required.
A minimum of ten (10) years of demonstrated prior work experience conducting the primary responsibilities outlined in this job description.
Experience with advanced debugging techniques, such as breakpoints, stepping through T-SQL code.
Deep knowledge of product domain attained through industry experience.
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 table and index partitioning
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.
Demonstrated experience developing large-scale, high-availability databases.
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.

Nice To Haves

Experience with Git source control, branching and merging, is an asset.
Experience working in an Agile development environment is an asset.

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.
Other duties as assigned.