Database Administrator(South Carolina Residents Only) - Full Time(W2) Only
Jobs via Dice, Columbia, SC, United States
Dice is the leading career destination for tech experts at every stage of their careers. Our client, eSystems, Inc., is seeking the following. Apply via Dice today!
Role: Database Administrator (South Carolina Residents Only) – Full Time (W2 Only) Client: State of South Carolina (SCJB) Work Type: Hybrid Location: Columbia, South Carolina Duration: 12 Months (Extendable) Max Payrate: 65$ Per Hour eSystems Inc. is a fast-growing Systems Integrator based in Princeton, New Jersey. We provide strategic IT solutions and services with primary practice areas in Java and Microsoft centric e‑Business solutions, ERP solutions, Enterprise Application Integration, Data Warehousing and Business Intelligence solutions. Our clients include Fortune 500 corporations, government agencies, small and mid‑sized local businesses, and non‑profit organizations.
As an equal opportunity employer, eSystems complies with all applicable laws, rules and regulations preventing discrimination against job applicants based on race, ethnicity, religious beliefs, gender, gender identity, age, veteran status, marital status, physical challenges, or any other relevant factor.
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. 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, judicial data warehouse, public index & reporting systems, Power BI and interactive data dashboards, cross‑county reporting standardization initiatives, and 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:
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 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
#J-18808-Ljbffr
Role: Database Administrator (South Carolina Residents Only) – Full Time (W2 Only) Client: State of South Carolina (SCJB) Work Type: Hybrid Location: Columbia, South Carolina Duration: 12 Months (Extendable) Max Payrate: 65$ Per Hour eSystems Inc. is a fast-growing Systems Integrator based in Princeton, New Jersey. We provide strategic IT solutions and services with primary practice areas in Java and Microsoft centric e‑Business solutions, ERP solutions, Enterprise Application Integration, Data Warehousing and Business Intelligence solutions. Our clients include Fortune 500 corporations, government agencies, small and mid‑sized local businesses, and non‑profit organizations.
As an equal opportunity employer, eSystems complies with all applicable laws, rules and regulations preventing discrimination against job applicants based on race, ethnicity, religious beliefs, gender, gender identity, age, veteran status, marital status, physical challenges, or any other relevant factor.
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. 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, judicial data warehouse, public index & reporting systems, Power BI and interactive data dashboards, cross‑county reporting standardization initiatives, and 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:
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 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
#J-18808-Ljbffr