ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo

ChaitanyaPrati

•Download as DOC, PDF•
•
Chaitanya Prati
Chaitanya Prati

This document provides a summary of Chaitanya Prati's work experience and qualifications. He has over 10 years of experience as an Oracle DBA providing support for multi-terabyte Oracle databases. Currently he works as an onsite technical lead for Wipro Technologies providing Oracle database administration support to Citigroup. His responsibilities include managing critical compliance applications, implementing GoldenGate replication, and resolving performance issues. He is proficient in technologies like Oracle RAC, ASM, GoldenGate and tools like SQL*Plus and Toad.

1 of 7
Download to read offline
Page 1 of 7 Chaitanya Prati Email ID: chaitanyaprati@gmail.com Mobile: +1 813 340 1610 Work Summary • More than 10 years of experience as Oracle DBA, provided frontline DBA support for 24X7 production and development support on Multi-terabyte 11gR2/11g/10g/9i/8i RAC and Non- RAC databases. First stabilizing critical and/or deteriorating situations then working toward permanent self-sufficiency, stability, and maintaining defined/expected service levels. • Proficient in Oracle Database Design & Administration, Backups & Recoveries, Performance Monitoring & Tuning and Shell Scripting. Good experience in Oracle RAC, ASM, OEM and Data Guard implementation and administration. • 3+ years of experience on 11gR2 GOLDENGATE setup for RAC and Non-RAC databases. Troubleshooting GoldenGate lag and finding a resolution for them. • Good practice in UNIX environments with EMC SAN Storage Systems, VERITAS Net backups, VERITAS Cluster environments on Midrange to Enterprise servers. • Experienced on Linux, AIX and Solaris with Oracle10g/11g/11gR2 RAC (Real Application Clusters), including all options for storage and justifications for deployment. • Good history of creative, maintainable, and robust application-development solutions using UNIX shell scripting and SQL. • Experience and knowledge with different PeopleSoft modules (HRMS & Financial) needed to support business critical applications. Currently working as Onsite Technical Lead in Oracle Administration with WIPRO Technologies, Texas providing Oracle database administration support to CITIGROUP having mission critical business environments both in RAC and non-RAC environments. Highlighting are few projects that I carried out pertaining to Designing/Solution providing. • Currently working on CitiScreening Project which is very critical for Citigroup in monetary terms. Implemented Bi/Unidirectional GoldenGate as part of replication set up. • Was instrumental in building up of Active-Passive Clusterware database on Linux platform. Installed ASM and on top of that 11gR2 database. Initiated from start with Meetings and discussions with Application team on the type of database (Cluster or RAC). Discussions included the criticality of Application data and its size. Depending on that advised them to go with Cluster which was beneficial in terms of cost incurred. • Improved performance of a database by closely working with Application team by having daily meetings to discuss the status of the workarounds implemented and parameters that was changed. These changes included, aligning jobs to different time zones, implementing SQL profile for SQLs that were performing badly, creating indexes on columns that were vastly used and had Full Table Scans and few other things. • Implemented Oracle’s Advanced Security Options (ASO) for an Application holding Citigroup’s (critical) LEGAL data. Prepared POC regarding the steps involved and the work that would be required from System Administrator and Application team. • Provided design steps and solutions on Solaris to AIX migration along with database upgrade from 9i to 10g. Prepared POC for the same.
Page 2 of 7 EDUCATION • B.E Mechanical Engineering from Mumbai University TECHNICAL SKILLS • RDBMS : Oracle 11gR2 and 11gR1/10g/9i/8i/8.x. Oracle RAC 11gR2. Oracle GoldenGate 11g • Operating System : Sun Solaris 5.6/5.8, IBM AIX 5.2, HP-UX, REDHAT Linux 2.1/ES- AS 3/4, Windows 95/98/2000/NT • Languages : PL/SQL, C++ • Tools : RAC, Oracle Golden Gate, RMAN, ASM, Tivoli, BMC Software for Backup and Monitoring, Oracle Enterprise Manager, Toad, SQL Navigator, Terminal Services, Putty, OEM, Log Miner, STATSPACK, SQL Loader, TkProf, Import/Export, SQL*Plus, WinSCP and other third party tools. ORACLE TRAININGS ATTENDED • Oracle 10g New Features • Oracle 10g Enterprise Manager • Oracle 10g Performance Tuning • Oracle 11g New Features • Oracle 11gR1 RAC PROFESSIONAL EXPERIENCE Presently working as Onsite Technical Lead in Oracle Administration with WIPRO Technologies (Previously it was Citi Technology Services) from Feb. 2007 till date. RESPONSIBILITES IN WIPRO TECHNOLOGIES Feb 2007 - Till Date Started at Wipro Technologies (then it was Citi Technology Services) as Database Administrator in a team of 10 managing more than 700 databases (PROD/UAT/DEV/COB). Current responsibilities include handling CitiScreening Application as a GLOBAL DBA. Experience in Wipro involves –
Page 3 of 7 • More than 6 years of experience in WIPRO as Oracle DBA, provided frontline DBA support for 24X7 production and development support on Multi-terabyte 11gR2/11g/10g/9i/8i RAC and Non-RAC databases. First stabilizing critical and/or deteriorating situations then working toward permanent self-sufficiency, stability, and maintaining defined/expected service levels. • Experience in creating and supporting 11.2.0.3 Oracle Single instance using Active/Passive Configuration without RAC. • Database build, refresh, restore, backup using RMAN • Experience and knowledge with different PeopleSoft modules (HRMS & Financial) needed to support business critical applications • Good experience in Transportable Table spaces, SQL Tuning Advisor, Data Pump, Flashback Table, Table space Management and Materialized Views. • Implemented ASM in many servers. • Implementing scripts and alerts across all servers and databases as per Standards. • Organizing frequent calls with Business for our applications to know about current and future activities and also in discussing any issues occurred. • Taken ownership for VTMs/Orasecure/Fortinet getting implemented in all our supported databases. • Prepare Plan of Action (POA) for specific activities as per project standards. • Regularly attending meetings with Client. • No issues major/minor is reported. • Guide the team about the process for any specific work. • All mails and tickets are acknowledged and worked upon. • Coordinating work between onsite and offshore team. • Helping my manager in preparing MIS reports. As part of Corporate Database Management (CDM) team, carried out many major activities. • Involved in re-org couple of Oracle 9i databases involving LOBs using Export/Import. One 330GB database was reduced by 121 GB. The other was 220GB database which was reduced by 90GB. • Part of each and every COB activity that came during my tenure. As a lead coordinated COB activity for all of our critical applications that was carried out simultaneously. • Carried out Tablespace level Re-org using transportable tablespace method. • Did Re-org using export/import of Partitioned Tables.
Page 4 of 7 As part of Corporate Database Management (CDM) team, carried out few successful projects. PROJECT 1 – Oracle 11g RAC Database Creation • As part of Build Team, created RAC databases using private IPs, public IPs and scan IPs. These RAC databases were part of critical Compliance Applications like AML-NS Monitoring, Global Interdict (Latam), STE Docs and ICG Docs and CitiScreening. • Created Standby (COB) database for STE and ICG Docs Prod databases on RAC. • Troubleshooting performance issues on RAC using AWR report • Resolve issues encountered during weekend reboot or after SA tasks. PROJECT 2 – Oracle 11g Golden Gate Implementation • Leading CitiScreening Application on a GLOBAL level. This application is based across NAM, Poland, EMEA, ASIA Pacific, Mexico, China and many more are in pipeline. • As part of Build Team, implemented GoldenGate on RAC databases that were part of critical Compliance Applications like AML-NS Monitoring, Global Interdict (Latam) and CitiScreening. • GoldenGate setup was bi-directional replication. They wanted this set up because of critical data flowing across both data centers. • Plan GoldenGate setup to achieve Bi/Unidirectional replication. • SAN storage, GoldenGate software version, type of data/tables that will be moved are some basics that needs to be discussed before going ahead with implementation. • Setup GoldenGate Database User with necessary privileges • Installed GoldenGate on testing environments to perform POC. • Prepare GoldenGate parameter files for Extraction and Replication • Implementing monitoring scripts for GoldenGate processes and lag. • Investigate Replication failures using LogDump utility • Test initial Data Load option of GoldenGate during environment build • Identify risks involved with replicating highly volatile tables with large data volume PROJECT 3 – Resolving Quick Screen Performance Issue
Page 5 of 7 • Resolving Performance issue for Quick Screen Application where the columns in SQL statement were not indexed properly. • Many SQLs were tuned and restructured. • Scheduled jobs in different time zones to avoid heavy load on server. PROJECT 4 – Solaris to AIX Migration • Part of a 2 member team that carried out Solaris to AIX migration for Citigroup Employee Portal application. Citigroup Employee Portal is a very complex application in CITI involving coordination between 36 teams. So we used to have weekly 2 calls to see that all teams are on the same page • Database was upgraded from Oracle 9i to 10g. • This also involved installation of Orasecure and DBvault. • There were few performance issues after migration which was resolved using new 10g features. . PROJECT 5 – Solaris to AIX Migration • Almost single handedly carried out Solaris to AIX migration of Esourcing Intranet database taking into consideration space issues. • Involved installation of Orasecure and DBvault. • This was carried out without any performance issues. PROJECT 6 – Oracle 11g Cluster Database Creation • Carried out 11g cluster database creation on Linux server using VIP. • Created Standby database too for the same. RESPONSIBILITES IN CLOVER TECHNOLOGIES PVT LTD. Nov 2007 – Feb 2007 In Clover Technologies started as Trainee in Database Administration in a team managing different clients having PROD/UAT/DEV/COB databases. ORACLE DBA • Installation & creation of Oracle software & database. • Logical & physical database designing.
Page 6 of 7 • Capacity planning. • Database Hardening. • Backup strategy. • Proactive monitoring through scheduled visits. • Disaster recovery. • Performance tuning. • Maintenance activity on production databases. • Creation and maintenance of oracle users. • Handling various troubleshooting calls for production databases. • Auditing existing critical production databases to implement strategies for optimum performance. • Cross OS platforms & Oracle version migration to desired levels in critical environment. • Database purging. • Database cloning. • Designing physical storage clause for tables/indexes and creating all database objects. • Creating physical layout of database and placement of files on various disk devices. • Database Replication using Materialized Views. DR Solutions – Oracle 10g/9i dataguard and 8i standby database Skills: • Oracle 9i dataguard/8i Standby implementation according to business criticality on UNIX, Windows 2000 server. • Server sizing and n/w bandwidth planning for DR • Trouble shooting errors in dataguard environment • 9i dataguard management – Switchover and fail over in critical situation. CUSTOMERS SITES HANDLED IN CLOVER TECHNOLOGIES PVT LTD. • Kotak Mahindra Bank Ltd. • Hutchison Essar • Man Financial solutions
Page 7 of 7

More Related Content

ChaitanyaPrati

  • 1. Page 1 of 7 Chaitanya Prati Email ID: chaitanyaprati@gmail.com Mobile: +1 813 340 1610 Work Summary • More than 10 years of experience as Oracle DBA, provided frontline DBA support for 24X7 production and development support on Multi-terabyte 11gR2/11g/10g/9i/8i RAC and Non- RAC databases. First stabilizing critical and/or deteriorating situations then working toward permanent self-sufficiency, stability, and maintaining defined/expected service levels. • Proficient in Oracle Database Design & Administration, Backups & Recoveries, Performance Monitoring & Tuning and Shell Scripting. Good experience in Oracle RAC, ASM, OEM and Data Guard implementation and administration. • 3+ years of experience on 11gR2 GOLDENGATE setup for RAC and Non-RAC databases. Troubleshooting GoldenGate lag and finding a resolution for them. • Good practice in UNIX environments with EMC SAN Storage Systems, VERITAS Net backups, VERITAS Cluster environments on Midrange to Enterprise servers. • Experienced on Linux, AIX and Solaris with Oracle10g/11g/11gR2 RAC (Real Application Clusters), including all options for storage and justifications for deployment. • Good history of creative, maintainable, and robust application-development solutions using UNIX shell scripting and SQL. • Experience and knowledge with different PeopleSoft modules (HRMS & Financial) needed to support business critical applications. Currently working as Onsite Technical Lead in Oracle Administration with WIPRO Technologies, Texas providing Oracle database administration support to CITIGROUP having mission critical business environments both in RAC and non-RAC environments. Highlighting are few projects that I carried out pertaining to Designing/Solution providing. • Currently working on CitiScreening Project which is very critical for Citigroup in monetary terms. Implemented Bi/Unidirectional GoldenGate as part of replication set up. • Was instrumental in building up of Active-Passive Clusterware database on Linux platform. Installed ASM and on top of that 11gR2 database. Initiated from start with Meetings and discussions with Application team on the type of database (Cluster or RAC). Discussions included the criticality of Application data and its size. Depending on that advised them to go with Cluster which was beneficial in terms of cost incurred. • Improved performance of a database by closely working with Application team by having daily meetings to discuss the status of the workarounds implemented and parameters that was changed. These changes included, aligning jobs to different time zones, implementing SQL profile for SQLs that were performing badly, creating indexes on columns that were vastly used and had Full Table Scans and few other things. • Implemented Oracle’s Advanced Security Options (ASO) for an Application holding Citigroup’s (critical) LEGAL data. Prepared POC regarding the steps involved and the work that would be required from System Administrator and Application team. • Provided design steps and solutions on Solaris to AIX migration along with database upgrade from 9i to 10g. Prepared POC for the same.
  • 2. Page 2 of 7 EDUCATION • B.E Mechanical Engineering from Mumbai University TECHNICAL SKILLS • RDBMS : Oracle 11gR2 and 11gR1/10g/9i/8i/8.x. Oracle RAC 11gR2. Oracle GoldenGate 11g • Operating System : Sun Solaris 5.6/5.8, IBM AIX 5.2, HP-UX, REDHAT Linux 2.1/ES- AS 3/4, Windows 95/98/2000/NT • Languages : PL/SQL, C++ • Tools : RAC, Oracle Golden Gate, RMAN, ASM, Tivoli, BMC Software for Backup and Monitoring, Oracle Enterprise Manager, Toad, SQL Navigator, Terminal Services, Putty, OEM, Log Miner, STATSPACK, SQL Loader, TkProf, Import/Export, SQL*Plus, WinSCP and other third party tools. ORACLE TRAININGS ATTENDED • Oracle 10g New Features • Oracle 10g Enterprise Manager • Oracle 10g Performance Tuning • Oracle 11g New Features • Oracle 11gR1 RAC PROFESSIONAL EXPERIENCE Presently working as Onsite Technical Lead in Oracle Administration with WIPRO Technologies (Previously it was Citi Technology Services) from Feb. 2007 till date. RESPONSIBILITES IN WIPRO TECHNOLOGIES Feb 2007 - Till Date Started at Wipro Technologies (then it was Citi Technology Services) as Database Administrator in a team of 10 managing more than 700 databases (PROD/UAT/DEV/COB). Current responsibilities include handling CitiScreening Application as a GLOBAL DBA. Experience in Wipro involves –
  • 3. Page 3 of 7 • More than 6 years of experience in WIPRO as Oracle DBA, provided frontline DBA support for 24X7 production and development support on Multi-terabyte 11gR2/11g/10g/9i/8i RAC and Non-RAC databases. First stabilizing critical and/or deteriorating situations then working toward permanent self-sufficiency, stability, and maintaining defined/expected service levels. • Experience in creating and supporting 11.2.0.3 Oracle Single instance using Active/Passive Configuration without RAC. • Database build, refresh, restore, backup using RMAN • Experience and knowledge with different PeopleSoft modules (HRMS & Financial) needed to support business critical applications • Good experience in Transportable Table spaces, SQL Tuning Advisor, Data Pump, Flashback Table, Table space Management and Materialized Views. • Implemented ASM in many servers. • Implementing scripts and alerts across all servers and databases as per Standards. • Organizing frequent calls with Business for our applications to know about current and future activities and also in discussing any issues occurred. • Taken ownership for VTMs/Orasecure/Fortinet getting implemented in all our supported databases. • Prepare Plan of Action (POA) for specific activities as per project standards. • Regularly attending meetings with Client. • No issues major/minor is reported. • Guide the team about the process for any specific work. • All mails and tickets are acknowledged and worked upon. • Coordinating work between onsite and offshore team. • Helping my manager in preparing MIS reports. As part of Corporate Database Management (CDM) team, carried out many major activities. • Involved in re-org couple of Oracle 9i databases involving LOBs using Export/Import. One 330GB database was reduced by 121 GB. The other was 220GB database which was reduced by 90GB. • Part of each and every COB activity that came during my tenure. As a lead coordinated COB activity for all of our critical applications that was carried out simultaneously. • Carried out Tablespace level Re-org using transportable tablespace method. • Did Re-org using export/import of Partitioned Tables.
  • 4. Page 4 of 7 As part of Corporate Database Management (CDM) team, carried out few successful projects. PROJECT 1 – Oracle 11g RAC Database Creation • As part of Build Team, created RAC databases using private IPs, public IPs and scan IPs. These RAC databases were part of critical Compliance Applications like AML-NS Monitoring, Global Interdict (Latam), STE Docs and ICG Docs and CitiScreening. • Created Standby (COB) database for STE and ICG Docs Prod databases on RAC. • Troubleshooting performance issues on RAC using AWR report • Resolve issues encountered during weekend reboot or after SA tasks. PROJECT 2 – Oracle 11g Golden Gate Implementation • Leading CitiScreening Application on a GLOBAL level. This application is based across NAM, Poland, EMEA, ASIA Pacific, Mexico, China and many more are in pipeline. • As part of Build Team, implemented GoldenGate on RAC databases that were part of critical Compliance Applications like AML-NS Monitoring, Global Interdict (Latam) and CitiScreening. • GoldenGate setup was bi-directional replication. They wanted this set up because of critical data flowing across both data centers. • Plan GoldenGate setup to achieve Bi/Unidirectional replication. • SAN storage, GoldenGate software version, type of data/tables that will be moved are some basics that needs to be discussed before going ahead with implementation. • Setup GoldenGate Database User with necessary privileges • Installed GoldenGate on testing environments to perform POC. • Prepare GoldenGate parameter files for Extraction and Replication • Implementing monitoring scripts for GoldenGate processes and lag. • Investigate Replication failures using LogDump utility • Test initial Data Load option of GoldenGate during environment build • Identify risks involved with replicating highly volatile tables with large data volume PROJECT 3 – Resolving Quick Screen Performance Issue
  • 5. Page 5 of 7 • Resolving Performance issue for Quick Screen Application where the columns in SQL statement were not indexed properly. • Many SQLs were tuned and restructured. • Scheduled jobs in different time zones to avoid heavy load on server. PROJECT 4 – Solaris to AIX Migration • Part of a 2 member team that carried out Solaris to AIX migration for Citigroup Employee Portal application. Citigroup Employee Portal is a very complex application in CITI involving coordination between 36 teams. So we used to have weekly 2 calls to see that all teams are on the same page • Database was upgraded from Oracle 9i to 10g. • This also involved installation of Orasecure and DBvault. • There were few performance issues after migration which was resolved using new 10g features. . PROJECT 5 – Solaris to AIX Migration • Almost single handedly carried out Solaris to AIX migration of Esourcing Intranet database taking into consideration space issues. • Involved installation of Orasecure and DBvault. • This was carried out without any performance issues. PROJECT 6 – Oracle 11g Cluster Database Creation • Carried out 11g cluster database creation on Linux server using VIP. • Created Standby database too for the same. RESPONSIBILITES IN CLOVER TECHNOLOGIES PVT LTD. Nov 2007 – Feb 2007 In Clover Technologies started as Trainee in Database Administration in a team managing different clients having PROD/UAT/DEV/COB databases. ORACLE DBA • Installation & creation of Oracle software & database. • Logical & physical database designing.
  • 6. Page 6 of 7 • Capacity planning. • Database Hardening. • Backup strategy. • Proactive monitoring through scheduled visits. • Disaster recovery. • Performance tuning. • Maintenance activity on production databases. • Creation and maintenance of oracle users. • Handling various troubleshooting calls for production databases. • Auditing existing critical production databases to implement strategies for optimum performance. • Cross OS platforms & Oracle version migration to desired levels in critical environment. • Database purging. • Database cloning. • Designing physical storage clause for tables/indexes and creating all database objects. • Creating physical layout of database and placement of files on various disk devices. • Database Replication using Materialized Views. DR Solutions – Oracle 10g/9i dataguard and 8i standby database Skills: • Oracle 9i dataguard/8i Standby implementation according to business criticality on UNIX, Windows 2000 server. • Server sizing and n/w bandwidth planning for DR • Trouble shooting errors in dataguard environment • 9i dataguard management – Switchover and fail over in critical situation. CUSTOMERS SITES HANDLED IN CLOVER TECHNOLOGIES PVT LTD. • Kotak Mahindra Bank Ltd. • Hutchison Essar • Man Financial solutions