Role: Not specified

Job Summary

The candidate will be responsible for designing, developing, and maintaining high-performance SQL and PL/SQL procedures, packages, and functions using cloud database technologies such as Snowflake. This role requires applying advanced performance tuning techniques, understanding and implementing business requirements via agile methodologies, and providing technical support throughout all phases of the software delivery lifecycle. The role plays a critical part in optimizing database performance, supporting automated ETL/ELT processes, and contributing to cloud modernization initiatives.

Responsibilities

• Design and Development: Create and maintain high-performance SQL and PL/SQL procedures, packages, and functions in Snowflake or other cloud-based databases.
• Performance Tuning: Apply advanced techniques to optimize database objects, queries, indexing strategies, and overall resource usage.
• Agile Development: Develop code based on business and functional requirements while following the agile process.
• Quality Assurance: Produce high-quality code that meets project deadlines and accurately reflects requirement specifications.
• Issue Resolution: Analyze and resolve issues identified during testing or pre-production, coordinating with cross-functional teams to ensure smooth delivery.
• Technical Support: Provide ongoing technical support to project teams and respond to inquiries regarding errors or program functionality.
• Process Improvement: Suggest and implement improvements for estimating, development, and testing processes, as well as for automated ETL/ELT and data transformation workflows.
• Cloud Migration: Support initiatives aimed at migrating legacy database objects to cloud-native platforms by re-platforming or refactoring as necessary.

Qualifications

• Technical Expertise:
  • Proficient in T-SQL, Microsoft SQL Server, SQL Server management, and Oracle PL/SQL.
  • Proven experience in writing and optimizing complex stored procedures, functions, and packages for relational databases (e.g., Oracle, MySQL, SQL Server).
  • Strong performance tuning skills, including query optimization, indexing, execution plans, and partitioning.
• Development Skills:
  • Solid understanding of software development principles, design patterns, and best practices.
  • Experience with ETL/ELT processes, data integration pipelines, and batch processing techniques.
• Educational Background: BS Degree in Computer Science, Information Technology, Electrical/Electronic Engineering, or a related field (or equivalent experience).
• Experience: A minimum of 7 years of experience working in an application and database development environment, demonstrating a track record of delivering systems and projects from inception through implementation.
• Soft Skills: Ability to work collaboratively with architects, technical leads, team members, and project managers. Strong analytical and problem-solving skills.

Preferred Skills

• Familiarity with Snowflake and cloud database technologies.
• Experience with Python scripting and data transformation frameworks like dbt.
• Background in developing web applications using Java, JavaScript, HTML, and JSP.
• Exposure to MVC frameworks such as Spring and Angular.

Experience

• A minimum of 7 years of relevant work experience in application and database development organizations, with deep expertise in Oracle PL/SQL or SQL Server T-SQL.

Environment

• The work environment details such as location, remote/in-office/hybrid settings, and other physical or environmental specifics are not specified.