Oracle Management
Resume:
B/***, GC Centrum, Ahinsha Khand -*,Indirapuram, Ghaziabad, 201010
Email id:************@*****.***
Home: +91-991*******
Cell: +91-991*******
Neeraj Kumar Goyal
Profile
An Oracle Certified Professional and MBA (IT) with 12 years Experience in Database Administration, Designing and Implementation of Oracle Database.
Extensive experience in Oracle Database and Oracle Applications (E Business SUITE) which includes Installations, Patching, Cloning, Administration and Implementation of Oracle Applications (E Business Suite) activities on Unix as well as Windows NT system.\
ITIL V3 Foundation Certified.
Prince 2 certified professional.
Strong database administration skills and 24*7 support knowledge.
Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
4.5 month overseas exp in GE - Commercial finance (USA).
8 Month overseas exp. In GE - Capital (UK)
Skill Set
ERP: Oracle Application business suits 11i, R12
RDBMS: Oracle 8i, 9i, 10g and 11g.
Middleware: - 10g AS, web logic,
Tool: Toad, OEM, HP Omni Backup.
Languages: Oracle SQL, C, C++
O/S: Dos, Windows NT/2000, and Windows 95/98,
HP-UNIX (11.0) /Linux (red hat), AIX, SUN SOLARIS
Training:
Oracle certified professional DBA At oracle Authorized training center.
Oracle 10g OEM grid Administration from LVC
Oracle 10g AS server administration From LVC
Oracle 10g Web logic server Admin. From LVC
ITIL V3 foundation training.
Prince 2 certified Professional.
Education:
Bachelor’s in Science (BSc.) - 1999, Rajasthan University (JAIPUR), India,
PGDITM (MBA-IT) -2001, AIMA-CME, New Delhi, India
Professional Experience
May 09 – Till date Oracle Apps DBA, IBM India Pvt. Ltd, Noida, India
Project Name :- SAPA BLUE ( largest Manufacture of Aluminum product)
Duration :- 10-Aug-2009 to till date
I am working for SAPA BLUE Project, Denmark. My role and responsibilities are above.
Currently working on Baseline patching and Platform migration project (Linux to AIX).
I am leading 5 member team. 3 in offshore and 2 Onsite.
Work with Change management team.
Involve in internal and external audit (PMR, Security, corporate audit).
Work with GEO for New RFS.
Provide the solution on new requirement.
Costing and budgeting of the project.
Resource planning and management
Vendor management.
Work on project life cycle.
Meeting with customer and understand the requirement.
Oracle 11g Oracle OEM grid Administration.
Install OEM grid agent, Add new nod.
Work on middleware oracle 10gAS and Web logic server.
Admin task on Oracle 10g interconnect.
Install the adapters.
Involve with Change management team
Work with new RFS
Discussion on release Plan with Developer and DPE.
Prepare on-call schedule.
Meeting with Change management team and schedule change request.
Weekly meeting with Client and discuss on open issue,
Database creation & installation.
Resolving Basic Database Tuning Problems.
Rapid Cloning Oracle apps 11i.
Application 11i one node, two node installation.
Apply patch in Oracle application 11i.
Maintenance activity using ADADMIN utility.
Manage the Logical & Physical Structure
Maintain the Integrity & security of database.
Performance tuning for oracle database (explain plan. Trace enabled, query optimization, db parameter level changes).
To Manage Database Availability.
User right & Deactivation (DATABASE & APPLICATION LEVEL)
Patch installation ON ORACLE
Space management (OS & Database Level)
Cloning of production instance on Urgent basis.
Document the assessment for records.(Patches applied, TAR documents)
Applying patches related to Localization, performance and bugs, on Test and Production instances.
Carrying out performance tuning using RDA and statspack at the application and Database server level.
Database backup and recovery procedures, security implementation including routine maintenance activities.
Coordinating with Oracle Support for logging TAR and knowledge base search to find solution to the problems occurring while applying patches (tar, Bug search, User forum participation).
Configuration of Forms Servers (load balancing).
DBA support to the development team in customization and extension of core apps functionality (Integration of
Customized applications with standard Oracle Applications & Customized Application queries tuning.
Installation and configuration of Printer.
Database Administration of Production (with more than 500 conc. Sessions), Test, UAT and Dev Instances.
Routine System administration functions like creating users, creating responsibilities and menus.
Interacting with Functional consultants to schedule the concurrent request, changing the schedule of specific requests to reduce the load on the system at peak times.
Routine DBA tasks like analyzing tables and schemas.
Managing profiles as per the requirements.
Writing backup, automatic system startup and shutdown UNIX scripts.
Maintenance of All flavors of UNIX system.
Environment: Oracle 11.5.10.2, Oracle 10g, AIX, UNIX, Oracle OEM Grid,
Team Size : 5 to 6
Project Name: - DHL (logistics company)
Duration: - 1-Oct-2014 to 5-may-15
I was working for DHL India and Aus. as Team lead DBA. My role and responsibilities were above:-
Weekly meeting with Client and discuss on open issue,
Database creation & installation.
Resolving Basic Database Tuning Problems.
Rapid Cloning Oracle apps 11i & R12
Application 11i one node, two node installation.
Apply patch in Oracle application 11i & R12
Maintenance activity using ADADMIN utility.
Manage the Logical & Physical Structure
Maintain the Integrity & security of database.
Performance tuning for oracle database (explain plan. Trace enabled, query optimization, dB parameter level changes).
To Manage Database Availability.
User right & Deactivation (DATABASE & APPLICATION LEVEL)
Patch installation ON ORACLE
Space management (OS & Database Level)
Cloning of production instance on Urgent basis.
Document the assessment for records.(Patches applied, TAR documents)
Applying patches related to Localization, performance and bugs, on Test and Production instances.
Carrying out performance tuning using RDA and stats pack at the application and Database server level.
Database backup and recovery procedures, security implementation including routine maintenance activities.
Coordinating with Oracle Support for logging TAR and knowledge base search to find solution to the problems occurring while applying patches (tar, Bug search, User forum participation).
Configuration of Forms Servers (load balancing).
DBA support to the development team in customization and extension of core apps functionality (Integration of
Customized applications with standard Oracle Applications & Customized Application queries tuning.
Installation and configuration of Printer.
Database Administration of Production (with more than 500 conc. Sessions), Test, UAT and Dev. Instances.
Routine System administration functions like creating users, creating responsibilities and menus.
Interacting with Functional consultants to schedule the concurrent request, changing the schedule of specific requests to reduce the load on the system at peak times.
Routine DBA tasks like analyzing tables and schemas.
Managing profiles as per the requirements.
Writing backup, automatic system startup and shutdown UNIX scripts.
Maintenance of All flavors of UNIX system.
Environment: Oracle 11i and R12 OEBS, Oracle 11g, RAC, ASM, AIX
Team Size : 6
Nov 05 – May 09, Sr. Software Engineer Birlasoft Ltd. Noida, India
Project name:- GE COMFIN USA
Birlasoft is a software development company, having prestigious clients like GE-Commercial finance, MetLife, Xerox etc. My role is as follows:
Administrating Whole Database.
Database creation & installation.
Resolving Basic Database Tuning Problems.
Rapid Cloning Oracle apps 11i.
Application 11i one node, two node installation.
Apply patch in Oracle application 11i.
Maintenance activity using ADADMIN utility.
Manage the Logical & Physical Structure
Maintain the Integrity & security of database
To Manage Database Availability.
User right & Deactivation (DATABASE & APPLICATION LEVEL)
Patch installation ON ORACLE
Space management (OS & Database Level)
Cloning of production instance on Urgent basis.
Document the assessment for records.(Patches applied, TAR documents)
Applying patches related to Localization, performance and bugs, on Test and Production instances.
Carrying out performance tuning using RDA and statspack at the application and Database server level.
Database backup and recovery procedures, security implementation including routine maintenance activities.
Coordinating with Oracle Support for logging TAR and knowledge base search to find solution to the problems occurring while applying patches (tar, Bug search, User forum participation).
Configuration of Forms Servers (load balancing).
DBA support to the development team in customization and extension of core apps functionality (Integration of
Customized applications with standard Oracle Applications & Customized Application queries tuning.
Installation and configuration of Printer.
Database Administration of Production (with more than 500 conc. Sessions), Test, UAT and Dev Instances.
Routine System administration functions like creating users, creating responsibilities and menus.
Interacting with Functional consultants to schedule the concurrent request, changing the schedule of specific requests to reduce the load on the system at peak times.
Routine DBA tasks like analyzing tables and schemas.
Managing profiles as per the requirements.
Writing backup, automatic system startup and shutdown UNIX scripts.
Maintenance of All flavors of UNIX system.
Environment: Oracle 9i, 10g, 11i, Lunix, HP-unix, AIX, Sun-Solaris,
Team Size : 16 to 20
Achievements: I have received one time employee of the month award and three time team of the month Awards.
Aug 05 – Nov 05, DBA-Engineer Wipro InfoTech Ltd, Mumbai, India
Project name :- Pedilite corporate office, Mumbai (Manufacturing)
Wipro InfoTech is a software development and IT support Provider Company. I was working as DBA-Engineer. My client is Pidilite India, Mumbai. My role is as follows:
Administrating Whole Database.
Database creation & installation.
Resolving Basic Database Tuning Problems
Manage the Logical & Physical Structure
To Manage Database Storage Management
Database Backup & Recovery (logical & physical backup ).
Maintain the Integrity & security of database
To Manage Database Availability.
User right & Deactivation (DATABASE & APPLICATION LEVEL)
Patch installation ON ORACLE
Space management (OS & Database Level)
Environment: Oracle 8i,9i, Lunix, HP-Unix, AIX, Sun-Solaris, Windows.
Team Size : 2 to 4
Jan 05 – Aug 05, DBA Globaltech Noida, India
Global tech is a solution provider and outsourcing company .having prestigious clients like Airtel, Hutch. My role is as follows:
Administrating Whole Database
Database creation & installation.
Resolving Basic Database Tuning Problems
Manage the Logical & Physical Structure
To Manage Database Storage Management
Database Backup & Recovery (logical & physical backup )
Maintain the Integrity & security of database
To Manage Database Availability.
Database Migration Oracle 8.1.6 to 9.2.0.6.
User right & Deactivation (DATABASE & APPLICATION LEVEL)
Patch installation ON ORACLE
Space management (OS & Database Level),OS CLUSTRING
Environment: TOAD, HP-OMNI BACKUP, Oracle 8i, 9i, Lunix, HP-Unix, AIX, Sun-Solaris, Windows.
Team Size : 2 to 4
Achievements: YCMAD AWARD (2005) WINNER
Jan 02 – Dec 04, DBA ACCIL, Ahmadabad, India
ACCIL is 100% export oriented firm and manufacturing unit. I was working in EDP dept as Oracle DBA. I was also providing the support on Quality management system. My roles are above.
Administrating Whole Database
Resolving Basic Database Tuning Problems
Manage the Logical & Physical Structure
To Manage Database Storage Management
Database Backup & Recovery
Maintain the Integrity & security of database
To Manage Database Availability
Have good hands on database cloning.
Environment: TOAD, OEM, Oracle 8i, 9i, Lunix, Windows.
Team Size : 1 to 2
Contact this candidate