ENTERPRISE DATA BASE CONSULTANT - 55004787

State of Florida

1d•Onsite

About The Position

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.

Requirements

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