Database Performance Engineer

Location: New York, NY

Duration: 12 MonthsHybrid – 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.