Database Administrator II

TransCore, LP; Houston (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

TransCore, LP in Houston, TX is seeking a Database Administrator II to join the Production Database Administration team. You will provide day-to-day and on-call first line support for Infinity production installations, configure databases, optimize performance, develop stored procedures, and ensure data flow and integrity across the system.

The role requires a Bachelor's degree and 6–9 years of SQL Server experience, expertise with AlwaysOn, SSIS/SSRS, PowerShell, data warehouse, and strong

Qualifications

• Bachelor's degree or equivalent work experience.
• 6–9 years of SQL Server Database Administration, Development and Data Warehouse experience.
• Experience with AlwaysOn Availability Groups and data warehouse environments.
• Proficiency in PowerShell scripting and SSIS/SSRS package maintenance.
• Strong communication skills and ability to work in a team.

Responsibilities

• Own daily, weekly, and monthly maintenance tasks including backups, replication and access control.
• Develop and optimize SQL queries, stored procedures and data loads for the data warehouse.
• Design fact/dimension tables and manage SSIS/SSRS reports and documentation.
• Provide first-line support during on-call hours and after-hours releases.
• Monitor performance, troubleshoot blocking, deadlocks and security issues.

Skills

SQL Server DBA

PowerShell scripting

SSIS packages

AlwaysOn Availability Groups

Performance tuning

Data Warehouse

On-call rotations

Team collaboration

Dynamic SQL

Education

Bachelor's degree

Tools

SSIS

SSRS

RedGate

SCOM

Job description

TransCore (TRN), a subsidiary of ST Engineering, is seeking a talented Database Administrator II to join our Production Database Administration team in Houston, Texas.

Summary

The Database Administrator II provides day-to-day and on-call first line technical support for our Infinity production installations. Troubleshoots and follows through-to-resolution issues concerning the application and the database. This position will involve ensuring the database systems are configured and deployed properly with the correct parameters, configurations, SW versions and performance settings, will develop and optimize stored procedures, and will analyze the flow of the data throughout the system to validate it is functioning properly. Will analyze and assure proper database performance.

Essential Duties and 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.

Requirements and 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.

Physical Demands/Work Environment

While performing the duties of this job, 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.

TransCore complies with federal and state disability laws and provides reasonable accommodation for employees with disabilities.