Ampcus inc

SQL DBA

Ampcus inc • $90K — $120K *
Fort Mill, SC 29708In-Person
Information Technology
5 - 7 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • 6+ years of Microsoft SQL Server DBA experience
  • Strong troubleshooting and database performance tuning skills
  • Experience supporting production-critical SQL Server environments
  • Knowledge of SQL Server High Availability (Always On AG)
  • Solid understanding of indexing, execution plans, Query Store, and T-SQL optimization

Responsibilities

  • Install, configure, and maintain SQL Server environments
  • Monitor database health, availability, and performance
  • Optimize T-SQL queries, stored procedures, and ad-hoc SQL
  • Analyze execution plans and implement Query Store recommendations
  • Manage indexes, statistics, and partitioning strategies
  • Administer Always On Availability Groups and Replication
  • Work closely with application development teams to resolve database-related issues

Benefits

  • Dynamic work environment in Fort Mill, SC
  • Opportunities for career advancement
  • Collaboration with a skilled team
  • Access to advanced database performance tools
  • Engagement with cutting-edge technologies in SQL Server
Full Job Description
Job Title: SQL DBA

Location(s): Fort Mill, SC

Primary Skills:
  • Microsoft SQL Server 2016/2017/2019/2022 Administration
  • T-SQL Query Analysis and Performance Tuning
  • SQL Query Optimization
  • Execution Plan Analysis
  • Query Store
  • Stored Procedure Performance Tuning
  • Ad-hoc SQL Performance Optimization
  • Index Design and Optimization
  • Index Rebuild and Reorganization
  • Statistics Update
  • Table and Index Partitioning
  • Database Blocking Analysis
  • SQL Server Monitoring
  • Database Troubleshooting
  • Database Performance, Availability, and Scalability
  • Always On Availability Groups
  • SQL Server Replication
  • TempDB Performance Optimization
  • CPU, Memory (RAM), and Disk Performance Monitoring
  • Database Space and Volume Management
  • SQL Server Installation and Configuration
  • SQL Server Patch Management (Service Packs, Cumulative Updates)
  • SQL Agent Jobs Administration
  • SSIS Administration
  • Database Security
  • User Roles and Permissions

Required Experience:
  • Strong experience with SQL Server Administration
  • Experience in SQL Performance Tuning
  • Experience analyzing execution plans and using Query Store
  • Experience working with application development teams
  • Experience troubleshooting production database environments
  • Experience with high availability and disaster recovery (Always On AG)
  • Experience with Replication
  • Experience managing enterprise SQL Server environments

Good to Have:
  • SolarWinds
  • SolarWinds Database Performance Analyzer (DPA)
  • Dynatrace
  • API-to-Database call tracing
  • Performance monitoring tools

Key Responsibilities:
  • Install, configure, and maintain SQL Server environments.
  • Monitor database health, availability, and performance.
  • Optimize T-SQL queries, stored procedures, and ad-hoc SQL.
  • Analyze execution plans and implement Query Store recommendations.
  • Manage indexes, statistics, and partitioning strategies.
  • Perform blocking analysis and resolve performance bottlenecks.
  • Administer Always On Availability Groups and Replication.
  • Manage SQL Agent and SSIS jobs.
  • Apply SQL Server patches, Cumulative Updates, and Service Packs.
  • Monitor CPU, memory, disk utilization, and TempDB performance.
  • Manage database security, user roles, and permissions.
  • Work closely with application development teams to resolve database-related issues.
  • Ensure database capacity planning and storage management.

Ideal Candidate Profile:
  • 6+ years of Microsoft SQL Server DBA experience (estimated based on the technologies listed)
  • Strong troubleshooting and database performance tuning skills
  • Experience supporting production-critical SQL Server environments
  • Knowledge of SQL Server High Availability (Always On AG)
  • Strong understanding of indexing, execution plans, Query Store, and T-SQL optimization
  • Experience collaborating with application development teams
  • Familiarity with enterprise monitoring tools such as SolarWinds DPA and Dynatrace is an advantage.

About Ampcus inc

Learn more about Ampcus inc
Industry
Technical Services
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Ampcus inc

  • Ampcus inc
    Enterprise Architect
    $130K — $180K *
    Remote
    Reposted Today
    Enterprise Technology
    Remote in Chicago, IL
  • Ampcus inc
    Enterprise Architect
    $120K — $160K *
    Chicago, IL 60629 (Cook County)
    Reposted Today
    Enterprise Technology
    In-Person
  • Ampcus inc
    SQL DBA
    $90K — $120K *
    Fort Mill, SC 29708 (York County)
    Today
    Information Technology
    In-Person
  • Ampcus inc
    ServiceNow FSM BA - FSM Implementation
    $90K — $120K *
    Remote
    Yesterday
    Information Technology
    Remote in Vienna, VA
  • Ampcus inc
    Business Analyst 4
    $85K — $110K *
    Richmond, VA 23223 (Richmond City County)
    Yesterday
    Enterprise Technology
    In-Person

More Information Technology Jobs

Find similar SQL DBA jobs:

NationwideFort Mill, SC