Senior Database Administrator (SQL Server) Columbia, SC

Job Title: Senior Database Administrator (SQL Server)
Location: Columbia SC (Hybrid 2 Days Onsite per Week)
Duration: 12 Months

Position Overview

Navitas Partners LLC is seeking a highly skilled Senior Database Administrator (DBA) to support mission-critical enterprise systems including statewide case management platforms data warehouse environments and reporting systems.

This role focuses on advanced database administration performance optimization security and data governance across complex SQL Server environments. The ideal candidate will play a key role in ensuring high availability data integrity and compliance while supporting large-scale reporting and analytics initiatives.

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

• Develop and maintain disaster recovery plans

Data Integrity & Standardization

• Enforce referential integrity and data consistency across systems

• Perform data remediation cleanup and identity reseeding

• Support enterprise-wide data standardization initiatives (codes mappings classifications)

• Collaborate on data quality validation processes

Data Warehouse & Reporting Support

• Optimize ETL processes and data loading strategies

• Enhance performance for reporting queries and dashboards (e.g. Power BI)

• Develop indexed views aggregation tables and incremental load processes

Security & Compliance

• Implement and maintain database security best practices

• Manage authentication models and role-based access controls

• Monitor audit logs and security events

• Ensure compliance with data governance and confidentiality standards

• Support secure application traffic visibility (e.g. WAF integrations such as Imperva)

Automation & DevOps

• Develop and maintain scripts for deployment migrations and schema changes

• Support CI/CD pipelines and version control integration

• Create reusable scripts for administrative tasks (security audits password rotation multi-database updates)

Required Qualifications

• 7 years of experience in SQL Server Database Administration

• 3 years of experience in performance tuning and optimization

• 3 years of experience supporting data integrity and governance

• 3 years of experience with data warehouse architecture and reporting systems

• 3 years of experience in database security and compliance

• 3 years of experience with automation and DevOps practices

Preferred Qualifications

• Experience in government judicial or public sector environments

• Experience optimizing backend queries for Power BI or similar reporting tools

• Familiarity application data access patterns

• Hands-on experience with Always On Availability Groups

• Experience with Azure DevOps or similar tools

• Experience working with legacy data structures across distributed environments

Work Environment

• Hybrid schedule with 2 days onsite per week in Columbia

• Collaborative environment working with developers analysts and infrastructure teams

For more details reach at

About Navitas Partners LLC:It is a certified WBENC and one of the fastest-growingTechnical / ITstaffing firms in the US providing services to numerous clients. We offer the most competitive pay for every position. We understand this is a partnership. You will not be blindsided and your salary will be discussed upfront.