Quality Assurance Oracle
Resume:
Raj S. Rajmanna
abns3c@r.postjobfree.com
Summary of experience: Sr Oracle DBA with over 10 years, Project Administration,
infrastructure planning, Performance & Sql testing, PeopleSoft Financials, PeopleSoft application
administration with Leadership and Team Skills
Skills and Competencies:
Over 8 years of Oracle Database / Peoplesoft Administration for Large Database Systems
on Unix / Linux
Oracle RAC ( 10 & 11G),RMAN & ASM
Logical and Physical Database Design
Database Performance Tuning
PeopleSoft Financials Administration
Performance Testing
Infrastructure Planning.
Ability to Work independently
12+ years IT Experience
Problem solving/Trouble Shooting
Project Analysis & Design
Excellent Communication Skills
FedEx
Memphis, TN
Sr Peoplesoft DBA / Analyst / Team Lead
Jan 2000 – Current
Supported FedEx group of companies FedEx Services, FedEx Ground, FedEx Express, FedEx
Freight, FedEx Kinko’s in multiple roles in multiple peoplesoft implementations and upgrades as
DBA and Peoplesoft application administrator. I have also performed as Project Lead and Testing
Lead in large implementations of FedEx Opcos merger, upgrades and new module
implementations
Here are the some of functions performed in each role.
Oracle DBA & APPS
Maintain the highest level of availability of the databases
•
Install, configure and upgrade Oracle server software and related products in a UNIX environment
•
Database backup, restore, refreshes, cloning and performance tuning
•
Implement and enforce SOX security for all of the databases
•
Monitor the databases and optimize database performance and use of resources
•
Assistance to developers in optimizing their applications, queries.
•
Administer all database objects, including tables, indexes, views, sequences, packages
•
and procedures
Control migrations of schema changes and stored programs through the development life
•
cycle
Table partitioning
•
Disk sizing and Raid level recommendations
•
Disaster recovery Cluster and failover strategies
•
P erformance planning
•
Capacity planning / EMC / Net App
•
P erformance tuning
•
Maintain documentation and standards.
•
Technical assistance and mentoring to junior staff
•
Managing PeopleSoft and Oracle TARs
•
P eoplesoft Administration
Maintain production systems for PeopleSoft Financial, HR Aand EPM.
•
Maintain non-production systems for PeopleSoft Financial, HR, CRM and Staffing
•
Front Office clients
•
Troubleshooting the web server, application servers and process schedulers
•
Installation and migration of PeopleSoft code to the web servers, application servers, and
•
process scheduler servers
Refresh dev/test/ train PS environments from production
•
Planning of new PeopleSoft environments
•
Upgrading PeopleTools on the web servers, application servers, and process scheduler
•
servers. Creating new PeopleSoft environments
P rovide expert troubleshooting for isolating technical problems in the PeopleSoft Internet
•
Architecture (PIA)
Build, configure, debug and support PeopleSoft applications in a multi-instance
•
environment
Apply PeopleTools updates, PeopleBooks updates, software updates and maintenance
•
packages using Change Assistant.
Debug and optimize SQL statements within Query, COBOL and Application Engine.
•
Run, analyze and correct issues reported in audit reports.
•
Have in-depth knowledge of PeopleSoft Internet Architecture security components.
•
Data migration support for PeopleSoft Development, Training, Quality Assurance, and
•
Production environments
Security Administration, Adding and deleting users, Modifying user access, Maintaining
•
documentation for Sox and other audits
Administer Tuxedo application servers on Unix load balancing activities in the hosting
•
environment
Aug 1997 – Dec 1999
Tuskegee University
Tuskegee, AL
DBA
Database Administrator for the Department Of Computer Science, Tasks included installing
and monitoring various Oracle databases for the Computer Science Department.
Detailed Responsibilities Included:
Monitoring of numerous Oracle Databases such as course and student advisory databases.
Applying all required patches using orapatch to upgrade the database to the most recent
version.
Automating user creation based on patterns of course enrollment using UNIX shell scripts.
Backing up the databases using Sqlbacktrack
Using SQL Loader to load data into the databases.
Tuning the database for performance issues.
Executing UNIX cron jobs for operating system backup errors.
Email notifications for errors.
Migrating user data across different databases based on system configuration.
Responding to student emails to solve database issues.
EDUCATION
Masters in Electrical Engineering June 1999
Tuskegee University, AL, USA.
Bachelor of Science in Engineering August 1996
Bharathiar University, India.
Contact this candidate