Senior SQL & PostgreSQL Database Performance Engineer

The Intersect Group; Greenville (SC); On-site; USD 120,000 - 160,000; Full time

Job summary

The Intersect Group is seeking a Senior Database Administrator to own the administration, performance, availability, and ongoing improvement of SQL Server and PostgreSQL environments. This role combines database administration with development, performance engineering, automation, and technical leadership.

You will manage production databases, lead tuning and troubleshooting, support HA/DR strategies, and mentor teammates while establishing database standards and best practices within a

Qualifications

• 5+ years of hands-on database administration and development experience across both Microsoft SQL Server and PostgreSQL environments.
• Advanced experience with database performance tuning including execution plans, query optimization, indexing, statistics, blocking, deadlocks, and wait analysis
• Strong production troubleshooting experience involving database performance, integrity, replication, connectivity, security, backup, and recovery
• Hands on experience implementing and supporting high availability and disaster recovery solutions for SQL Server and PostgreSQL
• Experience developing, deploying, and troubleshooting SSIS packages and designing and maintaining SSRS reports
• Experience automating database and operational tasks using PowerShell, T SQL, Python, Bash, or similar scripting technologies
• Experience with Git or GitHub, source control practices, and the software development lifecycle
• Strong communication, prioritization, and problem solving skills with the ability to mentor team members and communicate effectively with both technical and nontechnical stakeholders

Responsibilities

• Administer and support Microsoft SQL Server and PostgreSQL environments, including security, access, backup, recovery, patching, upgrades, and capacity planning
• Manage high availability and disaster recovery solutions including Always On Availability Groups, log shipping, PostgreSQL streaming replication, and failover strategies
• Lead database performance tuning using execution plans, indexing, statistics, wait analysis, query optimization, Query Store, DMVs, EXPLAIN ANALYZE, and related diagnostic tools
• Troubleshoot production database performance, integrity, replication, connectivity, and security issues while performing root cause analysis to prevent recurring problems
• Design, develop, review, and optimize stored procedures, functions, views, triggers, tables, indexes, partitions, constraints, and other database components
• Develop, deploy, and support SSIS packages, SQL Agent jobs, SSRS reports, and automated operational processes
• Partner with technical and business stakeholders to translate requirements and change requests into reliable and scalable database solutions
• Mentor database administrators and developers while establishing standards for database development, performance, reliability, and operational support

Skills

SQL Server

PostgreSQL

Performance tuning

High availability

Troubleshooting

Scripting

PowerShell

T-SQL

Python

Git

Mentoring

Communication

Education

Bachelor's degree

Tools

SSIS

SSRS

SSMS

Redgate

Idera

GitHub

Job description

The Intersect Group is seeking a Senior Database Administrator to own the administration, performance, availability, and ongoing improvement of SQL Server and PostgreSQL environments. This role combines database administration with development, performance engineering, automation, and technical leadership.

You will manage production databases, lead tuning and troubleshooting, support HA/DR strategies, and mentor teammates while establishing database standards and best practices within a