SENIOR DATA BASE ANALYST-INFORMATION TECHNOLOGY

Requisition No: 851283 

Agency: Department of Corrections

Working Title: SENIOR DATA BASE ANALYST-INFORMATION TECHNOLOGY

 Pay Plan: Career Service

Position Number: 70020790 

Salary:  $74,079.72 Annual Rate 

Posting Closing Date: 05/23/2025 

Total Compensation Estimator Tool

***OPEN COMPETITIVE ADVERTISEMENT***

This advertisement is for a Career Service position located at Central Office in Systems Development.

Salary: $74,079.72 Annual Rate

*This is an IBM mainframe-based job working with IBM’s DB2 database. All experience must be shown on your resume.*

SALARY WILL BE DETERMINED IN ACCORDANCE WITH CURRENT PAY POLICY.

SPECIFIC DUTIES & RESPONSIBILITIES:

• Implement and maintain quality assurance processes to improve development efforts.
• Participate in disaster recovery for enterprise data environments.
• Ensure the quality, accuracy, and integrity of data resources and the information derived from them.
• Develop and maintain the enterprise data model, data dictionary, and data warehouse.
• Collaborate with programming staff to ensure new data elements meet standards and support innovative technology solutions for cost savings and efficiency.

BENEFITS:

• Paid vacation, sick leave, and holidays.
• Comprehensive health insurance and life insurance with accidental death and dismemberment benefits.
• Supplemental Dental, Vision, Life, Disability and Hospitalization insurance.
• Tuition-Free college courses.
• Retirement Plans with the Florida Retirement System:
  • Pension Plan (Traditional Retirement Pension Plan)
  • Investment Plan (401(K)-Type Retirement Plan)
  • Deferred Retirement Option Program (Drop)
  • Deferred Compensation
  • Recently Retired? Beginning July 1, 2024, there is no longer a reemployment limitation; beginning with the 7th calendar month from the member's distribution date, there are no restrictions on working for an FRS employer. You will not be required to repay any prior distributions, and you may continue receiving distributions from the Investment Plan or Pension Plan without interruption.

REQUIRED QUALIFICATIONS:

• Minimum of five (5) years of IBM’s mainframe-based DB2 administration experience, where at least 3+ years with V12 (or higher) environment.
• Minimum of 5 years of IBM mainframe-based experience working with TSO, Xpeditor and related tools.
• Five (5) or more years of MIS or Data Processing experience. Postsecondary education may substitute up to four (4) years of the required experience.
• Minimum of five (5) years working with IBM’s mainframe-based CICS environments.
• Minimum of five (5) years of SQL and T-SQL experience from version 2012 and higher (writing, testing, and executing code).
• Five (5) or more years of experience writing, testing, troubleshooting, and executing SSIS packages.

PREFERRED QUALIFICATIONS:

• Minimum of five (5) years of experience working in a government environment, prefer prior Dept. of Corrections experience.
• Willingness to provide after-hours on-call duties.
• Knowledgeable creating and updating ERD diagrams.
• Experience building SQL views and stored procedures.

Support of knowledge, skills, and abilities should be demonstrated on the application, in the education, in the work experience, in the work sample, in the interview and/or during reference checks. If you are interested in this position and meet the above indicated qualification and have the desired education, knowledge, and experience, please submit a State of Florida Application and resume through the People First system. If you experience problems applying on-line, please call the People First Service Center at 1-877-562-7287. Applications will be accepted until 11:59 PM EST on the closing date.

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.