Database Administrator - W2 Only
Elegant Enterprise-Wide Solutions, Columbia, SC, United States
About this Position:
Learn more about the general tasks related to this opportunity below, as well as required skills.
Job Title: Database Administrator Responsibilities: Database Administration:
Administer and maintain SQL Server (2016+) instances across multiple judicial environments, managing security, authentication models, and contained users. Operational Maintenance:
Configure and monitor SQL Agent jobs, maintenance plans, and index strategies while validating backup/restore and disaster recovery procedures. High Availability & Scale:
Support Always On and clustering configurations while optimizing large-scale tables used for court case data. Performance Tuning:
Analyze and tune complex workloads, including stored procedures, dynamic SQL, CTEs, and cross-database queries to reduce blocking and deadlocks. ETL & Data Optimization:
Review ETL loops across multiple CMS databases, implementing partitioning and incremental load strategies where appropriate. Data Integrity & Remediation:
Assist with referential integrity enforcement, foreign key reconciliation, identity reseeding, and large-scale data cleanup. Statewide Standardization:
Support the alignment of county codes, circuit mappings, and court types to meet the Chief’s data and reporting standards. Reporting & Analytics Support:
Optimize fact/dimension loading and perform back-end query tuning to support Power BI reporting and aggregation tables. Security & Compliance:
Harden instances against unauthorized access and ensure strict compliance with judicial confidentiality and court system standards. DevOps & Automation:
Create reusable administrative scripts for multi-database updates and assist in scripting deployment pipelines for schema and code changes. 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. "No phone calls please. xywuqvp " "We are an equal opportunity employer and do not discriminate based on race, color, religion, gender, sexual orientation, national origin, age, disability, citizenship or any protected status."
Learn more about the general tasks related to this opportunity below, as well as required skills.
Job Title: Database Administrator Responsibilities: Database Administration:
Administer and maintain SQL Server (2016+) instances across multiple judicial environments, managing security, authentication models, and contained users. Operational Maintenance:
Configure and monitor SQL Agent jobs, maintenance plans, and index strategies while validating backup/restore and disaster recovery procedures. High Availability & Scale:
Support Always On and clustering configurations while optimizing large-scale tables used for court case data. Performance Tuning:
Analyze and tune complex workloads, including stored procedures, dynamic SQL, CTEs, and cross-database queries to reduce blocking and deadlocks. ETL & Data Optimization:
Review ETL loops across multiple CMS databases, implementing partitioning and incremental load strategies where appropriate. Data Integrity & Remediation:
Assist with referential integrity enforcement, foreign key reconciliation, identity reseeding, and large-scale data cleanup. Statewide Standardization:
Support the alignment of county codes, circuit mappings, and court types to meet the Chief’s data and reporting standards. Reporting & Analytics Support:
Optimize fact/dimension loading and perform back-end query tuning to support Power BI reporting and aggregation tables. Security & Compliance:
Harden instances against unauthorized access and ensure strict compliance with judicial confidentiality and court system standards. DevOps & Automation:
Create reusable administrative scripts for multi-database updates and assist in scripting deployment pipelines for schema and code changes. 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. "No phone calls please. xywuqvp " "We are an equal opportunity employer and do not discriminate based on race, color, religion, gender, sexual orientation, national origin, age, disability, citizenship or any protected status."