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