Data Architect - Advanced

We are seeking an experienced Data Architect (Advanced) to support the design, administration, and continuous improvement of multiple mission-critical criminal and juvenile justice information systems. The successful candidate will serve as the primary database authority for a portfolio of high-impact government applications, ensuring their availability, security, performance, and integrity. This role demands deep expertise in Microsoft SQL Server environments and a proactive approach to database operations and architecture., The Data Architect will be responsible for maintaining and/or creating databases supporting the following systems, as well as any additional databases required by the agency:

• Juvenile Justice Information System (JJIS)

• Criminal Justice Network (CJNET)

• Cost of Care (COC) database, including the JJIS Database component

• Payroll system databases

• DJJ Learning Management System (SKILLPRO)

• Positive Achievement Assessment Tool (CAT/RAY)

• Detention Risk Assessment Instrument (DRAI)

• Human Trafficking Screening Tool (HTST)

• 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)

• Central Communication Center (CCC)

• Any other databases as required by the agency

III. Specialized / Preferred Experience

Microsoft SQL Server

• Senior-level working experience with Microsoft SQL Server 2012 through SQL Server 2017.

• Installation and configuration of SQL Server instances and related services.

• Operating system interoperability with SQL Server environments.

• Regular maintenance, patching, and health-check procedures.

• Backups, restore operations, and disaster recovery planning and execution.

• Troubleshooting and root cause analysis for database issues.

• Security configuration, role management, and compliance enforcement.

• Performance optimization and tuning - including query optimization and index management.

Database Objects & Development

• Administration of databases and objects including schemas, tables, views, and indexes.

• Management of scheduled jobs and task automation.

• Creating and optimizing Triggers.

• Managing data transfers and transactional replication.

• Designing and developing database solutions aligned to business requirements.

• Creating and reviewing Stored Procedures for efficiency and performance.

• Creating tables on production servers with appropriate change management discipline.

• Creating DTS/SSIS Packages for ETL and data integration workflows.

• Adding fields to production tables with minimal service disruption.

Data Management & Integration

• Bulk copy and large-scale data operations.

• Data conversion across systems and formats.

• Data transfer between environments and external partners.

• Data cleansing, validation, and quality assurance processes.

• Software upgrade planning and execution with data integrity preservation.

• Data archiving aligned to retention policies and regulatory requirements.

Documentation & Governance

• Creating and maintaining a comprehensive Data Dictionary.

• Creating and modifying Data Models to reflect current architecture.

• Producing technical documentation for database structures, processes, and changes.

• Using Source Control tools (e.g., Git), SQL Prompt, and SQL Compare for version management.

• Transactional Replication setup, configuration, and monitoring.

Monitoring & Reliability

• Proactively monitoring database systems to ensure secure, available, and high-performance services.

• Minimizing planned and unplanned downtime through proactive maintenance and alerting.

• Bachelor''s degree in Computer Science, Information Systems, or a related technical field preferred.