SYSTEMS PROJECT CONSULTANT - 79011398

State of Florida • Tallahassee, FL

1d • $62,797 - $67,380

About The Position

The Systems Project Consultant (SPC) works on the database team, analyzing systems and applications and helping design database structures that meet business needs. The role supports database development, application design and maintenance, user permissions, and code migration. It also contributes to creating and maintaining system documentation, reports, and dashboards, and provides technical support to developers, project managers, and technicians. Duties include troubleshooting errors and performing routine Oracle and SQL Server database refreshes. The position participates in a rotational 24-hour on-call schedule for emergency support.

Requirements

• Meet the requirements for On-Call status under Chapter 60L-32.0012(2)(b), Florida Administrative Code.
• Documented work experience in Information Technology.
• Experience, 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.
• Ability to work 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 the analysis, design, development, and enhancement of systems, applications, and databases.
• Create and maintain detailed system documentation, including overall designs, schematics, and functional logic diagrams.
• Assist with creating and maintaining reports and dashboards, and prepare ad hoc reports on systems and infrastructure.
• Maintain and control database user access.
• Assist in building tables, views, and data connections to support end-user application needs.
• Assist with developing database structures, monitoring database performance, and researching potential solutions under the direction of the Data Architect.
• Assist with querying and analyzing data and presenting findings clearly with actionable insight.
• Help develop specifications for datasets and reports based on business requests.
• Create SQL Server users, manage permissions, and maintain code for migration.
• 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.
• 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 of Florida employee.
• Ability to earn up to 104 hours of paid sick leave annually.
• Health insurance coverage, including individual and family coverage, for eligible employees.
• $25,000 life insurance policy for eligible employees.
• Additional supplemental insurance policies, including dental, vision, hospital supplement, and cancer 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
• Education Level: No Education Listed