Database Performance Engineer

Database Performance Engineer

Location: New York, NY

Duration: 12 Months

Hybrid – 3 Days Onsite Mandatory

Job Overview

We are looking for a Database Performance Engineer with deep DB2 development and SQL performance tuning experience, along with strong Scala development skills and hands-on Snowflake experience.

This is not a traditional DB2 DBA/maintenance role . We are looking for a data/database engineer who can analyze complex database issues, develop and optimize DB2 SQL and stored procedures, and identify opportunities to move database logic into Scala.

Key Responsibilities

• Develop, optimize, and troubleshoot complex DB2 SQL and database solutions.
• Perform deep SQL performance tuning on DB2 databases.
• Analyze database performance issues and approach problems with a DBA mindset.
• Develop, refactor, and optimize DB2 stored procedures .
• Identify stored procedures and business logic that can be extracted from DB2 and implemented in Scala or a similar programming language.
• Rewrite existing stored-procedure logic using Scala where appropriate.
• Work with Snowflake warehouses and Snowflake SQL , including query performance tuning.
• Collaborate with data engineering and application teams to improve database performance and overall system efficiency.

Required Qualifications

• 8+ years of DB2 development experience , with strong hands-on SQL development skills.
• 6+ years of DB2 SQL performance tuning experience.
• 6+ years of experience developing and refactoring DB2 stored procedures .
• 4+ years of Scala development experience .
• Experience extracting/re-engineering database stored-procedure logic into Scala or a similar programming language.
• 2+ years of hands-on Snowflake experience .
• Strong understanding of Snowflake warehouses and Snowflake SQL performance tuning .
• Strong analytical and problem-solving skills.
• Ability to troubleshoot complex database issues and think beyond routine database maintenance.

Onsite Requirement: Candidates must be willing to work 3 days onsite in New York City, NY .