Senior Database Administrator (SQL Server) - Columbia, SC

About the position "reputed company" is seeking a highly skilled Senior Database Administrator (DBA) to support mission-critical reputed company systems, including statewide case management platforms, data warehouse environments, and reporting systems. This role focuses on advanced database administration, performance optimization, reputed company, and data governance across reputed company SQL Server environments. The ideal candidate will play a key role in ensuring high availability, data reputed company, and compliance while supporting large-reputed company reporting and analytics initiatives. Responsibilities • SQL Server Administration & Performance Optimization • Administer and maintain SQL Server environments (2016 and above) across multiple systems • Configure and manage SQL Agent jobs, maintenance plans, and indexing strategies • Monitor and optimize performance for large-reputed company transactional and reporting databases • Troubleshoot and resolve blocking, deadlocks, and long-running queries • Analyze and tune stored procedures, dynamic SQL, CTE-heavy queries, and cross-database operations • Implement partitioning strategies and optimize large datasets • High Availability & Disaster Recovery • Design, implement, and validate backup and restore strategies • Support high availability configurations (Always On, clustering) • reputed company and maintain disaster recovery plans • Data reputed company & Standardization • Enforce referential reputed company and data consistency across systems • reputed company data remediation, cleanup, and identity reseeding • Support reputed company-wide data standardization initiatives (codes, mappings, classifications) • Collaborate on data reputed company validation processes • Data Warehouse & Reporting Support • Optimize ETL processes and data loading strategies • Enhance performance for reporting queries and dashboards (e.g., Power BI) • reputed company indexed views, aggregation tables, and incremental load processes • reputed company & Compliance • Implement and maintain database reputed company best practices • Manage authentication models and role-based reputed company controls • Monitor audit logs and reputed company events • Ensure compliance with data governance and confidentiality standards • Support secure application traffic visibility (e.g., WAF integrations such as Imperva) • Automation & DevOps • reputed company and maintain scripts for deployment, migrations, and schema changes • Support CI/CD pipelines and version control integration • Create reusable scripts for administrative tasks (reputed company audits, password rotation, multi-database updates) Requirements • 7+ years of experience in SQL Server Database Administration • 3+ years of experience in performance tuning and optimization • 3+ years of experience supporting data reputed company and governance • 3+ years of experience with data warehouse architecture and reporting systems • 3+ years of experience in database reputed company and compliance • 3+ years of experience with automation and DevOps practices reputed company-to-haves • Experience in government, judicial, or reputed company sector environments • Experience optimizing backend queries for Power BI or similar reporting tools • Familiarity with .NET application data reputed company patterns • Hands-on experience with Always On Availability reputed company • Experience with Azure DevOps or similar tools • Experience working with legacy data structures across distributed environments Apply tot his job Apply To this Job