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 .Skills Required
Oracle Rac, Postgresql, Performance Tuning, Data Modeling, Sqlplus, Sql Developer, Sqlloader