Database Administrator II - Finance Data Warehouse & 24/7 On-Call

TransCore, LP in; Houston (TX); On-site; USD 85,000 - 110,000; Full time

Job summary

TransCore, a subsidiary of ST Engineering, seeks a Database Administrator II (Finance) to join the Production Database Administration team in Houston, TX. You will provide day-to-day and on-call support for Infinity production installations, ensure proper configuration, and optimize performance.

The role focuses on developing and maintaining SQL Server data warehouses, designing fact and dimension structures, maintaining SSIS/SSRS reports, and resolving data integrity or performance issues.

Qualifications

• 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 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.
• Previous experience within the tolling industry desired.

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 optimize 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.

Skills

Communication

Teamwork

Multitasking

On-call support

Education

Bachelor's degree

Tools

PowerShell

SSIS

Always-On

RedGate

SCOM

Job description

TransCore, a subsidiary of ST Engineering, seeks a Database Administrator II (Finance) to join the Production Database Administration team in Houston, TX. You will provide day-to-day and on-call support for Infinity production installations, ensure proper configuration, and optimize performance.

The role focuses on developing and maintaining SQL Server data warehouses, designing fact and dimension structures, maintaining SSIS/SSRS reports, and resolving data integrity or performance issues.