{"schemaVersion":"jobsearcher.job.v1","id":"9d8cb5d54f963996034c0ac5","url":"https://jobsearcher.com/jobs/9d8cb5d54f963996034c0ac5","canonicalUrl":"https://jobsearcher.com/jobs/9d8cb5d54f963996034c0ac5","title":"Senior PL/SQL Developer","description":"About the RoleWe're looking for a Senior PL/SQL Developer to help us continue to evolve the database-layer business logic that powers Revolution CRM. This is a hands-on technical role where you'll work deep inside a large, mature Oracle database with complex stored procedures, packages, triggers, and data pipelines.You'll write, optimize, and maintain the PL/SQL code that implements core business operations: payment processing, data exports, integrations, scheduled jobs, and reporting logic and become a critical contributor to both platform stability and future modernization.ResponsibilitiesDay-to-DayDesign, develop, and maintain PL/SQL packages, stored procedures, functions, and triggers that implement CRM business logic.Optimize SQL queries and PL/SQL code for performance across a large-scale multi-tenant environment.Troubleshoot and resolve production issues in database-layer code: trace execution paths, identify root causes, and deploy fixes.Support data pipeline operations: scheduled jobs, exports, imports, and integrations with external systems.Collaborate with application developers (Java) to ensure clean boundaries between application and database logic.Participate in code reviews and maintain documentation for database logic and processes.ModernizationIdentify and refactor legacy PL/SQL code for performance, maintainability, and portability.Contribute to decisions about what business logic should remain in the database vs.migrate to the application layer over time.Support integration with modern data platforms where CRM data feeds downstream analytics.Help establish best practices for PL/SQL development: version control, code review, testing, and repeatable deployment processes.Required Qualifications7+ years of hands-on PL/SQL development - packages, procedures, functions, triggers, collections, bulk operationsExpert-level SQL - complex queries, execution plan analysis, performance tuning across large datasetsOracle database internals knowledge - understanding of how Oracle executes queries, manages memory, handles concurrency, and processes transactionsPerformance tuning experience - you've diagnosed and fixed slow queries, optimized batch processes, and improved throughput on production systemsMulti-tenant or multi-schema experience - you've worked in environments where one database serves many customers with isolated dataProduction troubleshooting - you're comfortable tracing issues through database logs, execution plans, and application behavior to find root causes under pressureLinux proficiency - our Oracle environment runs on Linux. You're comfortable working in a Linux environment, navigating the filesystem, reading logs, and running command-line tools.Data security awareness - you understand the implications of working in a multi-tenant environment with PII. You think about data isolation, access control, and compliance as part of development, not as an afterthought.Collaboration skills - you'll work closely with Java developers, QA engineers, and product managers. Clear communication about technical constraints and timelines matters.Agile experience - you've worked in sprint-based development cycles with standups, backlog grooming, and iterative delivery.Preferred QualificationsExperience with Oracle DB@AWS (or Oracle on OCI/cloud infrastructure)Experience with DBMS_SCHEDULER, Oracle Jobs, and batch processing orchestrationExperience with data migration or platform modernization in legacy systemsFamiliarity with version control for database code (Git, GitLab, Liquibase, or similar)Experience with a PL/SQL SDLC: managing database code in source control, branching strategies for schema changes, migration scripts, code review workflows, and scripted deploymentsExperience in a multi-tenant SaaS environmentNonprofit or fundraising domain experience (understanding of donor records, gifts, campaigns, designations)Nice-to-HaveExperience with Java/Oracle integration patterns (JDBC, connection pooling)Familiarity with modern data platforms (understanding how CRM data feeds analytics)Experience mentoring junior developers on database development practicesProficiency with Oracle tooling: SQL Developer, TOAD, or similarFamiliarity with CI/CD pipelines for database deployment workflowsPLEASE NOTE:This role will work in the Eastern Time Zone.Limited travel. Generally fewer than five trips per year for in-person team, planning, or company meetings.This role is posted as remote, but it could be hybrid or in-office if that best fits your working style.This role is ONLY available for work in the following (24) locations: AL, AR, CO, FL, IL, IN, KY, MA, MD, ME, MI, MN, NC, NH, NJ, PA, SC, TX, VA, VT, WA, WI, WV, & DC.If you don't meet all the requirements mentioned above, don't worry. We strongly believe in creating a diverse and inclusive work environment. If you find this job opportunity interesting but don't meet all the qualifications listed in the job description, we encourage you to apply anyway. You might be the perfect candidate for this role or similar roles.Who We Are:ROI Solutions was founded in 1999 to help nonprofit organizations change the world through innovative technology solutions and services. We are focused on sustainable growth, hiring staff committed to working with the nonprofit sector, and constantly evolving our technology and services to help nonprofits succeed in their missions with passion and purpose. This is our calling. We're a proudly independent company, meaning we answer only to our clients rather than shareholders and investors. Our clients inspire our product and solution roadmaps, as well as our strategic direction. We're committed to this model and the opportunity it provides us to develop our solutions based on needs in the nonprofit sector.We are a proud equal opportunity employer. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. All qualified applicants will receive consideration for employment without regard to any protected characteristic as established by law.","company":"Roi Solutions","rawCompany":"roi solutions","city":"Bedford","state":"MA","isRemote":false,"isActive":false,"createdAt":"2026-09-19T13:12:44.183Z","occupations":[{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1251.00","title":"Computer Programmers","slug":"computer-programmers"},{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"}],"industries":[{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Senior PL/SQL Developer","description":"About the RoleWe're looking for a Senior PL/SQL Developer to help us continue to evolve the database-layer business logic that powers Revolution CRM. This is a hands-on technical role where you'll work deep inside a large, mature Oracle database with complex stored procedures, packages, triggers, and data pipelines.You'll write, optimize, and maintain the PL/SQL code that implements core business operations: payment processing, data exports, integrations, scheduled jobs, and reporting logic and become a critical contributor to both platform stability and future modernization.ResponsibilitiesDay-to-DayDesign, develop, and maintain PL/SQL packages, stored procedures, functions, and triggers that implement CRM business logic.Optimize SQL queries and PL/SQL code for performance across a large-scale multi-tenant environment.Troubleshoot and resolve production issues in database-layer code: trace execution paths, identify root causes, and deploy fixes.Support data pipeline operations: scheduled jobs, exports, imports, and integrations with external systems.Collaborate with application developers (Java) to ensure clean boundaries between application and database logic.Participate in code reviews and maintain documentation for database logic and processes.ModernizationIdentify and refactor legacy PL/SQL code for performance, maintainability, and portability.Contribute to decisions about what business logic should remain in the database vs.migrate to the application layer over time.Support integration with modern data platforms where CRM data feeds downstream analytics.Help establish best practices for PL/SQL development: version control, code review, testing, and repeatable deployment processes.Required Qualifications7+ years of hands-on PL/SQL development - packages, procedures, functions, triggers, collections, bulk operationsExpert-level SQL - complex queries, execution plan analysis, performance tuning across large datasetsOracle database internals knowledge - understanding of how Oracle executes queries, manages memory, handles concurrency, and processes transactionsPerformance tuning experience - you've diagnosed and fixed slow queries, optimized batch processes, and improved throughput on production systemsMulti-tenant or multi-schema experience - you've worked in environments where one database serves many customers with isolated dataProduction troubleshooting - you're comfortable tracing issues through database logs, execution plans, and application behavior to find root causes under pressureLinux proficiency - our Oracle environment runs on Linux. You're comfortable working in a Linux environment, navigating the filesystem, reading logs, and running command-line tools.Data security awareness - you understand the implications of working in a multi-tenant environment with PII. You think about data isolation, access control, and compliance as part of development, not as an afterthought.Collaboration skills - you'll work closely with Java developers, QA engineers, and product managers. Clear communication about technical constraints and timelines matters.Agile experience - you've worked in sprint-based development cycles with standups, backlog grooming, and iterative delivery.Preferred QualificationsExperience with Oracle DB@AWS (or Oracle on OCI/cloud infrastructure)Experience with DBMS_SCHEDULER, Oracle Jobs, and batch processing orchestrationExperience with data migration or platform modernization in legacy systemsFamiliarity with version control for database code (Git, GitLab, Liquibase, or similar)Experience with a PL/SQL SDLC: managing database code in source control, branching strategies for schema changes, migration scripts, code review workflows, and scripted deploymentsExperience in a multi-tenant SaaS environmentNonprofit or fundraising domain experience (understanding of donor records, gifts, campaigns, designations)Nice-to-HaveExperience with Java/Oracle integration patterns (JDBC, connection pooling)Familiarity with modern data platforms (understanding how CRM data feeds analytics)Experience mentoring junior developers on database development practicesProficiency with Oracle tooling: SQL Developer, TOAD, or similarFamiliarity with CI/CD pipelines for database deployment workflowsPLEASE NOTE:This role will work in the Eastern Time Zone.Limited travel. Generally fewer than five trips per year for in-person team, planning, or company meetings.This role is posted as remote, but it could be hybrid or in-office if that best fits your working style.This role is ONLY available for work in the following (24) locations: AL, AR, CO, FL, IL, IN, KY, MA, MD, ME, MI, MN, NC, NH, NJ, PA, SC, TX, VA, VT, WA, WI, WV, & DC.If you don't meet all the requirements mentioned above, don't worry. We strongly believe in creating a diverse and inclusive work environment. If you find this job opportunity interesting but don't meet all the qualifications listed in the job description, we encourage you to apply anyway. You might be the perfect candidate for this role or similar roles.Who We Are:ROI Solutions was founded in 1999 to help nonprofit organizations change the world through innovative technology solutions and services. We are focused on sustainable growth, hiring staff committed to working with the nonprofit sector, and constantly evolving our technology and services to help nonprofits succeed in their missions with passion and purpose. This is our calling. We're a proudly independent company, meaning we answer only to our clients rather than shareholders and investors. Our clients inspire our product and solution roadmaps, as well as our strategic direction. We're committed to this model and the opportunity it provides us to develop our solutions based on needs in the nonprofit sector.We are a proud equal opportunity employer. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. All qualified applicants will receive consideration for employment without regard to any protected characteristic as established by law.","datePosted":"2026-09-19T13:12:44.183Z","dateModified":"2026-09-19T13:12:44.183Z","hiringOrganization":{"@type":"Organization","name":"Roi Solutions","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Bedford","addressRegion":"MA","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"9d8cb5d54f963996034c0ac5"},"url":"https://jobsearcher.com/jobs/9d8cb5d54f963996034c0ac5"}}