Share this Job

Systems Project Consultant - DBPR/IT - *OPEN COMPETITIVE*

Date:  May 19, 2023
Location: 

TALLAHASSEE, FL, US, 32399


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

Requisition No: 803003 

Agency: Business and Professional Regulations

Working Title: Systems Project Consultant - DBPR/IT - *OPEN COMPETITIVE*

Position Number: 79011398 

Salary:  $1,763.38 - $1,939.73 Bi-weekly 

Posting Closing Date: 05/30/2023 

DIVISION OF TECHNOLOGY
SYSTEMS PROJECT CONSULTANT

Position Number: 79011398
Hiring Salary: $1,763.38 - $1,939.73 Bi-weekly


*OPEN COMPETITIVE*

**Anticipated Vacancy**

Minimum Requirements:

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.

 

The Systems Project Consultant (SPC) on the database team focuses on analyzing systems and applications in order 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.

 

 Duties & 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 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 & Abilities:

  • Knowledge of or ability 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 Difference You Will Make:

At DBPR, you will always have an opportunity to make a difference in the daily lives of Floridians and the communities where they live and work. As an employee, you help to “make DBPR and Florida great places to do business.” To that end we will invest in you, treat our licensees as valued customers and partners, and uphold laws that protect the public and Florida’s competitive marketplace.

 

 How You Will Grow:

DBPR employees are expected to uphold these seven core values: Accountability, Innovation, Integrity, Ownership, Responsiveness, Respect and Teamwork. In turn, we will involve you on important and often complex projects while offering you the opportunity to gain valuable experience quickly.

 Where You Will Work:

 

Tallahassee, Florida’s Capital City, lined with rolling hills, oak trees, and canopied roads combines old world charm with a modern pace of life. Home to two major universities as well as state government, Tallahassee is a mid-sized city in the heart of Florida’s Big Bend. Boasting proximity to the coast and centrally located to popular tourist destinations, Tallahassee is a highly desirable location for both those seeking their first job or those ready to enter the next exciting chapter in their career. Also, with no state income tax, Florida is a great place to work regardless of where you find yourself on the career ladder.

 

The Following Benefits Are Included:

  • State of Florida retirement package (pension & investments options);
  • 10 Paid holidays annually;
  • Annual Leave;
  • Sick Leave;
  • HMO and PPO Health Insurance – the State covers the majority of the premiums for Individual and Family coverage (over 80% employer paid);
  • $25,000 in automatic Basic Life insurance policy (100% employer paid);
  • Additional supplemental insurances available such as dental, vision, etc.;
  • Tax deferred medical and childcare reimbursement accounts available;
  • Tax deferred savings program available through payroll deduction;
  • Retirement plan options, including employer contributions (For more information, please click www.myfrs.com);
  • Flexible Spending Accounts; and
  • State of Florida Tuition Waiver Program. 
     

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 and/or 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 supports
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.

 

We hire only 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. 


Nearest Major Market: Tallahassee