SUMMARY

• 8+ years of experience as Oracle E - Business Consultant, provided 24x7 production support as well as for Development databases on 12c/ 11gR2/10gR2/9i/8i databases on different OS Platforms.
• Experience on oracle 12c/ 11g/ASM/RAC and converting of standalone databases to 11g RAC databases.
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Extensive technical and business experience in Procure-to-pay, Order-to-cash, Quote to Cash and Assets to GL Record to Report.
• Exposure in R12 Financial Modules and SLA, MOAC, TCA, E-BUSINESS TAX.
• Experience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
• Expertise in Client-Serverapplicationdevelopment using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADand SQL*LOADER.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-WriteandTransportable table spaces.
• Expert in the functional and technical aspects of Oracle E-Business Suite/ Applications 9i, 10g and 11i deployment Requirements, Coding/Development, Customizations, Testing, and Functional User Training.
• Strong experience inData warehouse concepts, ETL.
• Good knowledge on logical and physicalData Modelingusingnormalizing Techniques.
• CreatedTables, Views, Constraints, Index(B Tree, Bitmap and Function Based).
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• As Core Oracle database Administrator with Technical Services Infrastructure with Freddie Mac.
• Configure and administer Storage Area Network (SAN) and associated components; including Fibre Channel switch administration.
• Maintain storage aspects of new server integrations, storage allocation, and change management.
• Configure and administer Redundant Array of Independent Disks (RAID) storage and associated components.
• Its primary purpose is to set standards for transactions and information within the healthcare industry.
• Standardization of electronic patient health, administrative, and financial data.
• Unique health identifiers for individuals, employers, health plans, and healthcare providers.
• Installation, administration and maintenance of Oracle 11g/10g on OEL, RHEL, UNIX and Sun Solaris in OLTP environment.
• Configuration of Automatic Storage Management (ASM) for RAC databases using ASMLib and ASMCMD.
• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
• Delivering Oracle Database performance-tuning services for customers with Explain Plan, TKPROF, AWR, ADDM, ASH, SQL Trace, ORADEBUG, 10g OEM Grid Monitoring, Oracle Diagnostics pack, Oracle Tuning Pack.
• Experience in regular Database Administration activities such as Upgrades, Migration and Patches which are downloaded from oracle metalink.
• Installation and configuration of RMAN with and without Recovery Catalog on Oracle 12c/11g/10g databases.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)

TECHNICAL SKILLS

Operating System: Red Hat Linux, Solaris, HP-UX, Windows NT/2003/XP/7.

Databases: Oracle 9i/10g/11g, RAC 10g/11g

Languages: C++, SQL, PL/SQL, JAVA scripting, Shell scripting.

Web Servers: Apache Tomcat, Web logic

Tools: and Utilities(ORACLE): Import/Export, Data pump, SQL * Loader, SQL Trace, OEM, Explain Plan, STATSPACK, AWR, ASH, ADDM, RMAN, FTP, TKPROF, ASM. SAN.

Other Tools: WINSCP, Putty, TOAD.

PROFESSIONAL EXPERIENCE

Confidential, Scottsdale, AZ

Sr Oracle E-Business Consultant

Responsibilities:

• Implemented multi-org financial systems using Oracle E-Business modules such as GL, AR, AP, and CE
• 24x7 Production on call Database support.
• Installation and configuration of multi node Oracle 12c, Oracle 11g RAC, 10g RAC databases around 10 servers.
• Analyzingand understandingclient requirements and mapthemto work according toOracleApplicationR12.
• Experience in Resolving Concurrent Manager related issues
• Experience in troubleshooting Database and EBiz issues.
• Developed queries and Ad Hoc reports to extract business intelligence information from a Very Large Database (VLDB) that was in the Tera Bytes (TB) size using Oracle PL/SQL and TOAD software for Functional Government Customers.
• Monitored and troubleshoot Oracle Business Processes that consisted of Oracle Jobs in the OEM and Unix Shell Scripts, Materialized Views, PL/SQL constructs: packages, functions, procedures, tables, triggers, views, and types
• Experience in configuring Workflow Managers
• Good experience with Grid computing and RAC
• Scheduled jobs (Backups, Concurrent manager jobs)
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesformovingthe data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts todownloadand manipulate files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Configuring and implementing Standby databases (Active DataGuard) for high availability and disaster recovery purpose for RAC databases also involved in DR drills.
• Applied patches and patch sets on Oracle database and cluster ware by downloading from metalink and applying using OPatch utility.
• Installed and Configured Golden Gate.
• Trouble shooting and performance tuning golden gate replication.
• Assisted developers in creating Stored Procedures, Triggers, Functions and Packages.
• Responsible for memory and Application tuning of the databases using Oracle utilities like OEM, SQL Trace, TK Prof, Explain Plan, AWR, ADDM.
• Partitioning of large tables for better performance and management.
• Designed and implemented crash recovery strategies, and Hot, Cold and Logical backup plans.
• Performed Up gradation of oracle database from Oracle 10g to Oracle11g R1 and Oracle 11gR2, Performed Migration of databases from AIX to Linux environment using transportable tablespaces.
• Configured RMAN backup for RAC databases.
• Good experience of 11g RAC utilities like srvctl, crsctl, ocrdump, ocrcheck and ocrconfig.
• Performed converting single node instance to RAC and Adding instance to the existing 2 node RAC.
• Performance monitoring and Database/Instance/RAC tuning using Dictionary views, AWR, Stats pack, ADDM, ASH reports, OEM Grid Control.
• Performed Data pump operations for 10g and 11g Databases through command line and involved database refreshes using data pump.
• Implementing Database Replication using Oracle 10g Streams and Oracle Golden Gate

Environment: Oracle 12c,11g RAC, 10g, Grid Control 10gR5, SQL * Plus, TOAD, Oracle E-Business 11.5.7 (AP, PO, AR and OM), SQL*Loader,ASM, AIX, RHEL 4,5,, Oracle E-Business Application R12 (GL, AP,AR, FA,CE,OM, Service Contract, 9i, 10g, 11i and R12), Shell Scripting, Golden Gate . Data Guard, ASM, PL/SQL, RMAN.

Confidential, Irvine, CA

Oracle E-Business Consultant

Responsibilities:

• All screens were attached to Oracle E-Business menu for easy access. Extensively worked in performance tuning, security, deployment
• 24x7 Production on call Database support.
• Installed, configured and maintained Oracle 12c, Oracle 10g RAC, Oracle 11g RAC with ASM.
• Experience inDatabase Application Development, Query Optimization, Performance TuningandDBAsolutions and implementation experience incomplete System Development Life Cycle.
• UsedSQL Server SSIS toolto build high performance data integration solutions includingextraction, transformation andload packagesfordata ware housing.Extracted data from theXMLfile and loaded it into thedatabase.
• Designed and developedOracle forms & reportsgenerating up to 60 reports.
• Performed modifications on existingformas per change request and maintained it.
• UsedCrystal Reportsto track logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.
• Customized application according to Account Receivables Business process.
• Supporting custom interfaces to maintain an uninterrupted data flow between legacy systems andE-Businesssuite.
• Involved inbasiccustomizations inOracleApplication Framework(OAF)and OracleWorkflows.
• Setup the system to meet the desired business process and requirements based on knowledge about the Oracle Financials applications functionality and oracle Application Implementation methodologies.
• Implementing Oracle AP, AR, GL modules to meet Business requirements of the client.
• Created End User Layer and Business Areas using Discoverer Administrator.
• GAP Analysis, process mapping, training of end users and setting up new business processes in Oracle.
• Worked with developers and DBA team, to translate business needs into technical deliverables.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day. Used standard packages likeUTL FILE, DMBS SQL, and PL/SQLCollections and usedBULKBinding involved in writing database procedures, functions and packages for Front End Module.
• Involved in Migration of Non RAC single instance to Real Application Cluster (RAC) database instances.
• Completely built Oracle standby database (Data Guard) to ensure high availability, data protection and disaster recovery for enterprise data. Automated the tasks to monitor whether primary and standby databases are in sync.
• Performed capacity planning and bench marking.
• Involved in Capacity Planning for databases based on the future business growth requirements.
• Implemented Cumulative, Differential, Incremental backups using RMAN
• Written and modified UNIX shell scripts, to manage Oracle environments and scheduled through Crontab.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Organized various migration review meetings with the application team to discuss the migration strategy based on business requirements.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and active session history.
• Cloning & duplicating databases using scripts as well as RMAN for QA and developers.
• Implementing Range, List Partitions, Hash Partitions and Global and Locally partitioned indexes.

Environment: Red Hat Linux, AIX, Oracle 10g RAC and 11g RAC, Oracle Enterprise Manager/Grid Control, RMAN, Data Guard, ASM, SCP/SFTP, TKPROF, Oracle E-Business 11.5.10.2,Explain plan, AWR, ADDM, SQL* Plus, Crontab, PL/SQL, SQL* Loader.

Confidential, Austin,TX

Oracle E-Business Consultant

Responsibilities:

• Analyzed E-Business Suite system configuration and development changes using Gap analysis.
• Involved in 24x7 support for Production database and applications with on-call pager.
• Installation and creation and maintenance of 10g RAC and 9i databases for Testing, Development and Production.
• Wrote Shell Scripts forData loadingandDDL Scripts.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Remediating impactedOracleReports that contains obsolete 11i DB objects to make them work in R12 keeping the functionality intact.
• Remediation of existingOracleForms according to R12 functionality.
• Remediation of Discoverer Reports, Folder SQL query to achieve business functionality inEBSR12.
• Used OracleJDeveloperto support JAVA, JSP and HTML codes used in modules.
• Wrote conversion scripts usingSQL, PL/SQL, stored procedures,
• Conduct a study of the current GE’s applications and GE’s customer specific business rules and practices, user requirements and preparing specifications in the area of integrated General ledger
• Reported any functional gaps in existing applications and suggest business process improvements.
• Executed best practice business procedures and processes in application analysis and design. Designed custom interfaces, process and reports to meet client’s requirements in General Ledger, OM.
• Report any functional gaps in existing applications and suggest business process improvements. functionsandpackagesto migrate data from SQL server database to Oracle database.
• Performed Database Administration of all database objects includingtables, clusters, indexes, views, sequences packagesandprocedures.
• Provided support to customers to manage their operational dataranging from GB to TB in Oracle database, solving of space problem, data loading problem and other database maintenance operations.
• Designed and developed DS data flows and ETL components.
• Implemented both unidirectional replication as well as bi-directional replicate using Golden Gate.
• Upgraded production databases from 10g to 11g without downtime using Golden Gate.
• Involved in upgrades from oracle 9i to 10g, 9i/10g.
• Performed migration from 9i to 10g from AIX to Linux.
• Developed startup/shutdown guides, trouble shooting documents, root cause analysis documents.
• Worked on Data pump (Expdp / Impdp), Import / Export for logical database maintenance.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Constraints, Database Access, Roles and Privileges.
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users.
• Cloning databases from production to development and testing.
• Database Security User Management, Privileges, Roles, Auditing.
• Provided documentation for database design, analysis, modifications, creating schemas etc.
• Golden Gate installation and configuration.
• Replication using Golden Gate.
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining.
• Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.
• Resolving SQL tuning issues and Tuning Considerations for Different Applications.
• Monitoring the table growth, database growth, current users, and system resource usage and so on.
• Experience in SQL*Loader, loading data from flat files and from text files.
• Worked on Unix Shell scripting in csh, ksh for automating startup/shutdown of databases, getting system alerts etc
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Data guard. Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Implemented OLAP on Oracle platform using Oracle Express (OLAP server), Relational Access Administrator (RAM), Oracle Sales Analyzer (OLAP front-end) in Oracle 8i / 9i environment, Data Migration as part of enterprise data warehouse project. Logical and physical data modeling using Erwin, Dimensional / OLAP Data Modeling, Relational / OLTP modeling.

Environment: 10g RAC/9i, ASM, AIX, Sun Solaris, Red Hat Enterprise Linux, OEM, Explain Plan, Tkprof, SQL*LOADER, Oracle Express..

Confidential, Charlotte, NC

Oracle Consultant

Responsibilities:

• Responsible to provide 24 x 7 database administrative activities over different database servers.
• Involved in Installation, Upgrade from Oracle 9i to Oracle 10g and Configuration of Oracle NET services.
• Extensive experience in Performance Tuning, Memory Tuning etc.
• Applied patches including both one-off patches using OPatch as well as patch sets.
• Refresh/Cloning of database using data pump and RMAN utility.
• Standby Database setup and configuration.
• Worked alongside programmers and database developers for contributing to the development processes.
• Monitoring growth of tables and undertaking necessary re-organization of database as and when required
• Configuration of TNSNAMES.ora, LISTENER.ora for SQL*NET connectivity and resolving connection problems.
• Involved in decision making for the naming convention of datafiles, redolog files, tablespaces and segments.
• Partitioning Tables and indexes by determining the suitable methodology to improve performance and manageability.
• Maintained all documents of Oracle Database operations. Prepared documentation of database backup and recovery standards.
• Written shell scripts and automated nightly jobs using crontab to schedule the backups, exports and refreshing databases from production.
• OS level Tuning and balancing I/O by monitoring file system and tablespace I/O statistics..

Environment: HP-UX, Sun Solaris, Red Hat Enterprise Linux, OEM, Explain Plan, Tkprof, SQL*LOADER.

Confidential

Jr Oracle DBA

Responsibilities:

• Responsible for maintenance of production.
• Created tables, views, materialized views
• Database administration tasks included performing regular Hot&Cold Backups,Job Scheduling.
• Managing Database Structure, Storage Allocation, Table/Index segments
• Cloned databases from PRODUCTION to create TEST, DEVELOPMENT and UAT
• Configured and managed OEM to stabilized oracle database into healthy environment.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Trouble shooting performance issues using Explain Plan and TKPROF.
• Involved in numerous Unix Korn Shell Scripting pertaining to the activities of the DBA
• Maintenance & modification of Shell Scripts.
• Implemented Oracle's Advanced Features such as Partition table, Partition Index, Function Based Indexes and Loaded bulk data with SQL*Loader.
• Develop, document and enforce database standards and procedures.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth.
• Troubleshooting and fixing database listener issues.

Environment: Oracle 10g, Oracle 9i, Oracle 8i, RedHat Linux, Sun Solaris, Windows, Shell Scripts, RMAN, OEM/Grid Control, SQL*Loader, Data Pump