Principal Database Refactoring & Performance Architect

About Persistent

We are an AI-led platform-driven Digital Engineering and Enterprise Modernization partner combining deep technical expertise and industry experience to help our clients anticipate whats next. Our offerings and proven solutions create a unique competitive advantage for our clients by giving them the power to see beyond and rise above. We work with many industry-leading organizations across the world including 20 Fortune 50 companies and 4 of the 5 top banks in both the US and India and numerous innovators across the healthcare ecosystem.

Our disruptors mindset commitment to client success and agility to thrive in the dynamic environment have enabled us to sustain our growth momentum. Persistent has been recognized across top industry platforms for innovation leadership and inclusion. We reported $1654.4M FY26 revenue with 17.4% Y-o-Y growth. We have delivered 24sequential quarters of growth with $436.0M in Q4 FY26 revenue up 3.2% Q-o-Q and 16.2% Y-o-Y growth. Our 27500global team members located in 18 countries have been instrumental in helping the market leaders transform their industries. We have been recognized as theFastest Growing IT Services Brand Globally in the 2026 Brand Finance IT Services 25 Report. We named a Leader in theEverest Group Private Equity (PE) Services PEAK MatrixAssessment 2026andSoftware Product Engineering PEAK MatrixAssessment 2026.

About Position:

We are seeking an experienced Principal Database Refactoring & Performance Architect with 10 to 15 years of expertise in Oracle database modernization performance engineering and cloud-enabled data transformation initiatives. The ideal candidate will possess deep knowledge of Oracle 19c advanced SQL and PL/SQL optimization Azure-based data solutions and enterprise-scale database architecture.

• Role: Principal Database Refactoring & Performance Architect (Oracle 19c / Azure)
• Location: All Persistent Locations
• Experience: 10 to 15 Years
• Job Type: Full Time Employment

What Youll Do:

• Audit analyze and refactor legacy PL/SQL packages stored procedures functions and triggers into modular maintainable and optimized database components.
• Rewrite and optimize complex SQL queries using Oracle 19c Cost-Based Optimizer (CBO) best practices.
• Transform cursor-based and row-by-row processing logic into high-performance set-based SQL using BULK COLLECT and FORALL techniques.
• Perform comprehensive database performance assessments and recommend optimization strategies.
• Design and implement structured logging tracing monitoring auditing and error-handling frameworks.
• Lead schema redesign initiatives including normalization denormalization and optimization of large-scale enterprise databases.
• Develop advanced partitioning indexing compression and storage strategies for Oracle 19c environments.
• Identify and eliminate technical debt including obsolete database objects redundant indexes inefficient code and unnecessary data access patterns.
• Perform deep execution plan analysis using Oracle SQL Monitor SQLTXPLAIN AWR ASH and other diagnostic tools.
• Optimize Azure-hosted applications and services interacting with Oracle databases through enhanced connection pooling batch processing and integration patterns.
• Design scalable data integration frameworks leveraging Azure Data Factory and cloud-native technologies.
• Improve database availability scalability reliability and disaster recovery capabilities.
• Collaborate with application developers to embed database performance best practices within software development lifecycles.
• Lead database modernization and migration initiatives across cloud and hybrid environments.
• Establish database governance standards performance benchmarks and architectural best practices.
• Provide technical leadership and mentorship to database administrators developers and technical teams.

Expertise Youll Bring:

• 10 to 15 years of experience in Oracle Database Administration Architecture Performance Engineering and Database Modernization.
• Expert-level knowledge of Oracle PL/SQL Advanced SQL Query Optimization and Database Refactoring.
• Extensive experience with Oracle Database 19c and Autonomous Database environments.
• Strong understanding of Oracle Cost-Based Optimizer (CBO) Adaptive Query Optimization and SQL Plan Management.
• Proven expertise in execution plan analysis performance diagnostics and database tuning methodologies.
• Hands-on experience with BULK COLLECT FORALL Collection Types Object Types and Analytical Functions.
• Deep understanding of Oracle database internals memory architecture storage management and transaction processing.
• Experience designing highly available scalable and resilient database architectures.
• Strong expertise in partitioning indexing strategies data modeling and schema optimization.
• Experience working with Azure cloud services Azure Data Factory and cloud-based data integration patterns.
• Knowledge of hybrid cloud architectures and database migration strategies.
• Experience implementing monitoring observability logging and performance management frameworks.
• Strong understanding of enterprise data architecture and governance principles.
• Ability to identify and remediate technical debt within large-scale database ecosystems.
• Experience supporting mission-critical applications with demanding performance and availability requirements.
• Excellent troubleshooting analytical and problem-solving skills.
• Strong communication and stakeholder management capabilities.
• Ability to collaborate effectively with development architecture infrastructure and cloud engineering teams.
• Experience leading complex modernization initiatives and influencing strategic technology decisions.

Benefits:

• Competitive salary and benefits package
• Culture focused on talent development with quarterly growth opportunities and company-sponsored higher education and certifications
• Opportunity to work with cutting-edge technologies
• Employee engagement initiatives such as project parties flexible work hours and Long Service awards
• Annual health check-ups
• Insurance coverage: group term life personal accident and Mediclaim hospitalization for self spouse two children and parents

Values-Driven People-Centric & Inclusive Work Environment:

Persistent is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals including those with disabilities and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds.

• We support hybrid work and flexible hours to fit diverse lifestyles.
• Our office is accessibility-friendly with ergonomic setups and assistive technologies to support employees with physical disabilities.
• If you are a person with disabilities and have specific requirements please inform us during the application process or at any time during your employment

Lets unleash your full potential at Persistent- is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind.