SUMMARY

Over 15 years of experience in IT Industry. Performed as a Peoplesoft / Oracle DBA with the title of Sr. Peoplesoft DBA, Manager ERP, DBA and Tech Lead in Communication Industry, Health Care industry and Financial Institution. Provided technical leadership. Hands on experience on full life cycle of the project. Extensive experience in Peoplesoft Administration (Financial, FDM, SCM, EPM, ELM and HRMS). Experience includes Peoplesoft version from 7.5x to 8.x Implementation and Administration. Responsible for complete Installation, Configuration and Tuning of Peoplesoft systems using Peopletools and Applications, Databases, Application servers, Process schedulers, Weblogic server, Fax servers and integrating all the systems to bring it up to production level. Worked as a Tech lead for Finance and HR upgrade from 7.5x to 8.x. Designed PIA architecture, Capacity planning of databases, Successful upgrade completion to production. Hands on experience with tools like Peopletools, Application Designer, Datamover, Nvision, SQR, Configuration Manager and crystals. Applied bundles, patches and fixes on Peoplesoft tools and Application, Migrated projects from Test to Production, Implemented change control. As an Oracle DBA, extensive experience in Administration, configuration, upgrade, backup & recovery, maintenance, troubleshooting and performance tuning of databases. Performed as a SQL DBA and Systems Administration, Installation and support of Unix and NT based systems. Knowledge of DB2 and Sybase databases.

SOFTWARE SKILLS:

• Hardware: IBM RS6000 Model F40, Sun Solaris Enterprise 4500, 250, DELL Power Edge server 2300, Compaq servers DL850, SAN, EMC & Pentium PC’s.
• Operating systems IBM AIX 5.x, Solaris 2.8, Windows 2000, Windows NT 4.0, Windows 95/98, NetWare Operating System Ver 4.1x, SCO UNIX Ver3.2
• RDBMS / Tools:Oracle 10G/9.x/ 8.1.7.4/8.0.5/7.3 on AIX 5.0, Solaris 2.8 and on Windows 2000/NT4.0, SQL server on NT 4.0, Quest Central for Oracle, Foglight, DBA Studio, Oracle Enterprise Manager, SVRMGR, LSNRCTL SQLPLUS, SQR, SQL server on NT/2000, SQL Enterprise manager.
• Applications Peoplesoft Financials, FDM, SCM, EPM, ELM and HRMS Version 8.x/7.5x, Peopletools Version 8.x/7.5x, Tuxedo App Server, Upgrade Assistant, Change Assistant, Weblogic server, MS IIS 4.0 server, Seagate Crystals for Peoplesoft.
• Other Tools:Peopletools, App. Designer, SQR, Datamover, Nvision, Configuration Manager, Hyperion Essbase 6.x, Batch and Shell scripts, Crystals, IIS 4.0 Admin, DBA Studio, Tuxedo App. and Web Server

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities: Sr. Peoplesoft Admin

• Performed Peoplesoft Application upgrade from HRMS 8.3 to 8.9 and Tools 8.20 to 8.48.09.
• Configured Change Assistant for running upgrade steps.
• Applied patches, fixes and Maintenance packs using CA.
• Working with the team model onsite-offshore.
• Created and configured Peoplesoft Application server for the Demo, UPG, Test and production databases.
• Maintaining all the Process Schedulers and Application servers for databases.
• Resolved ongoing issues within the upgrade.

Confidential

Responsibilities: Sr. Peoplesoft Admin / DBA

• Created and configured Peoplesoft Application server for the Demo, Test and production databases.
• Maintaining all the Process Schedulers and Application servers for databases.
• Created scripts to automate startup and shutdown of databases, Process schedulers and Application Servers.
• Applied all the bundles, fixes and patches up to required level.
• Refreshed test databases as and when required by the Peoplesoft support team.
• Migrated the projects from Demo to Test and to prod environments.
• Installed and configured Oracle, Peoplesoft Peopletools 8.42,46,47,48, HRMS8.3, 8.9, ELM8.8, Financials 8.4, Crystals 8.5, Tuxedo Application Server 6.5 Jolt 1.2A. Created and configured Databases, Process Scheduler and application server.
• Setting up PIA env for all HRMS, ELM and financials.
• Setting up Peoplesoft report repository for multiple Peoplesoft PIA environments.
• Efficiently and successfully maintaining HRMS, ELM and Financials databases.
• Created and refreshed multiple databases for Peoplesoft upgrade from HRMS 8.3 to 8.9 and tools from 8.18 to 8.48.
• Upgraded Oracle from 9.2.0.7 to 10.2.0.3. using DBUA.
• Applied Oracle patches as and when required.
• Assisted the eam running upgrade for maintaining Oracle tablespaces, datafiles, extents, analyzing tables and indexes, backup and restore etc
• Doing the routine job like helping users to resolve Peoplesoft issues, maintaining extents of indexes, tables and tablespaces, controlling access to database for respective users, taking backup and exports of the tables and restoring and importing it, creating batch scripts for automation of the processes, as a single point of control moving sqr’s, projects, fixes and updates into Peoplesoft test, QA and production systems. Resolving Peoplesoft crystal, excel, Nvision and FTP, issues.

Confidential

Responsibilities: Lead Peoplesoft Application Administration / DBA

• Worked on Peoplesoft FSCM 8.4 and HRMS 8.8 and Tools 8.45.12.
• Installation, configuration, maintenance and tuning of WebSphere 5.1 Application server on AIX 5.2 and Windows servers.
• Installation, configuration, maintenance and tuning of Tuxedo Application server version 8.1 on AIX 5.2 and Windows servers.
• Configuration, maintenance and tuning of Process Schedulers on AIX 5.2 and Windows servers.
• Setting up Peoplesoft report repository for multiple Peoplesoft PIA environments.
• Configuration, maintenance and tuning of PIA for FSCM and HRMS Peoplesoft applications.
• Configured and tested LDAP for single signon on Peoplesoft Systems.
• Configured and tested Change Assistant on Peopletools 8.45.12 on Patch env. to apply patches and fixes and future upgrades.
• Worked on Integration Broker to facilitate the messaging between Peoplesoft Financials and HRMS applications.
• Installation and configuration of Microfocus 2.2 SP1 and 3.1 on AIX 5.2 and Windows respectively to compile Cobol source files for Peoplesoft application.

Confidential

Responsibilities: Peoplesoft / Oracle Database Administration

• Created scripts to automate startup and shutdown of databases, Process schedulers and Application Servers.
• Created scripts and switches to automate Peoplesoft client workstation.
• Applied all the bundles, fixes and patches up to required level.
• Refreshed test databases as and when required by the Peoplesoft support team.
• Moved the projects from Demo to Test and to prod environments.
• Installed and configured Oracle, Peoplesoft Peopletools 8.42, EPM 8.8, Crystals 8.5, Tuxedo Application Server 6.5 Jolt 1.2A. Created and configured Databases, Process Scheduler and application server.
• Worked on ETL’s. using Informatica 5.0.
• Worked with Cube Manager. Set all dimensions with cube manager.
• Worked with functional person who uses budgets module to run budget reports.
• Co-ordinating with Business team and setting up requirements for Crystal Reports and working with support team to develop, test and migrate reports into Prod.
• Doing the routine job like helping users to resolve Peoplesoft issues, maintaining extents of indexes, tables and tablespaces, controlling access to database for respective users, taking backup and exports of the tables and restoring and importing it, creating batch scripts for automation of the processes, as a single point of control moving sqr’s, projects, fixes and updates into Peoplesoft test, QA and production systems. Resolving Peoplesoft crystal, excel, Nvision and FTP, issue

Confidential

Oracle Database Administration:

• Installation and configuration of Oracle 805 on NT4.0.
• Creating and maintaining Test, Development, Demo, AUD and Production databases.
• Managing an Oracle Instance: Validating privileged users, creating parameter file, setting parameter values and managing startup and shutdown of the instance.
• Maintaining control files, Maintaining redo log buffers and archiving redo log files.
• Maintaining table spaces, data files and logical database structure.
• Managing rollback segments, using rollback segments with transactions, planning and creating rollback segments as per the database transaction requirements.
• Managing tables, indexes, data integrity, users, and profiles, privileges roles.
• Database backup and recovery using backup manager.

Confidential

Administration

• User and group management set up policies for users and groups.
• Creating directory structure, assigning sharing and permissions to groups and users on it.
• Installing and configuring the printers on the system.
• Performing Backup and restore activities. Monitoring and tuning the system.
• Installing and maintaining software applications on the system (Oracle, IIS server).

Confidential

Responsibilities: Consultant: Systems Administrator / Oracle DBA / SQL DBA

• Installation and configuration of Oracle 8I on Solaris and NT4.0.
• Creating and maintaining databases.
• Managing an Oracle Instance: Validating privileged users, creating parameter file, setting parameter values and managing startup and shutdown of the instance.
• Maintaining control files, Maintaining redo log buffers and archiving redo log files.
• Maintaining table spaces, data files and logical database structure.
• Managing rollback segments, using rollback segments with transactions, planning and creating rollback segments as per the database transaction requirements.
• Managing temporary segments,
• Managing tables, indexes, data integrity, users, and profiles, privileges roles.
• Database backup and recovery using backup manager.
• Monitoring the database performance and tuning the performance.
• Maintaining the Peoplesoft HRMS 7.51 Production, Development and Test Servers.
• Applying Peoplesoft and Oracle updates and fixes.

Confidential

Administration of Windows NT 4.0 Servers

• User and group management set up policies for users and groups.
• Creating directory structure, assigning sharing and permissions to groups and users on it.
• Installing and configuring the printers on the system.
• Performing Backup and restore activities. Monitoring and tuning the system.
• Installing and maintaining applications on the system (Oracle, Lotus Notes, IIS server).
• Installed and configured SQL server. Created and maintained databases for merchandise site.
• Installation and configuration of workstations. Extended complete system support.
• Designed, configured and implemented Unix Operating System Solaris 2.8 Sunsparc 250 enterprise server using Unix command line and installation wizard. Installed devices like array of hard disks, NIC network cards, created Unix partitions mount points, file systems, using SMC and command line mode.
• Create user and groups. Assign users to the respective groups.
• Set the permissions for the users on the groups, file system and applications.
• Maintaining user profile by modifying .local files in user home directories.
• Set system kernel parameters for the applications like shared memory min and max.
• Install, configure and administer applications like Oracle 8.1.5 and Weblogic 5.10 SP9.
• Backup and restore using Backup, CPIO, and TAR commands.

Confidential.

Responsibilities: Performed as a Senior Engineer

• Installation and configuration of the server AIX 4.1.5 (Creating File system and allocating memory space, configuration of DNS, Configuring it on the network.).
• Managing user and group accounts, permissions and security.
• Software installation and maintenance (Installing software bundles and applying patches to the existing Software, configuring the user profile to access the software).
• Device management (Adding and configuring devices on the system like printers and tapes).
• Managing queues and printers (firing jobs on to the printer through print queues).
• System storage management (Creating Volume groups, Logical volumes, physical partitions, File system and mount points).
• Managing Unix file system (Like directories, applications software and Boot image files).
• Monitoring performance and tuning using sar, ps, iostat, du, vmstat, , commands and SMIT.
• Backup and restore using (Backup, CPIO, and TAR) commands,
• User administration, job scheduling, Configuring system on to the network by setting up TCP/IP option and configuring host file.
• Installed EXCEED 6.1 on the client machines to facilitate with Xwindows.

Confidential

Oracle8 Database Administration

• Installation and configuration of Oracle8 on the AIX server.
• Creating and configuring Databases by using crdb, pfile, catalog and catproc scripts.
• Managing an Oracle Instance: Validating privileged users, creating parameter file, setting parameter values and managing startup and shutdown of the instance.
• Maintaining control files, Maintaining redo log buffers and archiving redo log files.
• Maintaining table spaces, data files and logical database structure.
• Storage structures and relationships: Types of segments, using block space utilization parameters, planning the location of the segments. Created the database links.
• Managing rollback segments, using rollback segments with transactions, planning and creating rollback segments as per the database transaction requirements.
• Managing tables, indexes, data integrity, users, and profiles, privileges roles.
• Database backup and recovery using backup manager.
• Monitoring the database performance and tuning the performance.

Confidential

Administration

• User and group management set up policies for users and groups.
• Creating directory structure, assigning sharing and permissions to groups and users on it.
• Installing and configuring the printers on the system.
• Performing Backup and restore activities. Monitoring and tuning the system.
• Installing and maintaining applications on the system (Oracle, Lotus Notes, IIS server).
• Looked after the hardware and software upgrade on the system.
• Installation and configuration of workstations. Extended complete system support.