Job Description
Database Performance Engineer
\n
Location: New York, NY
\n
Duration: 12 Months
\n
Hybrid – 3 Days Onsite Mandatory
\n
\n
Job Overview
\n
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.
\n
\n
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.
\n
\n
Key Responsibilities
\n
- \n
- 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.
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
Required Qualifications
\n
- \n
- 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.
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
Onsite Requirement: Candidates must be willing to work 3 days onsite in New York City, NY.