> Markdown version of [/jobs/ext/165699-senior-sql-server-dba-only-sc-candidates-no-relocation](https://www.wearedevelopers.com/jobs/ext/165699-senior-sql-server-dba-only-sc-candidates-no-relocation). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior SQL Server DBA- Only SC candidates No relocation - **Company:** PALMETTO TECHNOLOGIES, LLC - **Location:** Columbia, SC, United States - **Experience:** Expert - **Salary:** $162,240.0 - $170,560.0 - **Contract:** Permanent contract - **Skills:** .NET Framework, Adaptable Database Systems, Audit Trail, Microsoft Azure, Databases, Data Integrity, Extract Transform Load (ETL), Data Migration, Data Structures, Data Warehousing, Database Queries, DevOps, Disaster Recovery, Microsoft SQL Server, Performance Tuning, Power BI, Standard Sql, Application Data, Server Administration, Security Information and Event Management, SQL Stored Procedures, SQL Databases, SQL Server Agent, System Availability, Delivery Pipeline, Backend, Database Backup, Software Version Control, Sql Database Administration - **Published:** May 19, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=7bcf79dd045365aa ## About the Role * 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 ## Description 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 ## Related Videos - [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform) - [Developing the Backend with Stefan Lingler, CTO at Shpock](https://www.wearedevelopers.com/videos/100360-developing-the-backend-with-stefan-lingler-cto-at-shpock) - [Database DevOps with Containers](https://www.wearedevelopers.com/videos/145-database-devops-with-containers) - [DevOps Maturity Check – a way to balance autonomy and alignment](https://www.wearedevelopers.com/videos/58-devops-maturity-check-a-way-to-balance-autonomy-and-alignment) ## Related Articles - [Software Developer Salary in South Africa](https://www.wearedevelopers.com/magazine/232-software-developer-salary-in-south-africa) - [Frontend Developer Salary in South Africa](https://www.wearedevelopers.com/magazine/234-frontend-developer-salary-in-south-africa) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [The Best Job Search Websites of 2025](https://www.wearedevelopers.com/magazine/368-the-best-job-search-websites-of-2025)