Candidates About

Naveen Pati

             Senior Oracle DBA                                                                                                                                  

SUMMARY:

Senior Oracle Database Administrator with 14 plus years of experience supporting mission critical databases. A great team player with strong work ethic and have consistently stepped up to meet project deliverables under aggressive timelines. Great ability to troubleshoot with significant experience working in high pressure environments. Extremely flexible with working during off business hours to interact and support global teams across geographical locations.

Technical expertise includes:

• Oracle Database Administration (12c, 11gR2,11gR1,10gR2, 9i, 8i)
• Datacenter Migrations
• Migration and administration of Oracle Databases in Oracle Cloud.
• Oracle Golden Gate 11g/12c Implementation and administration.
• Database Upgrades (11g to 12c, 10g to 11g, 9i to 10g, 8i to 9i)
• Oracle RAC and ASM Administration (9i,10g,11gR2)
• Oracle Exadata Administration
• Oracle E-Business Suite Administration (R12.2.6, R12.1.3, R12.0.4, 11.5.x, 11.0.3)
• Oracle E-Business Suite Upgrades (11.5.10.2 to R12.1.3)
• Oracle E-Business Suite Upgrades (12.1.3 to R12.2.6)
• Oracle Database 10g/11g RAC Implementations for EBS and non-EBS systems.
• Oracle RMAN Backups Implementation.
• Oracle Enterprise Manager Cloud Control 12c/11g Implementation for very large environments
• Oracle WebLogic 11g administration
• Discoverer 11g Implementation.
• Experience in Data Conversion, Data Migration, Report Generation and Interfaces within several modules in Oracle EBS Applications
• Code Migrations into various systems
• Data Guard Setup and maintenance
• Datacenter Migration Expertise.
• Refreshes of TEST/DEV/UAT databases in RAC and Non-RAC environments using RMAN and other techniques
• Scripting and automation skills.
• Standardizing DBA processes and procedures and documentation

CERTIFICATIONS:

·         Oracle 12c DBA Certified Professional

·         Oracle 10g DBA Certified Professional

·         Oracle 9i DBA Certified Professional

TECHNICAL SKILLS:

ERP: E-Business Suite R12.2.4, R12.1.3, 11.5.10.2, 11.5.9. 

DATABASE: 9i, 10g, 11g, 12c

DB Management:  TOAD, Sql Developer, OEM 11gR2/ 12c

Operating Systems: RHEL, OEL, Solaris 5.9/5.10/5.11, AIX 6.1/7.1, HP-UX, Windows

BI/Reporting tools:  OBIEE 11.1.1.5, discoverer 10g/11g

Tuning Tools: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ASH, ADDM, SQLT

Programming: UNIX shell Programming, SQL, PL/SQL, HTML

Others: VMware, VERITAS Net Backup, Netapp snap manager, Tivoli, EMC, Citrix Server, Live Reorg, Kintana, Nagios, Ring Master, Big Brother, Chef, Git

.

PROFESSIONAL EXPERIENCE:

OSI Consulting Inc., Seattle, WA                                                                           Dec 2007 – Till date

(Dendreon Corp, Valeant Pharmaceuticals, Beachbody, CDK Global, Southern California Edison, Physio Control, Robbin Bros, Paramount Farms, Paramount Citrus)

Principal Consultant, Oracle DBA

Responsibilities (on multiple engagements and clients):

• Installations of Oracle Applications of versions 11.5.10.2 and R12
• Migrated Oracle databases from On premise to Oracle Cloud
• Implemented and Administered Oracle Golden Gate 11g.
• Oracle Exadata Administration
• Upgraded Oracle Applications 11.5.10.2 to R12.
• Installed R12.1 HRMS.
• Analysis and Design of the RAC Implementation
• Lead the various data center migration projects
• Installed GRC applications and integrated with ERP databases.
• Upgraded EBS Apps from 12.1.3 to 12.2.6
• Implemented 11gR2 Real Application Clusters(RAC) for ERP databases and non-ERP databases
• Upgraded multiple ERP PROD databases from 9i to 10g and from 10g to 11g versions
• Implemented Oracle Business Accelerators (OBA).
• Implemented OBIEE and integrated with EBS.
• Implemented 10g and 11g discoverer.
• Implemented Transparent Data Encryption(TDE) for EBS applications.
• Upgraded Discoverer from 4i to 10g discoverer
• Applied HRMS and Financials Family pack patches
• Implemented shared application tier for Oracle applications
• Implemented forms load balancer using F5 BIG IP.
• Labware Management System(LMS) setup.
• Intellivenge application support.
• Implemented DMZ for iSupplier module.
• Cloning of Oracle Applications from Multi-node to Multi-node and Multi-node to single node and vice-versa.
• Supported Functional and Technical teams with DBA requests.
• Executed numerous change controls in PROD
• Production support for oracle apps environments.
• System Administration activities like managing concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical issues. 
• Worked on applications like Apex and Clearorbit.
• RMAN backups implementation.
• Prepared number of Standard Operating Procedures (SOPs).
• Coordinated with Unix administrators and Network administrators and business people

• Upgraded Business critical production databases.
• Implemented 10g and 11gR2 Real Application Clusters(RAC)
• Implemented Oracle Dataguard.
• Setup the Dev, Test, UAT and PROD environments for different projects.
• Worked closely with Developers in preparing for the code deployments and bug fixings.
• Performed refreshes/clones of UAT/TEST/DEV databases from PROD using various technologies.
• Applied database CPU/PSU patches.
• Migrated databases between the datacenters in various platforms.
• Performed the restore and recovery of the databases.
• Performance monitoring and fixing the issues.
• Performed analysis of AWR and ADDM reports.
• Executed number of Change Controls in Production
• Worked as on-call DBA and provided 24*7 support for business-critical databases and applications.

Everest Consulting Group,                                                                      Feb 2007 – December 2007

(Northrup Grumman, County of San Diego)

Senior DBA

Responsibilities:

• Lead DBA team for datacenter Migration Project
• Migrated all production databases to another datacenter.
• Performed GAP analysis for Oracle R12 environment
• Worked on capacity planning for multiple environments
• Set up the environment for oracle apps on new machines.
• Configured Kernel parameters on UNIX machine
• Installed 11.5.10 Oracle Applications
• Upgraded 9i database to 10g database.
• Maintenance of 10g databases
• Cloned the Apps databases in a new datacenter
• Created OAT and UAT instances for testing and provided support
• Created standby database for Oracle Financials
• Migrated the Production database from San Diego datacenter to Plano datacenter
• Production support for oracle apps environments
• Migrated Dev/Test and Staging databases to a new datacenter.
• Provided support for ImageNet upgrade to Xendocs
• Created the production reporting instance.
• Troubleshooting the issues
• Scheduled the backups using RMAN and disk backups
• Worked with Oracle Support on resolution of SRs.
• Coordinated with Unix administrators and Network administrators.
• Performed the analysis for a databases migration to a new server
• Worked on capacity planning for Oracle Financials database
• Created OAT and UAT instances for testing
• Created standby database for Oracle Financials
• Migrated the Production databases from San Diego datacenter to Plano datacenter
• Production support for oracle apps environments
• Migrated Dev/Test and Staging databases to a new datacenter.
• Created the production reporting instance.
• Scheduled the backups using RMAN and disk backups

• Setup the environment for Kronos oracle database on a new box
• Created the new instances for OAT and UAT testing
• Created the standby database
• Performed the restore and recovery of the database

Wissen Infotech Pvt Ltd, India                                                                   April 2003 – December 2006

(GE Health Care and Mattel Inc.)

Lead Oracle DBA

Responsibilities:

• Installed Oracle APPS 11i
• Involved in 11.5.10 upgradation from 11.5.8
• Performed Oracle 9i upgrade from 8i of production APPS database.
• Performed many TEST, DEV, UAT database upgrades from 8i to 9i manually and through dbua.
• Installed Greek and Italy languages in production apps database
• Performed Markview 170 systems upgrade from 4.5 to 4.7 version
• Applied Oracle Apps patches with adpatch and through ring master tool
• Oracle application databases cloning and refreshes
• User account management - creating users, disabling users, responsibility management.
• Copying new forms, reports, custom code to production environment, Development.
• Applied Opatches, Security alert and CPU (rdbms related) patches.
• Standby database (data guard) configuration and maintenance

• Supported 9i RAC and 10g production databases
• Performed number of schema refreshes from production to test to dev using exp/imp.
• Working with VERITAS Netbackup Technology to take the hot and cold backups.
• Worked with RMAN utility to take the online and offline backups
• Restored and recovered databases using RMAN duplicate.
• Applied database patches using Opatch utility.
• Applied CPU (Critical Patch Updates) patches every quarterly.
• Performed database character set conversion.
• Coordinated with Oracle support for upgrades and new releases.

EDUCATION:

·         Bachelor of Engineering in Computer Sciences (B.E), 2001

Professional Development:

·         Oracle Cloud Control 12c administration

·         Amazon Cloud(AWS)

·         Oracle 10g/11g RAC Training from Oracle University.

·         Oracle Business Accelerator(OBA)

·         Golden Gate training from Oracle University.

·         Oracle database 12c

·         Oracle database vault 12c

·         .Oracle Exadata training from Oracle University.

·         MongoDB DBA administration

·         Oracle Identity Management