Siddharth Pawar

+1-437-***-**** adwat2@r.postjobfree.com

https://www.linkedin.com/in/siddharth-pawar-6a213459/

** ***** ** ******** ********** in IT industry which includes six years in cloud migration as Cloud Architect, Oracle, and SQL server Database Administration/migration along with 7 years as a project manager, in implementation, migration and steady state support projects. Also, have an experience in database upgradation and data centre migration projects as a Database Architect.

Worked on end-to-end migration of on-prem infrastructure to Aws Cloud using L&S, rehosting, re-platforming, refactoring and retiring migration strategies.

Worked on on-prem infrastructure discovery manually and using tools, from which design the cloud infra considering next five years performance, availability, scalability in mind.

Created milestone documents for project definition and deployments.

Created an infrastructure service design documents which includes the cloud services best suited for the application infrastructure. Work on creating costing and licensing documents for creation of infrastructure on Cloud.

Created interface documents which defines the communication matrix of application to be migrated to the applications on prem and public domains. Created terraform scripts for deployment of infrastructure on cloud.

Migrated the application, database, related dependencies from on-prem to cloud along with all its dependencies. Set up the monitoring on cloud including integration of them with ticketing tools and other dependencies.

Migrated different cross platform large databases using golden gate, MS DMA, AWS DMS, Azure DMS.

Experience in working with Kubernetes cluster and DEVOPS.

Worked and completed golden gate migration of Oracle database, was in TB cross-platform from HPUX to Solaris 11 VM. Also defined and maintained Golden gate table replication setup from Primary to DR and Teradata reporting servers.

Worked on Oracle single instance database and on RAC.

Worked as a data modeller to define new schemas, database objects, referential integrity, indexes, data flow and SQL/PLSQL for data accessibility and DML for applications.

Experience in Creating and supporting all flavours of standby databases like ADG, mount mode, delayed standby databases and snapshot standby database. Experienced FSFO configuration and management of ADG and PR using DGMGRL.

Worked on MS SQL server 5, 8, 12, 14, 16 databases. Worked on Always on availability for SQL server 16. Upgraded Databases from SQL server 2005, 08, 12 to 16. Supported Databases on Azure.

Migrated SQL server databases from lower version to SQL server 16. Configured and maintained on SQL Server mirroring.

Worked on SQL server scale up, scale down. Done Point in time recoveries for some databases. Experience on MS SQL SSIS,

SSAS and SSRS.

Completed configuration of SQL server backup and restore policies for SQL server Databases.

AWS Certified Cloud Practitioner

Azure Solution Architect Expert

AWS certified cloud architect associate

Oracle Cloud Infrastructure 2019 Architect Professional

Oracle Cloud Infrastructure 2019 Architect Associate

Oracle Autonomous Database Cloud 2019 Specialist

Oracle Cloud Infrastructure 2019 Cloud Operations Associate

Oracle Certified Professional DBA.

ITIL foundation 2011.

Prince2 Foundation and Practitioner

Bachelor of Engineering Computer Science and Engineering Amravati University 2001.

TechMahindra Limited Jan2020 to till date

Verizon:

Worked on SRE(Site reliability engineering) project as a Sr. Cloud Architect with client Verizon USA. In the project we created a product which was capable automating AWS cloud rehydration, patching and upgrades of all kinds of databases on cloud and on premises, CI/CD. The project technologies comprise Jenkins, GIT, UX/UI, Databases, AWS, DevOps CI/CD and Middleware.

Pladis:

Worked as a Sr. Cloud Architect. Migrated clients infra by Cloud Endure using L&S method. Worked on Planning and implementation of application and database server from on-prem to cloud. Completed migration of whole datacentre in record time of five and half months.

Telefonica:

Worked with Tech Mahindra Ltd. as a Senior Cloud Architect for telecom client Telefonica Germany on migration client’s application on AWS cloud. Worked on on-prem infrastructure manual discovery, from which design the cloud infra considering performance, availability, scalability in mind. Created milestone documents for project definition and deployments per application. Created an infrastructure service design documents which includes the cloud services best suited for the application infrastructure. Work on creating costing and licensing documents for creation of infrastructure on Cloud. Created interface documents which defines the communication matrix of application to be migrated to the applications on prem and public domains. Created terraform scripts for deployment of infrastructure on cloud. Migrated the application, database, related dependencies from on-prem to cloud along with all its dependencies. Set up the monitoring on cloud including integration of them with ticketing tools and other dependencies. Migrated different cross platform large databases using golden gate, MS DMA, AWS DMS, Azure DMS. Working with Kubernetes cluster and DEVOPS.

Company: QuessCorp Oct 2020 to Dec 2020

Worked as a Cloud Architect with QuessCorp. Worked as a contractor on the Azure migration project of client of Wipro Limited on the payroll of QuessCorp. The client is UK based insurance company.

Company: Technovato Inc Jan 2020 to Aug 2020

Worked as Azure solution architect, database architect and data modular at a client location Ministry of Transport Toronto. Worked on on-prem infrastructure discovery using tools and manually, from which design the cloud infra considering next five years performance, availability, scalability in mind. Created an infrastructure service design documents which includes the cloud services best suited for the application infrastructure. Created interface documents which defines the communication matrix of application to be migrated to the applications on prem and public domains. Created terraform scripts and database migration scripts for deployment of infrastructure on cloud. Migrated the application, database, related dependencies from on-prem to cloud along with all its dependencies. Set up the monitoring on cloud including integration of them with ticketing tools and other dependencies. Written a shell scripts to complete the automation of reports. Worked on data Migration from on premises oracle to Azure SQL databases for development project. Worked on the Azure DEVOPS pipelines to replicate database objects in different environments.

Company: CGI May 2019 to Oct 2019

Worked as OCI architect and Oracle / SQL server migration specialist at Client Encana Inc. Calgary CA. Worked on on-prem infrastructure discovery using tools and manually, from which design the cloud infra considering the future performance, availability, scalability in mind. Migrated the application, database, related dependencies from on-prem to OCI cloud along with all its dependencies.

Completed a scripting for day-to-day operation, Database upgradation, patching, refreshes for Oracle on Linux and SQL server on Windows platform. Worked on installation of Oracle 2 node cluster on Oracle cloud environment and migration of databases to new created Oracle cloud RAC. Worked on a troubleshooting and fixing the issues on SQL and Oracle Databases. Worked on the new processes set up in the projects. Troubleshoot and fixed the database, infra performance issues in oracle and SQL Databases. Worked extensively on database refreshes from production to QA using RMAN, export, import.

Company: TCS Nov 2018 to May 2019

Worked as AWS architect and Oracle and SQL server database Architect. Completed a migration project where SQL server databases were get migrated from old version 5,8,12 to SQL server 2016 on Azure along with applications. Worked on SQL server always on availability on windows cluster. Worked as a data modeller to define new schemas, database objects, referential integrity, indexes, data flow and SQL/PLSQL for data accessibility and DML for new upgrades for an application.

Worked on Migration project where SAP oracle databases are getting migrated to Oracle 12.2. Trained the team member to take over as a DBA. Worked on day-to-day DBA activities like SQL server performance monitoring, troubleshooting and fixing Database issues, database refreshes. The client was Algoma steel Inc. Sault Ste. Marie ON. Set up complete SQL and Oracle Database monitoring using Op’s manager tool.

Company: Atos Global IT solutions Pvt. Limited Nov 2016 to Aug 2018

Designated as a senior consultant (Database SME) in AHS database department, worked as an Oracle Database SME and team mentor for sixteen client projects including major clients Philips and SCB.

Client Projects: Philips

Philips is a Netherlands based electronic instrumentation company.

Role: Senior Oracle DBA/SME.

Domain : Electronics’

Responsibility: Worked as a shared database SME. Worked on high-end issues like design, application performance, P1-P2. Worked as a database architect while designing new environments. Worked extensively on performance tuning of a database, SQL, system, and memory on the database environment. Mentored the database teams, and help them resolve the day to day issues. Worked on Oracle and MYSQL Databases on AWS linux, AIX, Linux, Solaris and HP UX.

Supported more than 16 clients along with Philips resolving the mission-critical issues and helping the team grooming their technical skills. Supported Exadata X3 and X6 storage nodes compute nodes and database instances on compute nodes.

Coordinated support plans for commercial customers with enhanced or premium support offerings. Supported the Oracle Databases on Oracle cloud wherein completed configuration, installation, migration and maintained of the Oracle databases. Scheduled and delivered training to team members and clients as and when obligatory.

Company: TechMahindra Limited May 2014 to Oct 2016

Worked as a Project Manager and Oracle, SQL database SME, Oracle Database architect.

Client Project: Vodafone Australia (Sydney Australia)

Vodafone is the telecom Domain Company is giving services like mobile, broadband, Wi-Fi in Australia.

Role : Project manager/ Database architect

Team size: 16

Domain : Telecom

Responsibility: Worked as a project manager taken care of day-to-day operations, billing, process management, mentor to the team, new project definition and implementation. Worked as a database architect the role includes Planning and implementing, migration, installation, upgradation of the Oracle database from HP-UX to Solaris 11 and Linux VM and AWS. Migrated SQL server databases from on prem to AWS EC2 instance and supported those databases. Built five node Oracle RAC primary and ADG setup on Solaris 11 VM, database version was 11.2.0.4 and the database size was 40TB. Worked on the AWS RDS to configure database server, migrated and supported Oracle database from HP UNIX to Linux. Worked with a BAU team as a database manager and SME resolving mission critical L3/L4 issue. Worked on application, database and system’s performance tuning to fix business critical issues. Migrated and maintained SOA, BRM and Siebel databases.

Company: Infosys Limited Oct 2008 to April 2014

Designated and worked as Project manager and team mentor. Worked with IMS Database team for different client’s projects as below.

Client Project: Apple Sep 2010 to April 2014

Apple is the US based company having products like iPod, iPad, MacBook’s, iPhone, OS like MAC etc.

Role : Project Manager (Oracle DBA)

Team size:38

Domain : Telecom

Responsibility: Worked as a project manager taking care of billing, day to day operations, process implementation, handling escalations, Mentor to the team helping them in the Installation and cloning of binaries, ACFS ASM. Completed the Primary, standby database configuration and done the maintenance. Completed Cloning production database to QA. Worked on a day-to-day database operation, patching and upgradation of binaries and databases. In two years’, time, we built around 4000 database environments to support the business needs. Worked and fixed the Business-critical issues on Primary, ADG, and RAC. Supported Exadata V2 machine’s storage nodes and compute nodes.

Client Project: Viterra.Inc, (Regina SK Canada) Sep 2009 to Aug 2010

Viterra is a one of the largest grain company in Canada.

Role : On-site Database Administrator

Domain : Foodgrains.

Responsibility: Worked as a data modeller for addition of schemas, database objects, referential integrity, indexes, data flow and SQL/PLSQL for data accessibility and DML for addition of new functionality in existing application.

Worked as on-site Oracle database administrator on Linux and mainframe and SQL Server DBA on Windows platform in Regina. Viterra wants to migrate their 9i database from Zos (Mainframe) to Linux and upgrade to 11g. I planned and implemented the procedure of migration and upgradation of databases. Also worked on day-to-day operations like space usages handing, production implementations, PT, SQL tuning, database cloning, Patching and upgrade the binaries and databases. New project plan and implementations like OTM, CAMS, and Oracle fusion databases.

Client Project: PWC (PricewaterhouseCoopers) Nov 2008 to Aug 2009

PWC bring a global perspective along with in-depth knowledge of local, state and US issues. PwC focuses on audit and assurance, tax, and advisory services.

Additionally, in the US, PwC concentrates on 16 key industries and provides targeted services that include human resources, deals, forensics, and consulting services. We help resolve complex issues and identify opportunities.

Role : Oracle DBA

Domain : Auditing.

Responsibility: PWC was a new project, Worked as KT planner arranged and got KT from PWC SME. After KT worked as an offshore DBA and taken care of day-to-day operations. Which includes day to day issues like space management, backup and recovery by RMAN and snapshot back up by SAP tool. Database cloning from production to QA, test databases. Patching and upgrade the binaries and databases.

Company: KPIT Cummins Infosystems Limited Feb 2007 to Aug 2008

Worked on the client Project BNP Paribas as a DBA.

Client Project: BNP Paribas

BNP Paribas is French Bank.

Role : Sybase/oracle DBA.

Domain : Banking.

Responsibility: Installing Sybase on HP UNIX, Installing Sybase clients for developers. Creating databases, devices, data files as per requirement. Refreshing dev databases from Production databases. Worked on a data modelling to define new schemas, database objects, referential integrity, indexes, data flow and SQL/PLSQL for data accessibility and DML for billing applications.

Worked on Crystal reports, wrote optimized queries for reporting purpose. Worked on Performance tuning, handling backup management, Periodical check-up of data files and devices, memory structures, Capacity planning and user Management. Implemented database security using database roles, taking periodic backups for recovery purpose. Recover database on failure. SQL tuning, Creating stored procedures as per requirement.

Company: Webify Services Pvt. Limited Jun2006 to Jan 2007

Client Project: UHDE INDIA LTD (ThyssenKrupp)

Role : Oracle DBA, Database Designer & Database Programmer.

Domain : Manufacturing.

Responsibility : Responsibilities include Analysis, Database designing, Installing Oracle databases. Done the data modelling for new application creating database objects, added referential integrity to them, and created indexes for data accessibility after considering the column cardinality, data flow and SQL/PLSQL for different applications. Creating tablespaces and data files, rollback segments, verification of contention at various parts of SGA, Performance tuning and backup management. Periodical check-up of data files and tablespaces, buffer cache, shared pool, etc. Installing Oracle binaries for various platforms. Developed various functions, procedures, packages, database triggers Data Conversion Migration of data from SQL server 2000.

RDBMS

Oracle 8.x,9.x & 10g,11gR2,12cR2,18c,19c, Oracle RAC 10g and 11gR2 RAC,12cR2RAC,18cRAC,19c RAC, Sybase ASE 12 and 15, Mssql server 2005,2008,2012,2016,2019, Azure SQL

Machines/Operating System

Linux, Solaris, Exadata Machines X3, X6, X7, Mac, Window, HPUX

Tools

OEM, TOAD, HP-SM7, Remedy, Espresso, Golden Gate, VMware, NetApp Netback, Service Now, HPDP, Veritas NetBackup, Sybase Power Designer, SSMA, SSMS, SSRS, SSIS, SSAS, SSCA, AWS, Azure, OCI

Utilities

Export-import, Data pump, RMAN, AWR, ADDM, SRVCTL, CRSCTL, OCRDUMP, OCRCONFIG, logdump, Oracle data miner, ASH, DGMGRL, BRtools

Clouds

AWS, Azure, Oracle Cloud

Professional Summary

Certifications

Academics

Professional Experience (companies and Client Projects)

Technical Skills

Contact this candidate