IT - SCCOURTS - Database Administrator - Advanced
Abacus
- United States
- United States
À propos
Resume R2R Cover Letter Meets Work Location
Position Description Please ensure you attach the SC Cover Sheet (attached), a valid Right to Represent, and the candidate's resume with full legal first name, and last name. Withdrawn candidates will not be permitted to be replaced. If you would like to use a sub vendor, only 1 level deep, please submit the Sub Vendor usage form.
The State of South Carolina is looking for a Database Administrator - Advanced Why is this position open: 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. Will close to submissions on 3/26 at 5:00PM EST. Interview Process: 1 round, onsite Duration of the Contract: 12 months Possibility for Extension: Yes Work Location: Role is hybrid (2 days onsite per week) Candidate location: Candidate must be a CURRENT SC resident. No relocation allowed. Full job description attached and required and preferred skills are listed below. Required Skills Skill Type Skill Name 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 Skills Skill Type Skill Name 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
Attachment:
Job Title: Senior Database Administrator
Why is this position open? Job Description 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 (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.
Responsibilitie:
Working on SQL Server (v 2016+) dminister 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. nalyze 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. ssist 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. ssist with:
Indexed views ggregation 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
ssist 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 lways On Availability Groups zure DevOps Experience cleaning legacy data structures across multiple counties or jurisdictions
By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at Privacy Policy - Abacus.
Compétences linguistiques
- English
Avis aux utilisateurs
Cette offre provient d’une plateforme partenaire de TieTalent. Cliquez sur « Postuler maintenant » pour soumettre votre candidature directement sur leur site.