Sr Systems Analyst at Transcore in Cary, NC | Kablio

Role

Description

stored procedures

sql queries

application troubleshooting

network config

database performance

linux config

Review and execute stored procedures as needed.
Create ad-hoc SQL queries as needed but support the Database Team for system upgrades and or performance-related issues.
Troubleshoot and follow through-to-resolution issues concerning the application, including configuration, database, peripherals, registry setting, etc.
Networking tasks such as adding windows devices to domain, configuring NIC settings, NTP settings.
Create, review and utilize technical documents.
Provide software and hardware Support-Triage for all toll systems within the region during normal business and on-call shifts. This includes pre and post system deployments.
Support system configuration validation during and post deployment of new systems or system changes to legacy systems.
Troubleshoot and resolve database integrity issues, performance issues, replication issues, connectivity issues, and security issues.
Modifying configuration files and FTP session file transfers to Linux devices.

Requirements

windows server

powershell

sql server

msmq

remote sessions

virtual machine

3+ years of experience in Windows Server support and administration
Reporting and analytical skills to interpret system data and how it relates to possible system issues, general data flow, and accuracy.
Familiarity with MSMQ and services installation and configuration.
Ability to follow detailed instructions with little supervision.
Aptitude and desire to learn new scenarios quickly.
Proficiency with Windows scripting/PowerShell. Both editing and writing.
3+ years of professional experience in SQL Server Database support and administration. The latest experience should be with using SQL Server 2012, 2014, 2019, 2022.
Ability to analyze transaction data reports and reconcile data differences and report findings to stakeholders
Ability to understand business requirements and estimate for delivery commitments.
5+ years of professional experience with troubleshooting and customer support.
Excellent organizational, verbal, phone, and written communication skills.
Proficiency with remote sessions to servers, windows desktops and Linux devices.
5+ years of experience in Windows Server support and administration
Familiarity with Virtual Machine environments
3+ years of professional experience with troubleshooting and customer support.
Highly motivated team-player who can establish excellent working relationships with peers and other teams.

Benefits

Information not given or found

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

Founded 1939

Founded

The company began operations in 1939, initially outfitting Pennsylvania's first toll road with radio communications.

$1.7B Revenue

Yearly Revenue

Annual revenue as part of the Roper/ST Engineering group.

125M Tags

RFID Tags Sold

Over 125 million RFID tags sold, demonstrating global leadership in electronic tolling.

3.5K+ Lanes

High-Speed Lanes

Installed over 3,500 high-speed lanes worldwide, advancing intelligent transportation systems.

Evolved into a global provider of transportation solutions, now deploying express lanes, toll systems, and smart traffic networks.
Expertise spans electronic tolling, intelligent transportation systems, RFID-based access control, and customer service centers.
Has delivered projects like open-road tolling conversions, major express lane installations, and airport access systems.
Standout facts include operating toll customer service centers internationally and integrating vehicle-to-vehicle initiatives.

Culture + Values

Upholding the highest standards of honesty and ethics in everything we do.
Creating innovative solutions to meet customer needs and improve the future of transportation.
Committed to excellence in all aspects of business, delivering superior products and services.
Working together as a team, sharing knowledge and expertise to achieve common goals.
Prioritizing customers, striving to exceed their expectations through responsiveness and quality service.

Environment + Sustainability

2050

Net-zero by 2050

Aiming for net-zero carbon emissions by the year 2050.

Committed to environmental sustainability and reducing its carbon footprint.
Focused on energy-efficient operations and reducing waste.
Actively works on creating solutions for sustainable transportation infrastructure.

Inclusion & Diversity

Strives to create a workplace where all employees are treated with respect and valued for their contributions.
Has implemented programs aimed at promoting an inclusive work environment.
Gender diversity statistics and specific outcomes related to inclusion are not publicly disclosed.

Articles

Careers

Innovative Solutions

Role

Description

stored procedures

sql queries

application troubleshooting

network config

database performance

linux config

Review and execute stored procedures as needed.
Create ad-hoc SQL queries as needed but support the Database Team for system upgrades and or performance-related issues.
Troubleshoot and follow through-to-resolution issues concerning the application, including configuration, database, peripherals, registry setting, etc.
Networking tasks such as adding windows devices to domain, configuring NIC settings, NTP settings.
Create, review and utilize technical documents.
Provide software and hardware Support-Triage for all toll systems within the region during normal business and on-call shifts. This includes pre and post system deployments.
Support system configuration validation during and post deployment of new systems or system changes to legacy systems.
Troubleshoot and resolve database integrity issues, performance issues, replication issues, connectivity issues, and security issues.
Modifying configuration files and FTP session file transfers to Linux devices.

Requirements

windows server

powershell

sql server

msmq

remote sessions

virtual machine

3+ years of experience in Windows Server support and administration
Reporting and analytical skills to interpret system data and how it relates to possible system issues, general data flow, and accuracy.
Familiarity with MSMQ and services installation and configuration.
Ability to follow detailed instructions with little supervision.
Aptitude and desire to learn new scenarios quickly.
Proficiency with Windows scripting/PowerShell. Both editing and writing.
3+ years of professional experience in SQL Server Database support and administration. The latest experience should be with using SQL Server 2012, 2014, 2019, 2022.
Ability to analyze transaction data reports and reconcile data differences and report findings to stakeholders
Ability to understand business requirements and estimate for delivery commitments.
5+ years of professional experience with troubleshooting and customer support.
Excellent organizational, verbal, phone, and written communication skills.
Proficiency with remote sessions to servers, windows desktops and Linux devices.
5+ years of experience in Windows Server support and administration
Familiarity with Virtual Machine environments
3+ years of professional experience with troubleshooting and customer support.
Highly motivated team-player who can establish excellent working relationships with peers and other teams.

Benefits

Information not given or found

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

Founded 1939

Founded

The company began operations in 1939, initially outfitting Pennsylvania's first toll road with radio communications.

$1.7B Revenue

Yearly Revenue

Annual revenue as part of the Roper/ST Engineering group.

125M Tags

RFID Tags Sold

Over 125 million RFID tags sold, demonstrating global leadership in electronic tolling.

3.5K+ Lanes

High-Speed Lanes

Installed over 3,500 high-speed lanes worldwide, advancing intelligent transportation systems.

Evolved into a global provider of transportation solutions, now deploying express lanes, toll systems, and smart traffic networks.
Expertise spans electronic tolling, intelligent transportation systems, RFID-based access control, and customer service centers.
Has delivered projects like open-road tolling conversions, major express lane installations, and airport access systems.
Standout facts include operating toll customer service centers internationally and integrating vehicle-to-vehicle initiatives.

Culture + Values

Upholding the highest standards of honesty and ethics in everything we do.
Creating innovative solutions to meet customer needs and improve the future of transportation.
Committed to excellence in all aspects of business, delivering superior products and services.
Working together as a team, sharing knowledge and expertise to achieve common goals.
Prioritizing customers, striving to exceed their expectations through responsiveness and quality service.

Environment + Sustainability

2050

Net-zero by 2050

Aiming for net-zero carbon emissions by the year 2050.

Committed to environmental sustainability and reducing its carbon footprint.
Focused on energy-efficient operations and reducing waste.
Actively works on creating solutions for sustainable transportation infrastructure.

Inclusion & Diversity

Strives to create a workplace where all employees are treated with respect and valued for their contributions.
Has implemented programs aimed at promoting an inclusive work environment.
Gender diversity statistics and specific outcomes related to inclusion are not publicly disclosed.

Articles

Careers

Innovative Solutions