Data Architect- W2 - Onsite

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