SQL Database Administrator
Share
Job Location:
Columbia, IN - USA
Monthly Salary:
Not Disclosed
Posted on:
Yesterday
Vacancies:
1 Vacancy
Job Summary
Job Title: Database Administrator - Advanced
Duration: 12 Months from projected start date (Possible Extension)
Location: Columbia South Carolina (Hybrid 2 days onsite per week)
Position Type: Staff Augmentation
Hours Per Week: 38
Interview Type: 1 round onsite
Ceipal ID: SSCSQL330SN
Job Code: 10330
End Client: State of South Carolina (SCCOURTS)
Department: Office of Information Technology
Duration: 12 Months from projected start date (Possible Extension)
Location: Columbia South Carolina (Hybrid 2 days onsite per week)
Position Type: Staff Augmentation
Hours Per Week: 38
Interview Type: 1 round onsite
Ceipal ID: SSCSQL330SN
Job Code: 10330
End Client: State of South Carolina (SCCOURTS)
Department: Office of Information Technology
Scope of Project
The 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.
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 Justices 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
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 Justices 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
Required/Preferred 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
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
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
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
V Group Inc. is a NJ-based IT Services and Products Company with its business strategically categorized in various Business Units including Public Sector Enterprise Solutions Professional Services Ecommerce Projects and Products. Within Public Sector business unit we cater IT Professional Services to Federal State and Local. We have multiple awards/ contracts with 30 states including but not limited to NY CA FL GA MD MI NC OH OR CO CT TN PA TX VA NM VT and WA.
If you are considering applying for a position with V Group or in partnering with us on a position please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.
If you are considering applying for a position with V Group or in partnering with us on a position please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.
Please share my contact information with others working in Information Technology.
