ENTERPRISE DATA BASE CONSULTANT - 55004787

State of Florida•TALLAHASSEE, FL

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

About The Position

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

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
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 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
Ability 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.
Coordinate 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).
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.
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 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.
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.
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.
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.