02 Oct
|
Persistent Systems
|
Pune
02 Oct
Persistent Systems
Pune
About Position:
We are seeking an experienced Principal Database Refactoring & Performance Architect with 8 to 12 years of expertise in database modernization, performance engineering, data architecture, and cloud transformation initiatives. The ideal candidate will have solid hands-on experience in Oracle databases, Azure SQL, SQL Server, and enterprise data platforms. This role will be responsible for leading database refactoring initiatives, optimizing legacy systems, supporting Oracle-to-Azure migration programs, improving data quality, and designing scalable data architectures that support business intelligence, analytics, and digital transformation objectives.
• Role: Principal Database Refactoring & Performance Architect
• 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 database technical debt, redundant objects, duplicate logic, and inefficient processing patterns.
• Perform data profiling, reconciliation, validation, and root cause analysis to improve enterprise data quality.
• Design and optimize analytical data models, reporting datasets, data marts, and business KPIs.
• Support Oracle to Azure SQL migration and modernization initiatives.
• Conduct schema assessments, migration planning, data validation, and database modernization activities.
• Develop and optimize solutions across Oracle, Azure SQL Database, Microsoft SQL Server, and MySQL environments.
• Design scalable data architectures that support enterprise applications, analytics, and reporting platforms.
• Create dashboards, reports, and analytical solutions using Power BI and related BI platforms.
• Collaborate with business stakeholders, data team
📌 Principal Database Refactoring (Pune)
🏢 Persistent Systems
📍 Pune