Database Administrator

AppleOne Employment Services; South Carolina; On-site; USD 90,000 - 120,000; Full time

Job summary

A staffing agency is seeking an experienced Senior Database Administrator to support critical judicial and case-management systems in South Carolina. The role involves optimizing SQL Server environments and ensuring data governance security. Applicants should have at least 7 years of SQL Database Administration experience, with strong skills in performance tuning and data warehouse support. This position provides an excellent opportunity to impact statewide data initiatives while collaborating with various teams.

Qualifications

• 7+ years of SQL Database Administration & Operations.
• 3+ years of Performance Tuning & Optimization.
• 3+ years of Data Integrity & Governance.
• 3+ years of Data Warehouse & Reporting Support.
• 3+ years of Security & Compliance.

Responsibilities

• Administer, optimize, and secure SQL Server 2016+ environments.
• Manage authentication models and DB-level security.
• Oversee SQL Agent jobs and maintenance plans.
• Implement and optimize backup/restore plans.
• Support and optimize Always On high availability configurations.

Skills

SQL Database Administration

Performance Tuning

Data Integrity

Data Warehouse Support

Security Compliance

Automation & DevOps Support

Job description

We are supporting a confidential statewide government initiative seeking a highly skilled Senior Database Administrator to support mission‑critical judicial and case‑management systems. If you excel in SQL Server optimization, data governance, and enterprise‑scale performance tuning, this is a major opportunity to make an impact at the state level.

About the Role

As a Senior DBA, you will work within a large, multi‑environment SQL Server landscape supporting:

• Enterprise Data Warehouse
• Public Index & Reporting Systems
• Power BI and interactive data dashboards
• Multi‑county reporting and data standardization initiatives

You will collaborate with application development, data analytics, and infrastructure teams to ensure system reliability, security, and alignment with statewide data governance standards.

Key Responsibilities

• Administer, optimize, and secure SQL Server 2016+ environments
• Manage authentication models, contained users & DB‑level security
• Oversee SQL Agent jobs, maintenance plans & indexing strategies
• Implement, test & optimize backup/restore + disaster recovery plans
• Support and optimize Always On high availability configurations
• Reduce blocking, deadlocks & long‑running transactions
• Enforce referential integrity, identity reseeding & data cleanup
• Support Power BI backend query optimization
• Harden SQL Server environments & maintain compliance with security standards
• Assist with schema deployments, version control & automation scripting

Required Qualifications

• 7+ years SQL Database Administration & Operations
• 3+ years Performance Tuning & Optimization
• 3+ years Data Integrity & Governance
• 3+ years Data Warehouse & Reporting Support
• 3+ years Security & Compliance
• 3+ years Automation & DevOps Support

Preferred Experience

• Public sector or judicial systems
• .NET data access patterns
• Always On Availability Groups
• Legacy data cleanup across counties or jurisdictions