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); PeopleSoft 8.48; Siebel 8.1
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; Oracle RAC 9i/10g/11g;MySql 5.1;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; OEM; PL/SQL developer, Quest Toad
Middle Tier
Jboss, Tuxedo, AI, Oracle 10gAS/11g AS,Tomcat and Weblogic
Operating Systems
Solaris 2.5.1/2.6/2.8(SUN OS 5.5.1)/2.9/2.10, IBM AIX POWER systems 5.2/5.3/6.1, HP Tru64UNIX 5.1b/5.2/5.3, HP-UX-PA-RISK 11.23/11.31,HP-UX-Itanium 11.23, MS-DOS v7.0, Linux SESE 10/RedHat2.1,3,4,5 /OE, Windows 95/98/NT/2000/2003/XP/2008R2 and VMware
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 Oracle 11g: RAC and Grid Infrastructure Administration – Oracle Corp 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
Confidential,
Application Version: 11.5.10.2 through R12.X and Siebel 8.1
Operating System: Sun Solaris , Linux and Windows
Database: ORACLE 10g and 11g
Duration: Oct 2010 to till date
Role:
Oracle Database Maintenance/Oracle Application System administration/Solution Data architect Support for Oracle Applications 11.5.10.X through R12.X, Siebel ePharma 8.1running on various operating systems.
Played the role of Oracle DBA ,Application DBA, Siebel Admin and Solution Architect responsible for implementation and support of Oracle Application environments Install, configure and manage databases and Oracle Applications 11i,R12and Siebel 8.1 instances. Developed, implemented and administered the policies and procedures to ensure security and integrity of the databases and applications. Installed and configured the Oracle Enterprise manager (OEM), Grid control, agents to monitor the databases application environments. Applied database, Oracle EBS application 11i extended support,CPU patches Managed replications, Rapid cloning, and instance refreshes. Worked closely with other technical and non-technical personnel to set up and perform database, application, and workflow monitoring and tuning. Maintained the PROD maintenance activities, on- call support and produce the Sox auditing reports Key contact for the Change requests to deploy it into QA and PROD. Implemented the Physical standby Dataguard (DR) using grid control Configured the RMAN backups and developed the hot backups shell scripts. Responsible for Monthly maintenance on production instances and key contact person of the Production support. Installed and configured the Oracle 11g Grid infrastructure and RAC database for two node cluster. Project Title: Oracle Database/Application System Administration/Data Architect
Confidential,
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 2004 – Sept 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 to Unix. Managed and coordinated the client DBA’s, Offshore resources for on-time deliverables. Responsible for reporting status to the client.. Responsible for the infrastructure for the entire project. 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, 11.5.10 to R12.1 and installed all the Oracle application releases from 10.7 to R12. Upgraded the Oracle Application databases from 8i to 9, 9 to 10g and 10g to 11gR2. Installed and Maintained the Middle tier applications like Tuxedo, JBOSS, Apache, Weblogic and AI servers. Successfully tested and implemented Security in R11i by Secured Socket Layer (SSL) protocols for deploying R11i over the Internet for non-client users or external customers and remote users. SSL allows encryption and decryption of data transfer taking place between the client and the servers. Configured the Oracle Application 10g AS Single Sign on (SSO) for Portal and Discoverer Good Knowledge of Shared apple_tops, Parallel Concurrent processing and Setting up of DMZ server in High Availability environment for Oracle Applications 11i. Upgrade of Oracle Applications fusion SOA suite from 10.1.3.4 to 11g. Troubleshoot Database performance issues using EXPLAIN PLAN, TKPROF, SQL TRACE, Analyze, Hints, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) etc. Worked on various database tools like Statspack, Data pump, Flashback tables, Oracle wallet manager (OWM), Partitioning, Compression and SQL Tuning Advisor etc. Converted the Oracle Apps EBS regular 10g/11g databases into Oracle RAC 10g/11g. 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. Configured 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 Oracle enterprise Manager (OEM)/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 & OFSAAI 7.1
Project Title: Oracle Database/Application System Administration
Confidential,
Application Version: 11.5.9
Operating System: Sun Solaris 2.8
Database: ORACLE 8i and 9i
Duration: Aug 2003 – July 2004
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, Single sign on and Oracle Internet Directory (OID) 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
Confidential,
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 2001 – Aug 2003
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 Application Maintenance Patches to the various instances like PROD, TEST and Development Instances by using the Oracle tool adpatch, admrgpatch and external tools like Kintana,Ringmaster..etc 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 Configure Oracle application into SSL mode ( http to https). 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
Confidential,
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 2001 – Jun 2001
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
Confidential,
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 2000 – Apr 2001
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
Confidential,
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 2000 – Dec 2000
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
Confidential,
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 1998 – Jun 2000
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 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
Privacy Policy
