Post Job Free

Resume

Sign in

Database Administrator Recovery Manager

Location:
Houston, TX
Salary:
125000 to 135000
Posted:
February 07, 2023

Contact this candidate

Resume:

Abdul Raheem Syed

Cell: +1-346-***-****

Email: adu7d2@r.postjobfree.com

Summary:

Around 10+ years of experience in Information Technology areas involving PeopleSoft System Administration, Application and Tools Upgrades, Oracle database Administration, Oracle Application server administration and UNIX administration.

Professional expertise in Installation, Tools and Application Upgrades, Configuring and maintenance of PeopleSoft applications and applying Maintenance Packs, Bundles. Tax-Updates. Expertise on RDBMS like Oracle. Finesse revolves around Database refreshes, Scheduling Cron jobs and Appserver/Web Server Performance Enhancement. Experienced in the Oracle DB upgrades to 19c.

PeopleSoft Experience:

Working as Oracle DBA for upgrading the Oracle database from 12c to 19c.

Installed and maintained the 6 RAC Node DB for 19c.

Majorly responsible for upgrading the client Database into brand new servers, which includes Installing Oracle Software, creating oracle databases, and performing upgrades of the databases and software to the new release levels.

Actively involved in resolving the issues encountered at the time of DB installation and upgrade

Specializing in PeopleSoft Major Upgrades, Maintenance and patching activities, including support during the configuration, unit and system testing, user acceptance testing, for a successful project.

Expertise in implementing Change management using PUM, change assistant by handling applying bundles, patches and maintenance packs

Strong experience in performing requirement analysis, project planning and implementation

Extensively worked on Install and configure PeopleSoft server hosts, components, and for 3-Tier and 2-Tier clients.

Contributed to all phases of the software life cycle, including analysis, design, implementation and Maintenance.

Creating Application server, web server and process scheduler domains for the environment.

Refreshment of PS databases, Code Migrations.

Create Windows Client Profiles for various development, test and production users and install.

Implement load balancing for Web servers and application servers and monitor.

Maintain integrity and internal consistency of the database using DDDAUDIT, SYSAUDIT reports periodically.

Install Change Assist for Upgrade in newer versions of PeopleSoft and Installing and configuring PeopleSoft Test Framework.

Planning backup and recovery strategy for various database environments and good knowledge of exports/imports, RMAN

Experience in SQL Tuning Advisor, SQL Profiles, SQL Plan Management and SQL Tuning using hints & indexes

Migrating standalone Database to AWS Cloud

Additional Skills:

Databases - Oracle 9i to 19c, MS SQL Server

Application Server - Tuxedo, Oracle Application server, PeopleSoft

Web Server - Web-logic, OAS

Operating System - AIX, SUN Solaris 5.x, RedHat Linux,

Windows XP/2003/2000/NT/98/95/2016R2

Languages - SQL, PL/SQL, UNIX Shell

Cloud - Amazon/AWS

Educational Qualification:

Master of Computer Applications from Ferguson P.G College, Hyderabad in 2006.

Certifications:

Oracle Certified Professional 9i

Professional Experience:

Client: Hilton Hotels Worldwide, McLean, VA Aug 2021- Till now

Job title: Sr. Consultant

Job Responsibilities:

Working as Oracle DBA for upgrading the Oracle database from 12c to 19c.

Installed and maintained the 6 RAC Node DB for 19c.

Majorly responsible for upgrading the client Database into brand new servers, which includes Installing Oracle Software, creating oracle databases, and performing upgrades of the databases and software to the new release levels.

Actively involved in resolving the issues encountered at the time of DB installation and upgrade.

Performing the necessary tests after the upgrades are done successfully.

Performing the starting up and shutting down the database and managing the database's storage structures.

Involved in raising Service Requests with Oracle when bugs are found.

Working as PeopleSoft and the role involves providing support, maintenance, troubleshooting and applying patches/tax updates.

Performing daily PeopleSoft health checkup.

People tools upgraded from 8.54 to 8.57.

Performed a complete PeopleSoft installation using HCM 9.1, People tools 8.57 on the Lab servers for internal development team.

PeopleSoft/Oracle Patch Management/Upgrades - Researched & applied Patches and Fixes/Maintenance Packs/Tax Updates manually and using Change Assistant. Installed and configured Change Assistant to apply the People Tools upgrade

Compile the COBOL programs on PSUNX & PSNT using the COBOL compiler when the new cobols are delivered with patches and fixes.

Maintain the Oracle database server, Export & Import, RMAN Backups which are further used for Environment & Database Refreshes

Performing security related task like creating Oracle users and assigning roles.

Installing and configuring PeopleSoft Test Framework

Troubleshoot and fix performance issues

Worked on Migration projects

Configure and setup of Oracle Secure Enterprise Search (Oracle SES).

Applied all Tax Updates after as a part of maintenance

Environment: Oracle 19c 6 RAC Node, People FSCM 9.2 & FSCM US/UK 8.9, Peoplesoft tools 8.56/8.57, HCM 9.1, Red hat Linux 7.0, Windows 2016.

Client: Hilton Hotels Worldwide, McLean, VA(worked from Hyderabad, India) April 2014-Nov 2015

Job title: ERP Sr. Analyst

Job Responsibilities:

Primary Analyst for Major Upgrade projects, and member of team responsible for implementations, Migrations and Upgrades

Installed and Configure PUM for 9.2 Upgrades

Installed Oracle Enterprise Manager and Configured PeopleSoft plugin to Monitor and Manage PeopleSoft systems

Supported during testing for unit, system, and user acceptance and post implementation production support.

Configured tools to Monitor and Administer PeopleSoft Applications

Installing and Maintaining PeopleSoft Environment with People tools and all applications

Install and Administer Oracle Search Enterprise Server.

Configured PeopleSoft Plug-in on Oracle Enterprise Manager grid control.

Worked on Migration projects involving in Non-Unicode to Unicode conversion.

Installing Tuxedo and applying Tuxedo rolling patch

Installing Web Logic and applying patches

Performing Database Refreshes

Troubleshoot and fix performance issues

Implementing Single Sign On.

Installing and configuring PeopleSoft Test Framework

Performed Data Masking using Oracle Enterprise Manager Tools

Applied SQL profiles using Oracle Enterprise Manager Cloud 12c

Environment: Oracle 12c, FSCM, HCM 9.1, People tools 8.54, Red hat Linux 5.0 & 6.0, Windows 2012.

Client: Trinity Industries Inc, Dallas, TX (worked from Hyd, India) April 2014-Nov 2015

Job title: ERP Sr. Analyst

Job Responsibilities:

Technical Specialist, specializing in PeopleSoft Major Upgrades, Maintenance and patching activities, including support during the configuration, unit and system test, user acceptance testing, for a successful project.

Upgrade of PeopleSoft Tools from 8.50 to 8.53.

Installation, configuration and editing of Application Server, Web Server and Process Schedulers.

Applied all Tax Updates after as a part of maintenance

Installing and configuring PeopleSoft Test Framework

Environment: FSCM, People tools 8.50, 8.53, HCM 9.1 Sun Solaris 10, Windows 2008.

Client: Masco Corporation June 2009 – April 2014

Job Title: Consultant

Job Responsibilities

Technical specializing in PeopleSoft Major Upgrades, Maintenance and patching activities, including support during the configuration, unit and system testing, user acceptance testing, for a successful project.

Primary Analyst for Major Upgrade projects, and member of team responsible for implementations, Migrations and Upgrades

Handling tools patch and performing minor upgrades on modules primarily covering HRMS, ELM and FSCM.

Hands on experience using PeopleSoft and third-party development tools like Application Designer, Application Engines, SQR Reporting. Exposure to COBOL Customizations.

Supported during testing for unit, system, and user acceptance and post implementation production support.

Configured tools to Monitor and Administer PeopleSoft Applications

Installing and Maintaining PeopleSoft Environment with People tools and all applications

Install and Administer Oracle Search Enterprise Server

Worked on Migration projects involving in Non-Unicode to Unicode conversion

Installing Tuxedo and applying Tuxedo rolling patch

Installing Web Logic and applying patches

Performing Database Refreshes

Troubleshoot and fix performance issues

Implementing Single Sign On.

Implementation of New PeopleSoft Environments and creating a similar copy of the installations existing.

Research, Applying Fixes/Bundles, Tax updates and upgrades (tools & application).

Configuring & Editing Application Servers, Process Scheduler & Web Server.

Handling Production related issues while in UAT phase and on production move of upgrades.

Retrofitting of customizations of objects as integral part of Upgrades

Managing multiple environments (Demo/Test/Dev/Production) addressing areas such as security, monitoring, performance tuning.

Hands on experience in manual & automated DB refreshes of Oracle & SQL Server DB.

Handling Second Level Support after client go-live.

Involvement in non-routine projects for advanced engineering like Operational Acceptance certification of PeopleSoft products at AT&T and automation scripts for database and environment refreshes.

Actively participated in documentations to develop installation guides and operating procedures of PeopleSoft and third-party products integrations.

Upgrade of PeopleSoft Tools from 8.47 to 8.52.

Installation, configuration and editing of Application Server, Web Server and Process Schedulers.

Applied all Tax Updates after as a part of maintenance

Installed and Configured UPK

Environment: People tools 8.50, PeopleSoft HCM 9.1, Red hat Enterprise Linux 5.0/windows 2008

Client: Elkay Manufacturing June 2009 – April 2014

Job Title: Consultant

Upgrade of PeopleSoft applications from 8.9 to 9.1 and tools Upgrade from 8.47 to 8.50

Installation, configuration and editing of Application Server, Web Server and Process Schedulers

Tune the Application Servers for Peak Performance by testing the changes from Development Databases through Production Environment. Installed Tuxedo/Jolt, BEA Web logic Patches on application servers and web servers respectively to bring the servers current with the release

Configured Forgot Password functionality; Candidate gateway setup

Applied all Tax Updates after as a part of maintenance

Troubleshoot all issues pertaining to the application web and process scheduler servers

Create permission lists, roles and user profiles as per the business requirements

Maintain the Oracle database server, Export & Import; Backups & Recovery

Environment & Database Refreshes

Patches on application servers and web servers respectively to bring the servers current with the release

Plan and perform Backup & Recovery procedures activities (both in archive & no archive mode) using RMAN & Export/Import utilities

Environment: People tools 8.50, PeopleSoft HCM 9.1, Red hat Enterprise Linux 5.0/windows 2008

Client: 1-800Flowers, Carle Place, NY Aug 2008 to June 2009

Job Title: Database Administrator

Job Responsibilities:

Configured Physical standby database through Physical backup.

Performed database cloning through Rman/Physical Backup.

Performing Point-in-time recovery using recovery manager.

Taking Compressed and Incremental backups using RMAN.

Successfully Upgraded Oracle database 9i to higher versions.

Applying patches using OPatch utility.

For monitoring of critical errors in alert log on time base. Performed routine checks of space utilization. Extended Table spaces by resizing/adding data files when needed.

Alert Log Monitoring.

Environment: Oracle 9i

Client: General Motors March 2007 to July 2008

Job Title: Jr. Database Administrator

Job Responsibilities:

Creating users, roles, profiles, assigning roles and profiles to users.

Creating table spaces, Data files, Log files and control files.

Taking logical and physical backups periodically.

Configure SQL client using Database configuration assistant tool/creating networking Configuration files and creating service name.

Storage management, sizing the database objects, monitoring file Systems and table spaces growth

Used direct path loading via SQL*Loader

Database Space management

Environment: Oracle 9i

Training:

PeopleSoft HRMS and FSCM – AT&T, Hyderabad, 2010. Internal training at AT&T to enhance our functional knowledge on PeopleSoft HRMS and FSCM.



Contact this candidate