1

Database Analyst Jobs in Irmo, SC (NOW HIRING)

SQL Database Administrator

Columbia, SC · On-site

$46.25 - $57.75/hr

Analyze and tune: o Stored procedures o Dynamic SQL o Cross-database queries o CTE-heavy workloads o Index fragmentation and statistics * Review and optimize ETL loops across multiple CMS databases.

MO8.21-DBA 7901

West Columbia, SC · On-site

$38.25 - $52/hr

NA. The DBA will be responsible for using data modeling tools on ORACLE and MS SQL databases ... Collaborating with data architects, DBAs, developers, and business analysts to translate business ...

IN ADDITION DMV IS IMPLEMENTING HIGH AVAILABILITY SOLUTIONS ON A NUMBER OF THE SYSTEMS SUPPORTED BY THESE DATABASES AND INCREASING OUR USE OF REPORTING SERVICES AND ANALYSIS SERVICES IMPLEMENTED IN A ...

Oracle DBA - Project Lead

Columbia, SC · On-site

$47 - $63.75/hr

Candidate will be working in a team environment consisting of 5 database engineers and administrators and working directly with application developers, business analysts, and server support team.

Oracle DBA-Team Lead

Blythewood, SC · On-site

$40.50 - $55/hr

CANDIDATE WILL BE WORKING IN A TEAM ENVIRONMENT CONSISTING OF 5 DATABASE ENGINEERS AND ADMINISTRATORS AND WORKING DIRECTLY WITH APPLICATION DEVELOPERS, BUSINEE ANALYSTS, AND SERVER SUPPORT TEAM.

Showing results 21-40

Database Analyst information

See Irmo, SC salary details

$27.8K

$67.5K

$111.1K

How much do database analyst jobs pay per year?

As of Aug 23, 2026, the average yearly pay for database analyst in Irmo, SC is $67,480.00, according to ZipRecruiter salary data. Most workers in this role earn between $51,000.00 and $79,200.00 per year, depending on experience, location, and employer.

What is a database analyst?

Database Analysts are professionals responsible for designing, maintaining, and optimizing databases to ensure data is efficiently stored, accessed, and secured. They analyze data needs, troubleshoot database issues, and work with other IT staff to improve data management systems. Their role often includes developing queries, generating reports, and ensuring data integrity, which helps organizations make informed business decisions.

What are some common challenges database analysts face when working with large-scale databases?

Database Analysts working with large-scale databases often encounter challenges such as optimizing query performance, ensuring data integrity, and managing efficient data migration. They must constantly monitor database health and proactively address issues like slow queries or data bottlenecks. Collaborating closely with developers and IT teams is crucial to implement best practices for backup, security, and scalability as organizational data needs grow.

What are the key skills and qualifications needed to thrive as a database analyst, and why are they important?

To thrive as a Database Analyst, you need strong analytical abilities, proficiency in database design and management, and a relevant degree in computer science or information systems. Familiarity with SQL, database management systems (such as Oracle, MySQL, or Microsoft SQL Server), and sometimes certifications like Microsoft Certified: Azure Data Fundamentals are typically required. Attention to detail, problem-solving skills, and effective communication help analysts interpret data needs and collaborate with stakeholders. These competencies ensure accurate data management, robust system performance, and the translation of business requirements into actionable database solutions.

What does a database analyst do?

A database analyst is responsible for designing, maintaining, and analyzing databases to ensure data accuracy, security, and efficiency. They often use tools like SQL and data management systems, and may work closely with IT teams to optimize data storage and retrieval processes.
More about Database Analyst jobs

What cities near Irmo, SC are hiring for Database Analyst jobs?

Cities near Irmo, SC with the most Database Analyst job openings:

Infographic showing various Database Analyst job openings in Irmo, SC as of August 2026, with employment types broken down into 56% Full Time, 13% Part Time, 6% Temporary, and 25% Contract. Highlights an 88% In-person, 6% Hybrid, and 6% Remote job distribution, with an average salary of $67,480 per year, or $32.4 per hour.

SQL Database Administrator

Software People, Inc.

Columbia, SC • On-site

$46.25 - $57.75/hr

Contractor

Re-posted yesterday


Job description

Phone/Skype Hire. Onsite from day 1. Only SC residents

Location: Columbia, SC

Duration: 12+ months

Responsibilities

•             Working on SQL Server (v 2016+)

•             Administer and maintain SQL Server instances across multiple judicial environments.

•             Manage contained users, authentication models, and database-level security.

•             Configure and monitor SQL Agent jobs, maintenance plans, and index strategies.

•             Implement and validate backup/restore procedures and disaster recovery plans.

•             Support high availability configurations (Always On, clustering where applicable).

•             Optimize large-scale tables supporting court case data.

•             Analyze and tune:

o             Stored procedures

o             Dynamic SQL

o             Cross-database queries

o             CTE-heavy workloads

o             Index fragmentation and statistics

•             Review and optimize ETL loops across multiple CMS databases.

•             Reduce blocking, deadlocks, and long-running transactions.

•             Implement partitioning strategies where appropriate.

•             Assist with:

o             Referential integrity enforcement

o             Foreign key reconciliation

o             Identity reseeding

o             Data remediation & cleanup

•             Support statewide standardization of:

o             County codes

o             Circuit mappings

o             Court type alignment

o             Roster type consistency

•             Ensure alignment with the Chief Justice’s data initiative and reporting aggregation standards.

•             Optimize fact/dimension loading processes

•             Support performance tuning for Power BI reporting back-end queries.

•             Assist with:

o             Indexed views

o             Aggregation tables

o             Incremental load strategies

•             Collaborate on data quality validation routines.

•             Harden SQL Server instances against unauthorized access.

•             Review role-based security for judicial data.

•             Ensure compliance with:

o             Judicial confidentiality standards

o             CJIS considerations (where applicable)

•             Monitor audit logs and security events.

•             Support WAF/SQL visibility requirements for secure application traffic.

o             Imperva or similar security appliances

•             Assist in scripting deployment pipelines for:

o             Schema changes

o             Stored procedure deployments

o             Data migration scripts

•             Support version control integration.

•             Create reusable administrative scripts for:

o             Multi-database updates

o             Password rotation

o             Security audits

o             Cross-environment validation

Skills Needed

7+ years of experience with SQL Database Administration & Operations

3+ years of experience with Performance Tuning & Optimization

3+ years of experience with Data Integrity & Governance Support

3+ years of experience with Data Warehouse Architecture & Reporting Support

3+ years of experience with Security & Compliance

3+ years of experience with Automation & DevOps Support

Experience in judicial, government, or public sector environments

Power BI backend optimization

.NET application data access patterns

Always On Availability Groups

Azure DevOps

Experience cleaning legacy data structures across multiple counties or jurisdictions