Database Administrator

Intersources Inc.

Columbia, SC, United States

2 days ago

Apply on www.careerjet.com

Prepare application

Role details

Contract type

Temporary to permanent

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

3 years minimum

Compensation

$107,900.0 - $195,050.0

Working hours

Regular working hours

Job source

www.careerjet.com

Tech stack

.NET Framework Artificial Intelligence Data Analysis Microsoft Azure Big Data Cyber Security Information Technology Consulting Databases Custom Software Data Cleansing Data Integrity Extract Transform Load (ETL)

+24 more

Data Recovery Data Structures Data Warehousing Database Queries Database Security DevOps Web Development Disaster Recovery Design of User Interfaces Microsoft SQL Server Oracle (Applications) Performance Tuning Power BI Cloud Services Standard Sql Application Data Software Engineering SQL Stored Procedures Systems Integration Google Cloud Delivery Pipeline Backend Software Version Control Sql Database Administration

Job description

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

Requirements

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.