Systems Project Consultant - 79011398

State of Florida • Largo, FL

10h

About The Position

The Systems Project Consultant (SPC) works on the database team within the Division of Technology at the Florida Department of Business and Professional Regulation. The position analyzes systems and applications and helps design database structures that meet business needs. It supports database development, application design and maintenance, user permissions, code migration, documentation, reporting, and dashboards. The SPC also provides technical support to developers, project managers, and technicians, troubleshoots errors, performs routine database refreshes, and participates in a rotational 24-hour on-call assignment for emergency support.

The role works with Oracle and SQL Server, including migrating code to UAT and production, managing database users and permissions, and maintaining database structures and performance. It assists with data querying and analysis, report and dataset specifications, and presenting findings as clear, actionable insights. The employee works under the direction of the Data Architect and participates in design and maintenance meetings as required. Other related duties may be assigned.

Requirements

• Documented work experience in Information Technology.
• Must meet the requirements of Chapter 60L-32.0012 (2)(b), Florida Administrative Code, regarding On-Call status.
• Experience with, knowledge of, and ability to learn Oracle 19c, SQL Server 2019, MySQL, PostgreSQL, SolarWinds, Business Analysis, and relational database theory.
• 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.
• Strong analytical and problem-solving skills.
• 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 collaboratively on teams and independently as necessary.
• Ability to communicate effectively with technical and non-technical staff.
• Ability to establish and maintain effective working relationships with others.
• Ability to work shifts in an on-call rotation and overtime as necessary.

Nice To Haves

• Bachelor’s degree from an accredited college or university in a computer-related field; or an Associate’s degree and two years of technical IT experience; or a combination of documented IT work experience and IT training totaling four years.
• Experience with data visualization tools such as Qlik.
• Previous experience in Business Analysis and data analysis.
• Familiarity with Toad for Oracle, Oracle Enterprise Manager (OEM)/Cloud Control, SQL Server Management Studio (SSMS), Qlik, and AWS.

Responsibilities

• Assist application developers, technicians, and managers with analyzing, designing, developing, and enhancing systems, applications, and databases.
• Create and maintain detailed system documentation, including overall design, schematics, and functional logic diagrams.
• Assist with creating and maintaining reports and dashboards, and prepare ad hoc reports on systems and infrastructure as required.
• Maintain and control user access to databases; create SQL Server users and manage permissions.
• Assist with building tables, views, and data connections to support end-user application needs.
• Assist in developing database structures, monitoring database performance, and researching potential solutions within the departmental framework under the Data Architect’s direction.
• Assist with querying data, analyzing results, and presenting findings clearly with actionable insight.
• Assist in developing specifications for datasets and reports based on business requests.
• Maintain code for migration and migrate Oracle and SQL Server code to UAT and production.
• Participate in design and maintenance meetings as required.
• Assist with troubleshooting system errors and bugs and support Data Stewards as needed.
• Perform Oracle and SQL Server database refreshes as needed.
• Participate in a rotational 24-hour on-call assignment for emergency support.
• Perform other work-related duties as required.

Benefits

• State of Florida retirement package, with a required 3% employee contribution.
• Nine annual paid holidays and one personal holiday.
• Ability to earn up to 104 hours of paid annual leave annually as a new State employee.
• Ability to earn up to 104 hours of paid sick leave annually.
• Health insurance coverage, including individual and family coverage, for eligible employees.
• A $25,000 life insurance policy for eligible employees.
• Additional supplemental insurance policies are available for dental, vision, hospital supplement, cancer, and other coverage.
• Tax-deferred medical and childcare reimbursement accounts.
• Tuition waiver program for attendance at an approved State of Florida College or University.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed