Oracle Dba/applications Dba Resume
Adrian, MI
SUMMARY:
- Over 16 years of IT experience with 14 years on Oracle ERP and Database Technologies with most part worked in managed services and cloud hosting companies.
- Exposure working with hosting Database and applications on cloud environments both on public and Hybrid cloud.
- Well versed with AWS EC2 and S3
- Leadership roles as Solution Architect, Technical Account Manager, Manager and Lead DBA working with offshore and onshore teams and helping customers and businesses to be successful by following the best practices in running their respective IT organizations.
- Skilled in leading projects from pre - implementation to post-implementation as a Team Lead This includes upgrades and migrations of both the databases and applications. Provide clients with Advise on future roadmaps, as well as current infrastructure, including a complete assessment of the current environment
- Excellent customer facing skills with excellent communication, presentation, and problem-solving capabilities
- Exposure to working on Oracle ASCP, ERP and Demantra Implementations
- Experienced in working Oracle RAC environment
- Exposure to Hyperion Installation and Administration.
- Experienced in handling Noetix and Discoverer Administration
- Over 1 year of experience in installation, creation, maintenance and backups & recovery of database using SQL Server 7.0/2000 and Informix.
- Lead Disaster Recovery Exercise for Production Databases at IBM Disaster Recovery Site
- Exposure to Big Data Hadoop 2.0 and Cloudera technologies
- Well versed with SOX process and compliance.
TECHNICAL SKILLS:
ERP: Oracle Applications 10.7/11i (11.5.8, 11.5.10), Release 12, 12.2
E D Database: Oracle 7.x/8.x/9i/10g/11g,12c SQL Server 7.0/2000, Informix 7.0, Mango DB
Big Data Hadoop: Cloudera
Cloud Technologies: AWS, Private Cloud, Oracle
Administration Tools: Oracle Enterprise Manager(OEM), Embarcadero,TOAD, GoldenGate, AWR, ADDM, Statspack
Application Servers: Or Oracle 9iAS, OTM, WebLogic 5.1, Web sphere 4.0, Hyperion 11.111.1.1.3
Web Servers: IBM HTTP Server, Apache Web Server 1.3.19
Operating Systems: HP UNIX, Sun Solaris, MS Windows, AIX, Linux
PROFESSIONAL EXPERIENCE:
Confidential,LLC
Technical Account Manager/Sr Oracle Apps DBA
Responsibilities:
- Managing medium to large EBS and Database customers as Oracle Linux Cloud hosting partner
- Design various hands-on labs using Oracle technologies and AWS components
- Analyzing customer requirements and recommend cloud solution
- Technical solution using AWS building blocks like VPC, EC2, EBS storage with focus on availability and cost
- Support EBS hosted and non hosted customers as per agreed SLA
- Assist in preparation and participate in customer on boarding meetings.
- Define baselines to compare against future performance for CPU, Memory, Swap, I/O, and DB growth
- Active participant/owner in the Root Cause Analyses (RCAs). Tracking open action to assure closure.
- Proactive analysis and patching
- Assure proper Backup and Disaster Recovery process and documentation are in place
- Manage database and application administration activities
- Provide Proactive Health checks for customers on critical environments
- Review weekly/monthly reports being provided to customers
- Timely and effective communication with Customers
- Serve as initial point of contact for Issue Resolution/Management
Technologies: Oracle Applications R12, R12.2.4, Database 11g, 12c, Hadoop
Confidential, Lexington MA
Lead Oracle Apps DBA
Responsibilities:
- Oracle R12.2 Implementation and support
- Support current Oracle R12.1.3 E-biz with Oracle 11g Database.
- Well versed with latest Oracle R12.2 concepts including R12.2 Architecture, ADOP (AD online patching), WebLogic and new R12.2 file system concepts.
- Well versed with latest Oracle database 12c concepts and Architecture
- Handling SOX compliance at Cubist including adherence to internal controls and procedures designed to ensure the validity before migrating any changes to Production.
- Handling Data warehouse environments at Cubist which involves DataMart, Cognos and Siperian.
Technologies: Oracle Applications R12/12.2, Database 11g.12c on Linux VMware
Confidential, Waltham MA
Lead Oracle Apps DBA
Responsibilities:
- Worked as part of Hitachi US Managed Services, leading 6 DBA Accounts independently with Offshore/Onsite Model.
- Successfully Lead and Completed Oracle R12 Upgrades and 11g Database Upgrades.
- Worked on R12 and ASCP Implementation.
- Worked on latest Oracle Release 12.2
- Well versed with Offshore/Onsite Model, Managed Services Shared model concepts
- Exposure to Hyperion 11.1.1.3 Installation and Production Support.
- Worked on different reporting tool like Discoverer 10g/11g, Portal
- Well versed with Oracle tools like rapidclone, adconfig, adadmin, f60gen, adctrl, license manager, adpatch, admerge, etc
- Installed and supported multiple instances using Application R12, Database 11g..
- Exposure to working on different Ticketing Systems like Infradesk, Assure Desk based on ITIL model.
- Worked on configuring different Database/Application monitoring Tools like HP Sitescope, Nagios Groundwork
- Installed and Configured Discoverer10g
- Worked on DB Vault Implementation and configuration to meet iTAR compliance.
- Involved in SAN Migrations from Pillar to Compellent
- Good understanding of Network, Operating System and Hosting Servers/Datacenter with several of my Clients were Hosted at Savvis Datacenter
- Successfully lead and implemented different Backup strategy for our end Clients
- Successfully lead and completed Standby/data guard implementation and DR failover tests
- Good understanding of Production SLA’s in Support/Maintenance of Oracle Database and Oracle Applications
Technologies: Oracle Applications R12/11i/12.2, Discoverer 10g/11g, Oracle ASCP, Hyperion, Database 10g/11g on Linux and Unix Environments
Confidential,Adrian MI
Senior Oracle Apps DBA
Responsibilities:
- Worked as Oracle Apps DBA for Masco Group on Oracle R12 implementation Project using Oracle Application Release 12 on AIX.
- Installed Oracle Applications Release 12 on AIX.
- Worked on Oracle 10g RAC Environment
- Created multiple Oracle Applications instances for Demo, Dev, UAT, Training, Test, QA and Production with multi-org.
- Used rapidclone, adconfig, adadmin, f60gen, adctrl, license manager, adpatch, admerge, etc as part of day-to-day activities
- Installed and supported multiple instances using Application 12, Database 10g..
- Supported customizations and Interfaces.
- Installed and Configured Discoverer10g/Portal
- Installed and Configured Oracle Transportation Management
- Setup and Registered Custom Forms, Reports, Responsibilities and Custom Top.
- Applied numerous patches including family packs, mini-packs
- Created backup scripts for both Hot and Cold for regular and on-demand backups.
- Configured and Implemented RMAN Backup to Backup Critical Production and Development Environment
- Responsible for performance tuning of database server, concurrent managers and applications
- Production Support and Maintenance of the Oracle Database and Oracle Applications Release 12 Instances .
Technologies: Oracle Applications Release 12, Discoverer 10g, Oracle Advanced Supply chain Planning and Oracle Transportation Management on AIX, Linux Oracle Database10g RAC
Confidential
Senior Oracle Apps DBA
Responsibilities:
- Working as Senior Oracle Apps 11i DBA for Confidential on Oracle 11i implementation Project and Production Support using Oracle Apps 11.5.10.2 on Linux 4.0
- Installed Oracle Applications 11.5.10.2 on Linux 4.0
- Created multiple Oracle Applications instances for Demo, Dev, UAT, Training, Test, QA and Production with multi-org.
- Used HP VMware Tools for Cloning different environment
- Used rapidclone, adconfig, adadmin, f60gen, adctrl, license manager, adpatch, admerge, etc as part of day-to-day activities
- Configured and Implemented BIS (Discoverer 10g) with Oracle Apps 11i.
- Installed and Configured Oracle XML Publisher 5.6 Patches on Oracle 11i.
- Installed and supported multiple instances using Apps 11i, Database 10g..
- Supported customizations and Interfaces.
- Setup and Registered Custom Forms, Reports, Responsibilities and Custom Top.
- Applied numerous patches including family packs, mini-packs
- Created backup scripts for both Hot and Cold for regular and on-demand backups.
- Configured and Implemented EMC Networker Backup Technology to Backup Critical Production and Development Environment
- Responsible for performance tuning of database, server, concurrent managers and applications
- Production Support and Maintenance of the Oracle Database and Oracle Applications 11 i instance.
Technologies: Oracle 11.5.10.2 on Linux 4.0, Oracle 10g on Linux 4.0
Confidential
Oracle Applications DBA
Responsibilities:
- Working as Oracle Apps 11i DBA for Cummins Turbo Technologies on Palmetto Oracle 11i implementation Project using Oracle Apps 11.5.10.2 on Sun Solaris 5.9.
- Installed Oracle Applications 11.5.10.2 on Sun Solaris 5.9.
- Created multiple Oracle Applications instances for Demo, Dev, UAT, Training, Test, QA and Production with multi-org.
- Cloned and refreshed instances numerous times.
- Used rapidclone, adconfig, adadmin, f60gen, adctrl, license manager, adpatch, admerge, etc as part of day-to-day activities
- Configured and Implemented BIS (Discoverer 4i) with Oracle Apps 11i.
- Installed and Configured Noetix Views with Oracle Apps 11i.
- Installed and Configured Oracle XML Publisher 5.6 Patches on Oracle 11i.
- Installed and supported multiple instances using Apps 11i, Database 9i..
- Supported customizations and Interfaces.
- Setup and Registered Custom Forms, Reports, Responsibilities and Custom Top.
- Applied numerous patches including family packs, mini-packs
- Created backup scripts for both Hot and Cold for regular and on-demand backups.
- Responsible for performance tuning of database, server, concurrent managers and applications
- Production Support and Maintenance of the Oracle Database and Oracle Applications 11 i instance.
Technologies: Oracle 11.5.10.2 on Solaris 5.9, Oracle 9i on Solaris 5.9
Confidential, Boston, MA
Oracle DBA/Applications DBA
Responsibilities:
- Production Support and Maintenance of the Oracle Database and Oracle Applications 11i instance.
- Oracle application/database/web servers - installation, patching and cloning
- SSL configuration and troubleshoot issues in 9Ias
- Monitoring Concurrent Managers for pending requests, long running jobs and requests error etc
- Upgraded Oracle database from 8.1.7.4 to 9.2.0.4
- Oracle Application Server troubleshooting and configuration
- Implemented various 9i new features like Undo Management, Dynamic SGA, Online redefinition of tables, index monitoring.
- Provided 24 * 7 Oncall Support for Production database maintenance
- Cloning of Database with Rapid clone, Autoconfig.
- Research, test and install Application Patches.
- Coordination with Oracle Support and functional teams in effective resolution of
- Lead the Disaster Recovery Exercise for Production Databases
- Worked on VLDB Enterprise Data Warehouse Environment of Production, Development and Test Database Environment
- Worked in Change Management Environment
- Experience with very large production databases (200 GB+)
- Familiarity with EMC Storage and BCV Technology for Cloning Databases
Technologies: Oracle 7.x/8.x/9i on HP-UX 11/11i, Windows 2000/NT,Oracle 10.7/11i on HP-UX 11
Confidential
Oracle DBA
Responsibilities:
- Install of Database Software on different Unix environment
- Creation of new database for different Projects
- Index size estimation, creation and maintenance.
- Monitoring of databases and maintenance of servers
- Patching
- Muiltisite Oracle Replication
- Oracle Database Administration, Security and user account management
- Database Backup/Recovery planning and Database backup - Hot, Cold.
Technologies: Oracle 7.x/8.x/9i on HP-UX 10.2/11.0,Solaris, AIX, Linux and windows Informix on HP-UX 10.20/11.0 SQL Server 7.0/2000 on NT/2000. Unix Servers like Sun E-250, E-450, E-220, HP, and IBM & Intel Series Application Server
Confidential
Oracle DBA
Responsibilities:
- Responsible for performance analysis and tuning and Capacity planning.
- Responsible for establishing backup and recovery strategy
- Responsible for Code and Data Migrations in various database
- Responsible for establishing backup and recovery strategy
- Installed, created and supported Oracle 7.x/8.x databases on Solaris
Technologies: Sun Solaris 2.6 and Oracle 8.0 for Database