Database Administrator

Database Administrator – AdvancedLocation: Columbia, SC (Hybrid – 2 days onsite/week)Duration: 12 Months (Extension Possible)Interview Process: 1 Round – OnsiteCandidate Location: MUST be a CURRENT South Carolina resident (No relocation)Key ResponsibilitiesAdminister and maintain SQL Server environments (2016+) across multiple systemsPerform performance tuning & optimization of: Stored proceduresDynamic SQLComplex queries and ETL processesManage database security, authentication models, and role-based accessImplement and support: Backup & recovery strategiesDisaster recovery planningHigh availability solutions (Always On, clustering)Optimize large-scale datasets including case management and judicial dataIdentify and resolve: Blocking, deadlocks, long-running queriesIndex fragmentation and statistics issuesSupport data warehouse architecture, including fact/dimension modelsOptimize backend queries for Power BI reporting and dashboardsEnsure data integrity, governance, and standardization across systemsPerform data cleanup and remediation across multiple jurisdictionsDevelop and maintain automation scripts and DevOps pipelines for: Schema deploymentsData migrationsVersion control integrationMonitor and enforce security & compliance standards (CJIS, judicial confidentiality)Collaborate with developers, analysts, and infrastructure teamsRequired Skills7+ years of experience in SQL Database Administration & Operations3+ years of experience in Performance Tuning & Optimization3+ years of experience in Data Integrity & Governance Support3+ years of experience in Data Warehouse Architecture & Reporting Support3+ years of experience in Security & Compliance3+ years of experience in Automation & DevOps SupportPreferred SkillsExperience in judicial, government, or public sector environmentsExperience with Power BI backend optimizationKnowledge of.NET application data access patternsExperience with Always On Availability GroupsExperience using Azure DevOpsExperience cleaning legacy data structures across multiple jurisdictions/countiesAbout Us:InterSources Inc. is a Small, Woman, and Minority-Owned Business Enterprise, ISO/IEC 27001, SOC 2 Type 2 certified company with massive 18+ years of diversified experience in providing IT Consulting Services, Artificial Intelligence, Data Analysis, Application Development, Cloud Services, Cybersecurity, Digital Marketing, ERP Management, Custom Software Development, Web Development, UI/ UX Design, System Integration, QA Support etc. We make reasonable accommodations for clients and employees, and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud and Oracle partner company.