SENIOR DATA BASE ANALYST - 43004418

Requisition No: 827650 

Agency: Financial Services

Working Title: SENIOR DATA BASE ANALYST - 43004418

 Pay Plan: Career Service

Position Number: 43004418 

Salary:  $80,000.00 - $90,000.00 

Posting Closing Date: 05/06/2024 

Total Compensation Estimator Tool

*****OPEN COMPETITIVE EMPLOYMENT OPPORTUNITY*****

DIVISION: OFFICE OF INFORMATION TECHNOLOGY

BUREAU: ENTERPRISE APPLICATIONS

CITY: TALLAHASSEE

COUNTY: LEON

SPECIAL NOTES:

Four (4) years of experience in Computer Science or Information Technology-related field, such as cybersecurity, programming, computer science, engineering, or related field is preferred. A bachelor’s degree in Computer Science or Information Technology-related field, such as cybersecurity, programming, computer science, engineering or related field may substitute for the preferred experience. An associate degree in cybersecurity, programming, computer science, engineering or related field may substitute for two (2) years of the preferred experience.

Requirements

• Five (5) years of experience as a mainframe DB2 Data Base Analyst.
• Five (5) years of experience as an application programmer with preference in DB2 related products.

This position may be required to occasionally perform duties other than those listed on the position description.

The annual salary range for this position is $80,000.00 to 90,000.00. 

Employees of the Department of Financial Services are paid on a monthly pay cycle.

This position requires a security background check, including fingerprint as a condition of employment.

Responses to qualifying questions must be clearly supported by the state application and any omission, falsification, or misrepresentation in the answering of the qualifying questions will be cause for immediate elimination from the selection process.

MINIMUM QUALIFICATIONS FOR THIS POSITION INCLUDE THE FOLLOWING REQUIRED ENTRY LEVEL KNOWLEDGE, SKILLS, AND ABILITIES:

• Knowledge of Relational database, DB2 data base.
• Knowledge of Monitoring software BMC, TMON.
• Knowledge of programming, Cobol, REXX, CLIST, SQL.
• Ability to analyze and interpret highly technical information relating to computer programming, hardware, software, and telecommunications.
• Ability to be a team player in large and small groups (consensus building).
• Ability to communicate technical data processing information effectively verbally and in writing.
• Ability to communicate with developers in order to solve database related problems.
• Ability to assist in the design of data base systems.
• Ability to evaluate database designs or efficiency and usability.
• Ability to document problems, solutions, and enhancements.
• Ability to generate JCL for running of batch jobs.

BRIEF DESCRIPTION OF DUTIES:

This position will assist in the transformation of logical accounting (FLAIR) information requirement models to physical databases. 

Understand, use, and support selected modeling and data access tools in the analysis of customer’s information requirements from FLAIR and Worker’s Comp.

Evaluate customer’s requests for new data elements and systems, and incorporate them into the existing shared data environment, and maintain the data dictionary containing all metadata for the enterprise.

Coordinate use of the organization’s data to ensure data integrity and control redundancy.

Analyze and propose changes to database structures and aid in design and review design of the physical database.

Cross-train new ADABAS DBA in DB2 and Predict.

Develop and control the procedures necessary to save, retrieve, and recover data bases for hardware and/or software failure.

Set up and/or execute the jobs necessary to save, retrieve, and recover data bases and maintain data base access and update procedures to ensure proper control of the data bases.

Determine data base storage requirements, create / Refresh test data base environment for applications section.

Process Remedy tickets for DB2.  Monitor data base performance and recommend efficiency improvements.

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 canceled, suspended, or deemed ineligible depending upon the date of your retirement.

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