Senior PL/SQL Developer

RIPPLE EFFECT CONSULTING LLC

Senior PL/SQL Developer

Boulder, CO
Full Time
Paid
  • Responsibilities

    Benefits:

    401(k) matching

    Dental insurance

    Health insurance

    Paid time off

    Vision insurance

    Senior Database Developer

    Join the Market Leader in Electric Power Data and Analytics Solutions

    The electrical grid is the largest and most complex machine ever constructed. Ripple Effect Consulting’s industry-leading electric power trading analytics platform provides real-time insight into the enormous amount of data produced daily by the North American power grid. Our innovative perspective on this data helps guide both real-time trading strategies and long-term investment decisions that help keep utility costs low, support the energy transition, and ensure the reliability of the grid. The work is challenging, meaningful, and impactful.

    Join our successful and growing organization as we continue to expand and transform internationally.

    Position Summary

    As a Senior Database Developer on the Engineering Team, you will utilize your analytical and technical expertise across several key areas including designing and developing services for our commercial software products, enhancing database architecture and frameworks, and supporting database development for internal applications and automated software testing initiatives.

    This role provides an opportunity to deepen your knowledge of energy markets, cloud-based software platforms, and SaaS business models while continuing to develop your technical skills alongside one of the most innovative and dedicated teams in the industry.

    Position Details

    Salary Range: $130,000 – $160,000 (depending on experience)

    Location: Boulder, CO

    Employment Type: Full-Time

    Work Arrangement: Hybrid

    Reports To: Engineering Manager

    Primary Responsibilities

    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.

    Minimum Qualifications

    Bachelor’s degree in Computer Science or equivalent hands-on experience

    6+ years of experience developing Oracle PL/SQL (or similar procedural database technologies) in production environments

    Strong SQL expertise, including writing and optimizing queries across large relational datasets

    Experience analyzing and improving complex legacy database code

    Demonstrated ability to diagnose, tune, and optimize database performance

    Experience working with data-intensive systems

    Strong analytical thinking and problem-solving abilities

    Ability to collaborate effectively within Agile, cross-functional teams

    Preferred Qualifications

    Experience with Snowflake or similar cloud data warehouse technologies

    Familiarity with database change management tools such as Liquibase

    Experience working in SaaS or cloud-based environments

    Experience mentoring developers or performing code reviews

    Exposure to energy markets, commodities trading, or financial data systems

    At Ripple Effect Consulting, we prefer to engage directly with candidates. We kindly request that third-party recruiters and agencies refrain from submitting resumes, as we are not currently pursuing external recruiting partnerships.

    About Ripple Effect Consulting

    Overview

    Ripple Effect Consulting provides real-time market data and analytics solutions that support electric power trading decisions. More than 1,000 market participants rely on our solutions each day. The company is recognized as a leader in gathering, managing, and delivering high-quality information and market analytics.

    Since its founding in 2008, Ripple Effect Consulting has built a strong reputation as a trusted provider of innovative and reliable tools tailored to the needs of power market analysts, traders, and trading managers.

    Our global team includes more than 300 professionals across offices in:

    Boulder, CO (Headquarters)

    Boston, MA

    Chicago, IL

    Glendora, CA

    Richmond, VA

    London, United Kingdom

    Auckland, New Zealand

    Bucharest, Romania

    Culture

    Ripple Effect Consulting has been recognized as one of the Best Places to Work in Colorado, and our workplace culture reflects that recognition.

    Our team is committed to saying “yes” to customers. We prioritize listening, learning, and building solutions aligned with our customers’ evolving needs. We view our customers as partners, and when they succeed, we succeed.

    Our culture is shaped by several core values:

    We embrace innovation and enjoy solving complex challenges.

    We maintain high standards, combining passion and pride with hard work and meaningful rewards.

    We operate with a collaborative, team-first mindset and a flat organizational structure, working in small teams on clearly defined projects that directly impact business success.

    We leverage the strengths and expertise of each team member while encouraging cross-functional growth and learning.

    We believe in continuous growth, with professional development happening every day and every year.

    Compensation and Benefits

    Ripple Effect Consulting offers highly competitive compensation packages, including performance-based bonuses that employees can directly influence. Our benefits package includes:

    Comprehensive medical insurance

    401(k) plan with company matching

    Flexible vacation policy

    Flexible work schedules

    Support and funding for both formal and informal professional development opportunities

    Ripple Effect Consulting is committed to building a diverse, inclusive, and authentic workplace. If you’re excited about this opportunity but your background does not perfectly match every qualification listed, we still encourage you to apply. You may be a great fit for this role or another opportunity within our organization.

    In accordance with Colorado law, the salary range listed reflects Ripple Effect Consulting’s reasonable estimate for the base compensation of this role. Actual compensation may vary based on factors such as location, experience, skills, and knowledge.

    Equal Opportunity Employer

    Ripple Effect Consulting provides equal employment opportunities (EEO) to all employees and applicants without regard to race, color, religion, sex, national origin, age, disability, or genetic information. In addition to federal requirements, Ripple Effect Consulting complies with all applicable state and local laws governing nondiscrimination in employment across every location in which the company operates.

    This policy applies to all aspects of employment, including recruitment, hiring, placement, promotion, termination, layoff, recall, transfer, leave of absence, compensation, and training.