Peoplesoft Resume Profile
4.00/5 (Submit Your Rating)
Summary
- Oracle Exadata Database Machine Certified Specialist
- 19 years experience as an Oracle DBA/Architect and 23 years of IT experience
- 23 years in UNIX Solaris/Linux/HP/AIX/SCO
- Excellent experience in Designing, implementing and supporting Exadata, Oracle RAC, Data Guard and ASM
- Excellent experience in database design, implementation, performance tuning, EM Grid Control , backup and recovery
- Extensive experience in designing and implementing Disaster Recovery plans for Oracle databases
- Expertise in designing very large database systems with high availability and scalability needs
- Have strong inter-personal skills, good written/verbal communication and logical thinking
- Adept at crisis management, trouble shooting, problem solving and negotiating
- Deep understanding of Technology with focus on delivering business solutions
Experience
Confidential
Database Architect
- Responsible for providing Exadata Database Machine support for many Managed Services clients at BIAS. Currently working with Home Depot on providing support on their Exadata Machines.
- Responsible for managing Managed Services clients at BIAS including interacting with executives and resolving issues/escalations.
- Provided database maintenance and support to 250 PROD/QA/TEST/DEV RAC / non-RAC and Exadata / non-Exadata running mission critical applications on Oracle 10g/Oracle 11g for all Managed Services clients.
- Designed and implemented solutions for cross platform database migrations for various Managed Services clients
- Responsible for recommending and implementing new database technologies for all Managed Services clients
- Designed and implemented many Oracle 11g/Oracle10g RAC clusters Real Application Clusters for mission critical applications for Managed Services clients
- Designed and implemented solutions for PSU/CPU Critical Patch Updates and Patch Set Updates patching and11g upgrades for around 300 databases at various Managed Services clients
- Designed and implemented Data Guard solutions for Managed Services clients
- Designed and implemented Grid Control solutions for Managed Services clients
- Designed and implemented backup and recovery strategies using Grid Control/RMAN for various Managed Services clients
- Designed and implemented Disaster Recovery plans for Oracle databases for our Managed Services clients
- Provided database tuning for various Managed Services clients
- Provided Remote DBA service reports to all our Managed Services clients on a weekly/monthly/quarterly basis
- Recommended and influenced Managed Services clients to apply security updates Critical Patch updates and Patch Set Updates PSU on Oracle infrastructure
Confidential
Senior Database Administrator Oracle
- Designed and implemented Oracle RAC Real Application Clusters and Data Guard databases for many mission critical applications at Delta Airlines
- Responsible for setting database standards, recommending/ implementing new database technologies within Delta Airlines
- Lead Architect on the Database architecture team which is responsible for setting database standards, recommending/ implementing new database technologies within Delta Airlines
- Designed and implemented Disaster Recovery plans for all Oracle databases within Delta Airlines
- Designed and implemented Enterprise level backup and recovery strategies using Netbackup/RMAN
- Responsible for setting service level agreements for the DBA department
- Primary/Lead DBA on many mission critical databases for Delta Airlines including delta.com database, Data Warehouse database for Network Revenue Management, Flight schedule database and Customer Notification System database
- Provided database maintenance and support for 150 PROD, TEST and DEV databases running on Oracle 8i, 9i and 10g.
- Created new databases/schema's as required by new applications that are implemented at Delta Airlines
- Implemented Oracle databases on NetApp Filers, using NetApp snapshots as backup methods for databases
- Responsible for tuning Oracle databases and teaching developers in writing efficient SQL statements
- Implemented Oracle Internet Directory within Delta Airlines
- Upgraded databases from Oracle 9i to Oracle 10g and from Oracle 8i to Oracle 9i
- Provided 24X7 production support for high availability and mission critical airline systems
- Team Lead for one of the Oracle teams consisting of 8 DBA's
Confidential
Senior Database Administrator - Oracle
- Support and maintenance of PeopleSoft HR and PeopleSoft Financials databases running on Oracle 8.0.5 and Oracle 7.3.4
- Designing the logical and physical layouts for databases
- Converting MS SQL Server databases to Oracle 8.0.5
- Reorganization of databases at regular intervals to keep the database healthy
- Designing and implementing of backup and recovery strategies
- Performance tuning of databases
- Capacity planning for new and existing databases
- Administering security for the databases
- Development of stored procedures and database triggers
- Providing support for installation and upgrade of FLS software on the PeopleSoft Human Resources database
- Providing database support for PeopleSoft Upgrade from 4.0 to 6.0
Confidential
Member Technical Staff
- Database maintenance and support to PROD/QA/DEV databases running on Oracle 7.x
- Creating new databases as and when required and handling refreshes on DEV and QA databases from production database
- Designing the Logical and Physical Layouts for databases
- Administering security for the database
- Proper sizing of SGA and Reducing Row chaining
- Backup and Recovery of the database
- Tuning the application SQL using Plan Analyzer
- Reorganization of the Database at regular intervals to keep the database healthy
- Development of stored procedures and database triggers for application
Confidential
Database Administrator
- Support and maintenance of databases running on Oracle 7.x and Ingres 6.x
- Defining all entities and attributes using Designer/2000 to form the logical design
- Physical database design using Database wizard of Designer/2000
- Estimating and Defining Table/Index sizes and defining all storage parameters
- Database creation and maintenance
- Backup and Recovery of the database
- Tuning the database and the application SQL
- Reorganization of the Database at regular intervals to keep the database healthy
- Writing database triggers and stored procedures as required by the application
- Installing Oracle and Ingres executables on Solaris, HP and SCO UNIX environments