State of Florida
Location
Tallahassee, FL | United States
Job description
Requisition No: 824713
Agency: Department of Transportation
Working Title: DATA BASE CONSULTANT - 55002036
Pay Plan: Career Service
Position Number: 55002036
Salary: $70,329.94 - $79,476.57
Posting Closing Date: 03/21/2024
Total Compensation Estimator
STATE OF FLORIDA DEPARTMENT OF TRANSPORTATION
JOB POSTING DESCRIPTION
973 / Application Services
OPEN COMPETITIVE
CAREER SERVICE
CONTACT PERSON: Brian Wilson
CONTACT PHONE NUMBER: (850) 410-5557
CONTACT EMAIL ADDRESS: [email protected]
ANTICIPATED BI-WEEKLY HIRING SALARY: $2,911.23
Working for the State of Florida is more than a paycheck. The State’s total compensation package for employees features a highly competitive set of employee benefits including:
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!
For additional benefit information available to State of Florida employees, go to
SPECIAL REQUIREMENTS: You may be required to provide your Social Security Number to conduct required verifications. Male candidates 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 AND SUPPORTS EMPLOYMENT OF INDIVIDUALS WITH DISABILITIES. 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 located at 605 Suwannee Street, Tallahassee, Florida 32399, or call (850) 414-5300 for assistance.
POSITION DESCRIPTION: Provide technical support 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 data base 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. This position is located in the Application Services of the Office of Information Technology.
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 Northwest Regional Data Center (NWRDC) applications staff, and user offices as needed to support resolution and resubmission of mission critical batch jobs..
KNOWLEDGE, SKILLS AND ABILITIES: 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 complete projects on time; ability to perform long-range planning and impact analysis; 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; knowledge and ability to support multiple database platforms; knowledge in 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; ability to support the database infrastructure for a variety of custom and commercial-off-the-shelf (cots) software solutions; 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 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.
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. Additional compensation is given for on-call time.
MINIMUM QUALIFICATIONS: A bachelor's degree from a college or university, or three years of experience in computer systems analysis and/or data base design; or either (1) completion of a 720 classroom hour program of study from a vocational/technical school or community college in an area of data processing (excluding data entry), or (2) 60 semester or 90 quarter hours of college course work from an institution which includes four courses in computer science or management information systems. Experience in computer systems analysis and/or database design can substitute on a year-for-year basis for the required college education. 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 data base design experience.
As a CANDIDATE, you may be required to provide documentation (i.e. HIGH SCHOOL DIPLOMA OR EQUIVALENCY, college transcripts, ETC.) to verify meeting these Minimum Qualifications.
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. If you are a preference-eligible candidate who receives notice of a hiring decision and believe that you were not afforded employment preference in accordance with applicable Florida law and regulation, you may file a written complaint within 60 calendar days from the date you receive the notice, requesting an investigation to the Florida Department of Veterans’ Affairs, Division of Benefits and Assistance, 9500 Bay Pines Boulevard, Room 214, St. Petersburg, Florida 33708.
The State of Florida is an Equal Opportunity Employer/Affirmative Action Employer, and does not tolerate discrimination or violence in the workplace.
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 (1-866-663-4735). 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 receive waivers for postsecondary educational requirements. Candidates claiming Veterans’ Preference must attach supporting documentation with each submission that includes character of service (for example, DD Form 214 Member Copy #4) along with any other documentation as required by Rule 55A-7, Florida Administrative Code. Veterans’ Preference documentation requirements are available by clicking here . All documentation is due by the close of the vacancy announcement.
Job tags
Salary
