Data Integrity Government Experience DevOps Administrator
Coolsoft
- United States
- United States
Über
(Jobs in Columbia, SC
Requirement id 157601
Job title Administrator
Job location in Columbia, SC
Skills required SQL Database Administration, Performance Tuning, Performance Optimization, Data Integrity Government Experience Dev
Open Date 19-Mar-2026
Close Date
Job type Contract
Duration 12 Months
Compensation DOE
Status requirement ---
Job interview type ---
Email Recruiter:coolsoft
Job Description Administrator: SQL Database Administration, Performance Tuning, Performance Optimization, Data Integrity Government Experience Dev
Start date : 04/20/2026
End Date : 12 Months from projected start date
Submission deadline : 3/26/2026 5:00:00 PM
Client Info : SCCOURTS
Note:
Interview Process: 1 round, onsite
Possibility for Extension: Yes
*Work Location: Role is hybrid (2 days onsite per week)
Candidate location: Candidate must be a CURRENT SC resident. No relocation allowed.
Description :
The Client 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:
• Statewide Case Management Systems (CMS environments)
• Judicial Data Warehouse (DW)
• Public Index & Reporting Systems
• Power BI and Interactive Data Dashboards
• Cross-county reporting standardization initiatives
• Integrated court and justice partner systems
The DBA will work closely with the Deputy Director of Applications, IT Applications Development Manager, developers, data analysts, and infrastructure teams to ensure data integrity, high availability, performance optimization, and compliance with statewide data governance initiatives.
Responsibilities:
• 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:
o Stored procedures
o Dynamic SQL
o Cross-database queries
o CTE-heavy workloads
o 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:
o Referential integrity enforcement
o Foreign key reconciliation
o Identity reseeding
o Data remediation & cleanup
• Support statewide standardization of:
o County codes
o Circuit mappings
o Court type alignment
o Roster type consistency
• Ensure alignment with the Chief Justices data initiative and reporting aggregation standards.
• Optimize fact/dimension loading processes
• Support performance tuning for Power BI reporting back-end queries.
• Assist with:
o Indexed views
o Aggregation tables
o 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:
o Judicial confidentiality standards
o CJIS considerations (where applicable)
• Monitor audit logs and security events.
• Support WAF/SQL visibility requirements for secure application traffic.
o Imperva or similar security appliances
• Assist in scripting deployment pipelines for:
o Schema changes
o Stored procedure deployments
o Data migration scripts
• Support version control integration.
• Create reusable administrative scripts for:
o Multi-database updates
o Password rotation
o Security audits
o Cross-environment validation
Required Skills:
• 7+ years of experience with SQL Database Administration & Operations
• 3+ years of experience
Call502-379-4456 Ext 100for more details. Please provide Requirement id: 157601 while calling.
EOE Protected Veterans/Disability
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot stammt von einer Partnerplattform von TieTalent. Klicken Sie auf „Jetzt Bewerben“, um Ihre Bewerbung direkt auf deren Website einzureichen.