Database Performance Engineer

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., * 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.

• 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.