Senior PL/SQL Developer - Remote & ET Time Zone

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

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