Saugata Chatterjee Email & Phone Number

Kolkata, West Bengal, India

Currently working as the Tower Lead and POC for the Oracle Exadata,Enterprise Manager,Database for L3/L4 escalations, also working as IBM Pure Data Systems(Netezza) adminCoordinating and executing multiple client projects and Application go-lives and providing Oracle consulting solution and Exadata Patching activities.EXADATA CLOUD @ CUSTOMER TASK DETAILS:-Worked as Oracle platform Migration expert from Exadata On-Prem to Exadata Cloud @ Customer X9M and X10M Designed the Exadata Cloud @ Customer platform for hosting VMs and DatabasesWorked with Oracle as a POC for taking delivery of the Exadata Cloud @ Customer Machines to the DatacenterWorked on implementing OS-HardeningHands on experience on working extensively and End-to-End on Exadata Cloud @ Customer platform Worked on Design,Planning and Implementation of the database migration from Exadata On-Prem to Exadata Cloud @ CustomerEXADATA TASK DETAILS:-The tasks performed for the project is as follows• Working as a POC for Exadata escalations,Patching,Consulting• Providing Consultation for Oracle Database platform for Mission critical databases• Enabling the users to work on and use Oracle Enterprise Manager 13c• Implementation of new Exadata Machine at customer datacenter• Working closely with Oracle for regular maintenance of Exadata machine, hardware issues• As an Exadata Machine Admin (DMA) role is to involve in consultation solution for future roadmap of the customer• Staying in constant touch with Datacentre Team for any maintenance activity related to Exadata machine• Providing end-to-end support for Exadata Storage Server,Exadata Database Server, Oracle Grid,Oracle ASM and Oracle Databases running on Exadata machineApart from the above mentioned I am also involved in all the activities, which an Oracle Database Admin has to perform along with working as an OEM architect for providing consultation on using OEM to its full potential and all its features

Performing regular DBA tasksPerforming daily server health checkup by checking the Log files and AWR reportsMaintenance of database objects using TOAD and PLSQL DeveloperPerforming daily backup of the servers using RMAN and ExportHandling client calls regarding database issuesHandling and Managing RAC databasesHandling oracle Forms and ReportsManaging Oracle Application Server for various clientsMaintaining Active Datagaurd databases for different clientsRegular client side visit for database health checkupPerforming database objects manipulationsfor checking VALID and INVALID objects and validating INVALID objects using SQL commandFine tuning the databases on regular intervals using various tools and techniquesUsing Data recovery advisor for data recovery advisories and SQL tuning advisor for tuning the SQL queriesUsing SQL access advisor for the creation of indexes and materialized views which will improve system performancePerforming occasional database refresh operations on various client side databasesProjects Worked Upon:-DATABASE MIGRATION FROM 8i TO 11G FOR ACCOUNTANT GENERAL OF INDIAThe project is to migrate the database as well as the application from 8i Database and Forms 6 to 11g Database and Fusion Middleware 11g,its statewise all over india project and total number of databases to migrated was more than 25.TEAM SIZE:-The team comprises of 8 DBA's and 25 DevelopersTASK DETAILS:-Installation of 11g Database and Fusion Middleware components like weblogic server,forms and reports on linux 5.6 64 bit OSTaking backup of old server i.e oracle 8i Database using exportImporting the export into the newly created server i.e oracle 11g DatabaseChecking the database objects and create the missing objects manually Running the Forms and the Reports on to the newly created 11g serverProving training to the site officials about starting,shutting down and regular maintenance of the server

Creating the daily required database objects.Performing daily server health checkup by checking the Log files and AWR reportsHandling of the database and maintaining the details of the employees. Perform regular backup of the database Using RMAN.Fine tuning the databases on regular intervals.Projects worked on:-Creation,maintenance and taking regular backup of the database of the employees of Alvis solutions.which includes the record of the employees, and their details along with their daily entry and exit time record.Creation, maintenance and taking regular backup of the database of a franchisee of PTU(Punjab Technical Education) learning center named as A.R.Services which includes the data of all the teachers, courses offered, and the students.

Role:- Provide training of Personality development to the students of Guru Nanak Institute of Technology and Management in Mullana Ambala (Haryana)