14 Oct
|
Mphasis
|
Chennai
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.
- Solid 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.
📌 Database Architect / Performance Engineer (Chennai)
🏢 Mphasis
📍 Chennai