Soumya Sundar Das

Soumya Sundar Das Professional Summary: I am a database consultant with more than 9 years of experience. I have broad experience in the areas of various database system namely; Oracle , MySQL , MSSQL , PostgreSQL etc. Recently I have been recognized with Oracle Ace Associate award issued by Oracle Ace Program. I am also contributing to oracle community since 2014 by posting various technical posts related to databases, EBS, Fusion Middleware on https://dbasoumya.blogspot.com/ In the last 3.5 years I have been helping customers in implementation and configuration of different version of Database, with capacity planning for their database and formulation of different deployment architecture. Prior to the above role, I had spent three years in an IT company as a Senior Database administrator role where my responsibility was to handle few overseas clients along with leading a team of 5 DBA’s. Business Skills    Ability to provide leadership, motivation and strategic direction to a project team Equipped with interpersonal, collaboration, and problem solving skills Understand client’s needs; conceptualize the solutions and present and demonstrate them effectively Technical Skills:       Experience as a Database Administrator and Exadata Database machine administrator in Oracle/ Mysql / MSSQL on Linux, AIX , Solaris & Windows Platform. Database High Availability and Disaster Recovery Conversant with Oracle Fusion Middleware Expert in various oracle data migration strategies like export-import, RMAN, cross platform migration using Transportable Tablespace etc. Conversant with Oracle Rac Single node / Multi node Deployment Extensive experience as Oracle Application Technical Administrator in implementation, upgrade and customization of Oracle E-Business Suite Applications (R12, 11i). Organizational Facets Period March’17- Till Date August '13- March’ 17 June ' 11 - July ' 13 Organization Wizertech Informatics Pvt Ltd Kminfosystems E-Team Infocom Pvt Ltd Academic Credentials Bachelor of Computer Application, December 2010 Role Oracle Consultant Oracle DBA Systems Administrator Soumya Sundar Das Certifications         Oracle Cloud Infrastructure 2019 Certified Professional Oracle Cloud Infrastructure 2019 Certified Architect Associate Oracle Autonomous Database Cloud 2019 Certified Specialist Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials Oracle Certified Professional 11g Oracle Certified Professional 10g Oracle Certified Expert, Oracle 12c RAC & Grid Infrastructure Administrator R.H.C.E (Certificate id-) Responsibilities ORGANIZATIONAL EXPERIENCE Company:- Wizertech Informatics Pvt Ltd Since March 2017 Oracle Consultant Job Responsibilities Project Details :Client Role Environment Platform : : : : Eveready Industries Limited Consultant RHEL 6, 11gR2, EBS 12.1.3, Oracle Cloud RHEL on X-86 servers, along with virtualization Responsibilities on Database & Fusion Middleware migration project: This project entailed maintaining databases and E Business suite application running on various environments. An end to end APPS DBA activities involving Cloning, Patching, Performance tuning, space augmentation, OEM integration, DB Management, DB upgradation, migration etc. Following are the work that I performed in the project:  Migration of EBS R12.1.3 & DB 11.2.0.4, ASCP, Demantra , Discoverer from old server to new server  Cloning EBS instance in different environment.  Creation of Data guard between Production EBS on premise instance and Oracle Cloud  Database Performance monitoring and RCA to resolve issues related performance degradation  Reengineering workflow process to mitigate performance issues  Providing recommendation to customer to enablement of Numa support , Providing list of tables with Full table scans, index recommendations, defragmentation of database objects , tuning queries etc.  Patch implementation as per customer’s requirement  Managing & tuning manager, setting processes and scheduling work shifts as per concurrent programs for performance enhancement  Creation of user id and assigning responsibilities  Registration of Concurrent program, functions, menu, messages, request set, value set using FNDLOAD  Managing and troubleshooting of oracle workflows and alerts  Automating different jobs using shell script  Migration of PROD instance into new hardware  Troubleshooting issues related to migration Soumya Sundar Das Project Details :Client Role Environment Platform : : : : R S Software Consultant RHEL 6, 11gR2, EBS , Oracle Rac One node RHEL on X-86 servers, along with virtualization Responsibilities on Database Rac One node installation project : This project entailed migration Oracle Database 11.2.0.4 and EBS 12.1.3 from Old Server to a New Server. Following are the work that I performed in the project:  Deployment of pre-migration steps to make database & application ready for the migration.  Deployment of preclone on Database Server & Application Server for migration to the new Server.  Initialization of Database & EBS Backup on source environment and transition of backups into new server.  Initialization of adcfgclone to register Database on new server  Restoration of Database backup in new server  Initialization of adcfgclone to register Application on new server  Post migration activities Project Details :Client Role Environment Platform : : : : Hindalco Industries Pvt Ltd , Belur Consultant Aix 5.3/6.1, Oracle 9i/10gR2, EBS 11i IBM Power Server Responsibilities on Database Upgradation from old power server to new server on premise project : This project entailed of upgradation of Oracle 9i Database to 10g and migration of entire Database and Application Stack from deprecated Power Server running on 5.3 to New Power Server running on 6.1 on premise. Following are the work that I performed in the project:  Deployment of Pre upgrade steps to make database ready for the upgrade on old server  Deployment of various Rapid clone Patches & Developer 6i Patches.  Installation of Oracle 10g Binary, Companion CD & patches  Deployment of database upgrade from 9.2.0.6 to 10.2.0.5  Deployment of Post upgrade steps and making components ready for preclone activity  Deployment of preclone on dbTier and appsTier for final migration to new server running on 6.1 server  Transition of Application Tier and Data Tier from IBM Aix 5.3 server to Aix 6.1 server  Initialization of adcfgclone to register the application & database on new IBM Server running on Aix 6.1  Deployment of Post Upgrade activities  Creation and configuration of Disaster Recovery (DR) using manual Data Guard. Soumya Sundar Das Project Details :Client Role Environment Platform : : : : Govt. Kolkata Municipal Corportation , Finance Dept Consultant Windows, Oracle 10gR2, Oracle Application Server, Forms and Reports RHEL on X-86 servers, along with virtualization Responsibilities on Database and Application Server & Forms and Reports Migration project : This project entailed migrating an Oracle based application from an old and deprecating server to a new server, after properly virtualizing the new server so that an older version of operating system can be installed on the guest VMs to accommodate the older version of Oracle database (10g) and Oracle application server (10g) Following are the work that I performed in the project:  Installation of Oracle Database and Configuration of 2 Node Rac & Oracle Application server, Forms and Reports on the virtual machines designated for the same  Creating proper tablespaces and the relevant users in the database for migration  Migrating the data from the old database to the new database using Oracle data pump  Automating the Oracle forms recompilation and redeployment process, for redeploying all the existing Forms and Reports on the new Oracle Application Server platform  RAC Failover testing  Mitigating the challenges cropping up during the application migration (Forms and reports)  Manual Data guard configuration and automating the synchronization process through shell script. Project Details :Client Role Environment Platform : : : : Tata Bluescope Steel Consultant RHEL 7, 12cR2, Oracle Fusion Middleware RHEL on X-86 servers, along with virtualization Responsibilities on Database & Fusion Middleware migration project: This project entailed creating Oracle Database infrastructure along with Oracle Fusion Middleware installation on HPE ProLiant DL360 Gen10 server. Migration of Oracle Database running on 10g to 12c and Forms and reports running from old iAS 10g to Weblogic 12c. . Following are the work that I performed in the project:        License Optimization of all assets available Capacity planning for Production, QA, Dev and DR environment. Installation of RHEL 7 on virtual machine and configuring it for oracle Database and Fusion Middleware. Creation of Physical Standby Database Provision of high availability between Database and weblogic Failover & Switchover testing of Database and Application Providing backup solution for databases and application Soumya Sundar Das Project Details :Client Role Environment Platform : : : : Calcutta Electric Supply Corporation (CESC) Consultant Solaris 11, 10gR2, 11gR2, 12cR2 Oracle Super Cluster 2 node T5-8 Half rack , Oracle ZFS Storage Responsibilities on end to end Database administration activities: Following are the work that I performed in the project: Module 1: Database Consolidation planning & Implementation Following are the work that I performed in this module:  Planning and implementation of Database Resource Manager a) Create resource plans b) Create resource consumer groups c) Create resource plan directives d) Grant switch privilege for resource consumer groups to users or roles e) Assign users to resource consumer groups f) Specify a plan to be used by the instance  Planning and implementation of I/O Resource Manager a) b) c) d) Create IORM plan on each cell node. Activating the IORM plan Checking status of IORM plan Monitoring different I/O load metrics using cellcli command  Planning and implementation of Instance Caging on existing databases. a) Enabling Resource manager plan b) Setting proper CPU_Count parameter for aligning max cpu number an instance can use c) Resolving performance bottleneck d) Performance tuning of Databases Module 2:      Overall Active Data Guard planning in 2 node Rac . Performance tuning of Rac Database and providing RCA of various problem. Providing guidance related to Exadata database administration Performance optimization Ensuring high availability of databases to reach 99% database uptime SLA management Soumya Sundar Das Module 3: Hardware augmentation and storage space Augmentation and Administation on Exadata Storage a) Overall planning for space augmentation from default allocation of exadata storage b) Finding out the RAW disk space available in physical disks c) Finding out free space available in celldisk d) Increasing the size of Grid disks in every storage cells e) Increasing the size of ASM disks f) Extracting and uploading support bundle from ILOM to SR in case of storage failure g) Restarting Exadata Cell Nodes Module 4: Cross platform Database migration planning a) Overall planning to migrate database from Non Exadata platform to Exadata b) Cross platform migration of databases between different endianness from Supercluster to Oracle Cloud(OCI) Project Details :Client Role Environment Platform : : : : Fiat India Automobiles Private Limited Consultant Windows Server 2008/2012, SQL Server 2008/2012, Oracle 11gR2 Windows on X-86 Server, along with virtualization Responsibilities on Database Performance Tuning of on premise Database project : This project entailed of performance tuning of various SQL Server Database running on premise. Following are the work that I performed in the project:  Preparing the SQL Server inventory consisting various details related to SQL Server  Creating the SOP for daily administration.  Automating Database health checkup script .  Performing Root cause analysis on various Sql Server  Creating report based on Analysis performed on database.  Sharing performance improvement recommendations on SQL Server  Performing Root cause analysis on various Oracle Database.  Sharing performance improvement recommendations on Oracle Database Project Details :Client Role Environment Reports Platform : : : : Sarda Plywood Consultant RHEL 5, 11gR2, Oracle Weblogic Suite, Oracle Forms and RHEL on X-86 servers, along with virtualization Responsibilities on Database and Forms and Reports Migration project : Soumya Sundar Das This project entailed migrating an Oracle based application from an old and deprecating server to a new server. The migration consisted of migration and up-gradation of Oracle database and migrating the Oracle forms and reports running on Oracle Application Server to Oracle Weblogic suite Following are the work that I performed in the project:  Installation of Oracle Database and Oracle Weblogic server, on the virtual machines designated for the same  Creating proper tablespaces and the relevant users in the database for migration  Migrating the data from the old database to the new database using Oracle data pump  Recompiling the existing forms and reports in the new Weblogic environment  Redeploying the forms and reports in the Forms and Reports runtime on Weblogic suite  Automating the Oracle forms recompilation and redeployment process, for redeploying all the existing Forms and Reports on the new Weblogic platform Project Details :Client Role Environment Platform : : : : Biecco Lawrie Consultant Windows, Oracle 10gR2, Oracle Application Server, Forms and Reports RHEL on X-86 servers, along with virtualization Responsibilities on Database and Application Server & Forms and Reports Migration project : This project entailed migrating an Oracle based application from an old and deprecating server to a new server, after properly virtualizing the new server so that an older version of operating system can be installed on the guest VMs to accommodate the older version of Oracle database (10g) and Oracle application server (10g) Following are the work that I performed in the project:  Installation of Oracle Database and Oracle Application server, Forms and Reports on the virtual machines designated for the same  Creating proper tablespaces and the relevant users in the database for migration  Migrating the data from the old database to the new database using Oracle data pump  Recompiling the existing forms and reports , Pro*C objects in the new application environment  Redeploying the forms and reports in the newly installed Oracle Application Server environment  Automating the Oracle forms recompilation and redeployment process, for redeploying all the existing Forms and Reports on the new Oracle Application Server platform Project Details :Client Role Environment Platform : : Saf Fermion : Consultant : Windows Server 2012, SQL Server 2016 , IIS AWS EC2 instance Responsibilities on Database migration from on premise to cloud project : This project entailed migrating of SQL Server Databases and IIS application running at on-premise to AWS Cloud EC2 instance. Following are the work that I performed in the project:  Taking full backup of on premise’s SQL Database and IIS application  Transferring the backup into Cloud Soumya Sundar Das      Creation of EC2 instance on AWS Platform Installation of SQL Server and configuration Database & Application restoration. Final cut over and making it live. Automating database backup process and uploading to S3 bucket. Kminfosystems- A unit of Livewire IT Services August 2013- March 2017 System & Database Administrator Job Responsibilities  I was a part of our DBA team and was actively responsible for implementing, managing & providing Oracle and MYSQL & MSSQL Database related all kind of support for our 24x7 production database all over the world.  Used to manage more than 20+ production oracle databases present in all over the world which are based on cloud through AMAZON WEB SERVICES (AWS).  Configuration of Oracle databases as per new requirements.  Daily check up of alert log for all databases including primary and standby databases.  Extensively used DBA Utilities, RMAN, Oracle Enterprise Manager, SQL*Loader, and Export/Import, Performance Monitoring, Backup & Recovery.  Creating New users, Granting privileges to Users, storage management, taking backup and database recovery.  Coordinating with developments team to implement schema objects and schema migration from dev to prod databases.  Implementation of shell scripts to automate the procedures to generate statistics on Database Space Management, Performance , backup report for Oracle and Mysql , MSSQL server, shell script for Rman backup, to check Data guard log-gap , Golden gate status check-up and records monitoring ,Mysql Replication monitoring, Server availability and system status check-up monitoring etc.  Databases refresh activity from PROD to DEV.  Configuring Data guard as per client requirement between of different zone databases as Disaster recovery (DR) activity.  Implementation of 3 way bidirectional Golden gate (Schema level and table level replication) between 3 servers.  Synchronizing Golden gate between 3 different zone databases.  Mysql installation on different server.  Percona XtraDB galera clustering between 4 nodes.  SQL Server Backup , Restoration & Migration . Strengths: Team work, Confident and poised in interactions with individuals at all levels, Organizing Skills, Quick learner, Welcoming & cheerful nature able to multi- task effectively. Declaration: I hereby declare that the information furnished above is true to the best of my knowledge. Date: Place: Howrah, West Bengal ______________________ (Soumya Sundar Das)