Principal Database Refactoring & Performance Architect

Persistent

10–15 yrs Pune Full Time Hybrid (office + remote)
Persistent logo
Posted : today
Actively hiring

Job description

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.

Responsibilities

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.

Qualifications

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.

Essential Skills

Oracle Database AdministrationOracle PL/SQLAdvanced SQLQuery OptimizationDatabase RefactoringOracle 19cAutonomous DatabaseCost-Based Optimizer (CBO)Adaptive Query OptimizationSQL Plan ManagementExecution Plan AnalysisPerformance DiagnosticsDatabase TuningBULK COLLECTFORALLCollection TypesObject TypesAnalytical FunctionsDatabase InternalsMemory ArchitectureStorage ManagementTransaction ProcessingHigh Availability ArchitecturesScalable ArchitecturesResilient Database ArchitecturesPartitioningIndexing StrategiesData ModelingSchema OptimizationAzure Cloud ServicesAzure Data FactoryCloud Data IntegrationHybrid Cloud ArchitecturesDatabase MigrationMonitoring FrameworksObservabilityLogging FrameworksPerformance ManagementEnterprise Data ArchitectureData GovernanceTechnical Debt RemediationMission-Critical ApplicationsTroubleshootingAnalytical SkillsProblem-SolvingCommunication SkillsStakeholder ManagementCollaborationModernization InitiativesStrategic Technology Decisions

Highlights

  • Actively hiring

More Details

RolePrincipal Database Refactoring & Performance Architect
Employment TypeFull Time, Hybrid (office + remote)

About the Company

Persistent Systems logo

Persistent Systems

IT Consulting

Principal Database Refactoring & Performance Architect at Persistent | SkillMX | SkillMX