Oracle Manager
Resume:
RAJASHREE PATTANAYAK
**********.*************@*****.***
Objective:
To work in a challenging environment in an atmosphere of motivation and team spirit,
to perform to the best of my abilities in excelling in the tasks entrusted to me to the
satisfaction of one and all.
Experience Summary:
• Having 3+ years of extensive experience as Oracle Apps DBA .
• Experience in Installation and Configuration of Oracle Application Server(Oracle 8i/9i AS/ 10g).
• Sound knowledge in Backup and recovery using RMAN.
• Having experience of creating tablespace, resizing tablespace, creating users. Maintain user security, assist programmers and developers with oracle problems.
• Extensive experience in maintenance, development, Export/Import, Backup and Recovery
• Having good knowledge of SYSadmin tasks like creating user, assigning responsibilities, concurrent programs.
• Having good knowledge in monitoring and trouble shooting of Apache, Forms, Concurrent manager, servers, Networking and database related issues.
• Troubleshooting several user issues like application login issues, Yellowbar issues, and concurrent manager view log/output file issue.
• Extensive work on FNDCPASS, start / shutdown the application and database services and compiling invalids.
• Having good experience in Installation, Upgradation, patching and cloning of oracle database & applications.
• Familiar with AD Utilities : adadmin, adpatch, admrgpch, adctrl, adautocfg etc.
• A team player with good communication, team leadership, organizational and relationship management skills.
Education:
B.Tech in Computer Science & Engineering –ORISSA
Technical Skill
Platforms : RHEL AS 3 / 4, SUN SOLARIS 5.9/10, windows server 2000/05
Database : Oracle 9i & 10g
Technical Knowledge : Operating System, Database, Oracle ERP, SQL server
ERP : Oracle Applications 11i ( 11.5.10.2)
Tools : Putty,Toad
Utilities : AD utilities (AD patch, Adadmin, Adctrl), OAM, Export/Import, SQL * Loader
Employee Details:
• Working with Genpact India Pvt Ltd from dec 2008 till date
Project 1: configuration & Implementation
Company : Genpact India Pvt Ltd
Role : Oracle DBA & Oracle APPS DBA
Environment : Database Version- Oracle 9i&10g
Application Version - 11i
Operating System- RHEL AS 3/4/5
Responsibilities (As Oracle DBA & APPS DBA):
• Providing DBA support to ensure 24*7 DBA support.
• Database creation, monitoring setup in new servers and backup scheduling
• Resetting the user’s passwords.
• Managing roles, security and privileges for users
• Monitoring and fixing the alerts permanently
• Installation of Database 10g(10.2.0.1) on Linux platform
• Installation of Oracle application 11i(11.5.10.2) and 9i (9.2.0.1)on Linux platform.
• Cloning of Oracle Application Database (Rapid and Manual Cloning).
• Setup Physical Standby Database Using Data Guard, Data Guard Broker
• Setup RMAN Catalog
Project 2: Up gradation Of Database & EBS
• Upgradation of Database 10g(10.2.0.1 to 10.2.0.4)
• Upgradation of Dev6i(forms,reports,graphics)
• Upgradation of JRE(jinitiator)
Project 3:Production Support
• Providing DBA support to ensure 24*7 DBA support.
• Database creation, monitoring setup in new servers and backup scheduling
• Upgradation of Oracle Database from 10.2.0.1 to 10.2.0.4.
• Database cloning using hot, cold and rman backup
• Database patching
• Resetting the user’s passwords.
• Managing roles, security and privileges for users
• Backup and recovery using hot, cold and rman backup
• Database refreshes using export/import and expdp/impdp
• Managing tablespaces, datafiles, redo logs, tables and other database objects
• Activation of Archive Log Mode & conversion of Database in Archive Log / No Archive Log Modes
• Monitoring and fixing the alerts permanently
• Coordinated with customer and different teams(server team, network team, backup team) to resolve the issues(database failover, outages, backup issues)
• Provided On-call support to the entire Oracle environment in resolving production database issues over bridge calls
• Communication with Oracle On-demand by raising SRs, for certain database related activities those were supported by Oracle.
• Installation of Oracle application 11i and 9i on Linux platform.
• Patching using ADPATCH and OPTACH
• Cloning of Oracle Application Database (Rapid and Manual Cloning).
• Application and database User ,concurrent
• Evaluating, monitoring and managing the clients database
• Extensively worked on Oracle Applications AD utilities like adpatch, adadmin, adctrl
Admrgpch, adident,adspice,adlicmgr,adclone, adautocfg
• Applying patches and performing pre-patch analysis and troubleshoot several workers issues and used defaults file to reduce patch timelines
• Resolved the view log/out files issues of concurrent request.
• Application user creation and assigning responsibilities.
• Analyzing and managing oracle issues using Metalink with Oracle Corporation
• Troubleshoot several user issues like apps login issues and other connectivity issues.
• Interacting with oracle support to resolve application issues.
• Prepared backup status report for all the production databases consist of daily status & type of backups.
• Database refreshes using cold, hot, RMAN backups.
• Scheduling old archive cleanup & backup scripts in server.
• Monitoring table space size, resizing space, alert log, trace files.
• Alarm handling like mount point space, table space alert, alert log etc via alarm portal & then troubleshooting.
• Follow-up with backup team for backup failures & troubleshooting.
• Setup a new database in new server.
• Creating users, granting privileges.
• Worked in replication databases.
• Troubleshooting listener issues, failover issues, user issues.
• Moving of files in OS
• 11i refresh to DEV & UAT
• Done printer setup for check printing.
• Scheduled different concurrent requests for better performance.
• Workflow bounce through OAM.
• Form compilation
• Report compilation
• INVALID objects compilation
• .Ldt file execution
• Troubleshooting Apache errors.
• Scheduling the full backup and transaction log backup jobs in SQL server.
Strengths:-
• Skilled in ORACLE DBA, ORACLE ERP, UNIX (Linux utilities and process).
• Knowledge in UNIX File Management System and Memory Management.
• A fast learner with a positive attitude and flair for innovative ideas.
• Versatile Team player with Good Communication and problem solving skills.
Personal Details:
Name : Rajashree Pattanayak
Gender : Female
Marital Status : Single
Nationality : Indian
Languages Known : English, Hindi,Oriya
Passport : Available
Alternative Mail Id : **********.*************@*****.***
Place: Bangalore
(Rajashree Pattanayak)
Contact this candidate