Senior Software Engineer (Database focused)

Senior Software Engineer (Database focused)

*** only Arizona residents are being considered at this time ***

Our client is an established and successful technology company helping transportation businesses improve safety and efficiency. They are seeking an Sr. Engineer with strong database skills.

The Senior Software Engineer will help solve the complex challenges of building high performance,

decision support systems. With great problem solving and communication skills, the Senior Software

Engineer will work in an agile environment with fast paced design, development and deployment.

This position focuses extensively on SQL Server and the data access layer, but successful

candidate should be comfortable working in the full stack as needed.

Essential Functions:

• Maintain and improve the complex stored procedures that build the warehouse tables.
• Optimize database performance using indexing and other techniques needed for large

datasets (> 3000 million rows).

• Maintain and optimize SQL Jobs, including adjusting job scheduling if needed.
• Understand how the data is used throughout Gridline products and be able to identify

upstream impacts.

• Ability to understand and summarize complex telematics data using SQL.
• Maintain source control of SQL code using Git.
• SQL Server administration roles, users, schema management, backups, recovery.
• Create and maintain web, console, and API based solutions using appropriate languages

while helping to drive the improvement of internal coding standards and best practices.

• Write software to integrate complex data from external APIs/sources.
• Analyze telematics and safety data to provide actionable insights to customers.
• Work in fast iteration cycles on tight deadlines using an agile/scrum methodology.
• Study system flow, data usage and user workflows to develop solutions for both internal and

external customers.

• Ensure the robustness, performance, and failure characteristics of the system.

Knowledge, Skills and Abilities:

• Strong MS SQL Server skills, including table design and advanced stored procedure

development, data warehousing, SQL jobs and database tuning.

• Experience working with datasets that exceed 300 million rows.
• Strong object-oriented programming skills
• Exceptional problem solving & debugging skills
• Familiarity with the consumption and presentation of API data
• Comfortable with C#
• Strong analytical and documentation skills
• N-tier design and programming
• Exposure to big data/large language models a plus
• React experience a plus
• Proficient in Microsoft Office

Education and Experience:

• Bachelor s degree in CS, MIS or CIS or related field or equivalent job-related experience.
• 7+ years T-SQL
• 4+ years C#
• 1+ years .NET 6+
• MS SQL Server administration experience
• Experience working with telematics, CAN bus, or other complex data
• Data integration applications experience
• SSRS and SSIS experience

Supervisory Responsibility

None

Position Type/Expected Hours of Work

This is a full-time position which will typically involve 40 hours a week Monday through Friday but are

subject to change at the company s discretion.