Source description
About the role
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 .
More at PSS Global