Principal Database Refactoring & Performance Architect

Persistent Systems Limited; Pune District; Hybrid; INR 4,000,000 - 7,000,000; Full time

Benefits offered by this job

Competitive salary

Education sponsorship

Flexible work hours

Insurance coverage: group term life, 1

Job summary

Persistent Systems Limited seeks a Principal Database Refactoring & Performance Architect with 10–15 years in Oracle modernization (Oracle 19c) to lead refactoring, performance tuning, and Azure data transformations.

You’ll redesign schemas, implement partitioning and indexing, optimize SQL, monitor with AWR/ASH, and mentor teams while aligning with governance and cloud migration goals.

Qualifications

• 10 to 15 years of experience in Oracle database administration, architecture, performance engineering, and modernization.
• Expert-level PL/SQL, SQL tuning, and refactoring skills.
• Deep knowledge of Oracle 19c, CBO, and SQL Plan Management.

Responsibilities

• Refactor legacy PL/SQL into modular, maintainable components.
• Rewrite complex queries with set-based approaches and bulk processing.
• Lead schema redesign, partitioning, indexing, and data modeling.
• Implement logging, monitoring, and disaster recovery frameworks.
• Collaborate with developers to embed performance best practices.

Skills

Oracle PL/SQL

SQL optimization

Performance tuning

Data architecture

Azure cloud

Oracle 19c

Database modernization

Tools

Oracle 19c

Azure Data Factory

Job description

Principal Database Refactoring & Performance Architect

Job Description

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 what?s 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.

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 You'll 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 You'll 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.
• 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
• 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

Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind.