Principal Database Refactoring & Performance Architect (Pune)

Principal Database Refactoring & Performance Architect (Pune)

03 Nov
|
Persistent Systems
|
Pune

03 Nov

Persistent Systems

Pune

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 18 of the Fortune 50 companies, 7 of the 10 top US banks, 9 of the 10 technology companies, and numerous innovators across the healthcare ecosystem.

Our disruptor's mindset, commitment to client success, and agility to thrive in the dynamic workplace have enabled us to sustain our growth momentum. Persistent has been recognized across top industry platforms for innovation, leadership, and inclusion. We have delivered 26 sequential quarters of growth with $487.6M in Q4 FY26 revenue, up 7.8% Q-o-Q and 20.0% Y-o-Y.

Our 29,500+ global team members, located in 21 countries, have been instrumental in helping the market leaders transform their industries. We received five awards at the ISG (Information Services Group) Provider Lens Awards 2026 and, for the second year in a row, were awarded the Growth Honor of the Year at the Everest Group Elevate 2026.

About Position:

We are seeking an experienced Principal Database Refactoring & Performance Architect - Oracle & Azure to lead database modernization, performance optimization, and cloud transformation initiatives across enterprise data platforms. The ideal candidate will possess deep expertise in Oracle databases, Azure data technologies, database refactoring, and data architecture. This role will be responsible for analyzing legacy systems, optimizing database performance, designing scalable data solutions, and supporting Oracle-to-Azure migration programs while ensuring data quality, governance, and operational excellence.

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

What You'll Do:

- Analyze and refactor legacy Oracle database objects, including SQL queries, PL/SQL packages, procedures, functions, triggers, and views.
- Optimize complex SQL and PL/SQL code to improve performance,



scalability, maintainability, and operational efficiency.
- Identify and eliminate technical debt, redundant database objects, duplicate logic, and inefficient processing patterns.
- Perform data profiling, reconciliation, validation, and root-cause analysis to improve data quality and consistency.
- Design and optimize enterprise data models, analytical datasets, and reporting structures.
- Support Oracle-to-Azure migration and modernization initiatives, including schema assessment, performance tuning, and data validation.
- Develop and optimize solutions across Oracle, Azure SQL Database, Microsoft SQL Server, and MySQL environments.
- Design scalable data architecture frameworks that support enterprise analytics and reporting requirements.
- Build dashboards, reports, and business intelligence solutions using Power BI and related analytics tools.
- Collaborate with business stakeholders, solution architects, and engineering teams to translate requirements into scalable data solutions.
- Define and implement data governance, architecture standards, and best practices.
- Document data flows, business rules, mappings, technical specifications, and modernization recommendations.
- Support enterprise analytics, cloud transformation, and strategic data initiatives.
- Drive database performance assessments, optimization strategies, and architecture improvements.

Expertise You'll Bring:

- 8-12 years of experience in Data Architecture, Database Development, Data Engineering, and Analytics solutions.
- Strong experience in data analysis, SQL development, database refactoring, data quality management, and business intelligence.
- Deep expertise in Oracle Database (11g, 12c, and 19c) administration and development.
- Hands-on experience with Azure SQL Database and cloud-based data platforms.
- Strong working knowledge of Microsoft SQL Server and MySQL.
- Advanced proficiency in Oracle SQL, PL/SQL,



query optimization, and performance tuning.
- Extensive experience developing and maintaining packages, procedures, functions, triggers, and views.
- Proven experience identifying and resolving database performance bottlenecks and scalability challenges.
- Experience supporting Oracle-to-Azure cloud migration and modernization programs.
- Strong understanding of data modeling, database design, and analytics engineering principles.
- Hands-on experience with Power BI, reporting solutions, and business intelligence platforms.
- Experience with data governance, data quality, metadata management, and compliance frameworks.
- Strong analytical, troubleshooting, and problem-solving capabilities.
- Excellent stakeholder management and communication skills.
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline.

Benefits:

- Competitive salary and benefits package
- Culture focused on talent development with quarterly growth opportunities and company-sponsored higher education and certifications
- Prospect 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 Setting:

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

Let's unleash your full potential at Persistent - persistent.com/careers

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

📌 Principal Database Refactoring & Performance Architect (Pune)
🏢 Persistent Systems
📍 Pune

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: principal database refactoring & performance architect (pune) / pune