BRIEF PROFILE

An Oracle Applications Server System Administration and Database Administer with over 10+ years of IT experience which includes 5+ years in Oracle Applications Server / ERP and 4 years in Oracle Database Administrator Technical and Production Support. Experience in Oracle Application Server utilities like ADPATCH, ADADMIN, APPS Cloning, Portal Cloning, CRS, RAC, ASM, OIM, SSO, OID and database administration tools like Import/Export, RMAN, and Oracle Enterprise Manager with execution of 2 node and 3 node RAC implementations. Effective team player with building, leading, managing and motivating the team, conflicts resolutions, defining KRAs of each team member, excellent communication, presentation, inter-personal and leadership skills. Have also acquired knowledge on engineering activities for Business Intelligence tools like Oracle BI, Business Objects, Oracle BI, Kintana and Clearcase. LogicalApps for Governance, Risk, and Compliance (GRC) controls for enterprise applications.

Oracle Application 10.7 / 11.5.10 / 12.0.4
Oracle Application Server 10.1.2 AS
Portal 10.1.2
OID and SSO 10.1.2

SCM (Supply Chain) | FINANCIALS | HRMS
WIP (Work in Progress) | AP (Account Payables) | Payroll
INV (Inventory) | AR (Account Receivables) | Core HR
BOM (Bill of Material) | GL (General Ledger) | OAB (Advance Benefits)
ENG (Engineering) | CE (Cash Management) | Clear Orbit for SCM
OE (Order Entry) | ASP \\ OIM
Purchasing
OM (Order Management)

PC Pentiums | IBM - AIX
HP-UNIX | Sun Solaris | Red Hat Linux

Database: Oracle 11g, 10g, 9i, 8i, Teradata, SQL Server 7.0, Visual FoxPro 6.0, FoxPro2.6a, Access
Tools: SQL, PL/SQL, SQL*Loader, Oracle Enterprise Manager, Oracle Management Server, TOAD, RMAN, SQL Backtrack 2.0, OraSecure2.0, Statspack, SQL Trace, Tkprof, Import, Export, Data Guards, SQL Navigator4.0, DB Designer, Kintana, Clearcase, LogicalApps, GRC.

Programming languages: Visual Basic 6.0, UNIX Shell Scripts
Reporting tools: Crystal Reports 7.0
Operating systems: Sun Solaris, IBM AIX, HP - UX 10.2, Red Hat Linux AS4.0, Windows 9x/NT/2000

CERTIFICATION:

Oracle Certified Professional (OCP)

EDUCATION:

• Oracle Application 11i System Administration Course
• Oracle 9i DBA course
• Master's in Software Engineering (MSE)
• Bachelor's Degree in Science

CURRENT STUDIES:

• Preparing for PMP (Project Management Professional) Certification through PMI.

ACHIVEMENT:
Awarded Personnel Best Award Employee in the year 2001 by British Gas Exploration and Production India Ltd.

Confidential, 125 Wolf Road, Albany, NY - 12205
04/27/2009 - Till Date
Professional Consultant

Currently working on Oracle Applications Server 10.1.2 and IBM AIX 5.3 as Oracle Server Admin/DBA.
Routine activities involved are Installing applications, Migrations, Patches and Cloning related activities in the DEV / TEST / QA / PRODUCTION environment and working on 100+ instances.
Raise and Follow up MetaLink Service Requests to update patches.

As a DBA / System Admin working with different teams like the Application Development, Integration Test, QA and PROD users towards production support and issue resolutions.

• Installing, configuring and supporting Oracle database and LDAP (OID) servers in a UNIX environment.
• Administration of all environments starting from DEV, TEST, QA, and Production Server.
• Administration for various application servers with OID (Infra Tier) and Portal (Mid Tier) for Oracle application.
• Ability to perform backup and recovery operations related to Oracle database and application servers.
• Managing NYSDOT Mexis portal and CARSGOOGLE applications from migration to troubleshooting production servers.
• Migration of various application carried out such as Permits Automation, ADRP, MAMIS etc., which is critical and availability of these production applications is 24x7.
• Supporting enterprise level Database and Web Server application in a multi-tiered, UNIX environment, including a strong knowledge of shell scripting and cron jobs.
• Streamlining the Administration, Support, Maintenance process for Oracle Application Server, Unix systems, Oracle database and others, document related settings and troubleshooting
• Interacting with end-users for oracle application problems and Trouble-shooting technical and functional issues.
• Installation of Application Patches, Releases and New Applications.
• Worked closely with the Application Development team in solving user and application issues.
• Run LDAP commands for exporting or importing users/roles in OID using ldif files.
• Register programs, reports, and forms, copy files to Linux, compile source code.
• Support Self-service application for employees, and assist with implementation of Single Sign-on
• Perform printer setup and work on printer related problems
• Analyze patches from Oracle, check pre-requisites, coordinate patch release.
• Worked closely with Production Management on promoting code to instances
• Create an instance strategy to support Production and ongoing initiatives
• Develop and maintain strong relationships with other teams within the IT organization, including Operations, the DBA team, and Application Development.
• Availability for after hours and/or weekend support for unplanned and planned maintenance.
• Maintenance & Monitoring of the Oracle Test Instances (rebuild, refreshes, cloning, etc)
• Creating providing access permission to users, roles in OID.
• Analyzing production metadata tables, indexes and rebuilding indexes as and when required.
• Refreshing database schema using Export/Import utility as per the project requirements.

Environment: Oracle Applications Server 10.1.2, OEM GRID 10g, SQL Navigator, Toad, JDK1.4, JSP, IBM AIX 5.3/ Solaris, Oracle DB 10g.

Confidential, Edison, NJ - 08817
10/15/2007 - 03/31/2009
Program Analyst

Worked on Oracle Applications and Sun Solaris 10 as Oracle Server Admin/DBA.
Routine activities involved are Installing Customizations, Patches and Cloning related activities in the DEV / INT / QA / GOLD and PRODUCTION environment and working on 120+ instances. Along with this I am actively involved in Kintana and IBM Rational Clearcase V 7 code migration and version tracking with system administration activity for managing and creating the Roles and Responsibilities for the Order Management implementation project for B2B IT.
LogicalApps provides automated Governance, Risk, and Compliance (GRC) controls for enterprise applications.
LogicalApps used to automate GRC activities, such as enforcing proper segregation of duties in enterprise applications, reducing fraud with continuous monitoring of business transactions, and providing defensible evidence of a proper control environment.
Streamlining the Administration, Support, Maintenance process for Oracle Application Server, Unix systems, Oracle database and others, document related settings and troubleshooting and delivered to the client.
Creation of custom tops, adding customization, Cloning Database, Patching, Clearing Logs, Configuring Printers, Securing Applications, Defining roles and maintaining Apps Production, UAT and Testing Database server, optimizing performance.

As a DBA / System Admin, working with different teams like the Application Development, Integration Test, QA, GOLD and PROD users across 17 countries towards production support and issue resolutions.

• Extensively used oracle enterprise manager grid control to monitor and maintain oracle application server instance as well as the database.
• Oracle application server systems administration including installing, upgrading, maintaining and troubleshooting Oracle Application Servers systems in a Linux / Solaris environment.
• Troubleshooting of oracle internet directory 10.1.2 and single sign on 10.1.2 carried out and installations performed.
• Oracle forms and reports installation and configurations performed in a linux / solaris environment.
• Java J2EE related EAR files deployment carried out on all instance of applications.
• Grid control used to monitor the status and performance of servers across the business enterprise, also maintain system and software configurations.
• Pro-active tuning & maintenance of the Oracle Applications & Concurrent Manager servers
• Responsible for managing, maintaining, configuration and supporting Oracle Apps, interact with the client to understand and resolve all the technical and functional issues in the production environment.
• Streamlining the Administration, Support, Maintenance process for Oracle Application Server, Unix systems, Oracle database and others, document related settings and troubleshooting.
• Manage and configure application server components.
• Monitor server performance and application server logs.
• Create and configure j2ee service and deploy and monitor j2ee applications.
• Perform printer setup and work on printer related problems
• Analyze patches from Oracle, check pre-requisites, coordinate patch release
• Worked closely with Production Management on promoting code to instances
• Create an instance strategy to support Production and ongoing initiatives

Environment: Oracle Applications 10.1.2 , OEM 10g, SQL Navigator, Toad, JDK1.4, JSP, IBM AIX 5.3/ Solaris, Windows 2000, Kintana, IBM Rational Clearcase, LogicalApps for Security and SOX

Confidential
06/15/2006 - 09/13/2007
Manager - Oracle Applications

Confidential the world's leading financial institute, provides all kinds of services related to the finance industry. It uses the Oracle E-Business suite Oracle Applications 11.5.10 (Procure-to-Pay) for its internal inventory management across the globe.

Worked on Oracle Applications 10.1.2 / 11.5.10 and Sun Solaris 5.9 as Oracle Apps DBA / Admin. Routine activities involved are Installing Customizations, Patches and Cloning related activities in the DEV / STRESS / UAT and PRODUCTION environment and working on 30+ instances.
The Citigroup Business Services (CBS) Applications Portal is the gateway to Citigroup\'s Procure-to-Pay (P2P) system. P2P enables you to request goods and services, obtain approvals electronically, and pay for the goods and services purchased. If you are already logged in to another Single Sign-on application, such as Web T & E, and access P2P you will be taken directly to the P2P Portal (and tab) without an additional log in.
Streamlining the Administration, Support, Maintenance process for Oracle Application Server, Unix systems, Oracle database and others, document related settings and troubleshooting and send it to the client. Teradata 12.0 database for development as well as production support for the data ware housing.
Resolving Virtual Tickets on a daily basis having production issues. Also hands on Right Fax servers, Imaging Server, Data warehouse servers and Oracle Portals.
Raise and Follow up MetaLink Technical Assistance Requests (TARs) to update patches.
Creation of custom tops, adding customization, Cloning Database, Patching, Clearing Logs, Configuring Printers, Securing Applications, Defining roles and maintaining Apps Production, UAT and Testing Database server, optimizing performance.

As a DBA, worked with different teams like the Application Development, System Test, Stress Test and UAT users across 17 countries towards production support and issue resolutions.

• Installation, Implementation. Upgrades, Production support to Oracle Applications (Apps) 10.7/11.0.3/11.5.3/11.5.9 Systems and (ERP) Financials. Modules: GL, AP, AR, Fixed Assets (FA).
• Creation of custom tops, adding customization, Cloning Database, Patching, Clearing Logs, Configuring Printers, Securing Applications, Defining roles and maintaining Apps Production, UAT and Testing Database server, optimizing performance.
• Installation of Application Patches, Releases and New Applications.
• Perform system administration tasks like application AOL object setup (users, menus, responsibilities, forms, reports, folders, request groups, request set etc.) and Purge AOL tables.
• Responsible for managing, maintaining, configuration and supporting Oracle 11i Apps, interact with client to understand and resolve all the technical and functional issues in the production environment.
• Streamlining the Administration, Support, Maintenance process for Oracle Application Server, Unix systems, Oracle database and others, document related settings and troubleshooting and send it to the client.
• Interacting with end-users for oracle application problems and Trouble-shooting technical and functional issues.
• Visit client location to understand the implementation, support & upgrades process to bring the same to offshore, to train offshore team accordingly and manage the project from offshore.
• Raise and Follow up MetaLink Technical Assistance Requests (TARs) to update patches.
• Using TOAD for application development. Registering Report using AOL.
• Testing and documenting the processes including coordinating with onsite engineers, vendors and maintain better understanding of systems to train offsite team and new team-members joins in.
• Extensive experience Crystal Report and Crystal Analysis
• Used UMX and RBAC with R12 OAFramework for security management.
• Worked closely with the Application Development team in solving user and application issues.
• Menu exclusions and inclusions for responsibilities assigned to users.
• Support Oracle\'s GRC module, (Logical Apps), create rules to support logic and forms changes
• Design and maintain concurrent managers to best manage workloads across modules.
• Create custom menus, responsibilities and report groups as required by the business.
• Register programs, reports, and forms, copy files to Linux, compile source code.
• Follow CBS policy and audit requirements for system configuration and security setup.
• Support Self-service application for employees, and assist with implementation of Single Sign-on
• Monitor and support workflow processes, solve workflow problems and issues
• Schedule, monitor and troubleshoot interfaces inbound and outbound to external systems
• Perform printer setup and work on printer related problems
• Analyze patches from Oracle, check pre-requisites, coordinate patch release
• Worked closely with Production Management on promoting code to instances
• Create an instance strategy to support Production and ongoing initiatives
• Develop and maintain strong relationships with other teams within the IT organization, including Operations, the DBA team, and Application Development.
• Using EXPLAIN PLAN for gathering SQL statement statistics for query optimization.
• Using TKProf to gather physical reads and writes for performance tuning of queries.
• Extensively using SQL *Plus, OEM, SQL Navigatorand Toad for database administration tasks
• General database administration operational support included security administration, schema object management, and space management.
• Creating providing access permission to users, roles.
• Maintenance of database tables used for runtime processing
• Analyzing production tables, indexes and rebuilding indexes as and when required.
• Refresh database schema using Export/Import utility as per the project requirements.
• Gather statistics of database and related queries by running STATSPACK utility.

Environment: Oracle Applications 11.5.10.2 , OEM, SQL Navigator, Toad, JDK1.4, JSP, ChangeMan, IBM AIX 5.1/ Solaris, Windows 2000.

Confidential, Maharashtra, INDIA.
08/17/2005 - 06/14/2006
Senior Executive - Application Support

Worked on Oracle 11.5.9 and Sun Solaris 5.9 for client Huhtamaki as an Oracle Apps DBA / System Admin. Routine activities involved are Installing Customizations, Patches and Cloning related activities in the project environment and production environment. Worked on Oracle Apps Upgrade project and normal trouble shooting on oracle apps 11.5.9.

Oracle DBA for over 50 databases (10g, 9x, 8x on HP-Unix 10.2, Windows 2000). Experience in installing, maintenance, backup, tuning, security, migration, cloning, and troubleshooting of Oracle databases. Responsibilities included:

• Involved in Application Upgrades for test and Prod instances
• Performing DB upgrades from various versions or oracle and application of RDBMS patches and patch set to database.
• Installing Oracle 10g [10.1.0.2.1] under Red Hat Enterprise Linux AS 4.0.
• Installation of Application Patches, Releases and New Applications.
• Creating and configuring Physical Stand by database for fail-over situation.
• Creating different kinds of database Objects and Optimized space utilization.
• Providing high database availability and data protection using Data Guard.
• Maintaining Database security by creating and providing access permission to users, roles.
• Using EXPLAIN PLAN for gathering SQL statement statistics.
• Used UMX and RBAC with R12 OAFramework for security management.
• Worked closely with the Application Development team in solving user and application issues.
• Menu exclusions and inclusions for responsibilities assigned to users.
• Support Oracle\'s GRC module, (Logical Apps), create rules to support logic and forms changes
• Design and maintain concurrent managers to best manage workloads across modules.
• Create custom menus, responsibilities and report groups as required by the business.
• Register programs, reports, and forms, copy files to Linux, compile source code.
• Follow CBS policy and audit requirements for system configuration and security setup.
• Support Self-service application for employees, and assist with implementation of Single Sign-on
• Monitor and support workflow processes, solve workflow problems and issues
• Schedule, monitor and troubleshoot interfaces inbound and outbound to external systems
• Perform printer setup and work on printer related problems
• Analyze patches from Oracle, check pre-requisites, coordinate patch release
• Worked closely with Production Management on promoting code to instances
• Create an instance strategy to support Production and ongoing initiatives
• Loading data from flat files and text files using SQL * Loader scripts.
• Using Import/Export utility for cloning of databases.
• Planning and writing procedures for hot backup using Recovery Manager.
• Tuning the database using Oracle Enterprise Manager 9.2.0.
• Developing and testing Oracle back-end objects like database triggers, stored procedures.
• Providing 24/7 supports for about 20 designated production databases.
• Performing maintenance tasks including daily database performance monitoring and security/account maintenance.
• Monitoring the system response, archival area, and rollback contention and log file contention.
• Working with the application development team to resolve any performance problems in OLTP environment.

Environment: Oracle Applications 11.5.9, OEM, SQL Navigator, Toad, JDK1.4, IBM AIX 5.1 / Solaris, Windows 2000.

Confidential Mumbai - 96, India.
07/08/2004 - 08/12/2005

Senior Software Engineer

Oracle 11i Apps Production Support for Hilton Group of Hotels UK / DUBLIN / USA
Streamlining the Administration, Support, Maintenance process for Oracle Application Server, Unix systems, Oracle database and others, document related settings and troubleshooting and delivered to the client.
Raise and Follow up MetaLink Technical Assistance Requests (TARs) to update patches.
Creation of custom tops, adding customization, Cloning Database, Patching, Clearing Logs, Configuring Printers, Securing Applications, Defining roles and maintaining Apps Production, UAT and Testing Database server, optimizing performance.
Key Responsible Areas

• Performing Application Clones and Database clones on environment like Single and Multi Node Architectures of Oracle Apps.
• Involved in Application Upgrades for test and Prod instances
• Performing DB upgrades from various versions or oracle and application of RDBMS patches and patch set to database.
• Patch Analysis and application of one off patch, mini packs, family packs and maintenance pack for TEST, DEV and PROD instances. Troubleshooting patch application procedure and resolving issues encountered during patch application.
• Trouble shooting performance related issues
• Taking hot-cold backups of the database and performing restores. Performing regular DBA Activities such as Backups, Modifying Database Structures, Managing Database Storage, System Security, Profiles, roles etc.
• Performing complete Technology stack upgrades like Developer patchset, JDK upgrade, Jinitiatior upgrade etc. Running Diagnostic Scripts installation of support packs on Oracle 11i Apps
• Maintaining Oracle Database on Sun Solaris, AIX, Linux platforms and resolving issues related to space and background dump errors.
• Interacting with end-users for oracle application problems and Trouble-shooting technical and functional issues.
• Support Self-service application for employees, and assist with implementation of Single Sign-on
• Monitor and support workflow processes, solve workflow problems and issues
• Schedule, monitor and troubleshoot interfaces inbound and outbound to external systems
• Perform printer setup and work on printer related problems
• Analyze patches from Oracle, check pre-requisites, coordinate patch release
• Visit client location to understand the implementation, support & upgrades process to bring the same to offshore, to train offshore team accordingly and manage the project from offshore.
• Raise and Follow up MetaLink Technical Assistance Requests (TARs) to update patches.
• Using TOAD for application development. Registering Report using AOL.
• Testing and documenting the processes including coordinating with onsite engineers, vendors and maintain better understanding of systems to train offsite team and new team-members joins in.
• Using EXPLAIN PLAN for gathering SQL statement statistics for query optimization.
• Using TKProf to gather physical reads and writes for performance tuning of queries.

Environment: Oracle Apps 11i ,Oracle 10g, 9i, Data Guard, RMAN, OEM, JDK1.4, HP-Unix 10.2, RHAS 4.0, Solaris Windows 2000.

Confidential Mumbai- 76, India
03/02/2000 - 07/07/2004

Database Technician

Hands-on experience includes: Installation, Creation and Administration of Oracle 9i database on Windows NT. Monitoring performance of the database using utlbstat & utlestat, Enterprise Manager, diagnostics pack and tuning pack. Design of online backups, storage structures like rollback segments, table space and data files. Carried out user requirement study and migration strategy/backup and recovery strategy. Used Export & Import utilities at table, user & table space levels.
Creating & Maintaining Schemas, User Accounts.

The work involved managing the DSS32 Production Software as an Administrator. It involves interacting with the production division and developing software systems that work better in terms of Data integrity, Data security & Data storage. Defining and organizing database structures and contents, developing security procedures, developing database and DBMS documentation, maintaining DBMS software, and approving and monitoring the development of database applications. Creating Databases after through study of the Production system flow, Generating queries, Reports and creating Forms for data input. Oracle and SQL database management was a key role. Experience in Development of Database for Safety and Environment Department.
Worked on Maximo Software System used for Inventory management where backend used is Oracle.
Developing the Allocation system in Access and linking it to the DSS software system used for Production dept. for setting up well operations. Well Monitoring Data and Reports are also generated in this new system that has been developed. It is made for easy access to production data using RDBMS (Access / Oracle) as a tool for working on it.
Handling the Daily Processing Report of the Panna-Mukta & Tapti Platforms based Offshore (South Mumbai) where the whole system has to be developed in Access using VB as Front End tool.

Experience in installations, upgrades, maintenance, backup & recovery, performance tuning, reorganizations, refresh, data synchronization, documentation, and troubleshooting of Oracle databases.

Responsibilities included:

• Creating and managing users, roles, passwords and privileges.
• Creating and altering databases.
• Checking Alert Logs continuously for database error logs.
• Collecting database statistics on demand using STATSPACK utility.
• Planning and implementing hot, cold and export backups.
• Optimizing database by using partition tables performance and maintenance.
• Using Import/Export to migrate large volumes of data between the various environments.
• Planning and implementing procedures for hot backups and recovery (RMAN).
• Monitoring database performance using Oracle Enterprise Manager (OEM).
• Performance tuning and optimization of critical queries using AUTO TRACE and ANALYZE commands.
• Tuning the database using Oracle Enterprise Manager 9.2.0.
• Developing and testing Oracle back-end objects like database triggers, stored procedures.
• Providing 24/7 supports for about 20 designated production databases.
• Estimating the size of tables, indexes, table spaces, rollback segments and redo log files. Optimizing shared pool size, DB Buffer cache size and other SGA structures. Monitoring the performance (V$ dynamic performance views at peak load) of the databases.
• Using OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2005
• Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Extensive experience and outstanding knowledge of high availability SQL Server solutions, including Replication.
• Extensive experience with Monitor, tune and analyze db performance and allocate server resources to achieve optimum db performance.
• Working Experience in designing, implementing, maintaining, and documenting complex database applications, and data warehouse in financial environments
• Excellent report creation skills using Microsoft Reporting Services
• Extensive experience Crystal Report and Crystal Analysis
• Architect and implemented DSS System.
• Redesigned a thorough backup and recovery strategy for all major production systems.
• Upgraded all SQL Server 2000 to SQL Server 2005 without service interruption.
• Excellent communication, presentation and interpersonal skills
• Strong troubleshooting and organizational skill

Environment: Oracle 9i, 8i, SQL Server 2000, OEM, RMAN, PL/SQL, Java 2.0, HTML, HP-UX 10.2, Window 2000.