Profile

Over 15 years plus of experience in IT field experience with expertise in the areas of Oracle Applications Administration, Oracle Database Administration. Hands on experience in different versions of Oracle application Administration on various platforms like Solaris, Red hat Linux, HP UX, AIX, Windows etc., Expertise includes Database Development Life cycle/implementation/production support with managerial and technical emphasis in data architecture, Oracle Database Administration.

Summary

• Implementation and support projects with Oracle applications 11.0.3 to 11.5.10.2, 12i and 7x/8i/9i/10g//11g Oracle DBA in Production high availability, Test and Development Instance environment.
• Database Architecture Administration, Performance Tuning, Backup Recovery, RMAN, Database Security Management, Replication support, SQL Net configuration, Capacity Planning.
• Cloning of single node, multi node production and non production Application and DB instances.
• Platform migration of various databases from different operating systems.
• Have setup and working experience with VM ware, Oracle VM, IBM vio servers and Oracle Exalytics machines.
• Experienced with Parallel concurrent processing PCP , Oracle Discoverer, Oracle work flow mailer, SSL, Printer Configuration, automation.
• Install, create, administer, and monitor a RAC database install, administer ASM for RAC.
• Extensive experience in outlining plans procedures for online/offline backups, RMAN and performing complete/incomplete media recoveries like point-in-time, Cancel based etc.
• Excellent understanding of Oracle RDBMS 7.1 through 11g 11.1.0.7 , oracle applications 11.0.3 to 11.5.10.2 and Oracle data dictionary on AIX, Sun Solaris 7/8/9, HP UX 10.x/11.x, RHEL 3/4 and Windows 2003
• Development on SQL, PL/SQL and Dynamic SQL, Unix shell scripting Korn shell, CSH, BSH and development of Stored Procedures, Functions and Triggers.
• Upgrading databases of various versions, setting of Standby/Data Guard Databases, OEM, 10g Grid.
• Experience working with Oracle Streams and Replication. Experience with data replication technologies Oracle multi-master snapshots, Oracle Streams .
• Administration experience on Sun Solaris, IBM AIX, RHEL, HP-UX, Windows NT/2000.
• Have data modeling, design, programming and testing skills with strong analytical background.
• Excellent presentation, technical documentation, communication and interpersonal skills.
• Worked on PVCS, Kintana, Appworx, VNC, Magic Ticketing System, ITG, HP Service Desk,
• Databases supported ranging from small to large terra byte database instances on different platforms.
• Working Knowledge on various domains like Banking, Financial, Credit Card, Manufacturing, Retail, Health Care, Software etc.,

Software Skills

Work Experience

Confidential

Senior Oracle Application DBA/Application Architect

Assignments and Responsibilities:

• Installation of Production database and Maintenance of the Oracle databases R12 on AIX 6.1
• Oracle application EBS upgrade from 12.1.1 to 12.1.3.
• Yearend payroll patches for 12.1.3
• Workflow Java based notification mailer setup completed for oracle applications.
• External application setup completed for Oracle EBS modules iProcurement, iSupplier and Self Service HR where the VM servers are in DMZ.
• OBIEE reporting environment setup completed for EBS.
• Monitoring scripts for alerts, enqueues, temp, Locks and undo segments scheduling database.
• Patch application for applications using adpatch, adadmin, adctrl, admrgpch, adsplice utilities and Opatch for Rdbms issues. Trouble shooting of patch issues.
• Setup of VM ware , oracle VM and oracle exalytics machines.
• Automation of Positive payment, secured check printing setup completed.
• Hyperion Financial reporting setup completed for MSD.
• Database vault, Audit vault configuration and encryption setup completed for EBS and OBIEE applications.

Confidential

Assignments and Responsibilities:

• Installation / Upgradation and applying patches to Production database and Maintenance of the Oracle databases 11i / R12 .
• Oracle application EBS upgrade from 11.5.10.2 to 12i 12.0.4
• 10g R2 RAC software installation and upgrade on RHEL 3, 4 and Solaris.
• Discoverer upgraded completed from 3i to 4i. JDK upgrade from 1.3 to 1.6.
• RDBMS upgrade from 8.1.7.4 to 9.2.0.8 then 10.2.0.3 for Siebel CRM, Financial and Cognos BI databases
• Oracle application EBS upgrade from 11.5.4 to 11.5.10.2.
• OATM Oracle Application Tablespace Model setup for 11.5.10.2 oracle application.
• New Oracle 11G installation and configuration on RHEL servers.
• Dev, test instances upgraded to 11.1.0.6 from 10.2.0.3.
• Workflow Java based notification mailer setup completed for oracle applications.
• Oracle9iAS and oracle10gAS application server installation and upgrade.
• Upgrade setup completed for 6 development and 3 UAT environments for Global Business.
• Monitoring scripts for alerts, enqueues, temp, Locks and undo segments scheduling database.
• Configure and Maintenance of batch jobs using CRON. VMware environment for Oracle application nodes. Creating Tars and follow-up with the Oracle.
• Patch application for applications using adpatch, adadmin, adctrl, admrgpch, adsplice utilities and Opatch for Rdbms issues. Trouble shooting of patch issues.
• Oracle applications sysadmin activities user creation, register CM programs, administer CM programs, patching, Printer Issue resolution, OID, SSO, SSO integration, Active Directory AD , Apps Server 9iAS, 10giAS, AOL admin, AOL patches, WF admin, oracle alerts, PCP configuration, Load balancing, forms issues, JTF login issues, SSWA , MWA, SSHR, SQLNET issue resolution, Web ADI, Web ADI upgrade.
• Configure Materialized views and Streams to replicate data from SIEBEL environment. Setup and Manage Materialized views/snapshots.
• New Oracle 11G installation and configuration on RHEL servers.
• Few test instances upgraded to 11.1.0.6
• Provided 24x7 production support for oracle, Siebel, agile application RAC databases.
• Monitoring and perform preventive action using SQL, UNIX shell scripts and tools like OEM, TOAD.
• Cloning oracle applications from Production instance to Development, QA and Patching instance.
• SQL statement tuning, memory tuning based on ADDM, AWR Statspack report.
• Block corruption identified and rectified based on trace file dump information using logical data dump.
• Data Guard Physical standby database configuration and maintenance for oracle applications databases and Siebel application databases.
• Perform Database tuning, Optimization, Backup/Recovery, RMAN and Database administration.
• Creation and physical layout of new databases and Space Management.
• Oracle HTTP, 9i/10g application server installation, upgrade and setup for applications.
• Client Software Installation and configuration on Solaris, RHEL, AIX and windows platforms.
• Involved in planning and coordination of systems growth. Table partitioning for large volumes of data.
• DBA support for Data Guard and fail-over configuration on production databases.
• Assist functional consultants in fixing functional issues. Resolve Connectivity issues
• Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications.
• Database refresh using hot backup and logical backups Export and Data pump utilities .

Confidential

Senior Oracle Applications DBA/Consultant

Assignments and Responsibilities:

• Upgraded of oracle 11.5.9 to Maintenance pack 11.5.10.2 and all the Techstack Components.
• Installed and maintenance of Oracle 10G RAC on IA-64 bit servers with OCFS2.
• Oracle Certification validation for 10G R2 RAC on Itanium 64 bit Servers.
• RHEL server package RPM identification, validation, installation for RDBMS 10g R2 RAC.
• Separation of Concurrent Tier and DB tier. Database migrated from RHEL III to RHEL IV 32 bit to IA-64 bit using OCFS2.
• Monitoring scripts for alerts, enqueues, temp and undo segments scheduling database maintenance batch jobs using CRON, OEM, 10g Grid.
• Upgrade of Rdbms 9.2.0.5 to 9.2.0.8. and 9.2.0.8 to 10.2.0.3 10g
• Provided performance tuning on a 10G database.
• Installed a R12 and 11.5.10.2 techstack on Linux Red Hat servers
• Installed a 10G database in a non RAC environment on Linux Red Hat servers.
• Replication solution implemented for 65 Application Tables in Phase 1 300 tables in Phase 2 using 10g streams.
• Creating Tars and follow-up with the Oracle.
• Creating operating system users accounts, groups, home and their profiles and database accounts setup.
• Creation and physical layout of new databases and Space Management
• Refresh of oracle databases from Production instance to Development, QA and Patching environment.
• Database creation, cluster file system management, parameter management, storage management for RAC environment and administration of RAC databases.
• Cloning of 2 node databases to 2 node QA ENV and single node patch ENV and development ENV.
• Provided 24x7 production support for oracle, Sabrix, Siebel, agile application RAC databases.
• Installed and configured Oracle 9i RAC on Linux platform. Maintenance support for RAC.
• Oracle 10g iAS administration.BCV disk sync/split/mount/unmount for weekend maintenance.
• Automated the Startup, Shutdown and Backup Procedures using UNIX shell scripting.
• Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrators and Network administrators.
• Oracle applications sysadmin activities, user creation, Configuration of styles and drivers for printer setup, register CM programs, administer Managers, Oracle XML, PCP configuration and setup, patching, SCM job scheduling, dbms jobs, batch jobs, WF builder, Apps Server 9iAS.
• Application patches for financial issues, form issues, NLS patches, Time zone patches for 11i application E-business suite and opatch application for RDBMS issues.
• Managing Database Structure, Storage Allocation, Table/Index segments, rollback segments, Constraints, Database Access, Roles, Privileges and Locking issues.
• Involved in Unit testing and Integration testing of forms and reports.
• Single Sign On SSO , OID, apache, MWA, SSL customer authentication configuration and trouble shooting.
• Application patches for financial issues, form issues, Time zone patches and opatch application for RDBMS issues.

Confidential

Senior Oracle Applications DBA

Assignments and Responsibilities:

• Involved analysis, design, implementation, testing and support of project life cycle of DBI and SSHR products for Payroll, HR and HRMS modules.
• Responsible for the administration of existing enterprise databases and contribute in the analysis, design, and creation of new databases.
• Application User creation, register CM programs, administer CM programs, patching, AOL admin, AOL patches, WF admin and oracle alerts, SQLNET, printer setup, Load balancing, forms issues, JTF login issues, SSWA , MWA, SSHR issue resolution.
• Instance strategy plan for project implementation. HR global legislative data installation.
• WF mailer configuration for dev, test, UAT patch environments. Resolved WF listener services and agent issues.
• Ad worker issues and resolution. ADRELINK issue resolution and contingent worker address placement resolution.
• Upgrade of Oracle applications Family Pack from 11i.HR PF.K 3500000 to RUP.1 5055050 .
• Installation of new software and install new versions of DBMS software, application software, and other software related to DBMS administration.
• Configuration of Database, hardware and software working closely with Network and System administrators to optimize the performance of the RDBMS.
• Security administration, monitoring and administering DBMS security, including adding and removing users, administering quotas, auditing, and checking for security problems.
• Patches and Patch sets identification, patch migration and control for entire implementation.
• Database clone for development, testing, UAT, CRP1, CRP2, stage and Patch environment from production.
• Provide database design feedback on new data structures pointing out potential problems and special performance considerations to the Development team.
• Install and configure Oracle 8i/9i on Sun SPARC/Solaris servers.
• Perform Database tuning, Optimization, Backup/Recovery and Database administration.
• Creating Tars and follow-up with the Oracle for development and production issues.
• Provide database and application support to the customers 24x7 and On-call rotations.
• Installation of 10G database in a non RAC environment on Linux Red Hat server.

Confidential

Senior Oracle Applications DBA

Assignments and Responsibilities:

• Administrate, manage and maintain production, test and development databases.
• Oracle Applications 11.5.8 databases version migrated to Maintenance pack 11.5.10.
• Forms issue resolved as post migration task which was the cause of11.5.10 version upgrade.
• Trouble shooting of CUSTOM.pll issue.
• Performed System administration tasks on Oracle Applications Release 11i especially GL, AR, Collections, CRM modules and work Flow issues.
• Provided performance tuning on a 10G database.
• Configured a 10G database in a non RAC environment on Linux Red Hat server
• Worked closely with application developers in optimizing the query for performance issue.
• Monitoring scripts for alerts, enqueues, temp, undo segments and scheduling database maintenance batch jobs using cron/RSS.
• Re-build indexes to improve performance as well reclaim space. Reclaimed 22 of disk space by this exercise.
• Provide 24x7 production support and over all responsible for database production, QA, dev, patch Env.
• Reducing job run times by comparing and optimizing. The SQL code is optimized using statistics involved and Cost based optimizer for performance.
• proactive maintenance activities including index rebuilds, capacity planning efforts, table re-orgs, partitions, and purging data
• DR setup completed for production environment.
• user creations, register CM program, administer CM programs, patching, AOL admin, AOL patches, WF admin, oracle alerts, ADI, OFA standardization, Web Methods application support.
• Applied CRM, Language patches US, Japanese, Simplified Chinese Languages 11i application E-business suite and opatch application for RDBMS issues.
• Performance Tuning at Applications Level as well Database level using TKPROF, STATSPACK, OEM , Toad, SQL analyzer and VERITAS i3.
• Cloning of single node and multi node databases for Dev, QA, UAT and patch environment.
• Extensively involved taking daily production, QA, Test and Patch database hot backups using BCV copy. Hot back and logical backups.
• Upgraded three application databases from version 8.1.7.4 to 9.2.0.5 and 9.2.0.5 to 10.2.0.1.
• Responsible for application, Network, database security and Sarbanes-Oxley SOX audits to ensure database integrity and user access.

Confidential

Senior Oracle Applications DBA/Consultant

Assignments and Responsibilities:

• Installation Oracle Applications 11.5.8 on Solaris box
• Responsible for and supported four development databases, test QA databases and Production Databases.
• Database upgrade from Rdbms version 9.2.0.4 to 9.2.0.6.
• Trouble shooting of workflow performance issues.
• Installation Oracle Applications 11.0.3 11i on Solaris box
• Installed and supported Oracle 9i R2, Oracle 10g databases for all the applications. Obtained detailed understanding of Database Schemas and data sources and Migration of database from Solaris to RHEL.
• RSS job configuration, monitor, and maintenance
• Trouble shooting of workflow performance issues.
• Planning and configuring servers for TEST and DEV Instances.
• Perform all system administration tasks on Oracle Applications CRM modules.
• Worked closely with application developers in optimizing the query for performance.
• Monitoring scripts for alerts, enqueues, temp, undo segments scheduling database maintenance batch jobs using CRON.
• Provide 24x7 production support and over all responsible for database.
• Creating TARs and follow-up with the Oracle.
• Performance Tuning at applications level and Database level using TKPROF, STATSPACK.
• 170 System Export server installation and configuration. Recycle scripts for startup, shutdown and monitoring.
• Single Sign On, SSL customer authentication. Oracle applications sysadmin activities, user creation, register CM program, administer CM programs, patching, AOL admin, WF admin, ADI and oracle alerts.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listener is running, disk space availability, checking for errors in alert logs etc.
• Performance Tuning, monitoring using OAM and take preventive action.
• Automated the Startup, Shutdown and Backup Procedures using Unix shell scripting.
• Extensively involved taking daily production, QA, Test and Patch database hot backups using BCV copy.

Confidential

Senior Oracle Applications DBA/Lead Oracle DBA, Six Sigma Quality Lead

Assignments and Responsibilities:

• Installation and Maintenance of Oracle Applications 11i 11.5.9 databases on Solaris.
• Upgraded 11.5.7 to 11.5.9. Applied patches to over come issues, errors, performance issues and bugs. Created concurrent programs, Request Groups, assigned value sets.
• Applied patches to over come issues, errors, performance issues and bugs based on application module.
• Trouble shooting and Solving COST MANAGER Problems, work flow admin
• Responsible for redo log management, managing user role and privileges, and scheduling physical and logical backups of the databases as well as application.
• Index creation with partitions, re-creating indexes rebuilding indexes to improve the query performance. Reorg of database objects like Tables, Indexes etc.,
• Database performance tuning and monitoring system performance using top, prstat, iostat, netstat, SAR, VMSTAT utilities.
• Managed physical standby database. Setting up of printers. Oracle Mobile Server administration.
• Provide 24x7 production support and over all responsible for database.
• Performance Tuning in Applications Level and Database as well using TKPROF, STATSPACK, Precise HP Open view, EMC DBtuner , Tuning Concurrent Managers, Memory SGA Tuning and monitoring using OAM. .
• Extensively involved taking daily PROD, QA, Test and Patch DB hot backups using Legato Backups size 650 GB.
• 24 7 on call offshore support implemented first time for GE AE using GE transition toolkit.
• Streamlined Outage management and Escalation process, effort estimation based on the SLA, Weekly / Monthly dashboard to GE Customers.
• Asia Pacific and Europe Datacenters migrated to Cincinnati for GEAE in 4 different phases.
• Server Migration Project completed successfully using Six Sigma methodology.
• SOX audit system implemented and all the tasks documented.
• Managed a team of 5 dbas for building a 24 7 support. Trained and mentored junior DBAs.
• Administration and maintenance of Production, development, QA, Test and Patch databases on a round-the-clock.
• Performed Applications System Administration tasks like registering new forms, reports, fixing Printer Issues, Setting Profile Options, Creating/Assigning Responsibilities, Creating application User accounts.
• Setup and trouble shooting of forms 6i, reports 6i, discoverer, SSO.
• Implemented Oracle Data Guard as well as Oracle Advanced Replication.
• RAC installation, configuration, database creation, VERITAS cluster file system management
• Installation and configuration of Recovery Manager RMAN .Tar backup, Legato, RAID, RAW Devices.
• Performed a Database upgrade from 7.3.4 to 8.1.7.4 and 7.3.4 to 9.2.0.5
• Work experience on VERITAS Cluster Software, BCV, Net backup, VERITAS Volume manager..
• Extensive use of Unix Shell ksh/csh and CRON to monitor several databases alerts.
• Experience in Evaluating Hardware and Software Requirements and Making recommendations. Implementation of Data Center, New Support Plans, High Availability, Backups and Database Group Management.
• Exposure on ticket tracking tools like HP Service Desk, Kintana, and Support Central.

Confidential

Env. : 9i 9.2.0.3 on Solaris 8, Hyperion 6, Tomcat.

Assignments and Responsibilities:

• Installation of Hyperion products and oracle RDBMS 9 on Solaris 8.
• Configuration and setup of Hyperion products with Oracle database.
• Installation, configuration and setup of Tomcat web server.
• Application user creation and maintenance within oracle database for Essbase.
• Apache installation for Hyperion product.
• Backup and recovery procedure definition and implementations for Application as well as RDBMS.

Confidential

Senior Oracle Applications DBA/Consultant

Assignments and Responsibilities:

• Design of Database on Oracle8i, Memory planning for Oracle Database
• Installation, configuration of oracle 11.5.5. Upgrade of 11.0.3 to 11.5.5
• Application patch utilities adpatch, adadmin, adctrl used for patch application and opatch for RDBMS issues. Trouble shooting of patch issues.
• Created concurrent programs, Request Groups, assigned value sets.
• Client co-ordination, requirement analysis design specification preparation.
• Database designing, data migration, implementation end user training.
• Capacity planning for Oracle Database, Creation of Users and their permissions, profiles.
• Monitoring User and Group Management. Designing and Monitoring OFA Optimum Flexible Architecture
• Development of a backup strategy using Exports, Cold, and Hot Backups utilities.
• Snapshots for interfacing with the production system running on a separate system.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listener is running, disk space availability, checking for errors in alert logs etc.

Confidential

Oracle Applications DBA

Assignments and Responsibilities:

• Administration and maintenance of Prod, development, QA, Test and Patch databases on a round-the-clock basis.
• 24 7 production support for 150 oracle instances global environment. Monitoring of User and Group Management.
• Installation and implementation of Oracle Financials 11.0.3.
• Application user password, profile management, CM administration, sysadmin activities.
• Monitoring scripts for alerts, enqueues, temp, undo, scheduling database maintenance batch jobs using CRON.
• Installed, upgraded, migrated configured and administered Oracle 7x/8.0.5/8.1.7/ 9i database on Sun Servers.
• Designed and implemented database schema logical and physical data models .
• Set up and maintain automatic hot standby database for disaster recovery, Cloned Databases, backup / restoration using shell scripts. Data maintenance using utilities like REORG, Analyze, Backup / Recovery / Restore.
• Setup Oracle Enterprise Manager and STATSPACK, sqltrace to support monitoring and performance diagnosing.
• Daily backup process checkup using legato networker backup restore and recovery procedure.
• Perform Database tuning, Optimization, Backup/Recovery and Database administration work on multiple production Oracle databases and development Oracle databases