Ripple Effect Consulting LLC

Backend Engineer

• Design, develop, maintain, and optimize complex Oracle PL/SQL systems that support critical business logic across mission-critical applications.
• Investigate and work within large legacy PL/SQL codebases to diagnose issues, interpret embedded business rules, refactor code for clarity, and improve long-term maintainability.
• Perform in-depth data exploration to understand data structures, relationships, irregularities, and edge cases to strengthen system design and improve data quality.
• Develop and optimize sophisticated SQL queries across large, highly relational datasets.
• Tune SQL and PL/SQL performance using tools such as execution plans, optimizer statistics, trace files, hints, and indexing strategies.
• Maintain the reliability, integrity, and scalability of database systems responsible for processing and transforming high volumes of data.
• Contribute to architectural planning, database design guidelines, and coding standards with a focus on scalability and performance.
• Work with Snowflake for data storage and synchronization while ensuring data consistency, accuracy, and performance across systems.
• Support and mentor junior engineers through code reviews, technical guidance, and the promotion of high coding standards.

Senior Database Developer, PL/SQL