Database Performance Engineer

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

Position: Database Performance Engineer

Location: NYC, NY( 3 days onsite is must)

Duration: 12 Months

They need a person who not a database maintenance guy but a data engineer with deep DB2 and good Snowflake experience. Here is what we are looking for:

• DB2 database expertise and DB2 development experience not a DB2 maintenance person (8 years)
• Ability to think through issues like a DBA
• Deep experience in SQL performance tuning experience on DB2 (6 years)
• Understanding, developing and refactoring stored procedures on DB2 to DB2 SQL (6 years)
• Identifying stored procedures that can be extracted and programmed in Scala or a similar programming language (4 years)
• Exposure and hands-on understanding of Snowflake warehouses and Snowflake SQL tuning (2 years)
• Scala development to re-write existing Stored Procedures in Scala (4 years)

Thanks & Regards