IT - SCCOURTS - Database Administrator - Advanced - 10330

Responsibilitie:

• Working on SQL Server (v 2016+)

• Administer and maintain SQL Server instances across multiple judicial environments.

• Manage contained users, authentication models, and database-level security.

• Configure and monitor SQL Agent jobs, maintenance plans, and index strategies.

• Implement and validate backup/restore procedures and disaster recovery plans.

• Support high availability configurations (Always On, clustering where applicable).

• Optimize large-scale tables supporting court case data.

• Analyze and tune:

• Stored procedures

• Dynamic SQL

• Cross-database queries

• CTE-heavy workloads

• Index fragmentation and statistics

• Review and optimize ETL loops across multiple CMS databases.

• Reduce blocking, deadlocks, and long-running transactions.

• Implement partitioning strategies where appropriate.

• Assist with:

• Referential integrity enforcement

• Foreign key reconciliation

• Identity reseeding

• Data remediation & cleanup

• Support statewide standardization of:

• County codes

• Circuit mappings

• Court type alignment

• Roster type consistency

• Ensure alignment with the Chief Justice's data initiative and reporting aggregation standards.

• Optimize fact/dimension loading processes

• Support performance tuning for Power BI reporting back-end queries.

• Assist with:

• Indexed views

• Aggregation tables

• Incremental load strategies

• Collaborate on data quality validation routines.

• Harden SQL Server instances against unauthorized access.

• Review role-based security for judicial data.

• Ensure compliance with:

• Judicial confidentiality standards

• CJIS considerations (where applicable)

• Monitor audit logs and security events.

• Support WAF/SQL visibility requirements for secure application traffic.

• Imperva or similar security appliances

• Assist in scripting deployment pipelines for:

• Schema changes

• Stored procedure deployments

• Data migration scripts

• Support version control integration.

• Create reusable administrative scripts for:

• Multi-database updates

• Password rotation

• Security audits

• Cross-environment validation

Required Skills:

• 7+ years of experience with SQL Database Administration & Operations

• 3+ years of experience with Performance Tuning & Optimization

• 3+ years of experience with Data Integrity & Governance Support

• 3+ years of experience with Data Warehouse Architecture & Reporting Support

• 3+ years of experience with Security & Compliance

• 3+ years of experience with Automation & DevOps Support

Preferred/Nice to Have Skills:

• Experience in judicial, government, or public sector environments

• Power BI backend optimization

• .NET application data access patterns

• Always On Availability Groups

• Azure DevOps

• Experience cleaning legacy data structures across multiple counties or jurisdictions