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