SQL Server Database Admin

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Innosoul inc, is seeking the following. Apply via Dice today!Job ID: SC-10330Hybrid/Local SQL Server DBA with Data Integrity/Governance, DW/Reporting, Compliance, WAF/Imperva, Power BI, .Net, Automation, Azure DevOps, legacy cleaning, judicial experienceLocation: Columbia, SC (SCCOURTS)Duration: 12 MonthsCandidate location: Candidate must be a CURRENT SC resident. No relocation allowed.Required Skills:7+ years of experience with SQL Database Administration & Operations3+ years of experience with Performance Tuning & Optimization3+ years of experience with Data Integrity & Governance Support3+ years of experience with Data Warehouse Architecture & Reporting Support3+ years of experience with Security & Compliance3+ years of experience with Automation & DevOps SupportPreferred/Nice to Have Skills:Experience in judicial, government, or public sector environmentsPower BI backend optimizationNET application data access patternsAlways On Availability GroupsAzure DevOpsExperience cleaning legacy data structures across multiple counties or jurisdictionsJob DescriptionThe South Carolina Judicial Branch (SCJB) 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 SystemsPower BI and Interactive Data DashboardsCross-county reporting standardization initiativesIntegrated court and justice partner systemsThe 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.Responsibility: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 proceduresDynamic SQLCross-database queriesCTE-heavy workloadsIndex fragmentation and statisticsReview and optimize ETL loops across multiple CMS databases.Reduce blocking, deadlocks, and long-running transactions.Implement partitioning strategies where appropriate.Assist with:Referential integrity enforcementForeign key reconciliationIdentity reseedingData remediation & cleanupSupport statewide standardization of:County codesCircuit mappingsCourt type alignmentRoster type consistencyEnsure alignment with the Chief Justice s data initiative and reporting aggregation standards.Optimize fact/dimension loading processesSupport performance tuning for Power BI reporting back-end queries.Assist with:Indexed viewsAggregation tablesIncremental load strategiesCollaborate on data quality validation routines.Harden SQL Server instances against unauthorized access.Review role-based security for judicial data.Ensure compliance with:Judicial confidentiality standardsCJIS considerations (where applicable)Monitor audit logs and security events.Support WAF/SQL visibility requirements for secure application traffic.Imperva or similar security appliancesAssist in scripting deployment pipelines for:Schema changesStored procedure deploymentsData migration scriptsSupport version control integration.Create reusable administrative scripts for:Multi-database updatesPassword rotationSecurity auditsCross-environment validation