Job opportunity Senior SQL Performance Engineer/ Capital Management Client/ Florham Park - Hybrid 3 days

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

Position Title: Senior SQL Performance Engineer

Client: Capital Management Client

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.