PSPss Global
Vice President - Database Architect
Chennai ₹7-19 LPA Posted 9 Jul 2025
FULL TIME
Performance Tuning
Data Modeling
Oracle Rac
Sqlplus
Sqlloader
+2 more
Job Description
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 .
