Job title: Data Architect

Location: Tallahassee, FL 32399

Working Model: Onsite

Duration: 24+ months (long term)

Interview: MS Teams/In-person

Scope of Service:

The services provided will involve maintaining and/or creating the Juvenile Justice Information System (JJIS), Criminal Justice Network (CJNET), Cost of Care (COC), Payroll, DJJ’s Learning Management System (SKILLPRO), the New Positive Achievement Assessment Tool (CAT/RAY), the New Detention Risk Assessment (DRAI), Human Traffic Screening Tool (HTST), The Enterprise Document Management Solution, Residential Electronic Medical Record (EMR), Probation Resource Booking (PRB), Facility Management System (FMS), Evidence Based System (EBS), Staff Verification System (SVS), the JJIS Database portion for the Cost of Care database, Central Communication Center (CCC) and other databases as required.

The Juvenile Justice Information System Data Architect/ Database Maintenance Support contract is based on a fix quantity of predefined service units. A service unit is defined to be equivalent to an eight-hour workday for one person.

The JJIS database maintenance support is broken out into four services:

Version Release Service

Emergency Service Requests

Database Performance Management Service

Application Performance Service Units

Professional Requirements: The database administrator consultant is required to have professional working experience at an advance level to carry out the following job duties.

Working experience using Microsoft SQL 2012 through SQL 2017 environment.

Microsoft Clustering Services

Installation and Configuration

Operating system and interoperability

Regular maintenance

Backups and disaster recovery

Troubleshooting

Security

Performance optimization and tuning

Databases and objects administration

Scheduled jobs (tasks) management

Create Triggers

Data transfers and replication management

Design and development

Create & Review Stored Procedures for efficiency

Create Tables on production server

Create DTS\SSIS Packages

Adding fields to tables on production server

Bulk copy

Data Conversion

Data Transfer

Data Cleansing

Software Upgrade

Data Archiving

Create data dictionary

Create & Modify Data model

Documentation

Transactional Replication

Source Control, SQL Prompt & SQL Compare

Ensure proactive monitoring of the database systems to ensure secure services with minimum downtime.

JJIS Data Architect & Database Maintenance Support Details: Below are details of each JJIS database maintenance support service category.

The service units will be used towards a database administrator’s day-to-day task involved to keep the database systems up and running including daily maintenance of JJIS, JJIS WEB applications, STARS application, CJNET, the New Positive Achievement Assessment Tool (CAT/RAY), the New Detention Risk Assessment (DRAI), Staff Verification Systems (SVS), the JJIS Database portion for the Cost of Care and any other database as required for the agency

Tasks performed but not limited to are: System Backup and disaster recovery, Emergency Service, Monitoring Report, Change Requests, Database Security, Scheduled Jobs, Data Management, Inserting and Updating Date, Data Dictionary, Create and Modify Data Model, Data Transfer and replication management, Data Archiving, Create Tables and data fields, Installation and configuration of databases and servers, Data Cleansing, Software Upgrade, Trouble Shooting, Bug Fixes, Service Unit Report, Create Triggers & Create DTS\ISSI Packages.

1). Version Release Service – These units will be used towards any releases such as enhancements and bug fixes to the current JJIS, JJIS WEB applications, STOP application, CJNET, the JJIS Database portion for the Cost of Care systems and any other databases as required

Database Backup

Database Schema Copy

Production Database

Production Verification

Data Conversion

2). Emergency Service Requests – These units will be used towards any after hours support (during the week and weekends) required in case of a system breakdown that would involve bringing the system back up and running in full operational mode.

On call service

After hours service

2 hour response to down time calls

3). Database Performance Management Services – These units will be used towards a database administrator’s frequent tasks involved to keep the database systems up and running including monitoring performance of JJIS, JJIS WEB applications, STOP application, CJNET, Human Traffic Screening Tool (HTST), the JJIS Database portion of the Cost of Care System and any other database as required. Proposing any future enhancements to existing systems.

Review Stored Procedures

Performance optimization and fine tuning

Design review and evaluation

System Documentation

Database architecture modification

Monitor system performance and make recommendations to the IT Management.

4). Application Performance Service Units – These units will be used towards a developer’s frequent tasks involved to keep JJIS, JJIS WEB, CJNET and any other database applications up and running and any enhancements made to the system.

System performance optimization and fine tuning

Code review

Design review and evaluation

System documentation

Staff consultation

Review of Event Logs

Software Upgrade

Trouble Shooting

Bug Fixes

Service Unit Report