Senior PL​/SQL Developer

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.

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

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

• 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 file system, 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.

• Experience with Oracle DB@AWS (or Oracle on OCI/cloud infrastructure)
• Experience with , Oracle Jobs, and batch processing orchestration
• Experience with data migration or platform modernization in legacy systems
• Familiarity with version control for database code (Git, Git Lab, 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…