Oracle Database Administrator
Projects:Company: SHOPPERS STOP, CRISIL HOUSEMahindra Finance, Direct Team (Multiple Clients like IRS, Kotak Securities Toyo, Religare, SBI securities)Environment: Two Node Rac, Oracle 11g, Linux, Oracle 9i,11g, Linux, Oracle 9i,11g, Linux• Delivered 24*7 support to customers, ensuring continuity and reliability of services• Conducted database refreshes for User Acceptance Testing (UAT) environments to maintain data integrity• Utilized RMAN for hot/cold backup cloning, tailored to specific needs• Oversaw the configuration and maintenance of Disaster Recovery (DR) protocols for Production Instances• Performed DR drills incorporating meticulous Switch Over and Switch Back activities• Carried out schema-level refreshes through logical backup strategies, promoting efficient data handling• Effectively resolved a variety of database-related issues, including blocking sessions, blocking objects, and long-running requests• Conducted daily monitoring and implemented weekly cold backups of databases to maintain data integrity• Performed routine database maintenance activities, including Gathering Statistics and Index Rebuilding• Applied the latest patches to databases, ensuring system stability and up-to-date functionality• Implemented user scripts in both production and UAT environments, supporting user-specific tasks• Regularly brought Disaster Recovery (DR) into sync with production in instances of lag, reducing potential downtime• Enhanced Oracle security through the creation and assignment of specific roles and privileges.• Provided 9 hours of dedicated on-call support to customers, ensuring rapid response to queries• Spearheaded the installation of Oracle 11g on Windows platforms• Administered the purging of alert logs and trace files, and scheduled RMAN and Export backups via Task Scheduler, enhancing system performance and reliability