SQL Database Administrator at SUNSHINE ENTERPRISE USA LLC

Columbia, South Carolina, United States -

Full Time

Start Date

Immediate

Expiry Date

20 Jun, 26

Salary

0.0

Posted On

22 Mar, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL Server, Database Administration, Performance Tuning, Security Hardening, Disaster Recovery, Always On, Clustering, Stored Procedures, Query Optimization, Data Integrity, ETL Processes, Data Warehouse, RBAC, Automation, CI/CD, Power BI

Industry

Wholesale

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

Responsibilities

The Database Administrator will administer and maintain SQL Server environments, focusing on performance tuning, security hardening, high availability configurations, and disaster recovery planning for mission-critical enterprise systems. Key duties include optimizing large-scale databases, managing security compliance, supporting data warehouse workloads, and developing automation scripts for deployments and audits.