SQL Database Administrator

SUNSHINE ENTERPRISE USA LLC•Columbia, SC

22h•Hybrid

About The Position

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.

Requirements

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

Nice To Haves

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

Responsibilities

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)
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
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
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
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)
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