Software Engineer I

Posted 24 Minutes Ago
Be an Early Applicant
Nashville, TN, USA
Hybrid
Junior
Payments • Transportation
The Role
Develops and optimizes SQL Server databases supporting large-scale tolling applications. Responsibilities include designing tables, writing T-SQL procedures, tuning queries and performance, creating database objects and backup solutions, supporting application teams, analyzing requirements, and documenting database operations. The role also involves analytics, statistical modeling, data integration using XML, JSON, and CSV, and contributing to software upgrades and enterprise application development.
Summary Generated by Built In

TransCore (TRN), a subsidiary of ST Engineering, is seeking a full-time Software Engineer I, SQL Development to join our team in Nashville, Tennessee.

Summary:

This position is responsible for setting up, managing, and optimizing databases in support of enterprise and external web applications. This includes working closely with system managers and developers to add system functionality, tables, and data; optimizing systems for availability and performance; and contributing to system upgrades. This position is also responsible for maintaining applications, processes, and maintenance procedures; performance tuning; and documentation and management of changes to database operations.

TransCore toll systems are designed to maximize revenue collection for our customers through highly accurate products and efficient operations – 8 out of 10 toll agencies in the United States use TransCore toll collection systems.

You will be part of TransCore’s industry-leading Infinity Tolling Database Solution and a first-of-its-kind Congestion Pricing System Program in North America. You will handle billions of traffic transactions and images that facilitate improved traffic flow, more predictable travel time, reduced carbon emissions, and the recurring revenue necessary to improve public transportation infrastructure.

Essential job duties include the following but are not limited to:
  • Designing, developing, and implementing the company's proprietary software solutions,
  • Creating databases, designing tables, and writing T-SQL stored procedures,
  • Working with Application/Service Teams to identify best solutions based on business requirements and involved in design/implementation based on DB standards,
  • Enabling smarter business processes by using analytics for meaningful insights,
  • Researching, devising, and building innovative statistical models using algorithms to mine data stores,
Required Experience/Education:
  • Bachelor’s degree or Master's degree in Mathematics, Computer Science, Engineering, or a related IT field with 0-5 years of experience in SQL development that includes a strong understanding of RDBMS modeling, designing, coding, and developing applications,
  • Development that includes a strong understanding of RDBMS modeling, designing, coding, and developing applications,
  • Back-end application development for large-scale, high-performance systems using Microsoft SQL Server 2016/2019/2022,
  • SQL Server experience including performance tuning, query optimization, and writing stored procedures, user functions, indexes, and database triggers,
  • Sending and receiving data using XML, JSON, CSV formats and bulk insert/exports,
  • Creating objects for new data requirements; creating database backup jobs/solutions,
  • Analysis of business and technical requirements to develop and enhance complex code.
Desired Skills and Experience:
  • Ability to handle multiple tasks and adapt to a constantly changing environment,
  • Reviewing SQL Code, recommending suggestions for system performance,
  • Knowledge of table partitioning, execution plans, running profilers, error handling, using DevOps, Azure, and Red Gate,
  • Publishing ER diagrams, data dictionaries, and system documentation,
  • Microsoft certification (related to databases).

Physical Demands:   

While performing the duties of this job, the employee is regularly required to sit for extended periods of time. Requires frequent use of keyboard and mouse, must be able to wear a headset for prolonged periods. The noise level in the work environment is usually moderate.   

* TransCore complies with federal and state disability laws and provides reasonable accommodation for employees with disabilities.    

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.

Skills Required

  • Bachelor’s or master’s degree in Mathematics, Computer Science, Engineering, or a related IT field
  • 0–5 years of SQL development experience
  • Strong understanding of relational database modeling, design, coding, and application development
  • Back-end application development experience for large-scale, high-performance systems
  • Microsoft SQL Server 2016, 2019, or 2022 experience
  • SQL Server performance tuning and query optimization experience
  • Experience writing stored procedures, user-defined functions, indexes, and database triggers
  • Experience sending and receiving XML, JSON, and CSV data, including bulk inserts and exports
  • Experience creating database objects and database backup jobs or solutions
  • Ability to analyze business and technical requirements and develop or enhance complex code
  • Ability to manage multiple tasks and adapt to a changing environment
  • Experience reviewing SQL code and recommending performance improvements
  • Knowledge of table partitioning, execution plans, profilers, error handling, DevOps, Azure, and Red Gate
  • Experience publishing ER diagrams, data dictionaries, and system documentation
  • Microsoft database-related certification

TransCore Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about TransCore and has not been reviewed or approved by TransCore.

  • Healthcare Strength — Health, dental, and vision coverage are described, alongside company-paid life, AD&D, and short-term disability, plus access to an EAP.
  • Retirement Support — A 401(k) plan with company match and immediate vesting of employer contributions is offered, signaling solid retirement support.
  • Leave & Time Off Breadth — Paid holidays, sick days, and PTO are commonly listed, and parental leave is referenced in some contexts.

TransCore Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Nashville, TN
1,212 Employees
Year Founded: 1934

What We Do

A leader in the transportation industry, TransCore provides innovative, technical solutions and engineering services for applications encompassing next generation Open Road Tolling and Traffic Management systems. The company operates award-winning tolling customer service centers for departments of transportation throughout the U.S. and internationally. A pioneer in Radio Frequency Identification systems used in the transportation industry, TransCore secures access for airports, hospitals, parking garages, border patrols, trucking fleets and the rail industry. TransCore is a wholly-owned subsidiary of Roper Technologies, a diversified technology company in the S&P 500, Fortune 1000 and Russell 1000 indices.

Similar Jobs

Samsara Logo Samsara

Senior Software Engineer

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
United States
4000 Employees
155K-260K Annually

TransCore Logo TransCore

Quality Assurance Engineer

Payments • Transportation
Hybrid
Nashville, TN, USA
1212 Employees
In-Office or Remote
2 Locations
In-Office or Remote
2 Locations

Similar Companies Hiring

Playground (tryplayground.com) Thumbnail
Kids + Family • Payments • Social Impact • Software
New York City, New York
80 Employees
Scotch Thumbnail
Artificial Intelligence • eCommerce • Fintech • Payments • Retail • Software • Analytics
US
35 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account