Abrar Admin

Shvaas Consulting LLC

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:Specific Duties Include (But Are Not Limited To)<ul><li>Statewide Case Management Systems (CMS environments)</li><li>Judicial Data Warehouse (DW)</li><li>Public Index &amp; Reporting Systems</li><li>Power BI and Interactive Data Dashboards</li><li>Cross-county reporting standardization initiatives</li><li>Integrated court and justice partner systems</li></ul>The DBA will work closely with the Deputy Director of Applications, IT Applications Development Manager, developers, data analysts, and infrastructure teams to ensure:<ul><li>Data integrity</li><li>High availability</li><li>Performance optimization</li><li>Compliance with statewide data governance initiatives</li></ul>Key Responsibilities<ul><li>SQL Server Administration (v2016+)</li><li>Administer and maintain SQL Server instances across multiple judicial environments</li><li>Manage contained users, authentication models, and database-level security</li><li>Configure and monitor SQL Agent jobs, maintenance plans, and index strategies</li><li>Implement and validate backup/restore procedures and disaster recovery plans</li><li>Support high availability configurations (Always On, clustering where applicable)</li><li>Performance Tuning &amp; Optimization</li><li>Optimize large-scale tables supporting court case data</li><li>Analyze and tune: Stored procedures, Dynamic SQL, Cross-database queries, CTE-heavy workloads and Index fragmentation and statistics</li><li>Review and optimize ETL loops across multiple CMS databases</li><li>Reduce blocking, deadlocks, and long-running transactions</li><li>Implement partitioning strategies where appropriate</li><li>Data Integrity &amp; Standardization</li><li>Assist with: Referential integrity enforcement, Foreign key reconciliation, Identity reseeding and Data remediation &amp; cleanup</li><li>Support statewide standardization of: County codes, Circuit mappings, Court type alignment and Roster type consistency</li><li>Ensure alignment with the Chief Justice&rsquo;s data initiative and reporting aggregation standards</li><li>Data Warehouse &amp; Reporting Support</li><li>Optimize fact/dimension loading processes</li><li>Support performance tuning for Power BI reporting back-end queries</li><li>Assist with: Indexed views, Aggregation tables and Incremental load strategies</li><li>Collaborate on data quality validation routines</li><li>Security &amp; Compliance</li><li>Harden SQL Server instances against unauthorized access</li><li>Review role-based security for judicial data</li><li>Ensure compliance with: Judicial confidentiality standards, CJIS considerations (where applicable), Monitor audit logs and security events</li><li>Support WAF/SQL visibility requirements for secure application traffic</li><li>Work with Imperva or similar security appliances</li><li>Automation &amp; DevOps Support</li><li>Assist in scripting deployment pipelines for: Schema changes, Stored procedure deployments, Data migration scripts and Support version control integration</li><li>Create reusable administrative scripts for: Multi-database updates, Password rotation, Security audits and Cross-environment validation</li></ul>Required Skills<ul><li>7+ years of experience with SQL Database Administration &amp; Operations</li><li>3+ years of experience with Performance Tuning &amp; Optimization</li><li>3+ years of experience with Data Integrity &amp; Governance Support</li><li>3+ years of experience with Data Warehouse Architecture &amp; Reporting Support</li><li>3+ years of experience with Security &amp; Compliance</li><li>3+ years of experience with Automation &amp; DevOps Support</li><li>Preferred / Nice-to-Have Skills</li><li>Experience in judicial, government, or public sector environments</li><li>Power BI backend optimization</li><li>.NET application data access patterns</li><li>Always On Availability Groups</li><li>Azure DevOps</li><li>Experience cleaning legacy data structures across multiple counties or jurisdictions</li></ul>Others<ul><li>Authorized work statuses accepted: U.S. Citizen, Green Card holder, and H‑4 EAD</li><li>Candidate location: Candidate must be a CURRENT SC resident. No relocation allowed.</li></ul>Pay: $76.00 - $80.00 per hourWork Location: Hybrid remote in Columbia, SC 29201

SQL Server Database Administrator – Consultant

Join Shvaas Consulting LLC and explore 1   exciting career opportunities. They're hiring for various roles with options for remote or on-site work. Apply today and become part of their innovative team.

Shvaas Consulting LLC

About Company

SQL Server Database Administrator – Consultant