SENIOR DATA BASE ANALYST (WT: SENIOR ORACLE DATA BASE ANALYST) - 76002130

State of Florida•Tallahassee, FL

About The Position

The Senior Data Base Analyst is part of the Enterprise Data Management Services team and works as a database administrator for the Department’s Oracle databases. Reporting to the Oracle Services Manager, Data Base Administrator-SES, the analyst administers Oracle versions 11g, 12c, 19c, 23ai, and 26ai, and supports the Department’s planned migration to Oracle 26ai within the next year. The role supports database users, analyzes and implements database requests and systems, and monitors, troubleshoots, and resolves database issues. It establishes standards and procedures to optimize database architecture, reliability, and performance across application environments. The position places a strong emphasis on automation, including designing, developing, and maintaining Unix shell scripts for database management, monitoring, and administration. The successful candidate brings leadership, technical, analytical, communication, collaboration, and problem-solving capabilities. The position includes a regularly assigned on-call rotation of approximately one week per month, with occasional after-hours work, including nights and weekends. Employment is subject to Level 2 background investigation and CJIS clearance.

Requirements

Experience in Oracle 12c, 19c, and 23ai/26ai database administration.
Advanced proficiency with Unix/Linux operating systems, including Unix shell scripting for database automation and process optimization.
Knowledge of Oracle Multitenant Database Architecture.
Experience administering Oracle databases.
Experience with Oracle software installation, patching, and upgrading.
Ability to work independently and resolve complex issues.
Ability to diagnose, isolate, and resolve complex data-infrastructure problems.
Ability to write stored procedures, functions, packages, and database triggers.
Ability to tune SQL and PL/SQL performance.
Ability to multitask in a fast-paced environment.
Experience with operational support, including system installations, migrations, and upgrades.
Experience in logical database design and data models.
Understanding of the software development lifecycle.
Ability to stay current on tools, methodologies, and technologies related to data administration.
Knowledge of data privacy and protection initiatives.
Strong interpersonal skills and ability to resolve problems professionally.
Ability to communicate technical data-processing information effectively, verbally and in writing.
Ability to work in a team and establish and maintain effective working relationships.
Ability to receive and give constructive criticism.
A Level 2 background check and CJIS clearance, including a fingerprint-based FBI criminal-record check, are conditions of employment.
Applicants must be U.S. citizens or lawfully authorized to work in the United States; the Department does not sponsor work visas, CPT, or OPT.

Nice To Haves

Five or more years of experience working as an Oracle database administrator.
Hands-on experience planning, testing, and executing database migrations to newer Oracle versions, including 23ai and 26ai.
Extensive experience writing, debugging, and maintaining complex Unix/Linux shell scripts for automated database maintenance, backups, and alerting.
Experience developing Oracle database-driven applications.
Experience administering Oracle 12c and 19c databases and database infrastructure on RAC databases.
Working knowledge of Oracle Multitenant Architecture.
Experience writing stored procedures and programming in PL/SQL.
Experience in logical database design and data modeling.
A bachelor’s degree or higher in computer sciences or management information systems; a bachelor’s degree in any field; or completion of a two-year vocational/technical school or accredited community college program in data processing (excluding data entry).

Responsibilities

Administer the Department’s Oracle databases, including versions 11g, 12c, 19c, 23ai, and 26ai.
Support the Department’s planned migration to Oracle 26ai.
Assist and support database users.
Analyze, coordinate, and implement new database requests and systems.
Monitor, troubleshoot, and resolve database issues.
Establish database standards and procedures to optimize database architecture, reliability, and performance across application environments.
Design, develop, and maintain Unix shell scripts to automate database management, monitoring, and administrative tasks.
Provide operational database support, including installations, migrations, and upgrades.
Monitor and tune databases to provide high-availability service.
Participate in an on-call rotation of approximately one week per month and perform occasional after-hours work, including nights and weekends.