SUMMARY:

• Information technology professional with expert database administration experience.
• Background includes implementation, administration and analysis of Oracle and Mongo databases, with an emphasis on applications of PeopleSoft and Oracle Finance and Supply Chain Management, PeopleSoft Human Capital Management, Campus Solution, and business intelligence implementations.
• Have served in a variety of consulting roles including database administrator, PeopleSoft administrator, and project lead.

TECHNICAL SKILLS:

• Oracle RDBMS 10g, 11g, 12c
• NoSQL/MongoDB
• Oracle Data Guard, RAC, RMAN, Data Pump
• SQLPlus, PL/SQL, TOAD
• Oracle Flashback, Streams
• VLDB, Big Data, Data Warehouse
• Oracle Exadata, Amazon AWS
• SQL Tuning Advisor, AWR, ADDM, Profiles
• UNIX Shell Scripting and Tuning
• Linux, RHEL 6/7, Solaris, AIX, Mac OS
• BMC Footprints/Remedy/Patrol
• Crisis Turnaround, Agile Methodology
• NetBackup, Disaster Recovery
• PeopleSoft Query, Crystal Report
• Technical Documentation, MS Visio
• PeopleSoft App Designer, App Engine, SQR

PROFESSIONAL EXPERIENCE:

Confidential, CHICAGO, IL

Sr. Oracle Database Administrator

Responsibilities:

• Upgraded over 100 Oracle databases including development, test, QA, and production from 11g to 12c.
• Installed and deployed Oracle Enterprise Manager 12c to company’s global environment in Europe and Asia.
• Tuned and performance tested for multiple application environments from development to production using Oracle SQL Tuning Advisor, AWR, ADDM, SQL Profiles, table Partitions. The response time was reduced from long hours of running jobs or hanging interfaces to minutes or seconds.
• Administered and maintained 10 Terabyte large databases on Linux using OEM, TOAD, and SQLPLUS.
• Configured and tuned Redhat Linux Hugepage memory settings for server upgrade. This resulted in an 80% increase in production server performance.
• Developed and tested backup and restore strategy using RMAN and Data Guard to meet the system high availability requirement by the customers.
• Cloned, migrated and refreshed development, QA and production databases from Chicago to New Jersey data center to meet engineer team’s need.
• Worked with Linux team to ensure NetBackup reports were delivered and backups were running nightly. Updated documents for the process and conducted knowledge transfer.
• Developed and implemented Oracle data warehouse project to meet senior management’s report requirement.
• Streamlined and documented Oracle Enterprise Manager Monitoring rules, templates and processes to facilitate system monitor and smooth knowledge transfer.
• Identified key impacts and issues of Oracle user account management software with company’s existing technology. Worked with Oracle engineers to test authentication functionalities. Led and documented user auditing process to prepare for ISO certification.
• Documented the process for global platform standardization and optimal system performance.
• Installed and deployed MongoDB for company’s document databases with scalability and performance advantage.
• Supported Oracle and MongoDB databases hosted in AWS environment.

Confidential, Chicago, IL

Sr. Oracle Database Administrator

Responsibilities:

• Managed Oracle Users, Views, Tables, Index, Tablespace and Database Links among over 50 PeopleSoft application databases using SQL scripts, OEM and Toad.
• Implemented and supported PeopleSoft HR, Finance and Campus Solution reporting databases. Configured and automated refresh processes from production to report by shell scripting, dynamic SQL and Unix cron jobs. The timing of multiple refresh processes from production to report were improved from 3 days to 4 hours as a result of my performance tuning. This positively contributed to timely reporting deliveries to senior management.
• Provided SQL and Unix system performance tuning and monitoring for PeopleSoft databases to ensure all production systems run in high availability and optimal mode, especially during critical times such as End of Terms processing and Open Enrollment period.
• Established and enforced database and network security and accessibility for all users and developers of ERP system. Created master password file for organization wide servers to eliminate potential security risks and unnecessary workload for ad - hoc consultants and internal transitions.
• Performed weekly change control tasks to migrate PeopleSoft objects and source code, Oracle DDL and DML changes from test, QA to production databases to support development team.
• Participated in district and team meetings to discuss best practices and testing alternatives.
• Documented Oracle standard operation policies and best procedures. Ensured existing documentation was kept up to date as requirements changed.

Confidential, Chicago, IL

Independent Oracle Consultant

Responsibilities:

• EMC: Led the performance technical design reviews of newly developed objects to identify and resolve any potential performance issues as early as possible in the development cycle. Defined and established the methodology and performance matrix to streamline the review process. Evaluated and assessed tuning tools and set up the testing environment. Trained fellow consultants on the database server and application performance tuning. Participated in hands-on design and code reviews and gap tuning.
• Shell/Texaco: Managed the performance issues of the terminal interface system and two Web-based databases. Reviewed the technical architecture and made recommendations for optimal application performances. Reviewed migration plans from one system to a new server based on the on-going business practice. Helped the client in the process of hardware capacity planning and sizing.
• Upgraded Oracle from 10g to 11g for PeopleSoft test applications to meet the application system requirement.
• Configured disk logical volumes for the development and production on Unix machines. Adjusted operating system kernel parameters for Oracle and PeopleSoft applications on both development and production servers.

Confidential, Evanston, IL

Business Analyst

Responsibilities:

• Provided staff training on Oracle database management software, SQL and performance tuning.
• Created complex reports in a GUI-based program such as Crystal Reports based on the management’s requirements and needs.
• Provided operational support for client and server components of a dozen of mid-tier applications, including MS Project Server, Raisers Edge, and Footprints.
• Co-ordinated with third party consultants and provided managerial support and assistance to seamless transitions for support of mid-tier application environment.
• Adhered to standard operational procedures and change control processes of the organization. Documented team’s best practices and troubleshoot logs. Maintained the team’s knowledge database on MS Sharepoint.

Confidential, CHICAGO, IL

Principal DBA Consultant

Responsibilities:

• Installed and upgraded Oracle databases for PeopleSoft applications on multiple platforms including Unix/Linux, Windows and N-tiered web architecture and applications .
• Provided support for production operations queue and solved severity one issues for on demand customers.
• Simulated stress test using LoadRunner scripts. Configured database initialization parameters and used it as a starting point for the subsequent development and production databases configuration.
• Designed and implemented physical and logical database files layout optimization on multiple Unix platforms. Assessed production database environment and sizing.
• Maintained Oracle replication between source and target Oracle databases for dozens of customers.
• Performance tuned, optimized and monitored databases using OEM, Toad and SQL scripts to ensure best throughput and response time.
• Performed technology assessment and system audit. Defined technical architecture and deployment strategies for the implementation projects.
• Led the performance tuning for existing gaps and fixes for Oracle Financials. Evaluated tuning tools and set up the testing environment. Participated in hands-on design and code reviews meetings.
• Attended customer meetings and led presentations for Periodic Maintenance for Oracle and PeopleSoft Patches and Updates.
• Consulted in installing and configuring several critical system components, including two-tier & three-tier environments, batch environments, application server and other required servers.
• Assisted with the installation, test, and certification of the PeopleSoft systems. Worked side-by-side with client technical staff to integrate PeopleSoft applications into the production environment, ensuring that the system configuration and settings are optimal.

Confidential, CHICAGO, IL

Oracle PeopleSoft Database Administrator

Responsibilities:

• Set up PeopleSoft FDM production and development databases on Oracle from scratch. Administered multiple development databases on daily basis, including Oracle server and SCM application tuning, user management, process monitoring, Oracle network configuration and tuning.
• Performed on-line PeopleSoft application/ SQR/Application Engine/Cobol batch job tuning; PS/Query SQL tuning and PeopleSoft physical 3-tier configuration and troubleshooting.
• Led the complete upgrade path of PeopleSoft HRMS from 7 to 8, 8.1 to 8.x. Installed and configured Oracle Server, PeopleSoft application servers, web servers, and batch servers.
• Designed, developed and tested production database backup and disaster recovery strategies.
• Assessed the production database environment and sizing, designed and implemented physical and logical database backup/restoration strategy.
• B uilt integration, unit test and conversion databases and migrated database from development to integration to user acceptance test to production.
• Implemented Oracle WEB application server, implemented application level security for Crystal report users and automated data load from the mainframe to Oracle database for Web applications.
• Documented the process and methodology. Established procedures and baseline for future production support. Developed work plans and coordinated technical recourses for the projects.