SUMMARY:

• 17+ 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 .
• 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
• 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
• Transition of various customer to Confidential 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 Confidential hosted and non-hosted customer from NIMBUS to NAGIOS Monitoring.

CORE COMPETENCIES:

• 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
• 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
• 10+ Oracle Discoverer Release 10g/11g installation and Configurations
• 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 EXPERIENCE:

Technical Manager

Confidential

Responsibilities:

• 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 Confidential global level.
• Lead complete Confidential 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

Confidential

Responsibilities:

• 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

Confidential

Responsibilities:

• 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

Confidential

Oracle EBS DBA

Responsibilities:

• Upgrade and install Sun Cluster on multi-node Rac. Upgrade 9i Rac and 10g Rac to 11g RAC. Install Dataguard for Reporting and failover for DR.
• Proficiency in Upgrading, Patching and implementation of Oracle Apps (Release 12 / 11i) and Proficiency with several AD admin tools like Rapid clone, ADpatch, Auto upgrade, ADadmin, ADcontroller, Adsplicer Etc.
• Initiating & introducing some of the New Productivity Enhancement tools like Oracle Grid 10g / OEM and Management pack for Oracle Applications and Applications Manager.
• Training knowledge in Configuration of Oracle 10g Application Server including Fusion Middleware SOA and Portals
• Performed 11i To R12 Upgrade, We upgraded the database from 9.2.0.6 to 11GR2.
• Performed B2B Installation with Weblogic.
• Worked Extensively on OBIEE installation and configuration.
• Performed the Disaster Recovery setup for the Client. As a part of Maintenance activity
• Performed the DR drill. Health checkup of Production instances
• Installed and configured the Confidential for the oracle webmail and oracle Web conference
• Set up DR/Standby instances for reporting and Disaster Recovery scenarios using Data guard. Manage recovery efforts by involving consultants from Oracle and other Vendors. Advise the Management team about the hardware and EMC-SAN Storage, Network, database usage and Growth Impact for new and ongoing internal projects. Manage Capacity planning to accommodate future growth of the existing and historical Database and data warehouseBuild DR Site on M7 Servers with Oracle Physical Data Guard.
• Consolidate all Database on Super Cluster with Oracle 11g with Solaris 11 and EBS 12.1.3 on Solaris 10 for backward compatibility.

Confidential

Responsibilities:

• Manage Code migration, Data Conversion, disk space management, database performance and resource monitoring. Manage database network setup, Cluster setup, Fail Over set up, distributed database setup, and trouble-shooting (e.g. SQL statements, locking issues, network and performance problems)
• Backup the Database or logical/user objects for securing the data and database structure. Build up plans for cumulative or incremental backups using RMAN, Exp/Imp and Shell scripts. Set-up Backup policy and plans for Daily, Weekly and Monthly backup. Make cold or hot backups according to the production and Business requirements. Test and verify that the backup is completed and reliable to restore and roll forward if required. (Tools- Net backup, RMAN, Exp/Imp, shell scripts, Data Guard for Standby DB)
• Tune the database for optimum performance using historical statistics and other tuning utilities like stats pack. Reduce the disk contention and organize the load average. Review codes and other database objects to see if the indexes are used to reduce query run-time. Reduce stress on Oracle server by tuning the applications to use only the Just-in-Time Data (JIT). Tune the instance, Oracle server, codes and objects (packages and procedures) to improve end-user satisfaction with super-fast response time. Reduce stress on disks by reducing disk I/O to effectively avoid full table scans, and high CPU utilization.

DBA Consultant

Confidential

Responsibilities:

• 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

Confidential

Responsibilities:

• 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

Confidential

Responsibilities:

• 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.