Database Administrator II

About the role

TransCore (TRN), a subsidiary of ST Engineering, is seeking a Database Administrator II to join the Production Database Administration team in Houston, Texas. This position provides day-to-day and on-call first line technical support for Infinity production installations, troubleshooting application and database issues, ensuring proper configuration and deployment of database systems, and analyzing data flow for proper system functioning.

Responsibilities

• Own and execute daily, weekly, and monthly maintenance tasks including monitoring application performance, backups, replication, data restore, creating and granting logins, and supporting SQL-based infrastructure systems.
• Develop and sustain the SQL Server Data Warehouse, ensuring operational readiness (security, health, and performance), executing data loads, and performing data modeling.
• Design and create Fact and Dimension tables; maintain and troubleshoot SSIS packages.
• Create and maintain documentation for SSIS and SSRS reports.
• Conduct data analysis to answer business questions and forecast trends.
• Ensure storage, archiving, backup, and recovery procedures function correctly.
• Provide first-line software/database support for Infinity installations during business and off hours.
• Support current deployments and processes, troubleshoot existing processes, and validate system requirements.
• Develop and optimize SQL queries, stored procedures, and functions to support operations and customer requirements.
• Implement and troubleshoot SQL Server High Availability and Disaster Recovery (HADR) features such as AlwaysOn.
• Create and manage database indexes, index management, and maintain statistics.
• Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking, replication, connectivity, and security issues.
• Monitor system installations for performance degradation and perform preventative and corrective cleanup activities.
• Develop technical procedures, scripts, and documentation to improve and implement new processes.
• 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.

Requirements

• Bachelor’s degree from a four-year college or university or equivalent combination of education and work experience.
• 6–9 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 working with data warehouse environments.
• Experience using SQL Server tools and system stored procedures.
• Hands-on experience with Dynamic SQL.
• Experience with third-party tools such as RedGate and SCOM.
• Experience with Performance Tuning and Optimization.
• Ability to understand business requirements and estimate delivery commitments.
• Excellent verbal, phone, and written communication skills.
• Willingness to participate in 24/7 on-call rotations and shift rotations, if required.
• Ability to multi-task, work with minimal supervision, and function effectively within a team environment.
• Previous experience within the tolling industry is desired.

Physical Demands/Work Environment

• The employee is regularly required to talk or hear.
• The employee is frequently required to sit.
• The employee is occasionally required to stand, walk, use hands to finger, handle or feel, and reach with hands and arms.
• The employee must occasionally lift and/or move up to 10 pounds.
• The noise level in the work environment is usually moderate.