Senior Oracle PL/SQL Developer

Matlen Silver; Charlotte (NC); On-site; USD 140,000 - 190,000; Full time

Job summary

Matlen Silver is seeking a Senior Oracle Database Developer to design, develop, and optimize large-scale Oracle database solutions. You will lead PL/SQL development, performance tuning, and data architecture while mentoring teams across Agile projects.

The role requires 8–15 years of hands-on Oracle experience, strong collaboration with offshore teams, and ownership of delivering scalable enterprise-grade databases.

Qualifications

• 8–15 years of hands-on Oracle database development experience.
• Expert-level experience with Oracle Database 19c or higher.
• Proficient in PL/SQL, stored procedures, functions, and triggers.
• Strong SQL with performance tuning and optimization.
• Experience in data modeling and database design for enterprise apps.
• Familiarity with Git, Bitbucket, and Jira in Agile environments.
• Hands-on scripting for automation and operational support.

Responsibilities

• Design, develop, and maintain enterprise-scale Oracle database solutions (Oracle 19c/21c).
• Develop and support complex PL/SQL packages, procedures, functions, triggers, and SQL queries.
• Tune SQL/PL/SQL for performance and scalability.
• Model data and design robust database architectures for enterprise apps.
• Lead code reviews and mentor junior/mid developers on Agile teams.
• Coordinate with offshore teams and drive development standards and best practices.

Skills

Oracle development

Oracle 19c+

PL/SQL

Stored Procedures

Functions

Triggers

Analytical Functions

Complex SQL

SQL performance tuning

Data Modeling

Database design

Git

Bitbucket

JIRA

DevOps

Tools

Git

Bitbucket

JIRA

Job description

We are seeking a highly experienced Senior Oracle Database Developer to join our enterprise technology team. This is a senior-level, hands-on technical role requiring 8–15 years of experience designing, developing, and optimizing large-scale Oracle database solutions.

The ideal candidate is a strong Oracle development expert—not an ETL developer with Oracle exposure—and possesses deep expertise in database architecture, PL/SQL development, SQL performance tuning, and enterprise application support. This role also requires technical leadership experience, working with distributed and offshore teams while mentoring developers and driving best practices.

We are looking for someone who thrives in a fast-paced Agile environment, enjoys solving complex technical challenges, and takes ownership of delivering high-quality, scalable database solutions.

Key Responsibilities

• Design, develop, and maintain enterprise-scale Oracle database solutions using Oracle 19c/21c.
• Develop and support complex PL/SQL packages, stored procedures, functions, triggers, and SQL queries.
• Perform SQL and PL/SQL performance tuning to optimize application and database performance.
• Design and implement scalable data models and database architectures supporting enterprise applications.
• Develop reusable database components and establish development standards and best practices.
• Collaborate with application developers, architects, and business stakeholders to translate business requirements into technical solutions.
• Support large-scale enterprise applications through development, enhancement, troubleshooting, and production support.
• Conduct code reviews and mentor junior and mid-level developers across Agile teams.
• Lead technical discussions and coordinate development efforts with offshore teams.
• Participate in solution design, story grooming, sprint planning, and Agile ceremonies.
• Read and analyze existing application code and infrastructure to understand current-state architecture before implementing enhancements.
• Contribute to CI/CD initiatives and modern DevOps practices for database deployments.

Required Qualifications

• 8–15 years of hands-on Oracle database development experience.
• Expert-level experience with Oracle Database 19c or higher.
• PL/SQL Packages
• Stored Procedures
• Functions
• Triggers
• Analytical Functions
• Complex SQL
• Extensive experience with SQL performance tuning and query optimization.
• Strong expertise in data modeling and database design.
• Proven experience implementing and supporting large-scale Oracle databases.
• Experience supporting enterprise-level applications in complex production environments.
• Strong understanding of relational database concepts; experience with object databases is a plus.
• Hands‑on scripting experience for automation and operational support.
• Experience working with frontend development teams to support application integration.
• Experience using version control tools such as Git and Bitbucket.
• Experience working within Agile software development environments using JIRA.
• Strong analytical, troubleshooting, and problem‑solving skills.
• Excellent verbal and written communication skills.

Preferred Qualifications

• Technical leadership experience leading or mentoring medium to large development teams.
• Experience coordinating work with offshore development teams.
• Experience designing technical solutions for enterprise‑scale applications.
• Experience conducting code reviews and establishing development best practices.
• Experience with CI/CD pipelines and deployment platforms such as:
• Bitbucket
• Horizon
• SDM platforms
• Financial services or banking industry experience is considered an asset.

What We're Looking For

• A motivated and collaborative technology professional who takes initiative and ownership.
• Someone who enjoys working in a dynamic, fast-paced environment with evolving priorities.
• A strong communicator who can effectively partner with technical and business stakeholders.
• A mentor and technical leader who enjoys sharing knowledge and elevating team performance.
• An individual with a passion for continuous improvement, emerging technologies, and delivering high-quality enterprise solutions.