Share this Job

TEST DATA MANAGEMENT DATABASE CONSULTANT - 76000216

Date: Feb 13, 2020

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

Requisition No: 134901 

Agency: Highway Safety and Motor Vehicle

Working Title: TEST DATA MANAGEMENT DATABASE CONSULTANT - 76000216

Position Number: 76000216 

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

Posting Closing Date: 02/26/2020 

Department of Highway Safety and Motor Vehicles

Division of Information Systems Administration

Bureau of Strategic Business 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.

 

TEST DATA MANAGEMENT DATA BASE CONSULTANT (CLASS TITLE:  SR. DATA BASE ANALYST)

$60,000.00 - $75,000.00 Annually

Contact Person: Alyssa Newsom, 850-617-2016

 

Who We Are;

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: flhsmv.gov/careers

 

What Will l I Be Doing?

This Test Data Management Database Consultant position functions as an integral member of the Test Data Management team and will operate as a database administrator for the department’s Oracle and SQL databases. The incumbent will perform database administration on Oracle versions 10g, 11g, and 12c. Duties will include: Assisting and supporting test data management, database and data warehouse users, analyzing, coordinating and implementing new database requests and systems; monitoring, troubleshooting, and resolving test data management, database, and data warehouse issues.

 

Knowledge, Skills, and Abilities:

  • Experience in Oracle 10g,11g and 12c database administration.
  • Experience in Oracle database migration and upgrade planning.
  • Experience working in Unix/ Linux operating system.
  • Experience with Oracle software installation, patching and upgrading
  • Experience administering Oracle databases.
  • Ability to work independently and resolve complex Oracle issues.
  • Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure.
  • Ability to write SQL, PL-SQL and T-SQL stored procedures, Functions, Packages and Database Triggers.
  • Ability to Tune Oracle SQL and PL/SQL performance.
  • Operational support skills, including experience with system installations, migrations and upgrades.
  • Knowledge of Unix Scripting.
  • Experience with Oracle Data pump Utility.
  • Experience with Oracle Backup and recovery.
  • Knowledge of Test Data Management and Test Data Management Tools
  • Knowledge of data synchronization and data synchronization tools.
  • Experience in planning and design of data synchronization.
  • Experience in logical database design models.
  • Experience as PL/SQL Developer.
  • Understanding the software development lifecycle process.
  • Practical experience in monitoring and tuning a database to provide high availability service.
  • Ability to maintain concurrency in tools, methodologies and technologies related to database 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 receive and give constructive criticism and maintain effective working relationships with others.
  • Ability to serve as team lead/mentor; ability to transfer knowledge.

 

We are looking for individuals with the following experience:

  • Administering Oracle databases, particularly Oracle 12c databases.
  • Using the Oracle export/import or Data Pump utility.

 

Additional preference will be given to applicants with the following:

  • Professional experience writing stored procedures and PL/SQL programming
  • Experience as a PL/SQL Developer
  • Working with data synchronization tools
  • Working with data test data management tools

 

Education Preferred:

  • A bachelor’s degree or higher from an accredited college/university, preferably in one of the computer sciences or management information systems (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).        

 

What’s Required?

  • The position you are applying is subject to a Level 2 background and CJIS security clearance, to include fingerprinting as a condition of employment pursuant to Chapter 110.1127, 435 and 943, Florida Statutes.  As an applicant for positions requiring CJIS security clearance, you are required to disclose criminal records that have been sealed or expunged. 
  • This position may periodically be required to work outside regular business hours.
  • This position includes a regularly assigned (approximately one week a month) 24-7 on-call requirement. 

 

General 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 a fingerprint-based background investigation, which will include a check of the criminal history records of the FBI.

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. 


Nearest Major Market: Tallahassee