Database SME

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: Database SME

Location(s): Fort Mill, SC

Job Description
We are seeking an experienced Database Subject Matter Expert (SME) with strong expertise in SQL Server performance tuning, optimization, and database administration. The ideal candidate will have hands-on experience in high-performance, application-driven environments and deep knowledge of SQL Server architecture and troubleshooting.

Key Responsibilities
Performance Tuning & Optimization

• T-SQL query analysis and performance optimization.
• Execution plan analysis and optimization using Query Store.
• Index statistics updates and index rebuild operations.
• Table and index partitioning functions.
• Database blocking analysis and impact assessment.
• Performance tuning of stored procedures and ad hoc SQL queries based on execution patterns.
• Experience working in an application development environment.

Database Administration

• Install, configure, and maintain Microsoft SQL Server (2016/2017/2019/2022).
• Apply patches, service packs, and cumulative updates (CUs).
• Database and volume space management.
• Monitor and maintain SQL Server performance, availability, and scalability.
• Troubleshoot CPU, RAM, disk space, and TempDB performance issues.
• Manage Always On Availability Groups.
• Replication configuration and support.
• SSIS jobs and SQL Agent job administration.
• Manage user roles, permissions, and database security.

Good to Have (Operational Knowledge)

• SolarWinds
• DPA (Database Performance Analyzer)
• Dynatrace (API-DB call tracing)

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.