Oracle Manager

Mangesh Teware

Senior Principal Database Infrastructure Architect-Migration Expertise to Oracle Cloud Services

Oracle APPS DBA Expert

+1-312-***-**** *******.********@*****.***, 16+ years’ of experience

US Legal Status: Permanent Residance

https://www.linkedin.com/in/mangesh-teware-958162156

EXPERIENCE SNAPSHOT

16+ Years of Experience of Oracle products- Oracle E-Business Suite, Oracle RAC 11g, 12c, Data Center Infrastructure Services, Cloud Architecture & Operations, Fusion Applications, Database Solution Designing, Infrastructure Provisioning with involving multiple & multi terabytes of databases, applications on Unix, Linux, Windows with extensive experience in Oracle Databases, E-Business Suite and Fusion Middleware.

Specializations: Cloud Managed Services – PaaS, IaaS & SaaS

Oracle EBS R11i,R12.1,R12.2, RAC 10g,11g,12c,EM 12c,13c, Apex 5.x REST,SOAP Web Services

Certified ITIL Service Delivery Mgr/Oracle Certified DBA

Core Database(16)

Oracle Business Applications (14)

Oracle Exa Series(5)

Cloud Management(3)

Fusion Apps, Middleware(8)

Oracle DB, RAC,

Golden Gate, Advanced Performance Tuning, ODI

EBS R12,12.2,ASCP, Advanced Admin, Apps Optimization

ExaData, ExaLogic, Solaris Super Cluster

Oracle SOA Cloud CS,ICS, DevOps, AWS

Oracle Fusion Apps 11.1.x, Enterprise Manager 12c,13c,IDM SSO,SOA, REST, SOAP Web Services, Demantra,OTM, Hyperion, Fusion HCM,Agile PLM

Experience of ZFS infrastructures, including Data Security, Network, Computing, Storage, and Application Development.

Extensive experience in planning, designing, Implementation and Support Experience in Migrating to Oracle Database 12c Multitenant with Container Database (CDB) using Pluggable Databases (PDBs)

Implemented 2 Way and 3-Way Disaster Recovery Solution with Oracle 11g r2 Data Guard

Experience in Oracle Database Implementation, Planning, Designing, Installation, Upgrading and Maintaining Database Technologies (11g, 10g, 9i & 8i) on traditional systems

Experienced in Performance Tuning at Database, Instance( Query level)

Experience on 24x7 Production Environments for Large Oracle Databases

Areas of expertise include In-Memory, Database Security (ASO), Multitenant, Partitioning, RAT, Cloud Management Pack for Oracle Database, High Availability (RAC), Database Replication (Oracle Golden Gate), Disaster Recovery Site, Space Management, Capacity Planning, Backup & Recovery

Key Projects Summary:

Completed 12.1.3 to 12.2.7 Application Upgrade.

Implemented and configured Flexdeploy product.

Performed ASCP upgrade from 12.2.3 to 12.2.6.

Installed and configured Single Sign on ( SSO) with Oracle Access Manager and OID.

Integrated EBS with AD integration.

Performed Demantra upgrade to work with 12.2.6 Application tier.

Completed and architect solution for addition of new organization unit to existing org.

Installed and configure rapid planning instances.

Implementation of Oracle Apex ORDS REST, SOAP Web Services with Apache HTTP SSL

Architected, Implementation of Oracle SOA 12c Cloud Services –

Architected, Implementation, Upgrade Support for Fabrinet, USA for Oracle EBS 11i to 12 on Super Cluster, ExaData Storage with in place Business Continuity Site

Having experience in managing in-house developed application SAAS Services like Demand management & Payroll, HR Applications with previous company

Having experience on provisioning Oracle Database (DBaaS), Oracle Demantra & Oracle Value Chain Planning instances as SAAS – Rapidflow Inc., USA

Transition of various customer to ITC hosted environment.

Upgrade of Application from 12.1.3 to 12.2.x for various hosted and managed customer.

FAHRCS Implementation and configurations.

Migration of all ITC hosted and non-hosted customer from NIMBUS to NAGIOS Monitoring.

CORE COMPETENCIES

Cloud Products & Services

( PaaS, IaaS, PaaS)

Oracle SOA Cloud Services, BaaS, PaaS Provisioning through Oracle Enterprise Manager 12c

Knowledge of VMware VSphere, Cloud & V Motion Products for Business Continuity Services

Oracle SOA Cloud Services Infrastructure Services Planning and Deployment.

Infrastructure, Database, Application Solution Designing for In-house Web Applications for SaaS Services

Amazon EC2, S3 product implementation and operations management

Unix, Linux,Windows Administration

Oracle Enterprise Linux 5, 6 Administration, Mid-Level Oracle Solaris Administration and provisioning.

Shell, Perl, Python Scripting for administration and task automation.

Oracle Enterprise Manager 12c, Nagios Administration for Monitoring.

Well versed with Backup Management Tools – IBM Tivoli, Symantec

Oracle E-Business Suite/ Oracle Value Chain Planning/Oracle Fusion Middleware

Starting Release 11.0.3 through R12.1.3, 12.2, 7 Years on various releases of R12

Involved on mission critical performance tuning issue on 10g, 11g Database releases with Oracle EBS advanced architecture of IDM, SSO, RAC, PCP, Load balancer, proxy and multiple node architecture

10+ Upgrades from 11i to 12, 12.1 and 15+ Release 12 Upgrade Assessments

50+ Oracle EBS 11i, 12, 12.1 implementations including DMZ,PCP, Load Balancer

2 Upgrades from 11.0.3 to 11i, 2 Oracle EBS R12.1.3 on 10g/11g Release 1/ 11g Release2 RAC, Oracle EBS R11i on 10g/11g Release 1/ 11g Release2 RAC/12c

Oracle Database

7,8,8i,9i,10g,11g,12c Platform : Windows/Linux/Solaris/HPUX/IBM AIX

Enterprise Manager 12c,Disaster Recovery 11g Release 2 Active Data Guard

10+ Oracle 10g / Oracle 11g/12c RAC implementations and support

Oracle Business Intelligence

10+ Oracle Discoverer Release 10g/11g installation and Configurations

Oracle Fusion Products

Oracle Fusion Applications 11.1.x, OBIEE 10g/ 11g, Web Logic 10g Server Admin

Oracle Data Integrator (ODI) 10g, 11g with Oracle BI and other Fusion Integrations.

1 Project with Oracle SOA / BPEL for Oracle Transportation Management 6.2

PROFESSIONAL CERTIFICATIONS

ITILF - ITIL® Foundation Certificate in IT Service Management

OCP – Oracle Certified Database Administrator

Cloud- Oracle Infrastructure as service 2017 Presale Specialist

Oracle Database Cloud service 2017 Presale Specialist

ACADEMIC QUALIFICATIONS

B.E Electronics ( Visvesvaraya National Institute of Technology NAGPUR)

1996 - 2000

PROJECTS

# Technical Manager– ITC Cloud Managed services

Client : Hosted and Non Hosted customer (MAR‘2012 – Current)

Location : Dallas ( Texas, USA)

Key Roles : Responsible for overall delivery for E-Business Suite support from ISS offshore - Hyderabad Centre for more than 80 + ISS clients. It involves managing Operational and Technical Business Analysts, resource allocation, achieving timing delivery of issues reported to us, providing estimates and delivering roll out and enhancement projects. Working strategically with business partners on expansion plans and my profile also involves working on Business proposals for prospective clients.

Responsibility

Lead Center of excellence team, which involved all automation and global standardization

Conducted Application and Database security project for several clients

Created and mentor monitoring team at ITC global level.

Lead complete ITC US Operation.

Lead administration of database servers for the all hosted and non-hosted client of ITC.

Proactively identify issues and make sure services are meeting SLA’s.

Developed stronger ties between customers and Infrastructure team resulting in collaborating and working together to effectively use IT for business.

Guaranteed uptime on numerous database servers located in Chicago and San Francisco data centers to ensure a flawless execution with minimal downtime.

Managed the daily tasks of a team of core and Application database administrators. working with

PSS team for any implementation project.

Conducted interviews and participated in hiring decisions along with HR in order to retain the best talent in the organization.

Participated in quarterly meetings with Senior Management to discuss technical infrastructure and Business proposal for assisting in the formation of the technology roadmap.

Managed junior offshore resources as part of global delivery model resulting in reduced costs for the engagement.

Prepared statement of work (SOW) for custom projects to help with billing efforts to generate additional revenue for the organization

Developed documentation that details policies and service level agreements for various clients.

Mentored and trained staff members in addition to scheduling hands-on training to increase knowledge

Worked closely with developers, team members, and the project management office to design

Database structures and ensure objects are created efficiently.

Driven the Major upgrades and Implementation projects.

Performed planning, execution and control of project milestones.

Performed quality procedures like Six Sigma and CMM Level 5 processes while executing the projects.

Implemented the NIMBUS monitoring to the entire hosted customer.

Migrate complete Monitoring system from NIMBUS to NAGIOS.

# Senior DBA & Architect – DAZSI SYSTEM PVT LTD (NOV 2010 – MAR 2012)

Location : Hyderabad ( INDIA)

Key Roles : Handling the 50 + clients and there environment, Involved in the advance configuration like RAC configuration, OBIEE Setup, DMZ setup,SOA,OTM configuration and upgrades from 11i to R12., Upgrade from R12.0.6 to R12.1.3.Database upgrade from version 9i to 11GR2.

Responsibility:

Performed the database and application conversion from 32 bit to 64 bit OS.

Performed upgrade from R12.0.6 to R12.1.3

Implemented process for cloning, NON RAC to RAC Setup.

SOA and OTM setup for Different clients.

DMANTRA setup of various client.

OBIEE setup with Informatica and DAC setup.

Regular cloning and patching activity.

Performed full cycle implementation from CRP to PROD.

Installed and configured Oracle Secured Search.

Regular clone and patching as per requirement as a bug fix.

Regular application of Security patches..

# Senior DBA & Architect – SUNERA TECHNOLOGIES (DEC ‘2008 – NOV 2010)

Location : Hyderabad (INDIA)

Key Roles : Handling the 20 + clients and there environment, Involved in the advance configuration like Data guard configuration, OBIEE Setup, DMZ setup and upgrades from 11i to R12.Database upgrade from version 9i to 11GR2.

Client : National Institute of Blind

Responsibility :

Performed the Siebel CRM integration with oracle E-business Suite. Upgraded the database from 9.2.0.6 to 10.2.0.3 and applied the ATG RUP 6 patches. Installed the Fusion Middleware and applied the Functional and Fusion middleware patches. Health checkup of Production instances

Performed upgrade from 10.2.0.2 to 11.1.7.0 & Application upgrade from 12.0.4 to R12.1.1.

Implemented and configured the SSL setup for istore configuration.

Performed the SSL Implementation in DMZ setup.

Performed the OEM and 10g Grid installation and configured the database and application Alert. Performed alert mailing configuration so that if issue came it will notified through mail.

Upgrade large financial organization from 11.5.7 to R12.1. Design architecture put together all technical documentation, mentor dba's during the upgrade process.

Implemented Data Guard for standby migrated existing 9.2. Databases to 11g Real Application Clusters.

Implement a shared application top for both techstack and appl_top. Customers run AIX, HP-UX, Linux and Solaris.

Performed the database and application conversion from 32 bit to 64 bit OS.

Worked with several Multi node and multi-tier environments. Current environment is # of Node RAC with # of Node stand by database, with # of application servers with a hard ware load balancer. (Some open to Internet and some open for Intranet). SSL implemented on Internet tier. DB tier is # of server cluster with Failover.

Worked with several Multi node and multi-tier environments. Current environment is # of Node RAC with # of Node stand by database, with # of application servers with a hard ware load balancer. (Some open to Internet and some open for Intranet). SSL implemented on Internet tier. DB tier is # of server cluster with Failover

# DBA Consultant – GENPACT INDIA

Clients : GE, GE Healthcare, GE Energy, GE Parts

Location : Hyderabad (INDIA)

Duration : Nov-2006- Dec 2008

Role : Supporting GE Energy’s 150 ERP Instances, and 800 Non-ERP databases. Supporting 85,000 plus users in 20 countries. Administer and manage Oracle Applications 11.5.6, 11.5.8, 11.5.9 and 11.5.10.2. Lead 11.5.10.2 upgrade. Responsible for Country-Releases. Involved in planning of server consolidation/migration, Involved in day-to-day troubleshooting, monitoring, patching and cloning instances.

Responsibility :

Lead Upgrade project from 11.5.9 to 11.5.10.2 and Configure with 10g AS portal and Discoverer. Lead many Country-Releases by Installing and Applying new NLS Languages and Localizations.

Configure Oracle Apps 11i across data centers for High Availability and Load Balancing.

Installed and Configured Oracle 10gAS by Clustering across data centers for High Availability & Load Performed the database and application conversion from 32 bit to 64 bit OS.

Performed upgrade from R12.0.6 to R12.1.3

Implemented process for cloning, NON RAC to RAC Setup.

Balancing and configure Single Sign-On with Integrity (SiteMinder). Provisioning setup from 11i to OID and HR Connector to OID. Customized Autoconfig Templates and Drivers. Manage 11i along with 3rd party applications – ILM, SABRIX, 170 setup. Involved in Migration of Sun Solaris to IBM Aix Platform.

Configure Pasta Printing for various Languages in various Countries using NLS Territory.

Involved in day-to-day troubleshooting, monitoring, patching and cloning instances.

Document the various Oracle Application administration procedures.

Configured the Application with Shared APPL_TOP, cloning of Shared APPL_TOP

Cloning the 11.5.10 application from Single node to Multi-node.

Worked on hardware load balancing and it configuration.

# Software Engineer – Oracle India Pvt Ltd

Duration : Jan-2005- Nov 2006

Location : Bangalore (INDIA)

Role : Administer and manage Oracle Databases with different sizes from 100GB to 800 GB. Responsible for upgrading, patching and refreshing databases. Involved in troubleshooting, monitoring and tuning Oracle Databases.

Responsibility :

File system monitoring for space and performance management. Refresh development and test databases from production database. Checking and cleaning the file systems for log, out and temporary files. Cloning of 11.5.8, 11.5.9, 11.5.10.2 Applications and Database. Cloning the Application from Multi-node to single Node.

Maintenance of the Oracle Application databases.

Migrated 11.0.2 instances from one server to other servers

Re-Configured the rollback segments, redo log sizes and init parameters for optimal performance. Document the various database administration procedures for future reference.

Supporting various client of Oracle.

Perform the platform Migration from Windows to Linux. Prepared a complete Performance analysis and implemented my recommendations. Carrying out day-to-day administration tasks and troubleshooting various oracle errors concerning deadlocks/locks, technical issues.

Audited the Production servers / databases and implemented my recommendations.

Managing Database Structure, Storage Allocation, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges.

Tune database, Tune Applications, Tuning Memory, and Tuning Disk Usage. Monitoring user access and maintaining security of databases. Monitoring and optimizing the performance of the Database.

Maintaining a test database for testing and research. Sizing the database for future growth.

To re-organize the database using Oracle Export and Oracle Import. To implement a backup & recovery process. To implement a parallel replication environment to evaluate the performance and all changes required for this solution...

# Database Specialist – E-planet system

Duration : Aug-2003- Jan 2005

Location : Nagpur (INDIA)

Role : Client DBA

Responsibility :

Main Activity as DBA - Installation of Database, Designing Security, Space Management, Design Backup recovery, Tuning SQL Queries.

Refresh development from Production using Oracle Applications Cloning method.

Extensive development of Oracle PL/SQL objects including: packages, stored procedures and functions.

Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.

Apply application and database patches and Maintaining APPL_TOP's using AD utilities.

# Database Administrator – Manisha System, Nagpur

Duration : Jan-2002- Aug 2003

Location : Nagpur (INDIA)

Role : Troubleshooting client’s problems, Database designing and Maintenance of User Administration and OS Authentication

Responsibility :

Installed Oracle databases for various clients

Upgrade Oracle Database 8.1.6.2 to 8.1.7.3

Fixed many problems and applied relevant patches to oracle database.

Troubleshooting oracle Database related issues.

Backup and Recovery.

Contact this candidate