Senior Database Administrator

Columbia, SC, US • Posted 1 day ago • Updated 1 day ago

Contract W2

On-site

Depends on Experience

Fitment

Dice Job Match Score™

🤯 Applying directly to the forehead...

Job Details

Skills

DATABASE ADMINISTRATOR
SQL SERVER
Power BI
Performance Tuning
DevOps
.NET

Summary

DPP is seeking a Senior Database Administrator for an opportunity in Columbia, SC.

Location: Partially onsite – 2 days/week onsite.
Duration: 12 months, with possibility of extension.
Term: W2 position
Candidate location: Candidate must be a resident of South Carolina

Position summary:

The Senior Database Administrator (DBA) will 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

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:

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.
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.
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.
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.
- Imperva or similar security appliances
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

Required knowledge, skills, and abilities:

7+ years of experience with SQL Database Administration & Operations
3+ years of experience with Performance Tuning & Optimization
3+ years of experience with Data Integrity & Governance Support
3+ years of experience with Data Warehouse Architecture & Reporting Support
3+ years of experience with Security & Compliance
3+ years of experience with Automation & DevOps Support

Preferred/nice to have:

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

Interested? Learn more:
Click the apply button or contact our recruiter Sarah at to learn more about this position (#26-00233).

Authorized US Worker - s and those authorized to work in the US are encouraged to apply. We are unable to sponsor at this time. EOE/AA/V/D

DPP offers a range of compensation and benefits packages to our employees and their eligible dependents. Call today to learn more about working with DPP.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10114775
Position Id: 26-00233
Posted 1 day ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Senior Database Administrator

Hybrid in Columbia, South Carolina

•

Today

Location: Columbia, SC Work Arrangement: Hybrid (2 days onsite per week). Employment Type: Contract. Interview Mode: One round, Onsite in Columbia. Candidate Requirement: Must be a current South Carolina resident. No relocation is permitted. Core Responsibilities SQL Administration: Administer SQL Server (v2016+) instances, manage SQL Agent jobs, maintenance plans, and high-availability configurations (Always On/Clustering). Performance Tuning: Optimize large-scale tables, stored procedures, CTE

Easy Apply

Contract

Senior Database Administrator - Hybrid

Hybrid in Columbia, South Carolina

•

Today

Title: Senior Database Administrator - Hybrid Mandatory skills: database administration, case management databases, data warehouse platforms, Case Management Systems, Judicial Data Warehouse, performance tuning, security hardening, disaster recovery planning, Data Dashboards, SQL Server, Power BI, SQL Database Administration, Performance Tuning, Data Integrity, Governance Support, Automation, DevOps Support, Reporting Support, Power BI backend optimization, .NET application data access patterns

Easy Apply

Contract

Depends on Experience

Senior SQL Database Administrator (Judicial / Government / Public sector environment)

Columbia, South Carolina

•

Today

Trigyn's direct government client based out of South Carolina has a long-term contract assignment for Senior SQL Database Administrator. The particulars of the position are as follows. 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,

Contract

DOE

Senior SQL Database Administrator- Applicants must be local to SC

Columbia, South Carolina

•

Yesterday

Job Title: Senior SQL Database Administrator- Applicants must be local to South Carolina (SC) Location: Columbia, SC (Hybrid 2 days onsite/week) Duration: 12 Months (Possible Extension) Interview Process: 1 Round (Onsite) Job Summary IRG Clients are seeking an experienced Senior SQL Database Administrator to manage, maintain, and optimize SQL Server environments supporting statewide judicial systems. The role focuses on performance tuning, data integrity, security, and database standardiz

Easy Apply

Contract, Third Party

Depends on Experience

Search all similar jobs