Oracle System
Resume:
Rajendra Kalaskar
********@*****.***
EXPERIENCE SUMMARY
Mr Rajendra is an Oracle Certified Professional with Twelve years of
experience in IT industry. He is an Oracle DBA, Oracle Applications DBA,
PeopleSoft Admin and Application System Administrator/Architect on
different platforms with different flavors of UNIX. He has worked on
multiple versions of Oracle Applications such as R12.X, 11i, 11.0.3/10.7
NCA/10.7 SC (both GUI and Character based). Expertise in Installing,
upgrading, performance tuning, Unix kernel tuning, table space
management, monitoring database, backup, archiving,recovery plans,
database re-organizations and supporting multiple Oracle
instances/application system in a 24 by 7 environment of oracle
applications.
SKILL SETS
ERP - Oracle Ebusiness suite Applications 10.7.X through R12.X
(Financials, Manufacturing, Order Management, SSWA, CRM, Oracle Sales
Online, Quoting, Contracts, Advance Pricing, Federal, iProcurement,
Benefits, HRMS, Payroll and FAH)
Oracle Financial Services -
Siebel Analytics - Oracle Business intelligence enterprise edition
OBIEE 10.1
Revalues - Oracle Financial Service Analytical application
Infrastructure OFSAAI 7.1
RDBMS/Software Tools - Oracle 7.x/8.x/8i/9i/10g/11g ; SQL*PLUS; PL/SQL;
FORMS /10g/6.0/4.5; REPORTS 10g/6/2.5; Oracle Discoverer 3.1/4i, ADI
(Application Desktop Integrator),Oracle Workflow 2.6, GLDI; Oracle
Enterprise Manager.
Middle Tier - Jboss, Tuxedo, AI, Oracle 10gAS,Tomcat and Weblogic
Operating Systems - Solaris 2.5.1/2.6/2.8(SUN OS 5.5.1)/2.9, UNIX SVR4,
IBM AIX, HP 9000, MS-DOS v7.0, Linux, Windows 95/98/NT/2000/XP and VMware
Hardware - SUN Ultra Enterprise Servers, Pentium Server, Pentium PCs
Languages - C; Unix Shell Programming (Bourn, ksh, csh), crontab, awk,
perl and PL/SQL
Xclients - Hummingbird Exceed V7.1, Reflection, VNC Viewer
HIGHER EDUCATION
> Master In Computer Applications - Karnatak University, Dharwad, India.
> Bachelor Of Science(Mathematics) - Osmania University, Hyderabad,
India.
AFFILIATIONS/CERTIFICATIONS
> Oracle E-Business Suite Applications Database Administration
Certification Professional (OCP) in 11i and R12
> Oracle Certified Professional (OCP) in 9i and 10g
> 11i9 Oracle E-business Suite Technical Integration Champion.
> Oracle E-Business suite Accelerator(OBA) in R12.1 level 3.
> Diploma in Oracle Relational Database Management Systems.
> Member - Oracle Applications User Group.
TRAINING
> Completed one week classroom training in Oracle DatabaseXtender -
Outerbay
> Completed the Instructor led training in Oracle 9i RAC - Oracle
Corporation
> Completed the instructor led training in Administering SQL Server 2000
Database
> Completed the Instructor led training in PeopleSoft Admin - 8.48.08
> Capgemini- Engagement Management
RELEVANT EXPERIENCE
Project Title: Oracle Database/Application System
Administration/Data Architect
Client: Capgemini Ernst & Young - NJ Various Clientele ranging from
Financial,Healthcare,Telecom,Retail and Federal sectors(
Merrill Lynch, Wellcare, National Gallery of Arts, Seven-
Eleven, General Communications Inc, SwissRe, Vonage, De
Lage Landen, Covance, Aegon, iStar and Newedge)
Application Version: 11.0.3 through R12.X
Operating System: Sun Solaris,HP-Unix, IBM AIX, Linux and
Windows
Database: ORACLE 8i, 9i,10g and 11g
Duration: July'04 - Sept 02,2010
Role:
Oracle Database Maintenance/Oracle Application System
administration/Solution Data architect Support for Oracle Applications
(10.7.X through R12.X), running on various operating systems.
> Played the role of Oracle DBA,Application DBA and Solution Architect
responsible for implementation and support of Oracle Application
environments for multiple clients including the Oracle Development
Center at EY Newyork ADC.
> Played the lead architect and application dba for Migrated the Oracle
Applications from the different flavours of Unix RHEL 2.5 to RHEL 5 &
from Windows tro Unix.
> Managed the client DBA's and involved in key stakeholders meetings.
> Managed and coordinated with Offshore Resources for on-time
deliverables.
> Performed Installation and Configuration of Oracle Applications from
R11.X to R12.X on various operating systems.
> Upgraded Oracle Applications from 11.5.9 to 11.5.10, 11.5.5 to 11.5.10
and installed all the Oracle application releases from 10.7 to R12.
> Installed and Maintained the Middle tier applications like Tuxedo,
JBOSS, Apache, Weblogic and AI servers.
> Upgraded the Oracle Databases from 8.1.6.X to 8.1.7.X,8.1.7.x to 9i
and 9i to 10g.
> Cloning Oracle Applications using adclone, Autoconfig, Rapidclone
> Tuning the user defined SQL queries, procedures and functions using
Toad, explain plan, tkprof
> Identified the performance issues at the client site. Ran the bstat
and estat reports during the peak usage hours, analyzed the file
system layout, and system parameter settings.
> Worked on database performance tuning with various tools like
Statspack and AWR.
> Installed and Managed the Oracle ASM and Oracle 10g Databases with
RAC.
> Good knowledge of Oracle 10g Streams and data encryption techniques.
> Applied the latest Oracle Applications, Oracle CPU (Critical Patch
Updates) and DST (Daylight savings) patches.
> Implemented and maintained Oracle read-only standby databases and fail
over databases(Data guard).
> Responsible for code migration to all respective instances.
> Involved in Oracle Data Guard and Grid control implementations of
Oracle 10g R2
> Implemented the Oracle RMAN for backups and developed the shell
scripts for backups and monitor the database performances.
> Implemented & configured the the database control/Oracle DB Grid
control and managed the Oracle Instances.
> Converted the PeopleSoft Application database from Non Unicode into
Unicode
> Upgraded the PeopleSoft tools 8.2.0 to 8.48.08 and HRMS applications
from 8.0 to 9.0
> Installed and configured the OBIEE 10.1 and OFSAAI 7.1
Project Title: Oracle Database/Application System
Administration
Client: Merrill Lynch - New York
Application Version: 11.5.9
Operating System: Sun Solaris 2.8
Database: ORACLE 8i and 9i
Duration: Aug'03 - July'04
Role:
Oracle Database Maintenance / Oracle Application System administration
Support for Oracle Applications 11.5.9, running on Sun Solaris.
Oracle Apps DBA:
> Led the applications DBA team for conversion from PeopleSoft HR to
Oracle HR and the associated Customizations.
> Managed 15 instances by accessing the development team of 50 users
daily.
> Installed and configured NLS/MLS and implemented the additional
languages like Japanese, Chinese,.spanish...etc
> Installed and configured Oracle Enterprise manager (OEM), Discoverer
and Portal.
> Audited HRMS tables at application level.
> Installed and configured stats pack.
> Applied Latest HRMS (US/JA) Maintenance Patches to various application
Instances.
> Maintaining application source code version control system using PVCS.
> Made recommendations for the purge of workflow tables, analyzer
scripts to be run, change the key application/database user passwords.
Project Title: Oracle Database/Application System
Administration
Client: Core Services Corporation - NJ. Various Clientele ranging from
Technology through manufacturing facilities.(Ulticom,
World finer foods, Altec, MJ research, Weight
watchers) - New Jersey
Application Version: 10.7.X through 11i
Operating System: Sun Solaris 2.8/2.6/2.5.1, Windows NT, HP-UX, Linux
Intel, AIX
Database: ORACLE 8.X / 8i/9i
Duration: Jun'01 - Aug'03
Role:
Oracle Database Maintenance / Oracle Application System administration
Support for Oracle Applications (10.7.X through 11i), running on various
operating systems detailed above.
Oracle Application Database Administration:
> Performed Installation and Configuration of Oracle Applications 11i on
Sun Solaris UNIX
> Installed Oracle 9i and migrated from 8i to 9i to use Oracle
Applications 11i
> Upgrade from Oracle Applications 10.7 to 11.5.X, 11.0.X to 11.5.X and
11.5.X to 11.5.8 and 11.5.9
> Migrated Oracle Applications 11i from HP-UX to Solaris.
> Applied Latest Oracle Maintenance Patches to PROD, TEST and
Development Instances
> Rebuild the Highly fragmented objects by using the Proper storage
structure
> Loaded flat files and other data files from some non-networked
application and populated into Oracle Database using direct path
method of SQL* Loader and import/export.
> Scheduling concurrent processes to perform routine housekeeping
activities and also for improving Application performance (Gather
Statistics etc.,)
> Configure the Form server Load Balancing and web server load balancing
> Configure the Apache Single Listener
> Upgraded the Workflow from 2.5 to 2.6
> Installed the Developer 6i Patch sets for Upgrading forms and reports
> Upgraded the Jinitiator VER 1.1.8.X to 1.1.8.16 and 1.1.8.22
> Installed Multiple Reporting Currency (MRC)
> Installation and configuration of Application Desktop Integrator
(ADI)
> Installation and configuration of Oracle Discoverer 3i/4i
Project Title: Oracle Database/Application System
Administration
Client: Intertek Testing Services - Boston,MA
Application Version: 11.5.3
Modules: Financial, Manufacturing and CRM Modules
Operating System: Sun Solaris 2.6/2.5.1, Windows NT, HP-UX,
Linux Intel,
Database: ORACLE 8.X / 8i
Duration: Apr'01 - Jun'01
Role:
Oracle Database Maintenance / Oracle Application System administration
Support for Oracle Applications 11.5.3 running on various operating systems
detailed above.
Oracle Application Database Administration
> Performed Installation of Oracle E-Business Suite R11I (11.5.3) On HP-
UX 11.0
> Implementing All the Financial, Manufacturing and CRM Modules like OE,
AR, AP, GL, BOM, Engineering, Self Service Time, Isupport, Istore,
Ipayment, etc.
> Configure the Form server Load Balancing
> Migrate the Oracle Applications Database from 8.1.6.0.0 to 8.1.6.3.1
> Creating and assigning Responsibilities to the respectable Users
> Applying Latest Patches to the Test and Prod Instances
> Upgrading Oracle Developer 6 to Developer 6I Patch 3(6.0.8.12.x)
> Refreshed Oracle Applications from Prod to Test From One Unix Box to
Another Box
Project Title: Oracle Database/Application System
Administration
Client: Blue Meteor Inc. - Chicago,IL
Application Version: 10.7.X through 11i
Modules: Financial, Manufacturing and CRM Modules
Operating System: Sun Solaris 2.6/2.5.1, Windows NT, HP-UX,
Linux Intel
Database: ORACLE 8.X / 8i
Duration: Dec'00 - Apr'01
Role:
Oracle Database Maintenance / Oracle Application System administration
Support for Oracle Applications (10.7.X through 11i), running on various
operating systems detailed above.
Oracle Application Database Administration
> Performed Migration of Oracle Applications from HP UNIX to Sun Solaris
UNIX
> Upgrade from Oracle Applications 11.0.2 to 11.0.3
> Configuring the Web Server for Oracle Applications
> Installation/Upload of Quantum Vertex 2.0 (Tax calculation tool which
interface with Accounts Receivables taxes)
> In-charge of the maintenance team supporting nearly 20 instances of
Oracle Applications 11.0.3 and 11.1.5.2 with Oracle 8.0.5 and 8.1.6
running on Sun 4 servers
> Have designed, developed and implemented backup strategies and
database refresh procedures
> Design space allocations and relocations of custom oracle applications
form one server to avoid the maintenance nightmares and also to avoid
downtime of other applications running on the same machine
Project Title: Oracle Database/Application System
Administration
Client: AppShop Inc.- Freemount,CA
Application Version: 10.7.X through 11i
Modules: Financial, Manufacturing and CRM Modules
Operating System: Sun Solaris 2.6/2.5.1, Windows NT, HP-UX,
Linux Intel
Database: ORACLE 8.X / 8i
Duration: July'00 - Dec'00
Role:
Oracle Database Maintenance / Oracle Application System administration
Support for Oracle Applications (10.7.X through 11i), running on various
operating systems detailed above.
Oracle Application Database Administration
> Refreshed Schemas in development databases from production databases
on demand
> Developed and implemented procedures written using shell scripts for
monitoring the databases running on different machines
> Applied and Upgraded Customized Modules in Apps
> Wrote scripts for Phased loading of data from Legacy system to
interface tables
> Monitored Database for Max extents and for invalid objects using
scripts and rectify them
> Installed Discover 2000 on NT server
> Called Oracle Support for internal errors and flex bugs
> Created new custom Application tops
> Defined Concurrent Managers and scheduling
> Defined Concurrent requests and scheduling it for time intervals
> Registered forms and reports on financial tops
Project Title: Oracle Database/Application System
Administration
Client: QSPL - Bangalore India
Application Version: 10.7.X through 11i
Modules: Financial, Manufacturing and CRM Modules
Operating System: Sun Solaris 2.6/2.5.1, Windows NT, HP-UX,
Linux Intel,
Database: ORACLE 8.X / 8i
Duration: Jun'98 - Jun'00
Role:
Oracle Database Maintenance / Oracle Application System administration
Support for Oracle Applications (10.7.X through 11i), running on various
operating systems detailed above.
Oracle Database Administration
> Refreshed Installing and upgrading the Oracle7 Server and Application
tools
> Designing and creating database, Create Primary Database Storage
structures and Primary objects, Allocate system storage and plan
future storage requirements for database
> Modify database structure, Enroll users, Grant and Revoke database
privileges, Control and Monitor user access to the database
> Backup and recover the database
> Maintain System security, Monitor and Optimize database, Performance
> Wrote shell scripts to monitor trace files
> Wrote Cold backup shell script to take complete cold backup,
Implemented automatic startup of databases during system boot process
Oracle Application Database Administration
> Managed three independent Database servers running Under Sun Solaris
each with forty users accessing concurrently
> Monitoring users system activities and debugging their system related
problems
> Monitoring system performance by using Server Manager
> Daily, Weekly, Monthly backups (Export, Online, Offline)
> Completely recovered all databases when system crashed
> Solved SQL*NET connectivity problems and Listener Configuration
> Reconfigured All Databases in Multithreaded Server, Archive mode
Contact this candidate