Share this Job

DATA BASE CONSULTANT - 71001444

Date: Jul 30, 2021

Location: TALLAHASSEE, FL, US, 32308

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

Requisition No: 385981 

Agency: Department of Law Enforcement

Working Title: DATA BASE CONSULTANT - 71001444

Position Number: 71001444 

Salary:  $46,381.14 

Posting Closing Date: 08/12/2021 

ABOUT OUR AGENCY:

The Florida Department of Law Enforcement (FDLE) employs more than 1,900 members statewide – either at headquarters in Tallahassee or in one of seven regional operations centers (ROCs). Services are delivered by five key areas: Executive Direction and Business Support; Investigations and Forensic Science; Florida Capitol Police; Criminal Justice Information Services; and Criminal Justice Professionalism. Click here for additional information about FDLE.

MISSION:

To promote public safety and strengthen domestic security by providing services in partnership with local, state, and federal criminal justice agencies to prevent, investigate, and solve crimes while protecting Florida’s citizens and visitors.

 DATA BASE CONSULTANT – #71001444

 To be considered as a potential candidate, you must meet the minimum qualifications(s) listed below. Degrees must be from an accredited college or university as recognized by the U.S. Department of Education.

 MINIMUM QUALIFICATIONS:

1. A bachelor's degree from an accredited college or university and five years of experience in computer systems analysis and/or computer programming, three years of which must have been in data base design; or

2. A master's degree from an accredited college or university in management information systems or in one of the computer sciences and four years of experience in computer systems analysis and/or computer programming, three years of which must have been in data base design; or

3. A doctorate from an accredited college or university in management information systems or in one of the computer sciences and three years of experience in data base design; or

4. Seven years of experience in computer systems and analysis and/or computer programming, three years of which must have been in data base design and either (a) completion of a 720 classroom hour program of study from a vocational/technical school or community college in an area of data processing (excluding data entry), or (b) 60 semester or 90 quarter hours of college course work from an institution which includes four courses in computer science or management information systems; or

5. Experience in computer systems analysis and/or computer programming can substitute on a year-for-year basis for the required college education.

6. Completion of a one-year program of study from a vocational/technical school in an area of data processing (excluding data entry) can substitute for one year of computer systems analysis and/or computer programming experience. 

DUTIES & RESPONSIBILITIES:

  • Management and administration of Oracle, Microsoft SQL Server and MySQL database software and databases;
  • Installing, configuring, patching and maintaining Oracle, Microsoft SQL Server and MySQL database software and databases;
  • Ensuring the availability, integrity and security of database data; 
  • Providing database backup and recovery services;
  • Developing and maintaining utility programs, scripts and routines for management of database systems on Red Hat LINUX and Windows server systems;
  • Providing network support services for database-related network technologies and adapters such as TNS, ODBC, JDBC, OLEDB and .Net.
  • Collaborating with business experts to develop and document database infrastructure or design requirements;
  • Performing database design, data modeling and data administration;
  • Developing and documenting data standards;
  • Maintaining the enterprise data dictionary and model repository;
  • Utilizing data administration tools to construct data profiles, perform data analysis and provide data cleansing recommendations;
  • Providing support, diagnostic, troubleshooting and resolution of web-based and client server software applications in a distributed computer systems environment; 
  • Project planning related to maintenance and lifecycle management for multiple distributed systems;
  • Administering and supporting multiple statewide applications; and
  • Assisting in the establishment and enforcement of database administration policies, standards and procedures. 

KNOWLEDGE, SKILLS & ABILITIES:

  • Knowledge of Oracle and MySQL data base management technologies in UNIX/LINUX operating system environment;
  • Knowledge of Microsoft SQL Server in a Windows operating system environment;
  •  Knowledge of Oracle, Microsoft SQL Server and MySQL internals, data structures, and memory management;
  • Knowledge of Oracle network connectivity;
  • Knowledge of SQL and PL/SQL languages;
  • Knowledge of UNIX/LINUX operating system and commands;
  • Knowledge of Microsoft Server operating system and commands;
  • Knowledge of computer programming, systems analysis and systems design principles and practices; 
  • Skills in installing and maintaining Oracle, Microsoft SQL Server and MySQL software and databases;
  • Skills in designing, developing, testing, documenting and implementing database backup and recovery procedures;
  • Skills in performing database backup and recovery processes for Oracle using RMAN;  
  • Skills in performing database backup and recovery processes for Microsoft SQL Server; 
  • Skills in configuring data base parameters for performance tuning; 
  • Skills in developing, testing, documenting and implementing SQL, Oracle PL/SQL, UNIX/LINUX shell scripts and Windows operating system BAT or CMD shell scripts; 
  • Ability to plan, organize and coordinate multiple concurrent projects and work assignments;
  • Ability to use critical thinking skills and problem solve;
  • Ability to work independently;
  • Ability to create logical, well-written standards and procedures related to database design and database administration;
  • Ability to write, code, test, debug, and review computer programs and stored procedures;
  • Ability to process information logically and solve problems;
  • Ability to identify and define user requirements;
  • Ability to write technical data processing reports;
  • Ability to communicate effectively verbally and in writing; and
  • Ability to establish and maintain effective working relationships with others.  

SPECIAL NOTE: Preference will be given to applicants with training and experience or certification in Oracle Database Administration.

OUR SALARY & BENEFITS:

Starting salary will be the minimum of the class pay range, unless otherwise dictated by FDLE’s pay policy. FDLE is a State of Florida Employer and offers a comprehensive benefits package, including:

  • Paid holidays, vacation and sick leave;
  • HMO and PPO health insurance options with premiums starting as low as $50 per month;
  • $25,000 in automatic life insurance coverage;
  • Multiple supplemental insurance options including: dental, vision, disability and more;
  • Pension and investment retirement plan options;
  • Tax deferred medical and child care reimbursement accounts; and
  • State of Florida Tuition Waiver Program. 

HIRING PROCESS:

You will be evaluated for this job based on your previous knowledge and experience. Additional reviews may be performed to screen for preferred qualifications, experience and education. Your qualifications will be based on knowledge, skills, and abilities and other elements relevant to this position supported by the information in your application. Qualifying questions will only be credited if verifiable by the information provided on your application including specifically required software/computer skills. You may be contacted to participate in a selection process which may consist of written exercises, work samples, skills tests, and interviews.  You may be notified by email to participate in a selection process. Failure to reply within a designated timeframe may exclude you from further consideration. Future vacancies may be filled from this position advertisement.

BACKGROUND:

FDLE requires an extensive background process of all recommended applicants. The elements of a background include: financial credit check, criminal history of applicant and applicant’s immediate family or roommates, personal references, employment and education verifications (which includes official transcript(s)), drug screen and fingerprinting.  This information will be utilized to make the final hiring decision. 

NOTES:

Preference will be given to current FDLE members who have satisfactorily completed their probationary period or served at least one year in their current position. Preference may be given to applicants in the State Personnel System who have satisfactorily completed their probationary period or served at least one year in their current position.

REMINDERS:

  1. Male applicants born on or after October 1, 1962, will not be eligible for hire or promotion unless they are registered with the Selective Services System (SSS) before their 26th birthday, or have a Letter of Registration Exemption from the SSS. For more information, please visit the SSS website: http://www.sss.gov.
  2. If you are a retiree of the Florida Retirement System (FRS), please check with the FRS on how your current benefits will be affected if you are re-employed with the State of Florida. Your current retirement benefits may be cancelled, suspended, or deemed ineligible depending upon the date of your retirement. 

The State of Florida hires only U.S. citizens and lawfully authorized alien workers.

 

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