Database Systems Project Consultant

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

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.