Job Description

Database Administrator DBA

Location: Columbia, SC hybrid (2 days onsite per week)

Interview Process: 1 round, onsite

Duration: 12+ Months
Employment Type: Contract (C2C / W2)
Experience Required: 7+ Years

Work Location: Candidate must be a CURRENT SC resident. No relocation allowed.

Project Scope:

We are seeking a highly skilled Database Administrator (DBA) to support mission-critical enterprise systems, including case management databases, data warehouse platforms, and reporting environments.

This role involves advanced database administration, performance tuning, security hardening, disaster recovery planning, and cross-database standardization within a SQL Server environment . The DBA will collaborate with development, data, and infrastructure teams to ensure data integrity, system availability, and optimal performance across enterprise systems.

Key Responsibilities:

Database Administration & Operations

• Administer and maintain SQL Server (2016+) environments
  
• Manage authentication models, contained users, and database security
  
• Configure and monitor SQL Agent jobs, maintenance plans, and indexing strategies
  
• Implement and validate backup/restore and disaster recovery solutions
  
• Support high availability configurations (Always On, clustering)
  

Performance Tuning & Optimization

• Optimize large-scale databases and high-volume transactional systems
  
• Analyze and tune:
  
• Stored procedures and dynamic SQL
  
• Cross-database queries and CTE-heavy workloads
  
• Indexing strategies, fragmentation, and statistics
  
• Reduce blocking, deadlocks, and long-running queries
  
• Implement partitioning strategies and query performance improvements
  

Data Integrity & Governance

• Enforce referential integrity and manage data consistency
  
• Perform data remediation, cleanup, and reconciliation
  
• Support enterprise data standardization initiatives
  
• Collaborate on data quality validation and governance practices
  

Data Warehouse & Reporting Support

• Optimize ETL processes and data warehouse workloads
  
• Support fact/dimension loading and aggregation strategies
  
• Improve backend performance for Power BI and reporting queries
  
• Implement indexed views, aggregation tables, and incremental loads
  

Security & Compliance

• Harden SQL Server environments against unauthorized access
  
• Implement role-based access control (RBAC)
  
• Monitor audit logs and security events
  
• Ensure compliance with data security and confidentiality standards
  
• Support secure application traffic visibility (e.g., WAF tools like Imperva)
  

Automation & DevOps

• Develop scripts for:
  
• Schema deployments
  
• Stored procedure updates
  
• Data migration
  
• Support version control and CI/CD processes
  
• Build reusable scripts for:
  
• Multi-database updates
  
• Security audits
  
• Cross-environment validation
  

Required Skills & Experience:

·7+ years of experience in SQL Server Database Administration

·3+ years in performance tuning and query optimization

·3+ years supporting data integrity and governance

·3+ years working with data warehouse architecture and reporting systems

·3+ years in database security and compliance

·3+ years in automation and DevOps support

Preferred Skills:

· Experience in government or public sector environments

· Knowledge of Power BI backend optimization

· Understanding of .NET application data access patterns

· Hands-on experience with Always On Availability Groups

· Experience with Azure DevOps

· Experience handling legacy data cleanup and multi-system integration

Education:

Bachelor’s Degree or equivalent work experience

Job Tags

Similar Jobs