Database Administrator - Advanced

Columbus, NC, US • Posted 10 hours ago • Updated 10 hours ago

Contract Independent

Contract W2

Contract Corp To Corp

On-site

Depends on Experience

Datasoft Technologies, Inc.

Fitment

Dice Job Match Score™

👤 Reviewing your profile...

Job Details

Skills

DBA
SQL SERVER
TUNING
PERFORMANCE
AUTOMATION
SECURITY
OPTIMIZATION
SQL

Summary

Database Administrator - Advanced
Hybrid: Columbia, SC
About the Job

Duration: Long term Contract Position
Location: Hybrid: Columbia, SC
Pay rate: Hourly
Job ID: 10330

Overview:
Client is seeking 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 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:

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.

Qualification:
Required Skills:

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 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

About our Company
DataSoft Technologies is a highly recognized provider of professional IT Consulting services in the US. Founded in 1994, DataSoft Technologies, Inc. provides staff augmentation services for Information Technology and Automotive Services. Our team member benefits include:

Paid Holidays/Paid Time Off (PTO)
Medical/Dental Insurance Group
Accident/Critical Illness Insurance
Life Insurance
401 (K)

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: datga001
Position Id: 26-00288
Posted 10 hours ago

Company Info

About Datasoft Technologies, Inc.

Datasoft Technologies, Inc. is a software development and consulting firm. Our clients rely on us for software consulting, system engineering, software development, and computer consultancy services. We provide the most competitive rates in the industry to a broad range of private and public sector clients.

Go to company profile

Create job alert

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

Similar Jobs

Developer - Data Scientist/Developer

Jackson, Mississippi

•

Yesterday

Developer - Data Scientist/Developer Remote: Jackson, MS About the Job Duration: Long term Contract Position Location: Remote: Jackson, MS Pay rate: Hourly Job ID: 156572 Overview: Client seeks a data scientist/software developer to support a proof- of-concept demonstration using natural language processing and other machine learning methods to improve the intake process. This work is critical to demonstrating the potential of the latest technology to improve the lives of children at risk. R

Easy Apply

Contract, Third Party

Depends on Experience

IT Programmer/Analyst - Python, AI, Emerging Tech

Greenville, South Carolina

•

9d ago

Title : IT Programmer/Business Analyst Job# : 5263 Client Location : Greenville, SC 29607 Work Type : Hybrid / 80% Onsite in Greenville, SC Duration : 12 months with a possibility of further extension or conversion to full time but not guaranteed Day to day responsibilities for this role: - Research of new emerging technologies and academic paper - Implementation of end-to-end Proof of Concepts and MVPs for innovation use cases - Regular presentations to IT teams and business units - Handover o

Easy Apply

Contract

Depends on Experience

Sr. Software Engineer

Columbus, Ohio

•

9d ago

Title : Sr. Software Engineer Work Location : Candidates must be local to Columbus, Ohio 1400 City View Drive, Columbus, OH 43215 United States Relocation is not an option unless there is prior approval from both the business and HR. Hybrid schedule (3 days in office & 2 days WFH) Work Hours : Standard business hours (i.e., between 8 am 5 pm EST) Attend all scheduled team and department meetings. Job Description: Desired Industry Experience: Financial Services Experience, with direct knowle

Easy Apply

Contract

Depends on Experience

Search all similar jobs