ENTERPRISE DATA BASE CONSULTANT

Enterprise Data Base Consultant

Join FDOT and be part of the team that works as one to improve safety, enhance mobility and inspire innovation in the Florida transportation system. To ensure honesty and transparency, all applicants must provide their own work. Unless explicitly requested, the use of Artificial Intelligence (AI) tools to assist with qualifying questions, work samples, or interviews is strictly prohibited, and any breach of this requirement will lead to the applicant being removed from consideration. Candidates must be United States (U.S.) citizens or lawfully authorized alien workers. Visa sponsorship is not available.

The mission of the Florida Department of Transportation is to provide a safe statewide transportation system that promotes the efficient movement of people and goods, supports the state's economic competitiveness, prioritizes Florida's environment and natural resources, and preserves the quality of life and connectedness of the state's communities. As a OneFDOT team, we serve the people of Florida by providing a transportation network that is well planned, supports economic growth, and has the goal of being congestion and fatality free.

The work you will do:

Enterprise Data Base Consultant / Application Services

Please note this is an on-site Database Administrator position with FDOT heavily focused on SQL Server Database administration. The Enterprise Database Consultant provides technical leadership and coordination for the Department's enterprise database platforms, including planning, implementation, and ongoing support for mission-critical environments. This role manages DB2, Oracle, and SQL Server databases (both Azure and on-prem), oversees logical and physical administration, performance tuning, backups, and recovery. Responsibilities include collaborating with application development teams, resolving complex technical issues, ensuring compliance with best practices, and supporting long-range planning for infrastructure improvements. Additionally, the position requires mentoring staff, coordinating emergency support, and maintaining high availability for statewide enterprise applications.

The difference you will make:

Through cooperation, coordination and collaboration among the OneFDOT team, you will be contributing to a strong and empowering culture of TRREC: Trust, Relationships, Respect, Empowerment, and Communication.

How you will grow:

FDOT encourages our team members to grow through engagement, empowerment, training, and professional development. Through our agency's learning management system, you have access to hundreds of computer-based training and instructor-led courses.

Where you will work:

Florida Department of Transportation Application Services 3185 S Blair Stone Road Tallahassee, Florida 32311

Your specific responsibilities:

• Provide technical leadership and coordination for the Department's enterprise database platforms.
• Provide project planning and coordination, implementation planning, and technical assistance to other staff.
• Coordinate infrastructure support of the Department's enterprise and mission critical databases.
• Collaborate with enterprise application development teams and coordinate the enterprise database tasks associated with the analysis, implementation and maintenance of large-scale statewide application development and maintenance projects.
• Perform technical work establishing and maintaining mainframe and server based enterprise application database environments that support the Florida Department of Transportation's (FDOT's) Enterprise Business applications.
• Perform logical and physical database administration activities and transform logical data structures into physical database objects within the Department's enterprise application database environment.
• Analyze environment for potential improvements and technical direction.
• Participate in long-range planning related to application database performance and ongoing tuning for the Department's highly integrated database environment.
• Facilitate backups, recovery, and performance tuning of the database enterprise environments at the system level (DB2 for z/OS, Oracle, and SQL Server; both Azure and On-Prem).
• Ensure around-the-clock support as needed for the Department's enterprise applications and environments.

The successful candidate will have the following required knowledge, skills, and abilities:

• Knowledge of: One or more of the following database infrastructure areas – SQL server database servers, Oracle database servers, IBM DB2 for Z/OS, infrastructure level scripting, structured query language
• The principles, practices and techniques of computer programming and systems design
• Computer operations, systems and procedures
• Project control and cost estimating techniques
• Computer programming language
• Data processing flow charting techniques
• Database structures and theories
• Current database technologies
• Ability to: Evaluate and set technical architecture direction in a varied enterprise database environment for best solutions and system reliability
• Work and coordinate productively and professionally with management, coworkers, vendors and primary data center to resolve problems and accomplish goals
• Provide leadership including evaluation of technology, project planning and coordination, and technical assistance to staff; ability to plan, organize, coordinate and prioritize work
• Perform long-range planning and impact analysis
• Complete projects on time
• Give and receive constructive criticism
• Interpret and communicate technical information, both verbally and in writing
• Work effectively in a team environment
• Develop and maintain technical documentation for supported databases
• Evaluate technical databases, options, and risks for best solutions
• Learn and apply new computer technology
• Work in an enterprise environment where high system availability is required
• Quickly analyze and resolve problems utilizing various resources
• Maintain and support database software and hardware
• Support the database infrastructure for a variety of custom and commercial-off-the-shelf (cots) software solutions
• Design, develop and implement database backup and recovery procedures
• Create databases and monitor database performance
• Identify and define user task needs
• Process information logically
• Perform mathematical calculations

Other job-related requirements:

This position may be entrusted with access to confidential or sensitive data, with specific authorization from the Manager of Application Services. This position is authorized to perform duties related to the production environment which requires a high level of trusted security. This position has on-call responsibilities for returning to work to handle emergency situations or other needed activities.

Minimum qualifications:

Seven years of experience in computer systems analysis and/or computer programming, three years of which must have been in database administration and design; completion of a one-year program of study from a vocational/technical school in an area of data processing (excluding data entry) can substitute for one year of computer systems analysis and/or computer programming experience.

The State's total compensation package for employees features a highly competitive set of employee benefits including: health insurance (over 90% employer paid), $25,000 life insurance policy (100% employer paid), dental, vision and supplemental insurances, State of Florida retirement package, 10 paid holidays a year, generous vacation and sick leave, career advancement opportunities, tuition waiver for public college courses, a variety of training opportunities, Employee Assistance Program (EAP).

Special requirements:

You will be required to provide your Social Security Number to conduct required verifications. Male applicants born on or after October 1, 1962, will not be eligible for hire or promotion in the Career Service, or appointment in the Selected Exempt Service (SES) or Senior Management Service (SMS), unless they are registered with the Selective Service System (SSS) before their 26th birthday, or have a Letter of Registration Exemption from the SSS.

The Florida Department of Transportation values the service veterans and their family members have given to our country and supports the hiring of returning service members and military spouses. Qualified individuals with disabilities are encouraged to apply. In accordance with Section 110.112, Florida Statutes, and the Florida Department of Transportation's Individuals with Disabilities Affirmative Action Plan, the agency is committed to ensuring affirmative action and equal employment opportunity for qualified individuals with disabilities. Upon request and as appropriate, reasonable accommodations to individuals with disabilities may be provided. Please contact the Florida Department of Transportation's Human Resources Office at View phone number on click.appcast.io for assistance. Candidates requiring a reasonable accommodation, as defined by the Americans with Disabilities Act, must notify the agency hiring authority and/or People First Service Center View phone number on click.appcast.io). Notification to the hiring authority must be made in advance to allow sufficient time to provide the accommodation.

The State of Florida supports a Drug-Free workplace. All employees are subject to reasonable suspicion drug testing in accordance with Section 112.0455, F.S., Drug-Free Workplace Act. Veterans' Preference. Pursuant to Chapter 295, Florida Statutes, candidates eligible for Veterans' Preference will receive preference in employment for Career Service vacancies and are encouraged to apply. Certain service members may be eligible to