Job Description
Data Architect•W2•Onsite
CLOUDSCOUTS SOFTWARE SOLUTIONS LLC
Tallahassee, FL Job Details Full-time 1 day ago Qualifications Data model design Version control Data replication Data Integration (Data management) Operating systems Data modeling projects Data cleaning Database backup and recovery System performance optimization Software implementation Data recovery Database security hardening Server backup and recovery Software installation Schema design Database security management Server updates Stored procedures SQL Database server management Data Architecture Design (Architecture design skills) Release management Disaster recovery implementation Application design Data Security (Data management) Server installation Software documentation Data backup Failover clustering Application Maintenance Full Job Description 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
