Sr Oracle DBA,RAC,Peoplesoft DBA
Resume:
CERTIFICATIONS
• Oracle **g ( OCP )
• Oracle *i( OCA )
• Appear Oracle 10g RAC.
IMPLEMENTATIONS
• Implemented Database Built on AIX 5.3, Solaris 10 sparc,RHL4.
• Implemented 3 Node or RAC Set Up For Playtech S/W Project.
• SAP (SCM 4 to 7) up gradation on HP UX with Oracle 9i to 10g.
APPRECIATIONS
• Appreciated by PM of Playtech Software India Pvt Ltd. For Implement 2 Node Of RAC on Sun Solaris within time limit.
EDUCATION
• MCA (Master of Computer Applications)from Dr.BAMU University, 2007 batch with 65%.
• BSc computer science from Dr. BAMU University, 2004 batch with 60%.
Oracle DBA/People Soft DBA/Admin / RAC with over 5yr experience working in a team environment. Well versed in installation, configuration and Administrating on Oracle DBA / RAC. People soft Administration in Implementations, Support and Upgrades.
• Experience in PeopleSoft Up gradation HRMS and FCS on oracle 10g.
• Experience in managing multiple Databases on platform like Linux, Solaris, AIX
• Experience in up-gradations and Migrations of Databases
• Experience in Installation of Oracle on different O.S
• Experience in Handing RAC Databases in 10g.
• Experience in handling performance and Tuning task on large databases.
• Experience in preparing the shell script for automating the administrative activities for databases.
• Troubleshooting on a reasonable endeavor based on RAC/Non RAC Environments.
• Maintain and Monitor schedule jobs
• Configuring and Maintaining Database Backup Strategies.
• Applying Patches to Databases ( Bug- Fix Patch ,Feature Enhancement )
• Experience in managing Physical and Logical Databases.
• Monitoring and Tuning Indexes and Memory Parameters.
• Experience in managing Oracle 9i,10G,11G installations on UNIX platforms
• Managing Physical Structure and Logical for the databases.
• Basic knowledge of Different UNIX Platform like Linux, Solaris, AIX.
• Experience in Basic PS admin DBA.
Skills
Oracle 9i, 10g Internals
Data Guard 9i, 10g
Real Application Clusters (RAC)
Database Cloning
Disaster Recovery Solutions
Database Creating
Recovery Manager (RMAN)
Standby Database Solutions
Oracle Backup Scripting
UNIX, Solaris, AIX, Linux
Data Centre Activity, Toad
PeopleSoft HRMS/FSCM 8.x/9.0
ERP Skill:-
ERP : PeopleSoft HRMS/FSCM 8.x/9.0, People Tools 8.46/8.47/8.48/8.49
Databases : Oracle 10g, PS 8.48-8.49 up gradation
Operating Systems : Windows 2003/NT, RHEL AS 4.
Web server : Bea Web logic 8.1/9.2
People Tools : Data Mover, Integration Broker (PIA), Change Assistant,
Security, Process Scheduler, Configuration Manager, Application Designer, Tuxedo Application server.
Current Employment
Fujitsu Consulting India Pvt Ltd, PUNE.
IT Consultant Oracle Aug 2010 to Till Date.
Project Thomson Reuters RAC Support.(UK)
Company Fjitisu Consulting India Pvt Ltd.
Roles & Responsibilities • Support Oracle 10g RAC env on Solaris 10.
• Support SIEBEL Application with Oracle 10G.
• Support 10 Productions DB.
• Monitor RMAN backup and Export jobs.
Tools Used Oracle 10g on Solaris & Unix
Project SAP Up gradation SCM 4 to 7 and Oracle 9i to 10g
Company Georgia Pacific , Atlanta
Roles & Responsibilities • Perform role as SAP Basis.
• Up grade oracle 9i to 10g on HP UX Itanium and SCM 4 to SCM 7.
• Configure RMAN backup policy.
Tools Used Oracle 9i,10g on HP UX.
Saraswat Infotech Ltd.
Oracle DBA Jan 09 to Till Date.
Project Swicthover Activity ( Saraswat Bank)
Company Saraswat Infotech Ltd.
Roles & Responsibilities Implement Data Guard on DR side Physical standby database.
Set parameter on both side PR & DR side in init.ora file.
Backup of database with DB size 660GB.
Make primary db as standby and DR as Primary.
Now check whether the archive logs are being archived and applied on the DRDB.
It must be always kept in mind for a switchover, the production database (PR) must be made standby first.
Tools Used Oracle 10g, IBM AIX.
Project Implement Logminer utility and purging of table
Company Saraswat Bank,Mumbai
Roles & Responsibilities Using Logminer utility find out sql statement in Redo log.
DML statement.
Purging 20 production table wich is size of each 5gb.
Maintain disk space for creation archiving log.
Delete old data which are not required using date wise.
Drop old table and rename new table.
Tools Used Oracle 10g, IBM AIX.
Project AT &T Light Speed and Cramar
Company Amdocs,Pune India
Roles & Responsibilities DBA Task for AT&T.
Create user, synonyms and sequence. Grants on all tables.
Export and Import user, table, full level DB.
Check N/W issue for application level and DB level.
Core DBA Task for CRAMAR project.
Working as a Production DBA to assist support production.
Performing import/Export backups
Performing import/Export backups
Creating logical and physical structures
Creating Users and allocating Space.
Tools Used Oracle 9i,10g, Unix,Linux,windows
Work History
Playtech Software India Pvt. Ltd.
Oracle DBA Jul 08 to Dec 08.
Project Oracle 10g Real Application Cluster(RAC)
Company Playtech Software India Pvt. Ltd.
Roles & Responsibilities Oracle RAC (Real Application Clusters) setup and tuning.
Logical and physical database design.
Installations, backups and recovery using shell scripting, RMAN and media managers.
Install Solaris O/S, create user, group, directory structure as per requirement.
Configure Network connection.
Configure Shared storage on SAN – T2000.
Install and Configure Real Application cluster on Solaris 10.
Implement 2 nodes of RAC- RACDB1, and RACDB2.
Troubleshoot of Cluster, oracle, Hardwar, O/S error.
Configure ASM, Redolog disk group on shared storage.
Tools Used Oracle 10g, Solaris 10.
Project Install, Configure and Production Support of People soft Applications and Databases
Company Name Playtech Software India Pvt. Ltd.
Roles & Responsibilities Apply fixes, Updates and Patches for Demo, Dev, Test and Production Application
Take care of the Migration of data and PeopleSoft objects
Created Databases DEMO, DEV, TEST, CONFIG and PRODUCTION databases on UNIX.
Installed PeopleSoft applications – People Tools 8.49, Application (HCM 9.0 and Financials 9.0, CRM9.0), Tuxedo 9.1, and Web Logic 9.2.
Install and Configure Oracle Client and configure TNS files to get two-tier access to Developers and Users.
Tools Used Oracle 10g, Unix, FSCM 9.0, HCM 9.0, CRM9.0, People Tools 8.49
Accel Frontline Ltd.
Oracle DBA Oct 07 to Jul 08.
Project Residential RAC Database Administrator
Client’s Name Bajaj Allianz Life Co.Ltd. Pune.
Roles & Responsibilities Working as a Production DBA to assist support production databases of Oracle version 10gR2/RAC.
Currently working on 9i, 10g RAC
Performing import/Export backups
Creating logical and physical structures
Creating Users and allocating Space
Working with 10g ORACLE ASM, RAC, Data Guard 9i
Supported 10g RAC databases. Install Oracle 9i and 10g software. Create 10g database and configure Enterprise Manager Database Control feature.
Creating Database link.
Export backup, hot backup. Library Maintain backup on Tape on data storage manager of IBM Open view
Tools Used Oracle 10g, IBM Tivoli Storage Software, IBM AIX, Linux EL 4.
Project Oracle Data Guard 9iR2
Client’s Name Karnataka Bank (Banglore)
Roles & Responsibilities Troubleshooting with Primary database to Standby database.
Implement Data Guard on DR side Physical standby database.
Set parameter on both side PR & DR side in init.ora file archive_lag_target=1800.
Synchronize with PR to DR.
Tools Used Windows 2003 OS, Oracle 9i
Certification
• PeopleSoft DBA/Admin and Up gradation training.
• Oracle Certified Professional (OCP9i DBA) Exam Program from Apr 07 to Oct 07.
• Oracle Certified Professional in Oracle (OCP 10g) Exam Program May 2008.
• Appeared for Sun Solaris Certified Associate (Beta) Exam
• Preparing ORACLE RAC 10gR2 exam.
Education Details:-
• MCA – 2007 – (65%) – DR.B.A.M.U Aurangabad
• Bsc Computer – 2004 (60%) – DR.B.A.M.U Aurangabad
• HSC – 2001 – 2001 (55.17%) – Aurangabad Board
• SSC – 1999 (66%) – Aurangabad Board
Personal Details
Name : Mahendra M. Moharil
Birth date : 23/06/1984
Address : Sagar Society,Behind Vodafone,Wakadewadi,Pune - 411003
Mobile No : 982-***-****
Passport No : G1250080
Personal Email : *.*.********@*****.***
Contact this candidate