{"schemaVersion":"jobsearcher.job.v1","id":"dd7cae0adde4c0edb22111e8","url":"https://jobsearcher.com/jobs/dd7cae0adde4c0edb22111e8","canonicalUrl":"https://jobsearcher.com/jobs/dd7cae0adde4c0edb22111e8","title":"Senior Database Developer (PL/SQL)","description":"Senior Database Developer\r\nJoin the Market Leader in Electric Power Data and Analytics Solutions\r\nThe 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.\r\nJoin our successful and growing organization as we continue to expand and transform internationally.\r\nPosition Summary\r\nAs 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.\r\nThis 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.\r\nPosition Details\r\nSalary Range: $130,000 – $160,000 (depending on experience)\r\nLocation: Boulder, CO., Chicago, IL., Boston, MA., or Richmond, VA.\r\nEmployment Type: Full-Time | No C2C at this time. GC or USC\r\nWork Arrangement: Hybrid | 1-2 times/week in office\r\nReports To: Engineering Manager\r\nPrimary Responsibilities\r\nDesign, develop, maintain, and optimize complex Oracle PL/SQL systems that support critical business logic across mission-critical applications.\r\nInvestigate and work within large legacy PL/SQL codebases to diagnose issues, interpret embedded business rules, refactor code for clarity, and improve long-term maintainability.\r\nPerform in-depth data exploration to understand data structures, relationships, irregularities, and edge cases to strengthen system design and improve data quality.\r\nDevelop and optimize sophisticated SQL queries across large, highly relational datasets.\r\nTune SQL and PL/SQL performance using tools such as execution plans, optimizer statistics, trace files, hints, and indexing strategies.\r\nMaintain the reliability, integrity, and scalability of database systems responsible for processing and transforming high volumes of data.\r\nContribute to architectural planning, database design guidelines, and coding standards with a focus on scalability and performance.\r\nWork with Snowflake for data storage and synchronization while ensuring data consistency, accuracy, and performance across systems.\r\nSupport and mentor junior engineers through code reviews, technical guidance, and the promotion of high coding standards.\r\nMinimum Qualifications\r\nBachelor's degree in Computer Science or equivalent hands-on experience\r\n6+ years of experience developing Oracle PL/SQL (or similar procedural database technologies) in production environments\r\nStrong SQL expertise, including writing and optimizing queries across large relational datasets\r\nExperience analyzing and improving complex legacy database code\r\nDemonstrated ability to diagnose, tune, and optimize database performance\r\nPreferred Qualifications\r\nExperience with Snowflake or similar cloud data warehouse technologies\r\nFamiliarity with database change management tools such as Liquibase\r\nExperience working in SaaS or cloud-based environments\r\nExperience mentoring developers or performing code reviews\r\nExposure to energy markets, commodities trading, or financial data systems\r\nSalary: Up to $160k/annual DOE + Benefits (Medical, Dental, Vision, PTO, 401K)\r\nJ-18808-Ljbffr","company":"Ripple Effect Consulting","rawCompany":"ripple effect consulting","city":"Boulder","state":"CO","isRemote":false,"isActive":false,"createdAt":"2026-04-12T05:08:03.667Z","occupations":[{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"}],"industries":[{"code":"513210","title":"Software Publishers","slug":"software-publishers"},{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Senior Database Developer (PL/SQL)","description":"Senior Database Developer\r\nJoin the Market Leader in Electric Power Data and Analytics Solutions\r\nThe 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.\r\nJoin our successful and growing organization as we continue to expand and transform internationally.\r\nPosition Summary\r\nAs 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.\r\nThis 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.\r\nPosition Details\r\nSalary Range: $130,000 – $160,000 (depending on experience)\r\nLocation: Boulder, CO., Chicago, IL., Boston, MA., or Richmond, VA.\r\nEmployment Type: Full-Time | No C2C at this time. GC or USC\r\nWork Arrangement: Hybrid | 1-2 times/week in office\r\nReports To: Engineering Manager\r\nPrimary Responsibilities\r\nDesign, develop, maintain, and optimize complex Oracle PL/SQL systems that support critical business logic across mission-critical applications.\r\nInvestigate and work within large legacy PL/SQL codebases to diagnose issues, interpret embedded business rules, refactor code for clarity, and improve long-term maintainability.\r\nPerform in-depth data exploration to understand data structures, relationships, irregularities, and edge cases to strengthen system design and improve data quality.\r\nDevelop and optimize sophisticated SQL queries across large, highly relational datasets.\r\nTune SQL and PL/SQL performance using tools such as execution plans, optimizer statistics, trace files, hints, and indexing strategies.\r\nMaintain the reliability, integrity, and scalability of database systems responsible for processing and transforming high volumes of data.\r\nContribute to architectural planning, database design guidelines, and coding standards with a focus on scalability and performance.\r\nWork with Snowflake for data storage and synchronization while ensuring data consistency, accuracy, and performance across systems.\r\nSupport and mentor junior engineers through code reviews, technical guidance, and the promotion of high coding standards.\r\nMinimum Qualifications\r\nBachelor's degree in Computer Science or equivalent hands-on experience\r\n6+ years of experience developing Oracle PL/SQL (or similar procedural database technologies) in production environments\r\nStrong SQL expertise, including writing and optimizing queries across large relational datasets\r\nExperience analyzing and improving complex legacy database code\r\nDemonstrated ability to diagnose, tune, and optimize database performance\r\nPreferred Qualifications\r\nExperience with Snowflake or similar cloud data warehouse technologies\r\nFamiliarity with database change management tools such as Liquibase\r\nExperience working in SaaS or cloud-based environments\r\nExperience mentoring developers or performing code reviews\r\nExposure to energy markets, commodities trading, or financial data systems\r\nSalary: Up to $160k/annual DOE + Benefits (Medical, Dental, Vision, PTO, 401K)\r\nJ-18808-Ljbffr","datePosted":"2026-04-12T05:08:03.667Z","dateModified":"2026-04-12T05:08:03.667Z","hiringOrganization":{"@type":"Organization","name":"Ripple Effect Consulting","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Boulder","addressRegion":"CO","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"dd7cae0adde4c0edb22111e8"},"url":"https://jobsearcher.com/jobs/dd7cae0adde4c0edb22111e8"}}