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

State of Florida; Tallahassee (FL); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Annual and Sick Leave Package

Nine Paid Holidays

State Health and Life Insurance

Educational Benefits

Contributory Retirement Plan

Job summary

Florida Department of Highway Safety and Motor Vehicles (FLHSMV) is seeking a Senior Data Base Analyst to manage Oracle databases and lead migration efforts to Oracle 26ai. The role emphasizes automation, scripting, and high-availability database management across Oracle environments.

The ideal candidate will demonstrate strong leadership, communication, and problem-solving skills, with deep expertise in Oracle technologies and Unix/Linux scripting to support enterprise applications at FLHSMV.

Qualifications

• Experience in Oracle 12c, 19c, and 23ai/26ai database administration.
• Advanced proficiency in Unix/Linux operating systems, including Unix shell scripting for automation and optimization.
• Knowledge of Oracle Multitenant Database Architecture.
• Experience with Oracle software installation, patching, and upgrading.
• Ability to write Stored Procedures, Functions, Packages, and Triggers.
• Ability to Tune SQL and PL/SQL performance.

Responsibilities

• The Senior Data Base Analyst will serve as the Oracle DBA for FLHSMV databases and support migration to Oracle 26ai.
• Assist and support database users, analyze and implement new database requests, monitor, troubleshoot, and resolve issues.
• Develop and maintain robust Unix shell scripts to streamline database management and automation tasks.

Skills

Oracle 12c/19c/23ai/26ai

Unix/Linux shell scripting

Oracle Multitenant

Oracle installation/patching

SQL/PLSQL tuning

DBA leadership

Job description

Select how often (in days) to receive an alert:

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

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

Requisition No:886732

Agency: Highway Safety and Motor Vehicle

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

DIVISION OF INFORMATION SYSTEMS ADMINISTRATION

DEPUTY CHIEF INFORMATION OFFICE

BUREAU OF ENTERPRISE DATABASE SERVICES

ORACLE SERVICES

*Open Competitive Advertisement*

To be considered for this position, applicant responses to qualifying questions must be clearly stated within the employment history. Software systems, actual work experience, and years of employment must be clearly defined, or the application may not be considered for the position.

Contact Person: Coretha Gaymon, [phone] [e-mail]

The Organization

The Florida Department of Highway Safety and Motor Vehicles (FLHSMV) provides highway safety and security through excellence in service, education, and enforcement. With a workforce of approximately 4,500 employees throughout the state, the Department is leading the way to A Safer Florida through the efficient and professional execution of its core mission: the issuance of driver licenses, vehicle tags and titles, and operation of the Florida Highway Patrol.

Our Benefits Include

• Annual and Sick Leave Package
• Nine Paid Holidays
• State Health and Life Insurance
• Educational Benefits
• Contributory Retirement Plan

To learn more about FLHSMV and why it’s a great place to work, visit our website at: flhsmv.gov/careers.

If you're seeking employment with a meaningful mission, opportunities for skill growth and career advancement, competitive medical and life insurance, retirement benefits, ample vacation and sick leave, paid holidays, and educational assistance, consider building your career at FLHSMV!

Duties and Responsibilities

The Senior Data Base Analyst reports to the Oracle Services Manager, Data Base Administrator-SES. This position functions as an integral member of the Enterprise Data Management Services team and will operate as a Data Base Administrator (DBA) for the department’s Oracle databases. The incumbent will perform database administration on Oracle versions 11g, 12c, 19c, 23ai, and 26ai, actively supporting FLHSMV's upcoming migration to Oracle 26ai within the next year.

Duties will include but aren’t limited to assisting and supporting database users, analyzing, coordinating, and implementing new database requests and systems, and monitoring, troubleshooting, and resolving database issues. This position will also establish database standards and procedures that will optimize database architectures, reliability, and performance for all Department application environments. This role places a heavy emphasis on automation, requiring the design, development, and maintenance of robust Unix shell scripts to streamline database management, monitoring, and administrative tasks.

This position requires exceptional leadership, technical, and analysis skills. The successful candidate must have the ability to communicate effectively, precisely, and accurately across all levels of the organization. The ideal candidate would be able to form, express, and defend reasoned opinions, with a spirit of collaboration and problem-solving.

Knowledge, Skills, and Abilities

• Experience in Oracle 12c, 19c, and 23ai/26ai database administration.
• Advanced proficiency working in Unix/Linux operating systems, including deep knowledge of Unix shell scripting for database automation and process optimization.
• Knowledge of Oracle Multitenant Database Architecture.
• Experience with Oracle software installation, patching, and upgrading.
• Ability to work independently and to resolve complex issues.
• Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure.
• 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.
• Operational support skills, including experience with system installations, migrations, and upgrades.
• Experience in logical database design and data models.
• Understanding of the software development lifecycle process.
• Practical experience in monitoring and tuning databases to provide a high-availability service.
• Ability to remain current on tools, methodologies, and technologies related to data administration.
• Knowledge of data privacy and protection initiatives.
• Strong interpersonal skills to resolve problems in a professional manner.
• Ability to effectively communicate technical data processing information verbally and in writing.
• Ability to work well in a team environment, and to establish and maintain effective working relationships with others.
• Ability to receive and give constructive criticism, and maintain effective working relationships with others.

Preferred Qualifications

Preference will be given to candidates with the following:

• Five plus 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.
• Administering Oracle 12c and 19c databases and database infrastructure on RAC Databases.
• Working knowledge of Oracle Multi‑Tenant Architecture.
• Writing stored procedures and PL/SQL programming.
• Logical database design and data modeling.

Education Preferred:

• A bachelor’s degree or higher from an accredited college/university in one of the computer sciences or in management information systems (or)
• A bachelor’s degree from an accredited college or university (or)
• Completion of a two‑year program of study from a vocational/technical school or accredited community college in an area of data processing (excluding data entry)

Job Related Requirements

• The position you are applying is subject to a Level 2 background check, along with Criminal Justice Information System (CJIS) clearance, to include a fingerprint-based check of the criminal records of the FBI, as a condition of employment pursuant to Chapter 110.1127, 435 and 943, Florida Statutes. Please note that, since this position requires CJIS clearance, the Department will have access to all an applicant’s criminal and juvenile delinquency records, even those that have been sealed or expunged.
• This position includes a regularly assigned (approximately one week a month) 24-7 on-call requirement. You may also be required to work after hours on occasion, including nights and weekends.

General Information

• The state of Florida hires only U.S. citizens and lawfully authorized alien workers. All selected applicants are required to provide identification and either proof of U.S.
• citizenship or proof of authorization to work in the U.S. The Florida Department of Highway Safety and Motor Vehicles (FLHSMV) does not participate in employment sponsorship for work visa status (e.g., H-1B) or for Curricular Practical Training (CPT) or Optional Practical Training (OPT, STEM OPT).
• Applicants being considered for employment will be required to submit to a fingerprint-based background investigation, which will include a check of the criminal history records of the FBI. Fingerprints and associated information/biometrics will be retained in the FBI’s Next Generation Identification (NGI) system and fingerprints may continue to be compared against fingerprints submitted to or retained by NGI.
• In accordance with Section 110.1128, Florida Statutes, male applicants who were required to register with the Selective Service System must provide proof of registration or documentation verifying exemption status during the hiring process.
• The elements of the selection process may include a skill assessment and/or oral interview.
• FLHSMV employees are paid once a month on the last workday of each month. All state employees are required to participate in the direct deposit program pursuant to s. 110.113 Florida Statutes.

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.

Location:

TALLAHASSEE, FL, US, 32399 TALLAHASSEE, FL, US, 32301 TALLAHASSEE, FL, US, 32304 TALLAHASSEE, FL, US, 32311 TALLAHASSEE, FL, US, 32307 TALLAHASSEE, FL, US, 32316 TALLAHASSEE, FL, US, 32305 TALLAHASSEE, FL, US, 32310 TALLAHASSEE, FL, US, 32317 TALLAHASSEE, FL, US, 32303 TALLAHASSEE, FL, US, 32309 TALLAHASSEE, FL, US, 32302 TALLAHASSEE, FL, US, 32312 TALLAHASSEE, FL, US, 32308

For assistance, call the People First Service Center at [phone] Monday - Friday, 8:00 a.m. to 6:00 p.m., Eastern time. Pursuant to Florida Law, 110.211 F. S., the State of Florida is an EEO employer.