Email: ravijain1234@gmail.com
- About 3 plus years of experience as an Oracle
APPS DBA with experience in administrating and troubleshooting Oracle
Apps Instances in single & multi node environments.
- Applied numerous patches for oracle applications
using Ad-patch utility
- Day to day
support of general DBA activities like Patching, Cloning, Refreshing,
monitoring
- Extensive experience
in usage of AD Utilities like Adpatch,
Adadmin,Adctrl,Admrgpch, Adautocfg.
- Applying database
patches with Opatch utility.
- Installation,
Patching, Cloning, Concurrent Manager, Maintenance Pack Application and
handling day-to-day APPS DBA tasks.
- Extensive Oracle
DBA (11. x) experience in administrating, architecting and troubleshooting
single instance Databases in Production, Support and Development
environments.
- RDBMS Installation,
Backup and Recovery, Cloning.
- Automation of jobs
using crontab.
- Remotely worked
through third party S/W‘s like Putty, VNC
- Utilized DBA skills
for maintenance and administration of databases.
- Supporting 2 terabytes
of Databases.
- Providing 24/7 support to around 40000 users
- Supporting more
than 20 Oracle Application
Instances.
- Backup and
Recovery. Using RMAN to back up the database and for recovery purpose.
TECHNICAL
SKILLS
Operating System
|
:
|
Linux,Rhel, and
Windows NT/2000/XP
|
Database Servers
|
:
|
Oracle 10g/11g.
|
Languages
|
:
|
C#,SqlPlus
|
TOOLS
|
:
|
Oracle Enterprise
Manager, Import/Export, RMAN, Putty, VNC Server.
|
ERP
|
:
|
Oracle E-business
suite apps R12
|
· Oracle Database 11g: Administration I
· Oracle Database 11g: SQL Fundamentals
- Applying patches for enhancement and fixing bugs using adpatch
- Performed
Application admin tasks using ADADMIN utility
- Monitored
concurrent manager and its concurrent process
- Resolved the view log/out files issues of concurrent
requests.
- Resolved the concurrent manager’s
startup issues.
- Resolved the apache start up issues.
- Changing Apps
password using FNDCPASS utility.
- Monitoring
concurrent jobs for Oracle E-Business Suite
- Managed
system configuration using autoconfig.
- Routine
backups and restored when necessary. Testing the backup and restoration
plans
- Database
availability is 24X7. Database mode is ARCHIVELOG. Backup is HOT (online)
using utility tar and Cold (Off-line) in weekends. Recovery of Databases
including Incomplete & Complete Recovery. Recovery of Control files/
Data files/ Redo logs files.
- Regular meetings and interactions with
multiple client managers, project managers, system administrators and
approve DBA change requests on behalf of the DBA team.
- Daily activities include customization and
automation of regular DBA activities .
- Troubleshoot performance issues that might
have come up with data growth.
- Applying Patches and Cloning and
troubleshooting the same.
- Database
storage like managing the size and files of the database. Creation of
Tablespaces and Rollback Segments and Space Management Security Policies
like Managing Users and Profiles.
- Monitored
the Applications and database using OEM and OAM
0 comments:
Post a Comment