SYSTEMS PROJECT CONSULTANT - 79011398

State of Florida; Tallahassee (FL); On-site; USD 70,000 - 100,000; Full time

Benefits offered by this job

State retirement package

Nine annual paid holidays

Paid annual leave up to 104 hours

Paid sick leave up to 104 hours

Health insurance available

Life insurance issued by state

Tuition waiver program

Job summary

The Systems Project Consultant (SPC) on the DBPR 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.

Qualifications

• Knowledge of or ability to learn SQL Server, MySQL, Oracle, PostgreSQL and relational theory.
• Experience with Oracle and SQL Server administration tools (Toad, OEM/Cloud Control, SSMS).
• Ability to learn BI tools like Qlik and cloud platforms (AWS).
• Strong analytical and communicative skills; ability to design documentation.

Responsibilities

• Assist application developers, technicians, and managers in analysis, design, and development of systems, apps, and databases.
• Create and maintain detailed system documentation including design schematics and logic.
• Develop and maintain reports and dashboards; prepare ad hoc reports as required.
• Manage user access, build tables/views, and support data connections for end-user needs.
• Migrate Oracle/SQL Server code to UAT and production; support on-call rotation.

Skills

SQL Server

MySQL

Oracle

PostgreSQL

Data analysis

Problem solving

Education

Bachelor’s degree in computer field

Associate degree + 2 years IT experience

Tools

Toad

OEM / Cloud Control

SSMS

Qlik

AWS

Job description

Select how often (in days) to receive an alert:

The State Personnel System is an E-Verify employer. For more information click on our E-Verify Website .

Agency: Business and Professional Regulation

Working Title: SYSTEMS PROJECT CONSULTANT - 79011398

*Open Competitive*

Our Organization and Mission:

License efficiently. Regulate fairly. Florida counts on the Department of Business and Professional Regulation (DBPR) to ensure important matters are handled well. Responsibilities range from ensuring the safety of food service, maintaining the integrity of real estate transactions, furthering the transparency of condominium governance, and overseeing the qualifications of licensure that ensure work requiring a skilled professional is performed safely and sufficiently.DBPR’s stakeholders include these professionals and their customers alike.

Under the direction of Secretary Melanie S. Griffin, DBPR oversees many of Florida’s professions and industries in the areas above, and many more which can be seen on our website: http://www.myfloridalicense.com/DBPR/.

The Work You Will Do:

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.

Your Specific Responsibilities:

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 the database. Assists with building tables, views, and data connections necessary to support end-user application needs. Assists with the development of new database structures, monitors database performance, and research 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, 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 Oracle and 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 Server, MySQL, Oracle, PostgreSQL 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 upgrade SQL Server and Oracle.
• Knowledge of or ability to learn Business Analysis Methodologies.
• 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.
• 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 Oracle 19c, SQL Server 2019, MySQL, PostgreSQL, SolarWinds, Business Analysis, and relational database theory.

Preferred:

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.

Please Note: Preference will be given to candidates that have experience working with data visualization tools such as Qlik, as well as previous experience in Business Analysis, data analysis and familiarity with tools such as Toad for Oracle, Oracle Enterprise Manager (OEM)/Cloud Control, SQL Server Management Studio (SSMS), QLIK and AWS.

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

To maintain fairness and integrity in our hiring process, the use of Artificial Intelligence (AI) tools to answer qualifying questions or participate in interviews is strictly prohibited. Applicants must provide their own, authentic responses during all stages of the evaluation and recruitment process. Any candidate found using AI to assist in their answers will be disqualified from consideration

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.

The Florida Department of Business and Professional Regulation requires all job applicants, interns, volunteers and contractors to pass a Level 2 background check as per Chapter 435, Florida Statutes which consists of fingerprinting and a check of local, state, and national law enforcement records. Employees will be retained in the state and national rap back program, providing real-time arrest hit notifications. This check must be completed before you can start working or contracting.

We are 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 [phone]. DBPR requests applicants notify HR in advance to allow sufficient time to provide the accommodation.

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 on the date of your retirement.

The Florida Department of Business and 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 [e-mail].

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

Location:

TALLAHASSEE, FL, US, 32301 TALLAHASSEE, FL, US, 32302 TALLAHASSEE, FL, US, 32303 TALLAHASSEE, FL, US, 32304 TALLAHASSEE, FL, US, 32305 TALLAHASSEE, FL, US, 32307 TALLAHASSEE, FL, US, 32308 TALLAHASSEE, FL, US, 32309 TALLAHASSEE, FL, US, 32310 TALLAHASSEE, FL, US, 32311 TALLAHASSEE, FL, US, 32312 TALLAHASSEE, FL, US, 32316 TALLAHASSEE, FL, US, 32317 TALLAHASSEE, FL, US, 32399

For assistance, call the People First Service Center at [phone] Monday - Friday, 8:00 a.m. to 6:00 p.m., Eastern time. Pursuant to Florida Law, 110.211 F. S., the State of Florida is an EEO employer.