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.