SQL PERFORMANCE ENGINEER

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

Job summary

Iflowsoft Solutions inc in Florham Park, NJ, seeks a Senior SQL Performance Engineer to design, optimize, and support enterprise SQL Server environments with a focus on performance tuning and data integration. You will implement SSIS/ETL processes, bolster security, and ensure data integrity across production systems.

The ideal candidate has 8-10 years of relevant experience, deep SQL Server/T-SQL expertise, and proven ability to lead complex migrations and ERP integrations.

Qualifications

• Strong SQL Server and T-SQL expertise.
• SQL performance tuning and production monitoring.
• Database design, indexing, and partitioning.
• SSIS/ETL development and data integration.
• Data security, backup/recovery, and high-availability solutions.

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.
• 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

Database design

High availability

Security

Tools

SSIS

ETL development

Job description

Position Title: Senior SQL Performance Engineer

Location - Florham Park NJ - 3 days onsite

Duration - 1 year

Ideally Candidate must have 8-10 years of experience

Senior SQL Performance Engineer - Summary

Seeking an experienced Senior SQL Performance Engineer to design, optimize, and support enterprise SQL Server environments. The role focuses on database performance tuning, SQL development, ETL/SSIS solutions, production support, database security, and data integration.

Key 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.

Required Skills

• Strong SQL Server and T-SQL expertise.
• SQL performance tuning and production monitoring.
• Database design, indexing, and partitioning.
• SSIS and ETL development.
• Data migration, integration, and troubleshooting.
• Database security, backup/recovery, and high-availability solutions.

Preferred

• Experience with SQL Server, reporting tools, or cloud data platforms.
• Exposure to AI-assisted tools such as Microsoft Copilot, GitHub Copilot, or similar AI technologies.

Iflowsoft Solutions inc is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law. We promote and support a diverse workforce at all levels in the company. This is not an unsolicited mail and if it is not intended for you or you are not interested in receiving our e-mails, you may unsubscribe