Oracle Engineer

Shailesh R. 510-***-****

Have extensive experience as an Oracle Database Administrator providing 24/7 support to Production, Test &Development environmentsfor Oracle 11g, 10g & 9i and older versions as well Developing Custom Scripts using Shell/PERL Scripts, SQL, PL/SQL, SQL*Loader.

Have working knowledge of Installing, Upgrading, Maintaining and Cloning Oracle Application Release 12.1.x.

Have working knowledge of Installing and Maintaining Informatica 9.5.1 and OBIEE 11.1.1.7

A team player and quick learner with strong attention to detail, excellent analytical and multi-tasking skills and the ability to manage projects, teams, and client relationships as well as work independently.

Experienced in:

Oracle Database Administration activities such as installation, patching, upgrading, migration, cloning, backup & recovery, performance tuning and capacity planning.

Design, test, implement, maintain, and control the companies’ databases including Oracle11g, 10g,9i across multiple Sun Solaris, Linux and Windows platforms.

Using Oracle Utilities & functions including export, import, SQL*Loader, OEM grid controls.

Hands on experience in designing and implementing Backup and Recovery strategies including hot & cold backups and using Data Guard

Hands on experience in Golden gate for replication.

Conducting Performance Tuning for 11g.

Conducting Performance Tuning for complicated SQL Scripts.

Developing, Implementing and Supporting Custom Scripts for Extracting, Transforming and Loading data, using Shell/PERL Scripts, SQL Loader, External Tables and PL/SQL.

PL/SQL, SQL and Shell Scripting for UNIX and Linux systems.

Creating and maintaining Triggers, Stored Procedures, Functions, and Packages.

Setting up CRONJOBs and Daemon Processes for Automation of Processes.

Supporting Oracle Applications Release 12.1.3 Administration activities such as installation, patching, upgrading, and cloning.

Installation and Maintaining Informatica 9.5.1 and OBIEE 11.1.1.7 for Customer Trials

Working with both onshore and offshore teams and coordinated onshore issues with offshore team.

Upgrading Oracle Databases from Older Versions to Newer Versions.

Working with Sales Team for preparing Pre Sales and Post Sales presentation to prospective clients.

Legal Status in US: US Citizen

Computer Systems Experience

Operating System Sun Solaris, HP-UX, Linux, Windows

Databases Oracle 9i, 10g, 11g

Applications Oracle Apps R12 (12.1.3), Oracle Enterprise Manager, Toad, SQL Developer.

Languages/Tools SQL*Plus, PL/SQL, UNIX Shell Scripting

Professional Experience

Xoriant Corporation, Sunnyvale, CA

Duration : Feb’13 to Current

Role : Sr. Database Engineer

Project : Support for Oracle Applications Release 12

Contribution:

Installed of Oracle EBusiness Suite R12.1.1 and upgraded to R12.1.3

Applying patches as per requirements from development teams

Clone of Oracle application environment using Rapid Clone for User Training and User Testing.

Search knowledgebase of ‘My Oracle Support’ for getting solution for the issues reported by Development Team. In case if, there is no solution available, raising SR, getting solution and applying patches.

Designed, Developed and Implemented the Back Up and Recovery Procedures.

Developed scripts for monitoring growth of Database (TableSpaces, Data Files, and Segments etc.) which helps in space management.

Assisted Developers in fine tuning the SQL scripts for better performance.

Admin Tasks like:

oSetting Up Printers

oSchema Analyze

oUser Management

oConcurrent Managers

Used Oracle Application tools for maintaining database and application like adadmin, adpatch,adctrl, adautocfg, etc

As R12.1.3 went in production mode from Jan’14, maintained 11.5.6 production instance till the audit for 2013 is finished.

Supporting Special projects team for the Database requirements like:

oInstallation multiple instances of Vision Instance of R12.1.1 under RedHat Linux

oInstallation of Standalone Oracle 11gR2 Database under RedHat Linux as well as Windows

oInstallation of OBIEE 11.1.7

oInstallation of Informatica PowerCenter 9.5.1

oCreating Schemas for

DAC Repository

Informatica Domain

Informatica Repository

Oracle Business Analytics Warehouse

oTechnical Documentation of the entire project Steps.

Environment: RedHat Linux, Sun Solaris, Oracle Applications R 12.1.3 and 11.5.6.

Dialogic Inc. (FormerlyVeraz Networks, San Jose, CA)

Duration : Nov’05 to Jan’13

Role : Sr. Database Engineer

Project : Database Administration for Customers’ Database which stores various Data entities for EMS (Element Management System), DSE (Directory Service Engine) as well as CDR Call Data Recorder. Perform Installations and Upgrades of EMS, CDR and DSE Applications.

Installation and Support for Oracle Applications R12.

Design, Develop, Implement and Support the Customized Data Bulk Load scripts using Unix Shells, SQL, PL/SQL, SQL*Loader and APIs developed by Engineering, Scripts using Unix & PERL Shells to bulk load and transfer data from one server to another server.

Customer Support for the VoIP (with EMS, CDR and DSE)Applications.

Contribution:

Supporting Customers byinstalling and maintaining Oracle Database 9i& 11g on EMS & CDR and 10g on DSE for:

Installation of Oracle Database 9i, 10g & 11g along with EMS, CDR and DSE Applications

Maintaining Table Spaces and Data Files

MaintainingUser Schemas,

MaintainingDatabase Triggers

MaintainingProcedures

Database Backup and Recovery

Fine Tuning the Sequel Scripts developed by Customers for their OSS

Upgrading to Newer Versions of Customers’ Application in Production environment.

Providing training for new versions of application to Customers.

Installed Oracle Apps R12.1.1 and upgraded to 12.1.3 for Financial Modules like, AR, AP, GL, PO and Project.

Cloned and maintained multiple instances of Oracle Apps R12.1.3for Development and Testing.

Supporting Production Instances of Oracle Apps R12.1.3

Studying the As-Is Business processes of clients, and analyzing gaps in the existing processes to highlight areas of improvement.

Evaluating user requests for a new or modified program, compatibility with current system and computer capabilities.

Identifying the relevant activities, testing, monitoring and reporting about the progress.

Formulating plans outlining steps required to develop program, using structured analysis and design.

Preparing Statement of Work with

To-Be Processes Specifications.

Required Tools.

Estimated Efforts

Gaining user acceptance for SoW via Purchase Order.

Preparing Project Plan based of approved SoW.

Preparing Technical Design Document:

Breaking the complete task into sequence of sub-modules with detailed instructions and logical steps for coding

Using MS Visio flowcharts and diagrams

Preparing the Test Plan with Test Cases.

Developing the new Scripts for the Customer Applications using Oracle Database, PL/SQL, SQL*Plus, SQL*Loader and k-Shell under Sun Solaris environments.

Unit and End to End Testing

Preparing Installation and User Guide for the new Scripts.

Implementing the new Scripts on Customers’ Lab and Production Systems.

Analyzing, reviewing, and altering programs to increase operating efficiency or adapting to new requirements.

Developedand maintaining the Installation procedure for EMS and CDR Applications which includes installation of Oracle 9i, 10g and 11g and creating User Schema using the Template.

Environnent: Sun Solaris 5.8, Sun Solaris 5.10, Linux, Oracle 9i, Oracle 10g, Oracle 11g

Cisco Systems, San Jose, CA

Duration: Feb’02 to Nov’05

Role : Database Analyst (As Consultant).

Project :Development and Maintenance of PL/SQL Packages for Customized Quoting Module using Data from Install Base and Contracts for Services Modules of Oracle Applications. Production Support for the Customized Quoting Tools.PL/SQL Development for Customized Quoting Tools.

Contributions:

Prepared the Functional and Technical Design Documents after reviewing the Business Requirement and Functional Design Documents. Preparing the Test Cases.

Prepared Process Flow Diagrams using Microsoft Visio.

Developed and maintained of Packages, containing Procedures and Functions, used for create, modify and convert quotes to contract using PL/SQL.

Conducted Unit Tests and Integration Testing.

Provided training for new versions to End Users

Developed SQL Scripts for querying the Oracle Apps 11i’s tables for Contracts and Installed Base modules and querying and modifying the customized tables for the Quote Data

Fine Tuned SQL Queries using Explain Plan, Hints for Cost Based Optimizer and adding new indexes.

Prepared and executing packages for migrating code from Development to Test (for CRP and UAT) and Production instances using Kintana’s APPS Integrity tool.

Production support for the Quote Conversion Errors for Customized Quoting Applications SCC and IQT.

oSupported the business to identifying the data that causes issues during the Quote conversion.

Version Control and Code Migration for monthly and quarterly releases:

oUsed PVCS for Source Code Control for the Customized Forms, Reports, SQLs and PL/SQL Packages.

oCode Migration for Customized Forms, Reports, Concurrent Programs, SQLs, PL/SQL Packages and Shell Scripts from Development Instance to Production Instance via Stage Instance using Kintana’s APPS Integrity tool.

oDeveloped shell scripts those are used for Release Management Spread Sheets.

Environment: HP UNIX, Oracle 8.0.6, Oracle 8.1.7, Oracle Applications 11.5.6.

Xoriant Corporation, Sunnyvale, CA

Duration : Jul’98 – Feb’02

Role : Consultant as, Oracle DBA, Oracle APPS DBA and PL/SQL Developer.

Projects :

1: Fujitsu America Inc, San Jose, CA

Duration : Jul’01 – Jan’02

Role : Oracle APPS DBA and PL/SQL Developer (As Consultant)

Description : Oracle APPS 11i Implementation for GL, AR, AP, PO, FA and OM Modules

Contributions:

Installed, maintained and cloned various instances of Oracle Applications Release 11.5.4 for Development, CRPs, UAT and Production.

Installed Oracle Applications Desktop Integrator and Oracle Workflow on Client Machines.

Applied Family Patch sets, Patch sets and single patches to GL, AR, AP, PO, FA and OM modules along with AOL using adpatch utility. Also used adctrl, adsplice, and adlicmgr as and when required. Used adadmin utility for maintaining Applications Database Objects and Applications Files. Performed System Administrator’s activities like Creating and Maintaining Users, Responsibilities, Configuring various types of Printers for Oracle Applications etc.

Created and maintained Backup, Recovery and Refresh scripts using Unix Shell Scripts, for Oracle Database. Used Oracle’s DBA Studio (Oracle Enterprise Manager) for monitoring and managing the Database Objects.

Provided training to Client’s Administrators for System Administration.

Communicated with Oracle Support group through Tars and used metalink effectively for issues related to modules, patch application and Databases.

Tuning SQL Queries using the Hints.

Developed PL/SQL package for loading Employee and Vendor data from ASK ManMan System to Oracle Applications.

Environment : Sun Solaris, Oracle 8.0.6, Oracle 8.1.7, Oracle Applications 11.5.4.

2: Xoriant Corporation, Sunnyvale, CA

Duration : Jan’01 – Jun’02

Role : Oracle APPS DBA and PL/SQL Developer

Description : Migration from Apps 10.7 to Apps 11i

Contributions:

Installed and administered various instances of Oracle Applications Rel. 11.5.3.

Applied one of Patches, Family and Mega Patches for upgrading CRM module using adpatch utility. Also used adctrl, adsplice and adlicmgr as and when required. Used adadmin utility for maintaining Applications Database Objects and Applications Files.

Created and Maintained Users, Responsibilities, executables, menus, concurrent programs etc.

Scheduled and Monitored the Concurrent Jobs.

Created and Maintained UNIX Shell Scripts for monitoring backups for Database. Used Oracle’s DBA Studio for monitoring and managing the Database Objects.

Tuned SQL Queries developed by other developers using the Hints for Cost Based Optimizer.

Cloned APPS 10.7 Database for Development, Testing and QA instances.

Developed SQL scripts to migrate FND tables of 10.7 to FND Tables of 11i.

Environment : Sun Solaris, Oracle 8.0.6, Oracle 8.1.7, Oracle Applications 11.5.4.

3: SubmitOrder.com, Columbus, Ohio

Duration : Apr’00 – Dec’00

Role : Oracle APPS DBA and PL/SQL Developer

Description : Implementing Siebel’s Call Centre Management Module

Contributions:

Developed & maintained Database Procedures using PL/SQL for loading data to CRM Database for Siebel’s Call Center Management module from Oracle’s TPE for Products and Order Entry Modules.

Developed and maintained Pro*c program to get the tax data from Taxware Database. Developed and maintained Pro*c program to generate reports

Developed and maintained c program to authorize the payments through credit cards using the Paylinx APIs.

Helped Oracle DBA in Developing Unix Shell scripts for running the loading and extracting data to & from Oracle and Backups.

Environment : Sun Solaris, Oracle 8.x, PL/SQL, c, Pro*c, Taxware, Paylinx and

Siebel’s Call Center Management.

4: Netscape Communications, Mountain View, CA

Duration : Feb’99 – Mar’00

Role : Oracle DBA and PL/SQL Developer

Description : Production Support to multiple Databases and CustomizedApplications and

Oracle APPS 10.7 Instance

Contributions:

Created & maintained multiple Databases.

Created & Maintained User Schemas, Database Triggers & Procedures,

Developed Scripts for Database Backup and Recovery

Scheduled and monitored Database Backups.

Carried out the migration of database from 7.3.3 to 7.3.4 and from 7.3.4 to 8.0.5 using the migration utility provided by Oracle.

Helped developer users in fine-tuning the SQL queries.

Developed and maintained UNIX shell scripts for running the loading and extracting data to & from Oracle.

Maintained Oracle APPS 10.7 SC Instance.

Developed & maintained Database Procedures using PL/SQL for loading data to Oracle from flat files and extract data from oracle to flat files.

Developed and maintained Pro*c programs to generate reports.

Environment : Sun Solaris, Oracle 8.x, PL/SQL, c, Pro*c, Taxware, Paylinx and

Siebel’s Call Center Management.

5: A T & T, Sommerset, NJ

Duration : Jul’98 – Jan’99

Role : Oracle DBA and PL/SQL Developer

Description : Implementing Siebel’s Call Centre Management Module

Contributions:

Responsible for Installing, Creating & Maintaining Databases, Backup and Recovery Scripts, User Schemas, Database Triggers & Procedures, monitoring backups. Also responsible for helping other developers in fine tuning the sql scripts.

Also developed & maintained Database Procedures using PL/SQL to fetch, insert & update the information about frauds of different nature and generating priorities & alerts. Developed simulators to generate test cases used for unit testing using embedded PL/SQL in Pro*C programs.

Environment : Sun Solaris, Oracle 7.x, PL/SQL, Pro*C.

DDE ORG Systems Ltd, India

Worked as Software Engineer, Sr. Software Engineer and Manager, Software Engineering doing Installations and Upgrades of UNIX, Problem Solving, Trouble Shooting of Unix, Installation and Upgrades of ORACLE 4, 5, 6 and 7.3.x, ORACLE DATABASE Administration, DATABASE Backup & Recovery, Supporting Oracle and Application Software developed in-house, Technical Guidance/Support to Customers in Unix (File Systems, Security and Backup Management), Technical Guidance/Support to Customers in ORACLE, Participated in Developing Customized Applications for Clients of DDE ORG Systems using Oracle RDBMS and Oracle Tools under Unix and Second and Third Generation Languages in Team Member, Team Leader and Project Leader capacity.

Contact this candidate