ENTERPRISE DATA BASE CONSULTANT - 55004787

State of Florida•TALLAHASSEE, FL

6d•$80,100 - $93,450•Onsite

About The Position

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. Our Mission 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. Our Vision 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

Requirements

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
To support multiple database platforms
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.

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.
This involves coordination with appropriate personnel from other Application Services and Office of Information Technology (OIT) sections with issues pertaining to the resolution of technical application database problems (such as database access and application performance).
Responsibilities include: plan projects and implementations, track work items including service requests, incidents, problems, changes; collaborate with primary data center staff, other Application Services staff, and end users; estimate time requirements; coordinate and manage tasks needed to meet objectives; report status; resolve issues; resolve production problems; mentor other professional Application Services staff.
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.
Enterprise database environments include but are not limited to: DB2, Oracle, and SQL Server; both Azure and On-Prem.
Perform logical and physical database administration activities and transform logical data structures into physical database objects within the Department’s enterprise application database environment.
Responsibilities include: analyze and evaluate requests for major changes to database infrastructure; design and document solutions using the most appropriate tools; coordinate, test, and implement solutions; provide assistance and mentoring to other staff in the resolution of complex assignments.
Analyze environment for potential improvements and technical direction.
Responsibilities include: review existing database environment for performance improvement or cost-saving opportunities; perform long-range planning and impact analysis for technology and infrastructure upgrades; stay abreast of industry standards and best practices; define requirements for database or other infrastructure upgrades; recommend improvement opportunities to management.
Participate in long-range planning related to application database performance and ongoing tuning for the Department’s highly integrated database environment.
Responsibilities include: conduct planning related to measuring and improving application database efficiencies; facilitate and document Structured Query Language (SQL) reviews for both internal and outsourced projects.
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.
This includes but is not limited to: support decentralized processes and computing requirements (such as data replication and other district needs); coordinate with service center providers, applications staff, and user offices as needed to support resolution and resubmission of mission critical batch jobs.