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,
- 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.
- 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 DisabilitiesThis 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
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.







