TransCore (TRN), a subsidiary of ST Engineering, is seeking a full-time Manager, Database Administration to join our team in Orlando, FL.

Job Summary:TheManager, Database Administration is responsible for setting up, managing, and optimizing databases in support of Enterprise and External Web applications. This includes working closely with system managers and developers to add system functionality, tables, and data, optimizing systems for availability and performance, and contributing to system upgrades. The Manager is responsible for maintaining applications, processes, and maintenance procedures, performance tuning and documentation and management of changes to database operations.

Essential Duties and Responsibilities include the following but not limited to:

Setup, configure, and install database systems.

Optimizes and tunes database systems.

Pro-actively monitors performance and capacity.

Performs data ports and data loads; monitors and tests data integrity as required.

Backup, recovery, testing of recovery procedures, and archiving databases.

Troubleshoots database issues and performs database impact analysis for proposed changes.

Ensures that systems stay updated on all relevant patches and upgrades.

Alter tables and schema structure as required.

Serve as technical expert for database design and support issues.

Works with the Application and Internet Development teams to develop stored procedures, triggers, and code to support enterprise applications as well as to enforce coding standards.

Executes database release management processes and coordinates maintenance of development, testing, and production environments.

Directly supervises staff.

Responsibilities include interviewing, hiring, and training employees; planning, assigning, and directing work; appraising performance; rewarding and disciplining employees; addressing complaints and resolving problems.

May perform other duties and responsibilities as assigned

Education: Bachelor's degree (B.A.) in computer science, engineering, or information management from four-year college or university or equivalent combination of education and work experience.

Required Skills & Experience:

At least five years of experience in Database Administration

Microsoft Certified SQL Server Database Administrator

Experience writing and optimizing complex SQL and T-SQL
- Ability to dissect complex queries with sub-queries
- Able to debug T-SQL code issues
- Able to troubleshoot production environments for query performance issues
- Demonstrated ability to identify the bottlenecks in CPU and IO

Significant experience with architecture and database design for SQL Server 2014 and later.

Hands-on experience as a lead DBA supporting multiple database environments with a team.

Experience with capacity planning, performance tuning and optimization of database environments.
- Options to partition data.
- Options to access remote data.

Strong understanding of SQL Server high-availability solutions and architecture:
- Log shipping
- Always On
- Mirroring

Strong experience with DB backup and recovery

Able to handle shifting priorities and work in a team environment

Good interpersonal skills

Able to work remotely and support on call efforts

Desired Skills:

Data warehouse design experience

Experience using Red Gate tools (SQL Compare, SQL Data Compare, SQL Source Control preferred)

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractors legal duty to furnish information. 41 CFR 60-1.35(c)

Information Systems