Oracle Database Migration Architect
Job Summary
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 Oracle Database Migration Architect to lead database modernization performance optimization and migration initiatives from Oracle environments to Azure SQL platforms. The ideal candidate will possess deep expertise in Oracle database development PL/SQL programming database refactoring and cloud migration strategies. This role involves redesigning legacy database solutions modernizing data architectures optimizing performance and enabling successful migrations to Azure SQL Database and Azure SQL Managed Instance. The candidate will work closely with architects developers DBAs and business stakeholders to deliver scalable high-performing and cloud-ready database solutions.
- Role: Oracle Database Migration Architect
- Location: All Persistent Locations
- Experience: 8 to 12 Years
- Job Type: Full-Time Employment
What Youll Do:
- Analyze Oracle database schemas database objects and application dependencies.
- Assess Oracle packages procedures functions triggers views materialized views sequences and synonyms for migration readiness.
- Understand and document business logic embedded within Oracle SQL and PL/SQL code.
- Perform migration assessments dependency analysis impact analysis and remediation planning.
- Design migration strategies for Oracle databases moving to Azure SQL Database and Azure SQL Managed Instance.
- Convert Oracle SQL and PL/SQL code into Azure-compatible T-SQL solutions.
- Refactor Oracle-specific functionality and redesign database components for cloud-native execution.
- Optimize and modernize legacy database architectures to improve scalability and maintainability.
- Conduct schema conversion code remediation and database modernization activities.
- Perform source-to-target data validation reconciliation and migration testing.
- Validate functional equivalence between Oracle and Azure database environments.
- Execute performance tuning and optimization of converted database code and workloads.
- Support migration deployment cutover planning go-live activities and post-migration stabilization.
- Collaborate with DBAs architects developers QA teams and business stakeholders throughout the migration lifecycle.
- Create technical documentation migration reports architecture recommendations and best-practice guidelines.
- Identify risks dependencies and mitigation strategies related to database transformation initiatives.
- Drive continuous improvement and database modernization best practices across enterprise platforms.
Expertise Youll Bring:
- 812 years of experience in Oracle Database Development Database Architecture and Data Modernization initiatives.
- Strong hands-on expertise in Oracle SQL and PL/SQL development.
- Extensive experience with Oracle packages procedures functions triggers views materialized views sequences and synonyms.
- Proven experience analyzing complex Oracle codebases and understanding embedded business logic.
- Strong expertise in Oracle database performance tuning and query optimization.
- Hands-on experience delivering Oracle-to-Azure database migration projects.
- Experience working with Azure SQL Database and Azure SQL Managed Instance.
- Strong T-SQL development debugging optimization and troubleshooting skills.
- Experience using SQL Server Migration Assistant (SSMA) for Oracle migrations.
- Knowledge of schema conversion code conversion remediation migration testing and validation processes.
- Strong understanding of database architecture normalization data modeling and database design principles.
- Experience assessing and resolving migration challenges associated with Oracle-specific features and dependencies.
- Expertise in data migration reconciliation validation and data quality processes.
- Strong troubleshooting analytical and problem-solving skills.
- Experience working in large-scale enterprise transformation and modernization programs.
- Ability to collaborate effectively with technical teams and business stakeholders.
- Strong communication documentation and stakeholder management capabilities.
- Experience with Agile delivery methodologies and cloud transformation initiatives.
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.
Required Experience:
Staff IC
About Company
Re(AI)magining the World with Persistent Systems: Transform your AI journey with a trusted partner in digital engineering and enterprise modernization services.