Senior PL/SQL Developer

Roi Solutions Inc; Medford (MA); On-site; USD 120,000 - 170,000; Full time

Job summary

ROI Solutions seeks a Senior PL/SQL Developer to advance the database-layer business logic powering Revolution CRM. This hands-on role dives into a mature Oracle environment with complex stored procedures, packages, triggers, and data pipelines.

You will write, optimize, and maintain PL/SQL code for payment processing, data exports, integrations, and reporting, contributing to platform stability and modernization while collaborating with Java developers and product teams in a fast-paced, agile

Qualifications

• 7+ years hands-on PL/SQL development - packages, procedures, functions, triggers
• Expert-level SQL - complex queries, execution plan analysis, performance tuning
• Oracle database internals knowledge - memory, concurrency, transactions
• Performance tuning - diagnose slow queries, optimize batch processes
• Multi-tenant or multi-schema experience with isolated data
• Production troubleshooting using logs and execution plans
• Linux proficiency in Oracle environments
• Data security awareness in multi-tenant settings
• Cross-functional collaboration with Java teams and product managers
• Agile development experience with sprints and backlogs

Responsibilities

• Design, develop, and maintain PL/SQL packages, procedures, functions, and triggers
• Optimize SQL/PLSQL for performance across large multi-tenant datasets
• Troubleshoot production issues and deploy fixes
• Support data pipelines: scheduled jobs, exports, imports, integrations
• Collaborate with Java developers to keep clear boundaries between app and DB logic
• Participate in code reviews and document database logic and processes

Skills

PL/SQL development

SQL tuning

Oracle database internals

Performance optimization

Multi-tenant databases

Linux

Data security

Java collaboration

Agile

Tools

Oracle Database

DBMS_SCHEDULER

Git / Liquibase

SQL Developer

TOAD

Job description

About the Role

We’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.

Responsibilities

Day-to-Day

• Design, 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 integration 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.

Modernization

• Identify 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 Qualifications

• 7+ years of hands‑on PL/SQL development - packages, procedures, functions, triggers, collections, bulk operations
• Expert‑level SQL - complex queries, execution plan analysis, performance tuning across large datasets
• Oracle database internals knowledge - understanding of how Oracle executes queries, manages memory, handles concurrency, and processes transactions
• Performance tuning experience - you’ve diagnosed and fixed slow queries, optimized batch processes, and improved throughput on production systems
• Multi‑tenant or multi‑schema experience - you’ve worked in environments where one database serves many customers with isolated data
• Production troubleshooting - you’re comfortable tracing issues through database logs, execution plans, and application behavior to find root causes under pressure
• Linux 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 Qualifications

• Experience with Oracle DB@AWS (or Oracle on OCI/cloud infrastructure)
• Experience with DBMS_SCHEDULER, Oracle Jobs, and batch processing orchestration
• Experience with data migration or platform modernization in legacy systems
• Familiarity 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 deployments
• Experience in a multi‑tenant SaaS environment
• Nonprofit or fundraising domain experience (understanding of donor records, gifts, campaigns, designations)

Nice-to-Have

• Experience 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 practices
• Proficiency with Oracle tooling: SQL Developer, TOAD, or similar
• Familiarity with CI/CD pipelines for database deployment workflows

PLEASE 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.