Personal Summary Senior Oracle Database Administrator

Knowledge Experience

• Extensive experience working as an Oracle DBA/Unix Systems Administrator supporting high end mission critical databases. Database administrator with 10 year track record as Oracle DBA and 5 years Oracle E-Business Suite DBA.
• Experience with implementing and supporting Oracle Data Guard, Oracle RAC, and ASM.
• Extensive experience in EBS implementation or support, in-depth knowledge of different phases of EBS implementation lifecycle.
• Strong RAC/clustering experience, RMAN, and Data Guard experience
• knowledge of Oracle Database 11g technologies including RAC and ASM, RMAN, and Data Guard.
• performing required day-to-day, ticket-based DBA tasks such as database refreshes, query tuning and SQL deployments.
• proficiency in UNIX and able to administer Oracle databases running on Red Hat Enterprise Linux.
• able improve SQL performance results through use of explain plans.
• Ability to diagnose problems and triage/resolve issues across various tiers application, network, database, server, or storage tiers .
• Experience with Installation/Upgrade/Patching with eBusiness Suite and Databases.
• Experience with DataGuard running on Linux ,unix
• Identifying, analyzing and resolving problems with existing RAC databases as well as Exadata
• Strong expertise in Oracle Database and EBS Performance Tuning and Optimization.
• Extensive experience with Unix/Linux platform.
• Ability to understand and apply advanced database administration and management techniques.
• Extensive experience in working with customers to build and formulate business requirements.

• Extensive experience working as an Oracle DBA/Unix Systems Administrator supporting high end mission critical databases. Database administrator with 10 year track record as Oracle DBA and 5 years Oracle E-Business Suite DBA.
• extensive hands-on experience with Oracle 11g and 12c in a production environment
• 5 years production experience with SQL, instance, database tuning
• 2 years experience with administering SQL server In standalone and cluster environmentMust have the ability and
• Strong experience with RAC, load balancing, failover, workload management capabilities, ASM
• Experience with RMAN, Oracle Grid Control 12c, job scheduling, auditing
• Strong experience with Linux/Unix, shell scripting
• Experience with Golden Gate in a production environment
• Experience with logical/physical database design
• Experience working with Oracle support
• Experience with setting up Exadata
• Multiyear support for PeopleSoft 8 ERP in installation and customization and upgrade.
• Demonstrable experience of managing high-performance, high-capacity databases in a critical production environment.
• Solid Oracle 11gR1/R2 RAC experience including build, general administration, troubleshooting Break/Fix and performance tuning skills
• Experience in Clusterware GRID Infrastructure - CRS management and configuration
• Skilled in Oracle ASM and Dataguard administration
• Expertise in SQL Database Level performance tuning skills
• Expertise in backup and recovery and migration using RMAN, datapump and export/import.
• Experience in Oracle Exadata, Golden Gate replication
• Experience on Solaris, Linux and AIX OS including strong shell scripting skills.

Technical Skills Snapshot:

• ERP: Oracle Applications 10.6, 10.7/10SC/11.0/11i AOL, OM, OE, ONT, SHIPPING, ASCP, INV, FA, AR, AP, GL, PO, PA, WIP, BOM, MRP, CM, Incentive Comp, Time and Labor, HR, EDI, ALERTS, FSG, ADI , Oracle Applications Manager OAM , MAPICS XAR6
• RDBMS: Oracle 7.x, 8.x, 8i, 9i, 10g, 11g, 12c, RAC, ASM, SQL Server 7/2000
• Software: Workflow 2.6 and Oracle ADI, Oracle Discoverer, Oracle Developer 2000, Oracle Forms 4.5/3.0/2.3, Oracle Reports 6i/3.0/2.5, SQL Plus, SQL Loader, SQL Net, Server Manager, Oracle Discoverer 10g/9i/4.5/3.1/3i, Web cache, OID/SSO, Fusion Middle Ware, SQL, PL/SQL, Perl, Shell, MS-Project, MS-Access, Oracle E-Business Suite 11i, AD tools, Tivoli Storage Management, RAC, DataGuard, PeopleSoft
• Tools: Enterprise Manager OEM , OEM Grid Control, Oracle Applications Manager OAM , Oracle Data Guard, Quest TOAD, Quest SQL NAVIGATOR, SQL DBA, Import, Export utilities, SVN, PVCS Version Control, ADAIMGR, ADADMIN, ADCNTRL, ADPATCH, RMAN, VERITAS NETBACKUP Server 4.5, 6.0 , Tivoli Storage Manger 5.3.
• Languages: SQL, PL/SQL, Bourne Bash , Korn Ksh , C-Shell, UNIX Shell Scripting, Perl, AWK, SED, C, ProC
• Replication: Oracle data replication experience: Data Guard, Active Data Guard, Streams Goldengate. Installed configured and managed Oracle GoldenGate version 11.2.1.0.2 on a pair of Linux Oracle 11gR2 databases. Configured data capture using Extract. Configured data delivery using replicat. Generated data and managed the Golden Gate environment. Configured bidirectional support.
• Hardware: Sun Servers E-450, E-3500, V-880, V-490, V-240, HP 9000, RS6000, Intel X86, Sun StorEdge D1000, Sun StorEdge L7 Tape Backup, IBM AS/400, EMC CLARiiON CX300 networked storage systems
• OS: UNIX OELx, Sun Solaris 2.x, 8, 9, 10, HP-UX, HP Tru64, AIX, Red Hat AS 3.0/4.0/5.0 MS-DOS, CITRIX WinFrame Servers, Wintel VMware

Professional Experience:

Confidential

Oracle DBA

• Oracle DBA Technical Support in a UNIX and Windows infrastructure
• Upgrade databases: Oracle 9i 11g Oracle 10 - Oracle 11G
• Daily reactive Incident and Service Request support for Oracle Databases globally via hotline and ticketing systems. Perform triage, initial troubleshooting, and escalation
• Interface proactively with other Infrastructure support teams such as UNIX, WINTEL, Network, IT Facilities, Backup, Storage, Monitoring, Security etc
• Support application development teams with Version upgrades, application releases, and cloning / creating copies of existing databases for testing and development purpose

Confidential

Oracle DBA

• Upgrade databases: Oracle 9i 11g Oracle 10 - Oracle 11G
• Oracle Architecture Design including capacity planning, storage, clusters, servers with the ability to offer solutions for high availability, disaster recovery and scalability.
• Daily reactive Incident and Service Request support for Oracle Databases globally via hotline and ticketing systems. Perform triage, initial troubleshooting, and escalation.
• Proactively support the ongoing maintenance and optimization of preventative maintenance activities designed to increase the stability of the environment and maintain high levels of stability.
• Interface proactively with other Infrastructure support teams such as UNIX, WINTEL, Network, IT Facilities, Backup, Storage, Monitoring, Security etc.
• Provide 2nd level support to Oracle vendor teams, including training
• Support application development teams with Version upgrades, application releases, and cloning / creating copies of existing databases for testing and development purpose.
• Support day to day maintenance and operation of databases including table space maintenance, providing expertise and recommendation on performance tuning, and consultancy requests where application development teams require Oracle DBA expertise.
• Work with other global Oracle team members to provide follow-the-sun support and drive global consistency.
• Provide 2nd level support to application support teams managing Oracle based applications
• Provide on-going assistance to other service providers with new implementations and support issues
• Demonstrable experience of managing high-performance, high-capacity databases in a critical production environment.
• Solid Oracle 11gR1/R2 RAC experience including build, general administration, troubleshooting Break/Fix and performance tuning skills
• Experience in Clusterware GRID Infrastructure - CRS management and configuration
• Skilled in Oracle ASM and DataGuard administration
• Expertise in SQL Database Level performance tuning skills
• Expertise in backup and recovery and migration using RMAN, DataPump and export/import.
• Experience on Solaris, Linux and AIX OS including strong shell scripting skills.
• Strong initiative and sense of ownership.
• Expert knowledge of database scripting and automation technology
• Oracle database architecture installation, configuration, tuning, review, and troubleshooting on versions 9i, 10g, and 11g.

Confidential

Oracle DBA

• Oracle Architecture Design including capacity planning, storage, clusters, servers with the ability to offer solutions for high availability, disaster recovery and scalability.
• Oracle database architecture installation, configuration, tuning, review, and troubleshooting on versions 9i, 10g, and 11g.
• Hands-on Oracle 10g RAC and Data Guard on Linux. Database Backup and Recovery solutions including RMAN, Backup Scripts and SAN based backups. Oracle Monitoring with OMS and Grid Control. Strong knowledge of all primary Oracle platforms including UNIX, Linux and Windows.
• RAC . Set up and maintained a three node Linux RedHat based cluster using CRS Cluster Ready Services , ASM and Oracle RAC enabled software.
• Strong Programming skills including at a minimum: Unix Shell Scripting, PL/SQL.
• Backup and recovery of Oracle databases using RMAN.
• Upgrade databases when needed to the desired level.
• Document benchmarks and procedures needed to optimize performance. Monitor that all guidelines are followed
• Provide input on any design decisions for interfacing or integrating databases
• Work with the configuration manager to determine change control and impact analysis for the databases.
• Monitor and manage implementation of Oracle security patches and required Oracle operating system maintenance
• Monitor database growth sizing trends and develop capacity planning and data archival strategies
• Plan and execute Oracle level security based audit
• DataGuard setup, maintenance and monitoring.
• Monitoring of Oracle servers including capacity and space management.
• Extensive knowledge of Oracle database versions 11g, 10g, 9i.
• Proficiency in installation, configuration and administration of RAC clusters including Oracle Clusterware, Server side load balancing, Service based connectivity, Automatic Storage Management ASM , Physical and Virtual network address management, patching.
• Extensive use with Oracle Enterprise Manager Grid Control for monitoring, administration and performance tuning including installation and configuration of OMS and mass agent deployment, custom alerting through Grid .
• Expertise with Oracle Data Guard using Real-Time Apply in a physical and logical standby environment.
• Planned and built database instances and objects.
• Planned and implemented Oracle backup and recovery via extensive RMAN scripts.
• Monitored and tuned Oracle database for optimum performance. Assist in capacity planning of Oracle database servers.
• Frequent Troubleshoot Oracle infrastructure problems.
• Refreshed development/test databases from copies of production.
• Provided technical assistance and guidance to application support staff and project teams.
• Developed, documented, and implemented operational support procedures for the Oracle.
• Assisted application developers with writing efficient SQL, and train them on the use of database tools, techniques and concepts.
• Five years of experience in UNIX Korn/Bourne Shell scripting for automation.
• Reviewed, recommended, tested, and implemented Oracle application data model creations and/or changes.
• Ensured the high availability, performance and security of the production database.
• Tuned at the instance and SQL statement level and supported the test and development database environments.
• Knowledge in Advanced Replication/Materialized Views Partitioning DataGuard Streams.
• Installed and Configured SQL Server 2005 2008.
• Supported Sqlserver 2005, 2008 as DBA with Installation replication data modeling and moving data around and backup procedures.
• Created Database Snapshots.

Confidential

Oracle DBA

• Oracle Architecture Design including capacity planning, storage, clusters, servers with the ability to offer solutions for high availability, disaster recovery and scalability.
• Oracle database architecture installation, configuration, tuning, review, and troubleshooting on versions 9i, 10g, and 11g.
• Hands-on Oracle 10g RAC and Data Guard on Linux. Database Backup and Recovery solutions including RMAN, Backup Scripts and SAN based backups. Oracle Monitoring with OMS and Grid Control. Strong knowledge of all primary Oracle platforms including UNIX, Linux and Windows.
• RAC . Set up and maintained a three node Linux RedHat based cluster using CRS Cluster Ready Services , ASM and Oracle RAC enabled software.
• Strong Programming skills including at a minimum: Unix Shell Scripting, PL/SQL.
• Backup and recovery of Oracle databases using RMAN.
• E-Business Suite system Support including: upgrading, patching, cloning, installation, high availability, rapid recovery, performance tuning, capacity planning, and disaster recovery.
• AOL, OM, OE, ONT, SHIPPING, ASCP, INV, FA, AR, AP, GL, PO, PA, WIP, BOM, MRP, CM, Incentive Comp, Time and Labor, HR, EDI, ALERTS, FSG, ADI
• Oracle ERP 11.5.10, Oracle ERP 11.5.7 releases supported.
• Install, configure, administer and manage Oracle E-Business applications-11.5.10
• Experience with shared appl top.
• Experience implementing Oracle 10G application server.
• Experience with Designer Repository / HeadStart for Apps and OID/SSO.
• Modules supported included Iprocurement, GL, AP, AR, FA , Purchasing, Inventory, HR, Payroll.
• E-Business suite backup and recovery, and maintaining the Oracle E-business Suite and 9i databases as well as provide level 2 3 support on a rotating basis. Proactively identify and correct 11i performance problems and monitor space usage.
• Upgrading, patching, cloning, installation, high availability, performance tuning, capacity planning, and disaster recovery.
• Extensive utilization of all ad utilities for E-Business Suite.
• Install various components of database related software and configure it.
• Upgrade databases when needed to the desired level.
• Document benchmarks and procedures needed to optimize performance. Monitor that all guidelines are followed
• Provide input on any design decisions for interfacing or integrating databases
• Work with the configuration manager to determine change control and impact analysis for the databases.
• Monitor and manage implementation of Oracle security patches and required Oracle operating system maintenance
• Monitor database growth sizing trends and develop capacity planning and data archival strategies
• Plan and execute Oracle level security based audit
• DataGuard setup, maintenance and monitoring.
• Monitoring of Oracle servers including capacity and space management.
• Extensive knowledge of Oracle database versions 11g, 10g, 9i.
• Proficiency in installation, configuration and administration of RAC clusters including Oracle Clusterware, Server side load balancing, Service based connectivity, Automatic Storage Management ASM , Physical and Virtual network address management, patching.
• Extensive use with Oracle Enterprise Manager Grid Control for monitoring, administration and performance tuning including installation and configuration of OMS and mass agent deployment, custom alerting through Grid .
• Expertise with Oracle Data Guard using Real-Time Apply in a physical and logical standby environment.
• Planned and built database instances and objects.
• Planned and implemented Oracle backup and recovery via extensive RMAN scripts.
• Monitored and tuned Oracle database for optimum performance. Assist in capacity planning of Oracle database servers.
• Frequent Troubleshoot Oracle infrastructure problems.
• Refreshed development/test databases from copies of production.
• Provided technical assistance and guidance to application support staff and project teams.
• Developed, documented, and implemented operational support procedures for the Oracle infrastructure components.
• Developed, documented, and implemented security configuration for Oracle software and database instances to comply with existing standards.
• Supported production of database architecture.
• Developed procedures, processes, tools, and documentation to install, operate, administer, maintain, and provision the Oracle database infrastructure.
• Major areas of focus: Oracle Database 10g/11g on UNIX platforms.
• Analyzed performance issues and recommend solutions.
• Pro-actively automated routine DBA tasks, devise, execute, document and improve disaster recovery plans.
• EXP w/ RAC.
• Assisted application developers with writing efficient SQL, and train them on the use of database tools, techniques and concepts.
• Five years of experience in UNIX Korn/Bourne Shell scripting for automation.
• Reviewed, recommended, tested, and implemented Oracle application data model creations and/or changes.
• Ensured the high availability, performance and security of the production database.
• Tuned at the instance and SQL statement level and supported the test and development database environments.
• Knowledge in Advanced Replication/Materialized Views Partitioning DataGuard Streams.
• Installed and Configured SQL Server 2005 2008.
• Supported Sqlserver 2005, 2008 as DBA with Installation replication data modeling and moving data around and backup procedures.
• Created Database Snapshots.

Confidential

Oracle Financials/Oracle eBusiness Suite Database Administrator Contractor

E-Business Suite system Support including: upgrading, patching, cloning, installation, high availability, rapid recovery, performance tuning, capacity planning, and disaster recovery.

Oracle ERP 11.5.10, Oracle ERP 11.5.7 releases supported.

Supported both single instance and RAC enabled oracle databases

Proven Oracle Database Administration experience in production 5 years , including installing, patching, upgrading Oracle databases.

Strong hands-on experience in monitoring and tuning a database to provide a high availability service and optimum storage capability, including: query optimization, init.ora configuration, memory optimization, tablespace storage optimization, table/index analysis, tuning long-running processes.

Fluent with Oracle 10G and RAC environment and configuration.

Fluent with RMAN backup and configuration.

Used Netbackup software for all RMAN backups and recoveries.

Fluent in UNIX, shell scripting and Unix/Linux system administration.

Fluent with the usage of raw devices and ASM.

Fluent in SQL and PL/SQL.

Confidential

DBA/UNIX

• Worked in a RAC environment setting up Oracle RAC in a 3-node Linux cluster.
• Installed, maintained Solaris 8-9 in support of Oracle 9i and 10G Installations.
• Experience with CRS, and ASM to set up clustering.
• Worked on automating the installation of Oracle 9i and Oracle 10G.
• Heavy Korn and Bash scripting to automate repetitive procedures.
• Facilitated automation.
• Assisted with database technical design reviews.
• Used OEM for both monitoring and administrating Oracle 9i
• Tuned SQL queries using Explain Plan, SQL Trace and TKPROF.
• Used PL/SQL, Stored Procedures, triggers, packages, Sqllrd, export/import, datapump utilities.

Confidential

Senior Software Engineer/Oracle DBA

• Under contract to Lockheed Martin and ACS Computer Systems
• Functioned as both a DBA and /HPUX/SOLARIS 8-9/AIX/LINUX System Administrator in support of a PeopleSoft 8.4.4 ERP environment.
• Supported PeopleSoft 8 ERP in installation and customization.
• Helped with the setup of App Servers, Web Servers to support PeopleSoft 7 8.
• Helped with MULTIPLE PeopleSoft migrations.
• Managed Database Structure, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Configured and gave 24 7 production support to over 15 Oracle mission critical instances running on HP, Sun, Linux and AIX platforms running half a Terabyte.
• Linux Installation and Operational Support for RedHat ES 3, RedHat ES 4. Linux Operational Support for Suse, Fedora and Slackware.
• Cloned Oracle Instances using both RMAN DUPLICATE technology and prior to ORACLE 9i, using manual techniques of duplicating instances and recreating control files.
• Oracle DATAGUARD implemented for Disaster Recover.
• Used both Physical and Logical Standby Databases.
• Installed Oracle modules for various Applications including PeopleSoft.
• Implemented Oracle Security using standard Auditing guidelines.
• Implemented Virtual Private Databases VPD on Oracle 9i.
• Installed Bind NameServers, NFS and LDAP on Linux and UNIX Servers.
• Responsible for tuning all databases instance from OS down to Instance to SQL Level
• Analyzed evaluated, troubleshot and resolved database problems.
• Wrote advanced shell scripts using Perl, SQL, Bash, Ksh and Csh, Sqlldr, export/import, datapump utilities.
• Maintained, upgraded, and modified system and disk configuration.
• Responsible for maintaining Oracle 7.3 - 8.1.7- 9.2 on an IBM AIX platform and on an HPUX platform in a OLTP environment.
• Also supported same on a Sun Solaris 8 environment.
• Provided technical support for all database applications in development and production.
• Maintained and supported both production and development Oracle database environments.
• Created and configured Oracle databases and the PeopleSoft three-tier environment.
• Used RMAN Database backup and recovery, PL/SQL, Stored procedures, Triggers and Packages.
• Assisted with database technical design reviews.
• Used OEM for both monitoring and administrating Oracle 9i.
• Tuned Offensive SQL by using tools like Explain Plan and TKProf.
• Adhered strictly to Change Control/Change Management policies of the organization.
• Provided technical assistance to the development team.
• Ensured Oracle data security and integrity.
• Performed administration of all Data Base objects, including tables, clusters, indexes, views, sequences, packages, and procedures in an Oracle 8i and 9i environment.
• Upgraded the databases from Oracle 8.1.7 to Oracle 9.2.0.5.
• Used both Export/Import and Oracle Migration Tools to perform multiple migrations.
• Wrote RMAN scripts to automate the backups.
• Performed Disaster Recovery for all instances at SunGard Remote Site.
• Planed and implemented Oracle and PeopleSoft backup and recovery.
• Monitored and tuned Oracle databases for optimum performance.
• Installed Oracle 8.1.7 and Oracle 9.2.0.5.
• Created multiple instances to support a PeopleSoft 8.8 implementation.
• Created indexes and configure disc/table spaces to achieve optimal performance.
• Monitor databases via user written scripts and Oracle Enterprise Manager.
• Setting up multiple AIX RS6000 computers and multiple HPUX machines 7026/H70s and 7029's running Operating Systems AIX 4.3.3 and AIX 5.2.
• Installed HPUX 11i on an RP7410 and RP7420.
• Part of the team responsible for MC ServiceGuard for Oracle clustering.
• Documented Standard Operating Procedures and manuals, user guides and Technical Operating procedures.
• Streamlined error detection and correction as it related to the database and apps environment.