Database Administrator
1 week ago
Columbia, South Carolina, United States
Intersources
Full-time
Free with email or Google
Save this job and keep your search organized
Create a free account to save jobs, create alerts and return to this listing from your dashboard.
Free with email or Google
By continuing, you agree to our Terms & Privacy Policy.
Job Title: Database Administrator – Advanced (10330)
Location: Columbia, SC (Hybrid – 2 days onsite/week)
Duration: 12 Months (Extension Possible)
Interview Process: 1 Round – Onsite
Candidate Location: MUST be a CURRENT South Carolina resident (No relocation)
Key Responsibilities
Required Skills
Preferred Skills
Location: Columbia, SC (Hybrid – 2 days onsite/week)
Duration: 12 Months (Extension Possible)
Interview Process: 1 Round – Onsite
Candidate Location: MUST be a CURRENT South Carolina resident (No relocation)
Key Responsibilities
- Administer and maintain SQL Server environments (2016+) across multiple systems
- Perform performance tuning & optimization of:
- Stored procedures
- Dynamic SQL
- Complex queries and ETL processes
- Manage database security, authentication models, and role-based access
- Implement and support:
- Backup & recovery strategies
- Disaster recovery planning
- High availability solutions (Always On, clustering)
- Optimize large-scale datasets including case management and judicial data
- Identify and resolve:
- Blocking, deadlocks, long-running queries
- Index fragmentation and statistics issues
- Support data warehouse architecture, including fact/dimension models
- Optimize backend queries for Power BI reporting and dashboards
- Ensure data integrity, governance, and standardization across systems
- Perform data cleanup and remediation across multiple jurisdictions
- Develop and maintain automation scripts and DevOps pipelines for:
- Schema deployments
- Data migrations
- Version control integration
- Monitor and enforce security & compliance standards (CJIS, judicial confidentiality)
- Collaborate with developers, analysts, and infrastructure teams
Required Skills
- 7+ years of experience in SQL Database Administration & Operations
- 3+ years of experience in Performance Tuning & Optimization
- 3+ years of experience in Data Integrity & Governance Support
- 3+ years of experience in Data Warehouse Architecture & Reporting Support
- 3+ years of experience in Security & Compliance
- 3+ years of experience in Automation & DevOps Support
Preferred Skills
- Experience in judicial, government, or public sector environments
- Experience with Power BI backend optimization
- Knowledge of .NET application data access patterns
- Experience with Always On Availability Groups
- Experience using Azure DevOps
- Experience cleaning legacy data structures across multiple jurisdictions/counties