Lead Oracle Peoplesoft Dba, Resume
Somerset, NJ
SUMMARY:
- Oracle Certified Professional with over 16 years of extensive experience in the field of Oracle technologies with significant knowledge in Operations, Build, Upgrades, Patches, Performance Tuning, Backup and Recovery, Automatic Space Management, Database Security, Cloning, Migration, Shell Scripting.
- Defense Industrial Security Clearance Office (DISCO) FINAL Approval and Eligibility of a Position of TRUST on date: 2/: 00 AM, valid till 11/: 00 AM.
- Oracle DBA and Architect - RAC 11gr2
- Oracle Certified Professional (OCP).
- Involved in all major database administration activity like Creation, Maintenance and Upgrade/Migration of Databases. Backup and Recovery with and without RMAN, Optimization, Security and Storage Management, Performance Tuning.
- Experience with Monitoring tools like OEM, BMC Patrol, and TOAD.
- Extensive experience on SDLC and understanding of business requirements in areas of Finance & HR
- Extensively performed database administration tasks: installation, configuration, upgrades, patches, migration, backup and recovery, Space management, database security, performance tuning and cloning on Oracle 8i, 9i, 10g and 11gR2 on large scale database environments and mission critical large OLTP and OLAP systems.
- Skilled at managing all aspects of large Oracle Databases (upto 10TB and version 11gR2), Capacity Planning, upgrades, patching, database and sql tuning, RMAN, RAC, ASM, Oracle Streams, Data Guard & Grid Control.
- Experience on Unix/Linux & Windows platforms and managing systems based on Oracle’s best practices.
- Extensive performance tuning activities like Operating System Tuning, SQL Tuning, and Database/Instance Tuning.
- Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and SQL TRACE.
- Expert in Installing OEM Grid Control, Configuring and Maintaining.
- Supported business critical 24x7 PeopleSoft ERP environments from development to Production, size varies from 50GB to >10TB
- Provided production support for PeopleSoft Financials, EPM, HCMS,LMS,CRM and OBIEE
- System administration on a mix HP/ SUSE LINUX environment.
- Experienced in providing 24/7 support for database systems including performance monitoring, performance tuning, troubleshooting and client support.
- Possess good communication skills and the commitment to perform in a demanding schedule.
TECHNICAL SKILLS:
Software: Shareplex, Oracle Streams, OEM, PeopleSoft, Delphix, BMC Petrol, ERWin, OEM/10g Grid Control, RMAN, SVRMGR, Designer/2000, Toad, Developer/2000, SQL*Loader, Export/Import, PVCS, Veritas
Operating Systems: UNIX (Solaris, HP-UX, AIX), Windows NT, Linux
Hardware: IBM RS/6000, HP 9000, Sun E-5000, 4000 and 450, Windows NT/2000, EMC Time-Finder, SRDF, Dell x86 64, DEC VAX/ALPHA, AS/400
Languages: SQL, PL/SQL, Java, JSP, Java Script, Html, C, Perl, Korn Shell, C ShellOthers: Java Servlets, ProC, Crystal reports, Crystal enterprise
PROFESSIONAL EXPERIENCE:
Lead Oracle PeopleSoft DBA
Confidential, Somerset, NJ
Responsibilities:
- Implemented International & Domestic PeopleSoft Ledger applications on Oracle 11g
- Providing Support to large Production Databases (24x7) (FIN, HR, Reporting) on EMC hardware
- Modules GL, AP, AR, PO, PC, Time, Labor and expense
- Supported People Tools upgrade from from database perspective,
- Upgraded multiple Oracle databases from 10.2.0.4 to 11.2.0.3
- Resolved numerous Post upgrade performance issue by tuning online/batch, AE programs, SQR programs and reporting queries, BI Publisher queries and stabilized the ERP system for optimal performance
- Designed and implement new Combo process to run without / minimal downtime.
- Upgraded of Oracle PeopleSoft systems running on 10.2.0.3. Involved in cloning PeopleSoft database
- Maintained database security and implemented database auditing
- Troubleshooting post upgrade performance issue for App Engine Programs and SQR reports
- Identified & tuned long running jobs. Tuned performance issues associated with ERP (Financials, HRMS, EPM, Reporting Instance)
- Suggested and Implemented partitions for large tables
- Regular monitoring, troubleshooting and resolving technical issues.
- Standby database administration, Implement data guard broker and production database maintenance at tablespace, schema and object level.
- Set up OEM grid control 12C for multiple databases monitoring on AIX server and enterprise reporting portal.
- Implemented backup strategy, backup retention, database recovery
- Implemented automation for several processes to minimize manual intervention of DBAs.
- Capacity planning, growth analysis and database and table space level
- Applied patches and bundles at database and application levels.
- Identified and tuned resource intensive queries using explain plan, TKPROF, AWR Reports.
- Installed & maintained Shareplex (replication) environment for reporting.
- Implemented Oracle Stream for peoplesoft config tables and saved licensing cost of shareplex.
- Used advanced compression using secure file to save expensive space on EMC storage.
- Implemented Delphix tool to clone Production DBs + applications for developers
Production DBA - Consultant,
Confidential,NJ
Responsibilities:
- Responsible for backups and recoveries of various oracle databases.
- Installing, maintaining, performance tuning and monitoring of Oracle databases version 10g/9i/8i in different environments like Production, QA and development.
- Modifying physical database designs and making recommendations for application improvements.
- Responsible for Oracle Database Migration from 8i to 9i/10g
- Monitoring databases with OEM/10g Grid Control, STATSPACK and Shell Scripts.
- Participated in Disaster Recovery planning and testing.
- Performed/analyzed the execution plans to make the improvements to slow running queries in Data warehousing environments.
- Provided off hours on-call DBA support on a rotating basis when required.
- Implemented scripts and procedures to build the databases to support Sarbanes-Oxley controls
- Participated in executing IQ (Installation Qualification) to install software in validated environments.
Production DBA,
Confidential,, Bedminister, NJ,
Responsibilities:
- Responsible for installing, maintaining, performance tuning and monitoring of Oracle databases version 9i/8i in different environments like production, QA and development.
- Responsible for online and offline backups, and recoveries of various oracle databases.
- Used ERWin and Designer 2000 tools for modifying physical database designs and for making recommendations for application improvements.
- Analyzed query execution plans to make improvements and helped developers write efficient sql queries and stored procedures.
- Accomplished quality, stability and efficiency of the database across the projects by undertaking initiation and coming up several proposals.
- Provided production support on the various databases and resolved production issues proactively.
- Initiated and coordinated on database stress tests, analyzed the results and made recommendations for design and coding changes.
- Ensured security of company information by ensuring databases security and by monitoring environment to identify improper access.
- Scheduled and coordinated on database maintenance activities such as database reorganizations and restructures.
- Provided support on administration of HP UNIX servers. Applied patches to HP Unix, maintained storage arrays, developed scripts for backup and recovery of UNIX file systems using Omniback. Configured and maintained high availability cluster packages.
- Involved in data conversion from legacy system into oracle databases. Developed loading and other scripts for the data conversions and other activities.
- Responsible for Oracle 8i Migration and Upgrade
- Developed crystal reports and Administered/maintained Crystal Enterprise ePortfolio.
- Responsible for installing, maintaining and monitoring of SQL Server 2000 databases.
Tools: used: Oracle OEM, Toad, HP Omniback, Java, Designer 2000, Crystal Reports.HP-UX 11.0, Oracle9i/8i, Microsoft SQL Server 2000, Windows 2000/NT
Production DBA,
Confidential, Trenton, NJ,
Responsibilities:
- Responsible for installing, maintaining, performance tuning and monitoring of various oracle databases in different environments like Development, QA and Production.
- Responsible for maintaining five mission critical production databases and other test/QA databases. Also provided 24/7 support to all the databases.
- Developed online & offline backup scripts using OS backup and RMAN.
- Accomplished quality, stability and efficiency of the database across the projects by undertaking initiation and coming up several proposals.
- Provided production support on the various databases and resolved production issues proactively.
- Installed Oracle8/7 on Sun Solaris. Created table spaces using raw devices and tuned databases.
- Planned and performed database upgrades and oracle patches.
- Installed Application Server (Oracle Web Server), configured, and created applications.
- Worked with America's Job Bank and Applied Theory (Syracuse New York) on development, conversion and pre-implementation of system that will interface with all states and Federal Department of Labor. Set up production database and data warehouse on Oracle 8i & Solaris.
Tools: used: Oracle OEM, Toad, Veritas, RMAN, OPS, Designer 2000, PVCS, Oracle Forms Sun Solaris 2.6, Sun-E5000/4000 and 450, Oracle8/7, Windows NT