Oracle Dba Azure Cloud

Milind Shinde

Cloud Migration Architect / Senior Oracle DBA

Email: ********@*****.***

Ph. No:+1-737-***-****

www.linkedin.com/in/milindshinde

Summary:

Over 19+ years of rich experience with expertise in Azure Cloud migrations, Oracle DBA support for SAP & Non-SAP related databases with various replication technologies Create a well-informed cloud strategy and manage the adaptation process.

Work closely with IT security to monitor the company's cloud policy.

Respond to technical issues in a professional and timely manner.

Identify the top cloud architecture solutions to successfully meet the strategic needs of the company.

Good analysis, communication, administration, team co-ordination and interpersonal skills.

Responsible for ensuring that team delivers projects that are technically sound and comply with defined standards and procedures.

Responsible for the achievement of SLA objectives and ensuring that compliance with contract terms and conditions is achieved. Drive/manage service quality and improvement of service delivery processes.

Has practical applied knowledge in certain key technical areas such as virtualized environments, high availability, and storage management.

Experience in System Fault Tolerance Design, (COB) Business continuity and Disaster Recovery planning.

Core strengths in spearheading Oracle Administration, Using Data guard, Goldengate, Share plex, streams, CDC.

Strong exposure in installing, creating, upgrading, migrating, patching & supporting Oracle 12c/11g/10g/9i/8i databases on a broad set of platforms like Windows, UNIX, Linux, HP-UX & AIX 6.1/7.1

Expertise in applying patches on production, test & development instances, cloning databases using conventional backups.

Front-led highly complex global projects and implemented best practices in areas of services strategy, while enhancing delivery capability

Possess high level consulting skills, architecting viable solutions, and guiding the implementation.

Certification:

Microsoft: Designing Microsoft Azure Infrastructure Solutions- AZ-305

Microsoft Azure Administrator – AZ 104

Microsoft Certified Azure Fundamentals – AZ - 900

Certified Information Systems Auditor (CISA) in 2017 (Expired)

Certified Ethical Hacker by EC Council in 2016 (Expired)

Oracle Certified Associate (Paper 1)

Technical skills:

Operating Systems

Red Hat Linux RHEL 3.x, 4.x, 5.x, 6.x, HP-UX 10.x, 11.x, windows, Sun Solaris 10.0

Data Bases/ Storage

Oracle 19C/12c/11g, Oracle 19C,12c, 11g ASM, MySQL5.5/5.6/5.7/7/8, Blob, MySQL

Azure Cloud Platform

BLOB Storage, Azure, Azure DevOps, GIT Repository Management, ARM Templates, Terraform, Azure Monitor, Azure Update Manager, Azure Migrate, ASR, Azure Advisor, Azure Defender, Azure Active Directory

Architectures

Azure Well Architected, Azure Cloud Foundation, Zero Trust

Languages

SQL, PL/SQL

Tools/ Utilities

OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, DBCA, TOAD, Patch Management, SQLNET, ODBC, Export/Import, Data pump, Data-Guard, Crontab

Tuning Tools

EXPLAIN PLAN, ADDM, AWR

Terminal Emulation

Putty, Telnet, FTP

Cloud Solution Architect

Baker Hughes Oil Company, TX Feb 2022 to Till Date

Project Type: Azure cloud migration project

Responsibilities:

Providing Azure solutions to client

Azure cloud migrations

Creating VPN

Configuring Load balancer

Azure site Recovery

Azure Migrate

Azure Active Directory management

Creating pipeline and defining end-to-end data-driven workflows in Azure

Decreased Mean time to repair for hosted client systems by exposing performance bottlenecks utilizing Azure Monitor and Log Analytics and Increased application endpoint availability to 99% SLA.

Created database users, logins, and permissions to set up.

Install oracle 19c client and upgrade 12.2 databases to 19c using dbca.

Successful in applying RDBMS patches on 12c,19c databases, security patches for improving the security and functionality of the databases.

Helping team members to resolve any technical issue, Troubleshooting, Project Risk & Issue identification, and management.

Migration support for the project which has 200+ applications hosted on VMware platform.

Migrate the applications and databases using Rehost or Redeploy approach.

Run the Azure migrate tool, get an assessment report, Preparing playbook and Solution Architect documents.

As a part of Re-deploy, we provision new VM.

Migrating the Oracle databases from on-prem to azure Linux VMs

Post migration tasks

Creating Network and solution diagrams

Creating and configuring Azure migrate project.

Environment: Azure Cloud, BLOB Storage, Oracle 19c/12c, RHEL 5/6, OEM, RMAN, Performance Tuning, Data pumps, Exports/Imports

Cloud Solution Architect

McCormick, MD Dec 2017 – Jan 2022

Responsibilities:

Designed Hybrid cloud environment with production support efficiency and communicated target architectural plans & company roadmaps across all departments with experience in CI/CD concepts and toolset (Azure DevOps & Terraform)

Provided support & technical governance with expertise in cloud architectures, deployments, and operations.

Integrating Azure Active Directory with on-prem Active directory

Scheduling patching/reboot of vm through Azure Update manager

Led POCs & innovative solutions, deployed IaaS, PaaS and collaborated with peers in Data & Application architecture regarding technical architecture & details of cloud migration and datacenter transformation.

Designed & implemented continuous delivery pipelines that serve the purpose of provisioning & operating client test as well as production environments.

Steered functions including Azure Cloud Migrations, VPN Creation, Load Balancer Configuration and Azure Migrate

Led Migration support for the project which has 100+ applications hosted on VMware platform, VM Provision, Oracle Migration, Post Migration Task, Network & Solutions Diagram Creation and Resource deployment using Azure DevOps CI/CD pipelines.

Installation and use of High Availability and Disaster Recovery components

Created ASM volumes using ASMCA and Created ACFS for GoldenGate v12.

Installed Goldengate and Configured Integrated Extract and Replicate on Multitenant database 12.1.0.2.

Improved performance by optimizing computing time to process the streaming data and saved cost to company by optimizing the cluster run time.

Troubleshooting Golden gate lag Issues and various ORA alerts

Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods. Developing and Implementing Disaster Recovery (DR) Plan using Data guard.

Configured Data Guard Broker and used for switchover and stopping and Starting Media recovery process.

Environment: Oracle 12c, Azure Data Factory, Azure Data Lake, RHEL 5/6, OEM, RMAN, Grid, Data guard, ASM, Goldengate, TOAD, MySQL 5.6/5.7, SQL LOADER, Performance Tuning, Data pumps, Exports/Imports

Team Lead-Oracle DBA

MetLife Insurance Company, NC Jan 2017 –Dec 2017

Project Type: Database Support / Migration

Responsibilities:

Involved in 24x7 production database maintenance and on-call support.

Worked on maintenance of Oracle 11g/12c databases on Linux.

Administered and monitored over 500 databases both on 11g/12c/19c on prod/test/dev environments.

Administering Oracle Databases 11g/12c/19c of sizes ranging from 100GB to 30 TB.

Performed Data migration from On-prem oracle database to azure Cloud on IaaS

Migrated databases from Filesystem to Automatic Storage Management (ASM).

Responsible for using Flashback query mechanism along with automatic undo management.

Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases.

I worked here to support MySQL databases in production environments.

Upgraded MySQL from lower version 5.1 to higher version 5.5/5.6/5.7.

Worked on Active data guard, Fail over and Switch over cases.

Hands on Experience in SQL Tuning and SQL Optimization.

Created Oracle Tables, Table Partitions, Views, and Materialized Views

for protecting sensitive data in the database.

Creation of Users and granting them the required Roles and Privileges accordingly

Cloned schemas, objects and data on new server using Data pump utility.

Migration of client's spatial data to cloud-based instance of Oracle 12c databases.

Decreased Contention by reducing the Wait Events as a part of Performance Tuning

Implemented Backup and Recovery Strategies using RMAN and used Recovery advisor to repair data block corruptions & data dictionary corruptions.

Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports.

Responsible for all database activities such as User management, space management, database security management, rollback segments & creation of DB links between oracle servers

Environment: Oracle 11g, 12c,19c RHEL 5/6, OEM, RMAN, Grid, ASM, Data-guard, Golden Gate, Oracle TOAD, SQL*LOADER, AWR, ADDM, ASH, Data pumps, Exports/Import.

Sr. Oracle DBA

The Mosaic Company, Florida Feb 2011 – Dec 2016

Responsibilities:

Install and Support 11g Data guard.

Upgradati3on of 10gR2 database into 11gR2/12c using DBUA and Manually.

Define requirements for physical database consolidation, backup and recovery and application database disaster recovery.

Installation and Configuration of Physical and Logical standby databases with Maximum Protection, maximum availability mode and real-time apply.

Performance tuning instances

Migrate, upgrade and support SAP 10g and 11g databases.

Taking initiatives for maintaining SLA (Service Level Agreement) & SOP (Standards Operating Procedure).

Install OEM Grid control and migrate from OEM 10g to OEM11g and OEM12c.

Install and support OEM agent 10G, 11G and 12c.

Migrate from 10g to 11gR2. ASM installation and administration.

Plan and execute DR test for critical systems.

UNIX Shell scripting.

Environment: Redhat-Linux, HP-UX, AIX, Oracle 9i/10g/11g/12c

Oracle DBA

Genworth, UK Sep 2010- Jan 2011

Responsibilities:

Worked on Oracle Security Implementation using Virtual Private Database VPD

Worked on maintenance of Oracle 10g/11g on Linux.

Created Oracle Tables, Table Partitions, Views, and Materialized Views

Administering Oracle Databases 10g/11g of sizes from 50GB to 300 GB

Migrated databases from 10.2.0.4 to 11.2.0.3

Up-gradation of single-instance databases from 10G to 11G on Linux

Developed Test Cases and Test Scripts for System and UAT Testing.

Implemented Data Guard with maximum availability and performance configurations for production databases.

Worked on Active data guard, Failover, and Switch over cases.

Hands-on Experience in SQL Tuning and SQL Optimization.

Hands-on experience in software and firmware maintenance of both the Database and patching.

Creation of Users and granting them the required Roles and Privileges accordingly

Migrated schemas, objects, and data on a new server using Data pump utility.

Decreased Contention by reducing the Wait Events as a part of Performance Tuning

Implemented Backup and Recovery Strategies using RMAN and used Recovery advisor to repair data block corruptions & data dictionary corruptions.

Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) reports.

Responsible for all database activities such as User management, space management

Oracle DBA

British American Tobacco, India Jan 08 – Sep 10

Project Type: Database Support

Responsibilities:

Checked database health with Oracle and alert log files, trace files and back-up logs.

Migrated Oracle from 9i to 10g; rebuilt index; created Datalink and Table Partition

Scheduled cron jobs; refreshed UAT & Dev databases as per client

Monitored and resized storage space of the tablespaces; performed RMAN Back-up of the databases.

Undertook Oracle installations client/servers and Oracle Upgrade from 10.2.0.4 to 11.2.0.3

Obtained and monitored scheduled back-ups; executed recoveries using RMAN/Conventional back-ups.

Environment: Linux, UNIX, HP-UX, Oracle 8i, 9i, 10g, 11g, OEM, Toad, RMAN

Oracle DBA

International Network Operations Center, Mumbai- India Jan 05 – Dec 07

Project Type: 24*7 Administration & Support

Responsibilities:

Discussed project with clients and clarified queries regarding the functionality.

Managed INOC Oracle Database; created database instances for development, testing & production.

Performing user level administration, file & directory permission

Scheduled UNIX Cron jobs; set-up user environment variables on UNIX

Installed & created Oracle database; monitored Hot and Cold back-ups; maintained production databases.

Performed normal enhancements on Portal requested by clients using Java and JSP

Environment: Linux Server, Jboss, J2EE, XML, Oracle 9i, OEM, Toad, Tora

Education:

B.COM from Ramniranjan Jhunjhunwala College, Mumbai University

Honors Diploma in Systems management

Contact this candidate