Systems Project Consultant - 79011398

Requisition No: 844977 

Agency: Business and Professional Regulations

Working Title: Systems Project Consultant - 79011398

 Pay Plan: Career Service

Position Number: 79011398 

Salary:  $1,907.10 - $2,367.83 Bi-weekly 

Posting Closing Date: 01/30/2025 

Total Compensation Estimator Tool

DIVISION OF TECHNOLOGY
SYSTEMS PROJECT CONSULTANT
Position Number: 79011398
Hiring Salary: $1,907.10 - $2,367.83 Bi-weekly

*OPEN COMPETITIVE*
 

Our Organization and Mission: 
The Mission of the Florida Department of Business and Professional Regulation (DBPR) is to “License Efficiently and Regulate Fairly”. The Division of Technology supports the mission of DBPR through management of the systems that underpin the services the Department offers to the public. Our staff continually work to increase the efficiency and effectiveness of DBPR, through consultation with the business units within the Department to integrate new and innovative technology solutions.

Your Specific Responsibilities: 
The Systems Project Consultant (SPC) on the database team focuses on analyzing systems and applications to design database structures that meet business needs. Assist with database development, application design, and maintenance, as well as assisting with user permissions and code migration. This is a highly analytical position that must assist with the creation and maintenance of comprehensive system documentation, reports, and dashboards. The incumbent will provide technical support to developers, project managers, and technicians where appropriate. This role includes troubleshooting errors and performing routine database refreshes. This position will participate in a rotational 24-hour on-call for emergency support.

• Assists application developers, technicians, and managers in the analysis, design, development or enhancement of systems, applications, and databases. Creates and maintains detailed system documentation to include overall design, schematics, and functional logic diagrams. Assists with the creation and maintenance of reports and dashboards. Prepares ad hoc reports on systems and infrastructure as required.
• Maintains and controls user access to database. Assists with building table views, and data connections necessary to support end user application needs. Assists with the development of new database structures, monitors database performance, and researches potential solutions within the departmental framework at the direction of the Data Architect.
• Assists with the process of querying data, analyzing the results, and presenting the findings in a way that provides clarity and actionable insight. Assists with the development of specifications for datasets and reports based on business requests. Creates users in SQL Server and manages permissions and maintains code for migration. Responsible for migrating Oracle and SQL Server code to UAT and production. 
• Participates in design and maintenance meetings as required. Assists in troubleshooting errors and bugs in the system and assists Data Stewards as needed.
• Performs SQL Server database refreshes as needed.
• Performs other work-related duties as required.

Note: The omission of specific statements above does not preclude management from assigning specific duties not listed herein if such duties are a logical assignment to the position.
 

Knowledge, Skills, and Abilities:

• Knowledge of or ability to learn SQL and relational database theory. 
• Knowledge of or ability to learn Microsoft SQL Server, including 2005 and 2016. 
• Knowledge of or ability to learn Oracle RDBMS, including 10g RAC and 12c on Exadata. 
• Knowledge of or ability to learn MySQL. 
• Knowledge of or ability to learn Oracle administration tools (Toad, Oracle Enterprise Manager (OEM). 
• Knowledge of or ability to learn SQL authoring toolsets. 
• Knowledge of or ability to learn SQL Server Tools (Enterprise Manager).  
• Ability to upgrade SQL Server and Oracle. 
• Possess strong analytical and problem solving skills. 
• Possess effective verbal and written communication skills. 
• Ability to think nonlinearly and find resourceful solutions to challenging issues. 
• Ability to manage and prioritize concurrent tasks and projects. 
• Ability to work both collaboratively on teams, as well as independently as necessary. 
• Ability to communicate effectively with both technical and non-technical staff. 
• Ability to establish and maintain effective working relationships with others. 
• Ability to work shifts in an On-Call rotation. 
• Ability to work overtime as necessary.

Minimum Requirements:

• Must be able to meet the requirements of Chapter 60L-32.0012 (2)(b), Florida Administrative Code, regarding On-Call status; and
• Documented work experience in Information Technology; and
• Experience, knowledge of, and ability to learn SQL, MySQL, Oracle, and relational database theory.

Preference will be given to applicants with:

• Bachelor’s degree from an accredited college or university in a computer related field, or an Associate’s degree and two (2) years of technical IT experience; or
• Combination of documented work experience in an IT field and IT training totaling 4 years.
   

***Applicants must complete all fields in the Candidate Profile. Work history, hours worked and formal education are required to qualify for this position. 

Responses to Qualifying Questions must be verifiable in the Candidate Profile. Resumes and other documentation can be attached to provide additional information.*** 

Please Note:
Preference will be given to candidates that have experience working with data visualization tools such as Qlik, Tableau, Power BI, etc., as well as previous experience in data analysis and familiarity with tools such as QLIK, Tableau, Toad, Oracle or SQL Server. 
 

Note: Successful applicant must pass a Level 2 background screening, including fingerprinting, as a condition of employment. All positions within the Division of Technology are considered to be positions of special trust in accordance with Sections 110.1127 and 425.04, Florida Statutes. The recommended applicant will be required to submit to a background and fingerprint check.
 

Knowledge, Skills & Abilities:

• Knowledge of or ablity to learn SQL, MySQL, Oracle, and relational database theory.
• Knowledge of or ability to learn SQL and Oracle administration tools such as Toad, Oracle Enterprise Manager (OEM), and SQL Enterprise Manager.
• Knowledge of or ability to learn SQL authoring toolsets.
• Knowledge of or ability to learn upgrade of SQL Server and Oracle.
• Possess strong analytical and problem solving skills.
• Possess effective verbal and written communication skills.
• Ability to think nonlinearly and find resourceful solutions to challenging issues.
• Ability to architect system design documentation.
• Ability to manage and prioritize concurrent tasks and projects.
• Ability to work both collaboratively on teams, as well as independently as necessary.
• Ability to communicate effectively with both technical and non-technical staff.
• Ability to establish and maintain effective working relationships with others.
• Ability to work shifts in an On-Call rotation. Ability to work overtime as necessary. 

The Benefits of Working for the State of Florida:

 “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:

• State of Florida retirement package: 3% employee contribution required.
• Nine annual paid holidays and one personal holiday.
• Ability to earn up to 104 hours of paid annual leave annually as a new employee with the State of Florida.
• Ability to earn up to 104 hours of paid sick leave annually.
• The State of Florida offers health insurance coverage (i.e. individual and family coverage) to eligible employees.
• The State of Florida provides a $25,000 life insurance policy to eligible employees.
• Additional supplemental insurance policies are available for dental, vision, hospital supplement, cancer, etc.
• Tax deferred medical and childcare reimbursement accounts are available.
• Tuition waiver program to attend an approved State of Florida College or University.

For additional benefit information, please visit the following website: http://www.mybenefits.myflorida.com

Applicant Note: If you are the selected candidate for this position and hold a current license through the Florida Department of Business & Professional Regulation, you may be required to place your license in an inactive status.  

NOTE: This position requires a security background check, physician assessment, drug screening, and participation in direct deposit. You will be required to provide your Social Security Number (SSN) and date of birth in order to conduct this background check.
 
Applicants are required to apply through the People First system by the closing date, by applying online.  All required documentation must be received by the closing date of the advertisement.  If you have any questions regarding your application, you may call 1-877-562-7287.

The Florida Department of Business & Professional Regulation is committed to increasing recruitment and hiring of individuals with disabilities and improving employment outcomes.  
 

Candidates requiring a reasonable accommodation, as defined by the Americans with Disabilities Act, must contact the DBPR Human Resources (HR) Office at (850) 487-2074. DBPR requests applicants notify HR in advance to allow sufficient time to provide the accommodation.

SPECIAL REMINDERS:
Male applicants born on or after October 1, 1962, will not be eligible for hire or promotion unless they are registered with the Selective Services System (SSS) before their 26th birthday, or have a Letter of Registration Exemption from the SSS.  For more information, please visit the SSS website: http://www.sss.gov .

If you are a retiree of the Florida Retirement System (FRS), please check with the FRS on how your current benefits will be affected if you are re-employed with the State of Florida. Your current retirement benefits may be canceled, suspended or deemed ineligible depending upon the date of your retirement.
 

The Florida Department of Business & Professional Regulation values the sacrifices veterans and their family members have given to our country and support the hiring of returning service members and military spouses. 
 

A candidate for veterans’ preference who believes he or she was not afforded employment preference may file a complaint in accordance with Rule 55A-7.016, F.A.C., with the Florida Department of Veterans’ Affairs, Veterans’ Preference Coordinator, 11351 Ulmerton Road, Suite 311, Largo, FL, 33778. The Department of Veterans’ Affairs has also established an email where people can electronically file claims or ask questions. The email is veteranspreference@fdva.state.fl.us.

The Department of Business and Professional Regulation will only hire U. S. citizens and lawfully authorized alien workers. Our agency participates in the E-Verify System which is a federal government electronic database available for employers to use to verify the identity and employment eligibility of all persons hired to work in the United States. 

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.