PS

Vice President - Database Architect

Pss Global
Chennai7-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 .

Join WhatsApp Channel