Vice President - Database Architect (PSS07608)

About the Client:

PSS has been mandated to hire an experienced Database Architect with deep expertise in PostgreSQL and Oracle RAC to lead database architecture and operations for a a leading Indian financial technology company headquartered in Chennai. The company specializes in providing advanced software solutions for banking, insurance and other financial services sectors across the globe.

Role Overview: This role 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:

In-depth knowledge of Oracle RAC, standalone databases, and Primary vs Standby setups (both physical and logical).
Expertise in PostgreSQL (8+ years), and overall experience of 15+ years in database management.
Strong skills in performance tuning, data modeling, and query optimization.
Proficient in tools like SQLPlus, SQL Developer, SQLLoader, and technologies like Materialized Views, Explain Plan, SPM, and PL/SQL.
Good understanding of database metrics, MIS reporting, and resource/task management.
Proven experience with Oracle 19c+ installation, Disaster Recovery (DR) drills, and security & compliance protocols (e.g., TDE, PII masking).
Leadership qualities to manage cross-functional teams, support functions, and communicate with clients and auditors effectively.

Key Responsibilities:

Lead and mentor the database team handling business-as-usual (BAU) and production environments.
Define KRAs, manage performance appraisals, and plan support rosters.
Design and implement PostgreSQL & Oracle RAC systems with a focus on reliability and scalability.
Oversee production support, resolve issues swiftly, and minimize downtime.
Optimize database performance using AWR, ADDM, and SAR reports.
Plan and execute upgrades, year-end activities, DR drills, and migrations.
Implement security protocols like TDE, Redaction, and Compliance Mandates.
Collaborate with internal teams to deliver customized database solutions.
Participate in strategic discussions with clients, banks, and auditors.
Continuously drive automation, process improvements, and service-level enhancements.

Why Join?

Lead mission-critical database architecture in a fast-growing product-based tech company.
Work alongside top-tier database professionals and make a real impact.
Be part of strategic initiatives shaping the company’s future.
Enjoy a competitive salary, growth opportunities, and an innovation-driven culture.

#LI-NV1