What are the responsibilities and job description for the Database Administrator - Advanced position at Datasoft Technologies, Inc.?
Database Administrator - Advanced
Hybrid: Columbia, SC
About the Job
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 )
Required Skills:
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:
Hybrid: Columbia, SC
About the Job
- Duration: Long term Contract Position
- Location: Hybrid: Columbia, SC
- Pay rate: Hourly
- Job ID: 10330
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.
- 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.
- o Referential integrity enforcement
- o Foreign key reconciliation
- o Identity reseeding
- o Data remediation & cleanup
- 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.
- 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.
- o Judicial confidentiality standards
- o CJIS considerations (where applicable)
- • Monitor audit logs and security events.
- o Imperva or similar security appliances
- o Schema changes
- o Stored procedure deployments
- o Data migration scripts
- Support version control integration.
- o Multi-database updates
- o Password rotation
- o Security audits
- o Cross-environment validation.
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
- 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
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)