Database Administrator

InterSources Inc.

Columbia, SC

JOB DETAILS
SKILLS
Artificial Intelligence (AI), Authentication, Automation, Case Management, Cloud Applications, Cloud Computing, Data Analysis, Data Cleaning, Data Migration, Data Quality, Data Recovery, Data Sets, Data Structures, Data Warehousing, Database Administration, Database Extract Transform and Load (ETL), DevOps, Disaster Recovery, ERP (Enterprise Resource Planning), Government, High Availability, ISO (International Organization for Standardization), Information Technology Consulting, Information/Data Security (InfoSec), International Electro-Technical Commission (IEC), Internet Security, Microsoft .NET, Microsoft SQL Server DBA (Database Administration), Microsoft Windows Azure, Online Marketing, Oracle, Performance Tuning/Optimization, Power BI, Quality Assurance, Query Optimization, Regulatory Compliance, Reporting Dashboards, SQL (Structured Query Language), SQL Databases, Scripting (Scripting Languages), Security Monitoring, Software Development, Source Code/Configuration Management (SCM), Statistics, Stored Procedures, System Integration (SI), User Experience Design (UXD), User Interface Design, Web Programming
LOCATION
Columbia, SC
POSTED
30+ days ago
Job Title: Database Administrator – Advanced (10330)
Location: Columbia, SC (Hybrid – 2 days onsite/week)
Duration: 12 Months (Extension Possible)
Interview Process: 1 Round – Onsite
Candidate Location: MUST be a CURRENT South Carolina resident (No relocation)

Key Responsibilities
  • Administer and maintain SQL Server environments (2016+) across multiple systems
  • Perform performance tuning & optimization of:
    • Stored procedures
    • Dynamic SQL
    • Complex queries and ETL processes
  • Manage database security, authentication models, and role-based access
  • Implement and support:
    • Backup & recovery strategies
    • Disaster recovery planning
    • High availability solutions (Always On, clustering)
  • Optimize large-scale datasets including case management and judicial data
  • Identify and resolve:
    • Blocking, deadlocks, long-running queries
    • Index fragmentation and statistics issues
  • Support data warehouse architecture, including fact/dimension models
  • Optimize backend queries for Power BI reporting and dashboards
  • Ensure data integrity, governance, and standardization across systems
  • Perform data cleanup and remediation across multiple jurisdictions
  • Develop and maintain automation scripts and DevOps pipelines for:
    • Schema deployments
    • Data migrations
    • Version control integration
  • Monitor and enforce security & compliance standards (CJIS, judicial confidentiality)
  • Collaborate with developers, analysts, and infrastructure teams

Required Skills
  • 7+ years of experience in SQL Database Administration & Operations
  • 3+ years of experience in Performance Tuning & Optimization
  • 3+ years of experience in Data Integrity & Governance Support
  • 3+ years of experience in Data Warehouse Architecture & Reporting Support
  • 3+ years of experience in Security & Compliance
  • 3+ years of experience in Automation & DevOps Support

Preferred Skills
  • Experience in judicial, government, or public sector environments
  • Experience with Power BI backend optimization
  • Knowledge of .NET application data access patterns
  • Experience with Always On Availability Groups
  • Experience using Azure DevOps
  • Experience cleaning legacy data structures across multiple jurisdictions/counties
About 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.

About the Company

I

InterSources Inc.

It’s all about harnessing the real power of data. InterSources Inc was founded in 2007 providing intelligent data solutions to clients across industries and geographies.

Over the years, we have built products on Business Intelligence & Big Data platform simplifying and transforming the way business intelligence and real-time data analytics empower Corporations and end-users using Softwares like Tableau, Business Objects, MicroStrategy, etc.

In the process, we have enabled companies to use data analytics to help better understand, predict and influence consumer behavior, identify new market opportunities as they emerge, provide to users the data they need, alert the user when and why key business metrics have changed and enable them to make smart decisions.

COMPANY SIZE
100 to 499 employees
INDUSTRY
Computer/IT Services
FOUNDED
2007
WEBSITE
https://www.intersourcesinc.com/