Relevant Experience

Oracle related DBA experience is 11 years which includes 9 years of e - Business Applications e-BS administration DBA and 2 years as a core Oracle DBA. Production and Development DBA experience in complex and heavily customized environments in both Operations and Projects Oracle DBA roles. Senior and Lead DBA in several Oracle e-BS R12 implementation and upgrade projects with hands on experience. Additional exposure to SQL development, shell scripting, Data Warehousing DW and MS SQL server administration. Developed and implemented time and cost saving methodology and custom code for automating and extending routine Oracle e-BS maintenance procedures cloning, patching, backups, system's monitoring for customers. Helped in avoiding delays and reducing support cost in different projects working in a role Oracle DBA/Apps DBA and Systems engineer Linux/Unix and Windows 2003 Server administrator . Secured customers Oracle Apps environments for SOX compliance by creating, implementing and supporting special auditing procedures and custom scripts and solutions in multiple projects. Good team player with effective communication and analytical skills in delivering technology solutions. Strong skills in switching quickly between multiple different tasks, good in planning and scheduling.

Technical Skills

Oracle Databases / Applications e-BS : 7, 8, 8i, 9i, 10g, 11g / Apps 10.7, 11.0.3, 11i, R12, Agile PLM 9.2, GRC Oracle Developer Suite: Application server iAS 9i, iAS 10g, Designer, Discoverer 4i, Business Intelligence 10g, WF Builder, APEX, SOA, OID, LDAP, SSO, Portal 10g, Web ADI, XML Publisher, iPayment 3d party Applications: UC4 Appworx, Cofax Markview, HP Kintana/PPM, Compusearch PRISM, MySQL, MS-SQL Technologies: RAC, PCP, ASM, Data Guard/Standby, RMAN, Shared APPL TOP, SSL Operating Systems: Sun Solaris, HP-UX, IBM AIX, Red Hat RHEL Linux, Oracle Linux, Windows Server DBA Tools: Oracle OEM/Grid control, SQL developer, ITG SiteScope, QUEST PL/SQL Developer,Toad, Shareplex Languages and Shell Scripts: Ksh, Bash, Perl, SQL, PL/SQL, HTML, JavaScript

Employment History

Confidential

Lead Oracle Apps DBA on e-BS R12 upgrade project

Developed project documentation for complete upgrade cycle from DBA side. Developed and implemented an approach to reduce downtime in half. Completed 4 upgrade passes in Apps DBA and Dev DBA roles. Completed Dev and SIT phases and obtained sign off from local DBA team to pass the knowledge. Resolved issues with long running upgrade scripts/ SQL queries using OEM and AWR/ADDM. Identified resource intensive queries and worked on improvements. Adapted and improved existing code deployment process. Automated Oracle 11g RDBMS and 10g iAS upgrade and patch applying procedures PSU and CPU patches . Participated in 3-d party tools Markview upgrade/reimplementation.

Confidential ,

Oracle Apps DBA

• Performed Oracle database 10G and 11G and Applications e-BS 11i with RAC and PCP Production/Non-Production routine support activity: cloning, patching, upgrade, code deployment release support, application user support, OEM grid control 11g troubleshooting and alerts monitoring. Resolved database version specific bugs such as AWR/ADDM jobs hanging and others. Resolved applications forms and reports issues related to Oracle e-BS and remote Databases db-links used in 3-d party applications. Automated refresh of Oracle 11g databases ETL sources using DataGuard/Standby and Flashback technologies and SQL/PLSQL and shell scripting. Performed migration of Oracle and 3-d party software to new hardware both Unix and Windows based using custom scripts and documented the process. Worked on tuning of SQL queries running in remote databases. Developed and supported automated solution for objects comparison during code migration cycle release using FNDLOAD routine.
• Primary DBA in a server migration project. On call Production DBA in 7 days shift.

Confidential ,

Oracle DBA

Configured and supported Oracle Grid Control 11g OEM for existing and freshly installed instances. Developed and Implemented scripts for monitoring of Oracle On Demand eBS R12 instances. Performed performance analysis and provided recommendations for improvements. Installed 11g RAC in Linux RHE, implemented and supported RMAN and cold backup procedures. Completed performance analysis using ADDM and implemented valid recommendations on schema and storage level. Performed schema and table copies by request. Primary DBA in a project involving several Production DW databases. Participated in troubleshooting and supported Quest Shareplex implementation.

Confidential

Oracle Apps DBA

Primary Lead DB and e-BS/Apps DBA for 4-6 customers. Planned, distributed and managed tasks done by offshore team. Secondary/Backup DBA for other Primary DBAs in the team. Performed various tasks of routine support of Oracle Apps 11i and R12: installation, migration, and upgrade, code promotion, resolving performance issues and bugs in following configurations: RAC, Standby/Data Guard, PCP, Shared APPL top, Load balancing and DMZ on various platforms for hosted and non hosted customers. Primary and Lead DBA on Agile PLM implementation project for major client. Participated in configuration of Oracle Grid Control OEM . Implemented and supported RMAN and hot backup procedures. Performed urgent point-in-time Production databases restores by requests from customers. Completed several Production DW databases migrations for major customer. Completed performance analysis and providing recommendation for improvements. Completed two Oracle R12 implementation projects and several projects of upgrade of Oracle 11g, R12, Oracle iAS 10g and Discoverer 10g on Linux RHEL. Installed Oracle 11g and upgraded 10g databases. Automated procedures for cloning, applying patches and backups for Oracle 11i and R12 Worked as Linux RHEL administrator.

Confidential ,

Oracle Apps DBA

Worked on a customer side during final stage of Oracle 11i implementation and support project with Oracle RDBMS 10g RAC in multi-node configuration with Oracle Advanced Security. Participated in SR tracking, troubleshooting of issues and errors found by monitoring tools and technical consultants requests. Assisted in bugs resolution. Assisted in daily maintenance procedures cloning, patching, backups . On call DBA in the shift.

Confidential ,

Oracle Apps Development DBA

Worked in team of Development DBA in DELL EMEA project to support DEV/UAT/SIT environments of Oracle 11i with Oracle RDBMS 10g RAC ASM in multi-node configuration also PCP and iAS/Forms load balancer including Oracle iAS 10g. Performed SOA 10g instances cloning and configuration. Resolved Oracle RDBMS 10g RAC/ASM, Forms/iAS performance issues. Implemented DRM in Oracle apps 11i 10g RAC database and Oracle iAS 10g iPayment. Performed code deployment and resolved code deployment issues with testing and development teams. Performed technical writing and project documentation support.

Confidential ,

Oracle DBA, Linux RHEL Systems Engineer

Senior Consultant Oracle e-BS/Apps DBA and Systems engineer in R12 implementation/migration project . Completed tasks in preparing hardware platforms HP and OS configuration Linux RHEL for Oracle apps software and implementing advanced security settings in OS for Oracle environments. Developed and implemented strategy of Linux RHEL OS system cloning. Developed and implement disk and tape backups of Oracle 11i,R12, Oracle Designer Repository and Linux OS. Participated in the code migration process from Oracle 11i to R12 also upgrade of Oracle Designer and Oracle Developer Suite . Participated in bug tracking and installation of performance testing tools for Oracle applications.

Confidential ,

Oracle DBA

Worked in offshore team for DATA INTENSITY. Participated in Oracle e-BS and Oracle database migration projects to the different hardware and OS: HP-UX -> RHEL and versions: Oracle 7 -> Oracle 8i, 8i -> 9, 9i ->10g. Performed various kinds of Oracle software installations and patching single and multi node options and other administration tasks on almost all Oracle supported platforms AIX, Solaris, HP, Linux, Windows Server . Performed all set of maintenance procedures and tasks passed from monitoring team DB and OS resource planning, resolving performance issues on OS and database level . Reconfigured shared APPL TOP installations split, merge .

Confidential , Oracle DBA and SQL Server DBA

Performed technical support of automated banking system in primary-standby configuration, performed cloning and backup tasks. Created and configured standby Oracle 9i instance on new hardware. Participated in migration to new hardware and version from Windows NT4 to W2K, Oracle 8i to Oracle 9i . Interacted with developer's team for resolving performance issues and updates installation, independently completed task of partitioning of largest tables.