Database Administrator II

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

Job 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 Include the following. Other duties may be assigned.

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

Requirements and Qualifications To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below represent the knowledge, skill, and / or ability required.

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. While performing the duties of this job, the employee is occasionally exposed to fumes or airborne particles; outside weather conditions and moving traffic. The noise level in the work environment is usually moderate.

Equal Opportunity Employer / Protected Veterans / Individuals with Disabilities

This employer is required to notify all applicants of their rights pursuant to federal employment laws.

For further information, please review the Know Your Rights notice from the Department of Labor.