Principal Database Refactoring & Performance Architect
Persistent
Persistent
Join Persistent as a Principal Database Refactoring & Performance Architect, an AI-led digital engineering partner. We specialize in enterprise modernization, empowering clients with deep technical expertise and innovative solutions. With a global presence across 18 countries and a team of over 27,500 professionals, we drive significant growth and deliver award-winning services to industry leaders. Our commitment to client success and a disruptor's mindset define our culture.
This role involves auditing and refactoring legacy PL/SQL code into optimized database components. You will rewrite and tune complex SQL queries using Oracle 19c best practices, transforming cursor-based logic into efficient set-based SQL. Key duties include comprehensive database performance assessments, designing logging and monitoring frameworks, and leading schema redesign initiatives. Responsibilities also encompass developing advanced partitioning and indexing strategies, identifying and eliminating technical debt, and performing deep execution plan analysis. Additionally, you'll optimize Azure-hosted applications interacting with Oracle databases, design data integration frameworks, and improve database availability and disaster recovery capabilities. Collaboration with application developers to embed performance best practices and leading modernization initiatives are crucial.
We seek an architect with 10 to 15 years of experience in Oracle database modernization, performance engineering, and cloud data transformation. Essential expertise includes Oracle 19c, advanced SQL and PL/SQL optimization, and Azure-based data solutions. You should possess a strong understanding of Oracle CBO, adaptive query optimization, and SQL plan management. Proven experience in execution plan analysis, performance diagnostics, and tuning methodologies is required. Hands-on experience with BULK COLLECT, FORALL, and analytical functions is vital. A deep understanding of Oracle database internals, memory architecture, and storage management is expected. Experience with partitioning, indexing strategies, data modeling, and schema optimization is necessary. Proficiency with Azure cloud services, Azure Data Factory, and hybrid cloud architectures is also a key requirement.
Persistent Systems
IT Consulting