Database Administrator II

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

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.

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