SQL Database Performance Engineer - W2, Sponsorship OK

Mindlance; Dallas (TX); On-site; USD 120,000 - 150,000; Full time

Job summary

Mindlance is seeking a Core Database skillset specialist focused on SQL Server and PostgreSQL to optimize queries, tune indexes, and ensure database health. This role emphasizes performance and scalability within a dynamic environment.

The successful candidate will analyze complex queries, implement partitioning for large datasets, and collaborate with software engineers to resolve DB issues while improving overall efficiency and reliability.

Qualifications

• Strong experience in SQL query optimization and database performance tuning.
• Expertise in index design, missing index analysis, and execution plan analysis.
• Experience tuning stored procedures and optimizing database workloads.
• Knowledge of table partitioning strategies and large-scale database performance optimization.
• Strong understanding of database monitoring, contention analysis, CPU and memory utilization.
• Ability to collaborate closely with software engineers to resolve database-related application issues.
• Strong analytical and problem-solving skills with a proactive approach to performance optimization.

Responsibilities

• Analyze and optimize complex SQL queries for maximum performance and scalability.
• Design, evaluate, and maintain effective indexing strategies, including identifying and resolving missing or inefficient indexes.
• Tune and optimize stored procedures, functions, and database objects.
• Implement and maintain table partitioning strategies for large datasets.
• Investigate and resolve database performance bottlenecks, blocking, locking, and contention issues.
• Partner with application development teams to troubleshoot database-related issues and improve application performance.
• Evaluate how application changes impact database performance and recommend optimization strategies.
• Perform root cause analysis for production database performance issues and implement long-term solutions.
• Continuously monitor and improve overall database efficiency and reliability.

Skills

SQL query optimization

database performance tuning

index design

execution plan analysis

partitioning strategies

database monitoring

Tools

SQL Server

PostgreSQL

Job description

Mindlance is seeking a Core Database skillset specialist focused on SQL Server and PostgreSQL to optimize queries, tune indexes, and ensure database health. This role emphasizes performance and scalability within a dynamic environment.

The successful candidate will analyze complex queries, implement partitioning for large datasets, and collaborate with software engineers to resolve DB issues while improving overall efficiency and reliability.