Requisition No: 31764 

Agency: Highway Safety and Motor Vehicle

Working Title: SR ORACLE DATA BASE ANALYST - 76000043

Position Number: 76000043 

Salary:  $60,000.00 - $75,000.12 Annually 

Posting Closing Date: 03/22/2018 

Department of Highway Safety and Motor Vehicles

Division of Information Systems Administration

Bureau of Service Operations


*Open Competitive Opportunity*


In order 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.



$60,000.00 - $75,000.12 Annually


Contact Person: Coretha Gaymon, (850) 617-2007


The Organization:

The Florida Department of Highway Safety and Motor Vehicles (DHSMV) 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 DHSMV and why it’s a great place to work, visit our website at: 


Description of Job:

The Senior Data Base Analyst reports to the Oracle Services 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 10g, 11g, and 12c.  Duties will include but aren’t limited to: assisting and supporting database and data warehouse users, analyzing, coordinating and implementing new database requests and systems, and monitoring, troubleshooting, and resolving database and data warehouse issues.  This position will also establish database standards, and procedures that will optimize database architectures, reliability, and performance for all Department application environments.

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.


Preference will be given to applicants with professional experience in the following:

  • Developing Oracle database driven applications
  • Writing stored procedures and PL/SQL programming.
  • Logical database design and data modeling.


Preference will also be given to applicants who have completed a two-year program of study from a vocational/technical school or accredited community college in an area of data processing (excluding data entry) and/or who have obtained an Associate’s degree or higher from an accredited college/university in one of the computers sciences, management information systems, and/or any field of study.


Desired Knowledge, Skills, and Abilities:

  • Experience in Oracle database administration.
  • Experience working in Unix operating systems.
  • 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 PL/SQL performance.
  • Operational support skills, including experience with system installations, migrations and upgrades.
  • Knowledge of data synchronization technologies (Informatica, Shareplex, etc.).
  • Knowledge of shell scripting.
  • Knowledge of Oracle Server database administration.
  • Experience in logical database design and data models.
  • Understanding of the software development lifecycle process.
  • Practical experience in monitoring and tuning a database to provide a high availability service.
  • Ability to maintain currency 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.
  • Ability to receive and give constructive criticism, and maintain effective working relationships with others.


Job Related Requirements:

  • The selected applicant must pass a Criminal Justice Information Services (CJIS) criminal history background check.  
  • 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.


Additional Information:

The elements of the selection process may include a skill assessment and/or oral interview.

Applicants being considered for employment will be required to submit to pre-employment fingerprinting, and a background investigation.

The process for selecting applicant(s) for this position could take up to six months.  Following the six month period, a new application must be submitted to an open advertisement in order to be considered for that vacancy.

HSMV 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.

The State of Florida is an Equal Opportunity Employer/Affirmative Action Employer, and does not tolerate discrimination or violence in the workplace.

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.  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. 

State of Florida
Full time
TALLAHASSEE, Florida 32399, US