Senior DB2 & Snowflake Performance Engineer (Scala)

Kaltechsoft Inc; New York (NY); On-site; USD 120,000 - 170,000; Full time

Job summary

Kaltechsoft Inc in NYC is seeking a Database Performance Engineer for a 12-month engagement. The role demands deep DB2 expertise, strong SQL performance tuning, and experience refactoring stored procedures to improve efficiency.

You will also evaluate opportunities to port logic to Scala and work with Snowflake warehouses to optimize SQL patterns. The ideal candidate has hands-on DB2 development background and will spend 3 days on-site in NYC, collaborating with the local team to ensure robust,

Qualifications

• 8 years DB2 development experience.
• 6 years SQL performance tuning on DB2.
• 6 years DB2 stored procedure refactoring.
• 4 years Scala for rewriting stored procedures.
• 2 years Snowflake warehouses and Snowflake SQL tuning.

Responsibilities

• Tune DB2 SQL performance and optimize stored procedures.
• Refactor and rewrite stored procedures to Scala where applicable.
• Collaborate on Snowflake warehouse tuning and SQL optimization.
• Work with on-site team in NYC for 3 days per week.

Skills

DB2 expertise

SQL performance tuning

Stored procedures refactoring

Scala development

Snowflake familiarity

Tools

DB2 development environment

Snowflake

Job description

Kaltechsoft Inc in NYC is seeking a Database Performance Engineer for a 12-month engagement. The role demands deep DB2 expertise, strong SQL performance tuning, and experience refactoring stored procedures to improve efficiency.

You will also evaluate opportunities to port logic to Scala and work with Snowflake warehouses to optimize SQL patterns. The ideal candidate has hands-on DB2 development background and will spend 3 days on-site in NYC, collaborating with the local team to ensure robust,