Data Architect- W2 - Onsite

CLOUDSCOUTS SOFTWARE SOLUTIONS LLC•Tallahassee, FL

16d•Onsite

About The Position

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, and Application Performance Service Units. 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.

Requirements

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.

Responsibilities

Maintain and/or create 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.
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.
Perform System Backup and disaster recovery.
Handle Emergency Service Requests, including after-hours support.
Monitor database performance and make recommendations for enhancements.
Perform application performance optimization and fine-tuning.
Conduct code review and design review and evaluation.
Perform system documentation.
Consult with staff.
Review Event Logs.
Perform Software Upgrades.
Troubleshoot and fix bugs.
Manage Version Release Services, including enhancements and bug fixes.
Perform Database Backup, Database Schema Copy, Production Database, Production Verification, and Data Conversion for version releases.
Provide on-call service for emergency requests with a 2-hour response to downtime calls.
Monitor system performance and make recommendations to IT Management.
Perform database architecture modification.