Database Architect / Performance Engineer

Mphasis; Chennai District; On-site; INR 2,500,000 - 4,000,000; Full time

Job summary

Mphasis is seeking an experienced Database Architect / Performance Engineer to design enterprise-scale database environments with a strong focus on Oracle Database performance and scalability. You will optimize SQL, implement caching layers with Redis, and drive data migration strategies across cloud-based platforms.

The role requires 8+ years of relevant experience and close collaboration with product owners, developers, and infrastructure teams to ensure highly available, efficient data

Qualifications

• 8+ years of professional experience in Database Architecture, Engineering, and Performance Optimization.
• Expertise in Oracle Database design, administration, optimization, and performance management.
• Experience with Redis-based caching solutions and data migration planning.

Responsibilities

• Analyze data workloads to design scalable, high-performance database architectures.
• Collaborate with product owners and development teams to translate requirements into database solutions.
• Perform query tuning, performance troubleshooting, and capacity planning.
• Develop operational procedures, technical documentation, and benchmarks.

Skills

Oracle DB

SQL Performance Tuning

Query Optimization

Redis Caching

Data Migration

Performance Engineering

Cloud DB Platforms

Database Security

Education

Bachelor's or Master's in CS/IT/Engineering

Tools

Oracle C++ Libs

Redis

AWS RDS

Job description

Role: Database Architect / Performance Engineer

Exp : 8+ Yrs

Location: Offshore - Chennai / Bangalore

NP: 0-30 Days

Interview Mode: F2F

Who are we looking for?

We are seeking an experienced Database Architect / Performance Engineer with 8+ years of professional experience in designing, optimizing, and managing enterprise-scale database environments. The ideal candidate will possess deep expertise in Oracle Database, SQL Performance Tuning, Query Optimization, Database Caching, Redis, and Data Migration Strategy, with a strong focus on performance, scalability, reliability, and data integrity. The candidate should have a proactive engineering mindset, excellent analytical capabilities, and a proven ability to transform complex business requirements into robust, high-performing database architectures. This role requires close collaboration with application architects, developers, infrastructure teams, and business stakeholders to deliver highly available and efficient data platforms.

Technical Skills

• Minimum 8+ years of experience in Database Architecture, Database Engineering, and Performance Optimization.
• Strong expertise in Oracle Database for enterprise-scale database design, administration, optimization, and performance management.
• Rich experience with Oracle C++ Libs, SQL Performance Tuning, Query Optimization, and Redis-based Database Caching solutions.
• Deep understanding of database architecture principles, data modeling, indexing strategies, normalization, denormalization, partitioning, and high-performance database design methodologies.
• Extensive experience in query tuning, performance troubleshooting, database monitoring, workload analysis, capacity planning, and system optimization.
• Strong knowledge of database governance, security standards, backup and recovery procedures, disaster recovery planning, and database management best practices.
• Expertise in SQL query optimization, execution plan analysis, schema design, data migration planning, and performance benchmarking.
• Experience in building, maintaining, and optimizing Oracle database environments, Redis caching layers, and cloud-based database platforms.
• Strong understanding of database caching strategies, data consistency models, transaction management, and performance engineering practices.
• Working knowledge of AWS RDS, High Availability architectures, Backup & Recovery solutions, and Database Security frameworks.
• Experience with database migration initiatives, modernization programs, cloud adoption strategies, and large-scale data movement projects.
• Ability to collaborate closely with Product Owners, Business Analysts, Solution Architects, and Development Teams to translate business requirements into scalable, secure, and high-performing database solutions.
• Strong portfolio demonstrating successful delivery of enterprise-grade database architectures, performance optimization initiatives, migration projects, and measurable business impact.

Process Skills

• Analyze business requirements and data workloads to design scalable, resilient, and performance-oriented database architectures.
• Conduct stakeholder and technical team discussions to gather, assess, and refine database requirements, performance objectives, and migration strategies.
• Create and review database designs, performance reports, optimization recommendations, operational procedures, and technical documentation.
• Collaborate with Agile/Scrum teams to deliver secure, highly available, and reliable database solutions while driving continuous performance improvements.

Behavioral Skills

• Excellent problem-solving skills with the ability to identify complex database bottlenecks, performance gaps, and architectural challenges and propose innovative solutions.
• Strong collaboration skills and ability to work effectively with business stakeholders, developers, infrastructure teams, cloud engineers, and product teams.
• Excellent written and verbal communication skills with the ability to present technical findings and recommendations to both technical and non-technical audiences.
• Ability to mentor and guide junior database engineers and administrators while promoting database best practices and operational excellence.
• Strong attention to detail, data quality, performance optimization, reliability, and security across all database platforms.
• Proactive mindset with the ability to manage multiple priorities, drive strategic initiatives, and deliver results in a fast-paced enterprise environment.

Qualification

• Bachelor's Degree or Master's Degree in Computer Science, Information Technology, Engineering, or a related field.
• Minimum 8+ years of professional experience in Database Architecture, Database Engineering, and Performance Optimization with a strong, proven track record demonstrating expertise in Oracle Database, SQL Performance Tuning, Query Optimization, Redis, and Data Migration Strategy.