Sr. Oracle DBA Consultant Resume West Des Moines, IA - Hire IT People

PROFESSIONAL SUMMARY:

Result oriented professional with around 10+ years of Industry experience in Oracle and related technologies.
Worked on Pricing & Quoting in R12.
Suite including Oracle Order Management, Oracle iPayment, Purchasing, Oracle Inventory Management, AR, AP - R12, 11i, 11.0.3.
Conversant with Order to Cash, iPayment, Procure to Pay Flow and designed several business process maps for clients
Experience in creating Functional specifications and reviewing technical design documentation and unit testing in applications using Testing tools, Oracle Forms/Reports6i, Discoverer,PL/SQL queries, Concurrent programs, conversions, interfaces concerning RICE components.
Experience in Configuring 10g/11gR2 Oracle Real Application Clusters (RAC), Automatic Storage Management (ASM) and Data guard.
Installed OracleGoldenGate and configured heterogeneous replication.
Experience with very large scale database environments and mission critical OLTP and OLAP systems.
Experienced in Installation, Patching, Cloning, and Upgrade of Oracle Databases.
Experienced in Backup&Recovery, Disaster Recovery options, Oracle Recovery Manager (RMAN).
Provided 24x7 production support
Experience in working with Grid Controland Oracle Enterprise Manager (OEM).
Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning.
Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, packages, performanceTuning, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
Experience in maintaining Oracle Data Guard&Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
Experience in Migrating Data using Oracle Data Integrator.
Experience in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
Expertise Oracle Enterprise Manager (OEM), Grid Control, TOAD, RMAN.
Cloned Database from Production to Test and Development.
Experience in migration of oracle databases and installing patches.
Exporting and Importing of dumps using expdp and impdp.
Experience on handling VERY LARGE DATABASES (VLDB).
Experience in Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, AWR report, 12c OEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities.
Experience in SQL Server databases (2000, 2005, 2008, 2012), SSIS and SSRS
Reviewed functional requirements related to Oracle payroll, HRMS,
Oracle payroll consultant for a two phase Oracle 11i HRMS/Payroll implementation
Knowledge of Oracle HRMS and detailed functionality
Oracle HRMS/Payroll Release 10.7 to 11i upgrade
Involved in understanding of Software Development Life Cycle (SDLC) phases - including requirement gathering, functional design, technical design (MD070), unit-test plans (TE020), and execution and application maintenance..
Proficient in estimating efforts in design, development, unit testing.
Have covered all testing phases such as, Unit testing, Regression testing, Integration testing.
Conducted UAT sessions and managed UAT Checklist
Worked on test planning, test cases designing and execution.
Experience in Software Development Life Cycle (SDLC), Web Application using Java/J2EE technologies.
Working Knowledge of Programming Language like Java, J2EE

TECHNICAL SKILLS:

ERP Application: Oracle HRMS,Oracle Applications EBS R12, 11i - Oracle Supply Chain Management (Order Management, Purchasing, and Inventory) and working knowledge of Oracle Financial (AP, GL, AR), iPayment

Databases / DB Tools: Oracle, TOAD, SQL*Plus, SQL Developer, PVCS, Perforce

Application Development Tools: Oracle Reports, XML Publisher, SQL Loader, Discoverer, Jet Forms.

Programming Languages: SQL, PL/SQL, Java, J2EE

Desktop Tools: MS Office suite 2003 and 2007

Methodologies / Techniques: Enterprise Resource Planning (AIM - OUM)

Operating Systems: Windows NT, Windows 98/2000/2007/ XP/Vista/7

WORK EXPERIENCE:

Confidential, West Des Moines, IA

Sr. Oracle DBA Consultant

Responsibilities:

Successfully implemented 11g R2 RAC on 4 nodes for high availability.
Involved in Knowledge Transfer of Golden Gate Product and Installed Golden Gate(10.4/11.1)
Hands on experience in troubleshooting RAC databases.
Installation and creation of 10g and 11g databases for Testing, Development and Production.
Successfully implemented oracle 11g grid control.
Installed and applied patches for oracle 11g and 10g databases for supporting applications.
Up-gradation and Migration of Database from 10.2.0.4 to 11.2.0.3 and applying patches whenever required.
Applying upgrade patches, maintenance and interim patches on all the databases.
Configured Automatic storage management (ASM) with EMC storage for managing data in SAN.
Involved in 24x7 supports for production databases with on-call pager.
Involved in EDW Support for OLTP and OLAP Data ware house Applications.
Installation of database software and with analyzing, designing, and implementing databases.
Used Oracle Real Application Testing for performing tests in QA environment.
Creating and Managing Table spaces with different block-sizes to prevent row chaining.
Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, SQL profiling and TKPROF, STATSPACK.
Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack.
Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
Involved in applications administration including 11g Database/Applications cloning, tuning, patching and monitoring concurrent manager processing etc.
Experienced in handling database issues using OEM as well as command prompt.
Worked with T-SQL statements like DELETE and UPDATE statements and also like BULK insert of data into the datable.
Other activities like applying RDBMS patches, security patches, sox reporting proactive monitoring of databases and applications.
Experience in DB capacity planning, data normalization and rationalization
Loads databases, reorganizes as necessary, and assists in monitoring database performance
Developing and Implementing Disaster Recovery (DR) Plan using Datagaurd.
I along with team implemented physical standy database using Datagaurd.
Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures
Daily Health Check Up of the Database using staspack, AWR, ADDM & ASH.
Rebuilding of Indexes for better performance, maintenance of Oracle Database.
Performance tuning of Oracle Database Objects by fixing row chaining.
Taking periodic Backup of the Database and the software using RMAN and VERITAS Netbackup.
Written shell scripts for digitization the process. Scheduling jobs through Oracle Job Scheduler.
Maintaining security of databases and users.
Reading Alert Log and User trace Files and Diagnosing the Problem.
Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
Installation and configuration of Oracle Client software and Tools.
Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration·
Written Shell scripting which monitors the server’s performance and logs output on periodic basis to database.
Supported Production issues relating our data warehouse databases.
Worked along with the teams supporting various applications relating to data warehouse.
Written SQL scripts to monitor table space and extent growth.
Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints
Space Management which includes table space creation, adding new data files.
Experienced with monitoring the database security issues and resolving them on timely basis.

Environment: Oracle Applications R12.0.3. (Order to Cash) Oracle SQL, PL/SQL, Oracle Reports 6i, Conversion, Interfaces, MYSQL,Windows XP, Oracle 9i/ 10g, RAC, OEM, Grid Control, RMAN, DBCA, Data Guard, Putty, TOAD 8.1, UNIX, Linux 4.0,SQL DEVELOPER

Confidential, Mclean VA

Sr. Oracle Consultant

Responsibilities:

Involved in developing the Process flows for the Order to Cash, AP, AR, GL
Implemented Oracle Financials 11i iPayment, Accounts Payable
Exports and imports from one Oracle database to another (proprietary binary format)
Set up Drop ship Functionality to enable the OM team to ship the goods directly to Customers from Supplier warehouse.
Responsible for developing and maintaining documentation like RD020, BR-100, TE040 test scripts and results
Conduct oracle training for the business users
Reviewed functional requirements related to Oracle payroll, HRMS,
Oracle payroll consultant for a two phase Oracle 11i HRMS/Payroll implementation
Provided extensive user support during CRP,UAT and Post Production phases
Requirement gathering from business users.
Worked on Pricing and Quoting in Oracle R12.
Preparing Technical design documents.
Taking part in business reviews for Functional / Technical design documents.
Responsibility for quality and on time delivery from offshore.
Providing data profiling details to customer’s IT team.
Responsible for doing POC for new functionality and providing feedback to business users.
Providing estimates to customer / IT leads.
Experience in Software Development Life Cycle (SDLC), Web Application using Java/J2EE technologies.
Imports/exports all schema object types
Imports/exports entire database, entire schema, multiple schemas, multiple table spaces, or multiple tables.
Introduced new templates for Release Planning, RCA, Test cases, Defect reporting, Managed Test status report
Conducted UAT sessions, managed UAT checklist and UAT status reports.
Test planning, designing and execution, bug reporting and verification

Confidential, Chantilly, VA

Oracle DBA

Responsibilities:

Provided Oracle database administration support in OLTP and DSS corporate environment.
Managed Data warehouse(Cognos) Databases DSS
Built Development, UAT, QA, Performance and Production environment to support People soft application.
Implemented Golden Gates replication between RAC and non RAC database environments.
Successfully configured and installed Oracle Golden Gate for replication.
Maintained the Heart beat tables to check the lag between the sites.
Installed Oracle Golden Gates as an enhancement for the Client’s DW method and monitored issues using Grid Control.
Worked with application team to help resolving the conflict and trouble shouting the replication issues.
Involved in Installation and configuration of Oracle 10g &11gRAC using Cluster ware and ASM.
Experience in cloning RAC databases using RMAN tool .
Experienced in Design, implementation and generation of documentation on Oracle 10g &11g Data Guard on physical standby databases in high availability mode.
Writing and modifying UNIX shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle Processes.
SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
Implemented backup strategies using hot/cold, exp/imp used on the business req.
Cloning databases using scripts as well as RMAN and performed Table space point in time recovery (TSPITR) using RMAN.
Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
Assisted DBAs’ team to help migrate databases from Oracle 9i Release 2 to Oracle 10g Release 2.
Worked on Automatic Storage Management (ASM) with SAN Storage for managing data in EMC Symmetrix.
Work with team members to provide 7x24 production support
Utilize a working knowledge of Oracle database and consuming third-party applications to troubleshoot technical issues, i.e. error messages, software bugs, availability, etc.
Worked very closely with developer for performance and tuning for database
Worked with ADDM, AWR and SQL tuning advisor to tune any long running queries and overall database sessions.
Performed cold backups
Respond to trouble tickets and customer requests.
Monitor and troubleshoot database backups, disk space, and server availability.
Setup, configuration and management of Oracle Enterprise Manager.
Implemented and monitored user access and security.
Conducted and managed full and incremental database backups via RMAN.
Documented database and related server equipment & procedures.
Configured and updated user security in accordance with agency policy.
Troubleshot errors related to availability of data to system users, space, database software, or data access.

Confidential - Dallas, Tx

Sr Database Administrator

Responsibilities:

Performed CloningUpgraded Database from10.2.0.3 to 11.2.0. and from 11.2.0. to 11.2.0.3
Performed Migration of databases from Unix version to Linux two Node RAC and performed data transition using Golden Gate version 11.2.0.7
Production support Maintenance activities, written shell scripts for Monitoring production activities.
Perform general technical troubleshooting and working with Functional teams for possible solutions for various issues.
Concurrent manager administration and Oracle Apps sysadmin functions.
Performed Backup and Recovery using RMAN and written shell scripts for scheduled online backups.
Troubleshooting RMAN backup and recovery related issues.
Worked with Oracle Corporation to resolve applications/database issues by opening TAR/SR
Supporting Oracle Databases 9i/10g/11g also RAC on Linux
Experience in troubleshooting some Oracle EBS hosted databases on R12 and 11.5.10.2
Performed Cloning, export/import and Patching.
Designing the logical and physical database structure.
Designing the security and database access strategies.
Taking Backups on scheduled time and monitoring scheduled Backups
Performing backups and recoveries using RMAN conventional hot backups.
Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
Expertise in installing, designing and testing using the Golden Gate in RAC for the high accessibility of data-Integration and data replication in the oracle 11g environment.
Creating and dropping of users, granting and revoking rights as and when required.
Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
Tuning heavy data loads. Monitoring and Performance tuning.
Monitoring of database for growth and performance
Monitoring Database for fragmentation and correcting them.
Performed and Monitored Database using tools TOAD and OEM 10g.

Environment: Oracle Server 10g/11g, SQL, PL/SQL, Linux Itanium, Solaris 10, Shell scripting, TOAD, OEM 10g, Oracle EBS, Golden-Gate, MYSQL,Windows XP, Oracle 9i/ 10g, RAC, OEM, Grid Control, RMAN, DBCA, Data Guard, Putty, TOAD 8.1, UNIX, Linux 4.0,SQL DEVELOPER.

Confidential, Richmond, VA

Oracle Database Administrator

Responsibilities:

Performed configuration, Installations of ORACLE 11gR2 RAC databases Including Grid Infrastructure.
Configured application backups / RMAN, worked on Data pump, ASM and RMAN.
Configuration, Installation and maintenance of Oracle 11gR2 RAC databases including Grid Infrastructure.
Performed upgrades from Oracle 10g to 11g and applied patches.
Involved in setting up of data guard for 2-node standby.
Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
Worked on Features: Data Pump, ASM and RMAN. Data Base Recovery (complete & Incomplete).
Proficient in managing Oracle Instance, database storage structure, schema objects.
Experienced with SRVCTL, OCR and Voting Disk of 10g, 11g RAC.
Experience in SQL Server and MYSQL databases.
Experience in Supporting Teradata for data ware Houses and analytical applications.
Involved & performed Production Change Requests for PROD major DB changes. New DB creation, Existing DB deletion, various DB Housekeeping activities. Implemented 10g RAC on a test basis.
Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
Involved in the matters of performance issues and auditing the required down time.
Installing ASM environment and migrating database from NON-ASM to ASM.
Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production supports.
Skilled with AWR, ADDM, SAR to check health of database & hardware.
Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users. Co-coordinating with on-site counterpart as well as Clients and understanding requirements.
Installation of Oracle database 10g software with RAC using Oracle Clusterware. Oracle Data Guard setup done for RAC. Installation of Oracle 10g management agent and grid control.
Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning.
Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
Knowledge on Oracle Golden Gate.
Created Cluster database, Cloning of Cluster database on Linux, start and stop Cluster database services.
Designed and developed Database structures (Database triggers, Procedures, Functions to implement business Rules). Loaded data into Database using external tables.
Expert in Oracle Utilities and Tools like OEM, Import-Export, RMAN.
Exposure to AS400 IBM Server.

Environment: Oracle 9i/10g, Oracle Applications 11i (11.5.10), iProcurement, Purchasing, Procure 2 Pay, Inventory, Payables, Oracle Workflow, PL/SQL, SQL* Loader, Reports 6i, SQL*Plus, MYSQL,Windows XP, Oracle 9i/ 10g, RAC, OEM, Grid Control, RMAN, DBCA, Data Guard, Putty, TOAD 8.1, UNIX, Linux 4.0,SQL DEVELOPER.

Confidential, Irvine, CA

Oracle Apps 11i iProcurement / Functional Consultant

Responsibilities:

Gathering the requirements from Business owners, Users group.
Presenting to the users how the system would work according to the requirements.
Presentation on how a blanket works and explained the advantages of a blanket.
Creation of the structure of the item category.
Worked on Order to Cash (O2C) life cycle and supported Pricing & QuotingOrder Management, Inventory, Shipping Execution and PO modules.
Oracle Order Management, Oracle Receivables, Oracle iPayment, iProcurement .
Involved in Implementation of Procure to Pay (P2P) cycle which includes Items and Categories, Requisitions/Quotations, Purchase Orders, Receiving, Inventory, and processing Invoices.
Assigning of all the categories to a category set in order to make them available in Purchasing.
Creation of Realms and assigning those realms to different users, i-proc responsibility depending upon the business requirements.
Worked on Bulk loader extractor in order to load catalogs into i-procurement.
Worked on Punch outs (from which the users will be redirected to the supplier website and can add the items from supplier inventory to i-procurement shopping cart).
Creation of Blankets and extraction of blanket data, categories into i-procurement.
Personalized iProcurement web pages according to the business requirements.
Defining the Approval groups, jobs and assigning the approval groups to jobs and assigning those jobs to employees (Employee Supervisor hierarchy) depending upon the business requirements.
Creation of Vendor master.
Creation of Approved Supplier List linkages in order to auto creates the requisitions into blanket releases without manual intervention.
Customized the Requisition Approval Workflow in order to send some notifications to the users based on some specific business requirements.
Worked on Order to Cash Cycle, starting from enter order stage to move order stage followed by the ship confirm and updating the GL.
Developed Custom program to convert Suppliers and SupplierSites in AP Module.
Developed Custom program to convert Invoices in AP Module.
Developed Custom program to convert PurchaseOrder in PO Module.
Creation of training documents to the users on how to use the system.
Presentation of the training documents to the users.
Ran several CRP s.

We provide IT Staff Augmentation Services!

Sr. Oracle Dba Consultant Resume

West Des Moines, IA

Client Services

Job Seekers

Visa Sponsorship