TransCore · 23 hours ago
Database Administrator II
Houston, TX
Full-time
Onsite
Mid, Senior Level
5+ years expTransCore, a subsidiary of ST Engineering, is seeking a full time Database Administrator II to join their team. The role involves providing technical support for Infinity production installations, troubleshooting database issues, and ensuring optimal database performance and configuration.
RFIDSoftwareTransportationTravel
Responsibilities
Owns and executes daily, weekly, and monthly maintenance tasks, monitoring application performance, backups, replication and data restore, creating and granting logins and support procedures of supported SQL-based infrastructure systems
Responsible for the development and sustainment of the SQL Server Data Warehouse, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modeling
Design and create Fact and Dimension tables; involve in maintaining and troubleshooting SSIS packages
Create and maintain proper documentation of all the SSIS and SSRS reports
Conduct analysis on data to answer important business questions and forecast business threads
Ensure that storage, archiving, back-up and recovery procedures are functioning correctly
Provide first line of software/database support for our Infinity installations during normal business and off hours
Provide support to current deployments and processes, contributing to new requests for enhancements, troubleshooting existing processes and validating system requirements
Develop and optimizing SQL queries, stored procedures and functions to support system operations and customer requirements
Experienced in HADR features like AlwaysOn implementation and troubleshooting
Create required database indexes, index management, and maintain statistics
Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, and security issues
Monitor current system installations for performance degradation and perform preventative and corrective cleanup activities to assure proper functioning of the database systems
Develops technical procedures, scripts and associated documentation to improve existing processes and implement new ones
Support Production, Data Warehouse, Development and QA Environments
Analyze Transaction Data Reports and reconcile data differences
Perform scheduled maintenance and support release deployment activities after hours
Qualification
Required
Bachelor's degree from a four-year college or university, or equivalent combination of education and work experience
5+ years of professional experience in SQL Server Database Administration, Development and Data Warehouse configuration
Expertise in creating PowerShell scripts for automating repetitive SQL Server tasks
Expertise in creating, maintaining, and troubleshooting SSIS packages
Experience configuring and managing SQL Server Always-On Availability Groups
Experience with side-by-side and/or in-place Database Migration/Upgrade
Experience on working with data warehouse environment
Experience with using SQL Server tools and system stored procedures
Have firsthand experience with Dynamic SQL
Have experience with 3rd party tools like RedGate and SCOM
Experience with Performance Tuning and Optimization
Highly motivated team player who can establish excellent working relationships with peers and other teams
Ability to understand business requirements and estimate for delivery commitments
Excellent verbal, phone, and written communication skills
Willing to take part in 24/7 on-call rotations and shift rotations, if required
Ability to multi-task, nimbleness and highly functional within a team environment
Ability to work with minimal supervision
Preferred
Previous experience within the tolling industry desired
Company
TransCore
Transcore is a transportation service provider that develops solutions for open road tolling.
1001-5000 employees
H1B Sponsorship
TransCore has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2024 (5)
2023 (5)
2022 (4)
2021 (1)
2020 (2)
Funding
Current Stage
Late StageTotal Funding
unknown2021-09-03Acquired
2012-07-13Grant
Leadership Team
Whitt Hall
President & Chief Executive Officer
Gary Bucciarelli
Executive Vice President and Chief Financial Officer
Recent News
Company data provided by crunchbase