Senior SQL Server DBA- Only SC candidates No relocation

The South Carolina State seeks a highly skilled Database Administrator (DBA) to support mission-critical judicial systems, statewide case management databases, data warehouse platforms, and reporting environments.

This position will provide advanced database administration, performance tuning, security hardening, disaster recovery planning, and cross-database standardization support for enterprise SQL Server environments supporting, Key ResponsibilitiesSQL Server Administration (v2016+)

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

Performance Tuning & Optimization

• 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

Data Integrity & Standardization

• 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

Data Warehouse & Reporting Support

• 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

Security & Compliance

• 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
• Work with Imperva or similar security appliances

Automation & DevOps Support

• 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

• 9+ years of experience with SQL Database Administration & Operations
• 5+ years of experience with Performance Tuning & Optimization
• 5+ years of experience with Data Integrity & Governance Support
• 5+ years of experience with Data Warehouse Architecture & Reporting Support
• 5+ years of experience with Security & Compliance
• 5+ 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, * Citizens, Green card or EAD. Sorry No H1B
• 5+ years of experience with Automation & DevOps Support
• Experience cleaning legacy data structures across multiple counties or jurisdictions
• .NET application data access patterns
• Must have 9 years' experience as a Senior SQL Server DBA
• Must have 5 years of experience with Performance Tuning & Optimization
• 5+ years of experience with Data Integrity & Governance Support
• 5+ years of experience with Data Warehouse Architecture & Reporting Support
• 5+ years of experience with Security & Compliance
• Only South Carolina residents- No relocation

Job Types: Full-time, Contract

Pay: $78.00 - $82.00 per hour