1

Database Automation Engineer Jobs in South Carolina

SQL Database Administrator

Columbia, SC · On-site

$46.25 - $57.75/hr

Manage contained users, authentication models, and database-level security. * Configure and monitor ... Automation & DevOps Support Experience in judicial, government, or public sector environments Power ...

THIS ENGINEER WILL BE EXPECTED TO PROVIDE SUPPORT FOR THIS INITIATIVE. IN ADDITION, THIS POSITION ... SQL Server o Setup and maintain data replication and mirroring o Configure maintenance automation o ...

THIS ENGINEER WILL BE EXPECTED TO PROVIDE SUPPORT FOR THIS INITIATIVE. IN ADDITION, THIS POSITION ... SQL Server o Setup and maintain data replication and mirroring o Configure maintenance automation o ...

Programmer III

Fort Mill, SC · On-site

$120 - $140/hr

... database, and hardware communication issues. · Apply operational technology cybersecurity principles to protect critical infrastructure and automation systems. · Lead programming activities during ...

Sr. Controls Engineer - PLC

Trenton, SC · On-site

$105K - $139K/yr

Responsibilities include automation controls systems design, PLC/SCADA programming, simulation and ... Experience with SQL Server databases. * Experience successfully managing technical projects through ...

Showing results 21-40

Database Automation Engineer information

What is a database automation engineer?

Database Automation Engineers are IT professionals who design, implement, and manage automated processes to streamline database operations. Their primary goal is to reduce manual intervention by leveraging scripting, tools, and technologies such as DevOps pipelines, configuration management, and monitoring solutions. They ensure databases are efficiently deployed, maintained, and monitored for performance and reliability, often collaborating with database administrators and development teams. This role requires a strong understanding of database systems, automation tools, and programming languages.

What are the key skills and qualifications needed to thrive as a database automation engineer?

To thrive as a Database Automation Engineer, you need expertise in database management, scripting languages (such as Python or PowerShell), and a solid understanding of automation processes, often supported by a degree in computer science or a related field. Familiarity with database platforms (like MySQL, SQL Server, or Oracle), automation tools (such as Ansible or Jenkins), and certifications like Microsoft Certified: Azure Database Administrator Associate are typically beneficial. Strong problem-solving skills, attention to detail, and effective communication set top performers apart in this role. These skills are crucial for ensuring efficient, reliable, and scalable database operations in complex, data-driven environments.

How does a database automation engineer typically collaborate with development and operations teams?

Database Automation Engineers work closely with both development and operations teams to streamline database deployment, management, and monitoring. They often design automated workflows for database provisioning, backups, and updates, ensuring that developers have reliable access to data while minimizing downtime. Collaboration includes participating in DevOps initiatives, supporting CI/CD pipelines, and troubleshooting performance issues alongside other team members. This cross-functional teamwork helps maintain database reliability and supports rapid delivery cycles.

What is the difference between Database Automation Engineer vs Database Administrator?

AspectDatabase Automation EngineerDatabase Administrator
Primary FocusDevelops automation scripts and tools to streamline database processesManages, maintains, and secures databases manually
Skills & CertificationsSQL, scripting, automation tools, certifications like Oracle or Microsoft SQL ServerDatabase management, backup, recovery, certifications like Oracle DBA or Microsoft Certified Database Administrator
Work EnvironmentOften works in DevOps, software development, or IT automation teamsTypically in IT operations, data management teams

While both roles require strong SQL knowledge and certifications, the Database Automation Engineer focuses on creating automated solutions to improve database efficiency, whereas the Database Administrator handles the day-to-day management and security of databases. Understanding these differences helps organizations assign the right skills to optimize database performance and reliability.

What are popular job titles related to Database Automation Engineer jobs in South Carolina?

For Database Automation Engineer jobs in South Carolina, the most frequently searched job titles are:

What job categories do people searching Database Automation Engineer jobs in South Carolina look for?

The top searched job categories for Database Automation Engineer jobs in South Carolina are:

What cities in South Carolina are hiring for Database Automation Engineer jobs?

Cities in South Carolina with the most Database Automation Engineer job openings:

SQL Database Administrator

Software People, Inc.

Columbia, SC • On-site

$46.25 - $57.75/hr

Contractor

Re-posted 12 days ago


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