DBA Senior Consultant

Job Description

Role: Database Architect / Performance Engineer
Location: Offshore - Chennai / Bangalore

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.