Senior SQL Performance Engineer - Data & Optimizations

IFLOWSOFT Solutions Inc.; Florham Park (NJ); On-site; USD 120,000 - 180,000; Full time

Job summary

IFLOWSOFT Solutions Inc. seeks a Senior SQL Performance Engineer to design, optimize, and support enterprise SQL Server environments, focusing on performance tuning, SQL development, ETL/SSIS, and data integration.

The role is based in Florham Park, NJ with 3 days onsite. You will design queries, implement indexing and partitioning, ensure high availability, lead data migration projects, and enforce data governance and security.

Qualifications

• 8+ years of experience in SQL Server design, tuning, and performance optimization.
• Strong T-SQL skills and ability to optimize complex queries.
• Experience with SSIS/ETL development and data integration.
• Experience with high availability, backup/recovery, and security.

Responsibilities

• Design and develop complex SQL queries, stored procedures, views, and functions.
• Optimize SQL Server performance through query tuning, indexing, partitioning, and monitoring.
• Manage and support production SQL databases, ensuring high availability, reliability, and data integrity.
• Design and maintain scalable database schemas and data structures.
• Develop, support, and troubleshoot SSIS/ETL solutions for data migration, transformation, and integration.
• Implement database security, backup, recovery, replication, and disaster recovery strategies.
• Lead data migration and integration initiatives across multiple systems and platforms.
• Ensure data governance, quality, compliance, and reporting accuracy.
• Provide technical leadership and support for database management, reporting, and ERP integrations.

Skills

SQL Server

T-SQL

Query tuning

Performance monitoring

Database design

Indexing

Partitioning

SSIS/ETL

Data migration

Security/HA/Backup

AI tools familiarity

Tools

Copilot (Microsoft)

GitHub Copilot

Job description

IFLOWSOFT Solutions Inc. seeks a Senior SQL Performance Engineer to design, optimize, and support enterprise SQL Server environments, focusing on performance tuning, SQL development, ETL/SSIS, and data integration.

The role is based in Florham Park, NJ with 3 days onsite. You will design queries, implement indexing and partitioning, ensure high availability, lead data migration projects, and enforce data governance and security.