Role-Database Architect

Grade-VP

Location-Pune/Mumbai/Chennai-WFO

Exp-17+

About the Role

We are seeking a Senior Database Architect with deep expertise in PostgreSQL and Oracle RAC to lead our database architecture and operations. This is a senior level role that requires a hands-on professional who can design, optimize, and manage enterprise-grade database solutions while ensuring high availability, security, and performance. The ideal candidate will be responsible for leading a team, managing production support, and driving database optimization strategies.

Key Requirements

• Deep understanding of Oracle RAC, Standalone Databases, Primary vs. Standby Architectures (Physical & Logical), and Data Space Optimization.
• Experience in Application Performance Tuning, Oracle Architecture, and Data Modeling.
• Hands-on expertise in Oracle tools such as SQLPlus, SQL Developer, SQLLoader, Materialized Views, Explain Plan, SQLRT, SPM, and PL/SQL.
• Strong knowledge of Database Metrics collection & MIS Reporting.
• Proven experience in Resource Management, Task Assignment, and Technical Impact Analysis.
• Overall 18+ years of experience with 8+ years of strong PostgreSQL experience with expertise in database installation (Oracle 19c and above).
• Ability to handle Disaster Recovery (DR) drills and ensure robust recovery strategies.
• Familiarity with Change Log Management, Process Orientation, and Compliance Mandates.
• Strong communication and leadership skills to interact with cross-functional teams, clients, and stakeholders.

Key Responsibilities

• Lead a team to provide support for business-as-usual (BAU) operations and production systems.
• Define and manage KRAs (Key Result Areas) for the team and oversee performance appraisals.
• Experience in preparing Support Rosters, planning for major activities like upgrades/EOY etc
• Ensure efficient task allocation, tracking, throughput management, conflict resolution, and attrition handling within the team.
• Design, implement, and maintain PostgreSQL and Oracle RAC architectures, ensuring scalability and reliability.
• Provide production support and resolve database-related issues while ensuring minimal downtime.
• Conduct database performance tuning, application tuning, and data model optimization.
• Plan and execute major activities such as database upgrades, end-of-year processing, disaster recovery (DR) drills, and migrations.
• Analyse AWR, ADDM, and SAR reports to optimize database performance.
• Implement and manage data security controls such as TDE (Transparent Data Encryption), Redaction, PII Masking, and other compliance-related mandates.
• Oversee database recovery, backup strategies, and troubleshooting of control file corruptions.
• Collaborate with internal project teams to provide tailored database solutions based on business needs.
• Represent the organization in client, bank, and auditor discussions to address database-related inquiries.
• Drive process improvements and service-level enhancements through automation and best practices.

Why Join Us?

• Lead cutting-edge database architecture initiatives in a dynamic product based organisation.
• Engage in strategic discussions and have a significant impact on the company's database infrastructure and performance.
• Competitive salary and benefits package with opportunities for growth.

If you're a seasoned database architect with a passion for performance, scalability, and security, we'd love to hear from you!

Apply now and be part of our journey toward innovation and excellence!