SUMMARY

• An Oracle Database Administrator with 8+ years of total IT experience in implementing Oracle’s different technologies including RAC Cluster/Dataguard/Golden gate.
• Complete command over handling Gigabyte size databases in several environments including Production, Test and Development Databases.
• Excellent team player with effective communication skill.
• Experience in Oracle 11g/10g/9i database installation & configuration, Data Guard Implementation, 10g EM Grid Control Implementation, administration and troubleshooting, Migration & Upgradation of Database.
• Handling over 1000+ databases.
• Experienced in complete range of Oracle DBA activities including day - to-day production database monitoring, Backup & Recovery using RMAN, Troubleshooting production issues.
• Good working experience with Oracle 11g/10g/9i on UNIX platforms supporting Production Database of size ranges from 50 GB to 10TB.
• Experienced in Linux/Solaris, UNIX Architecture and Shell Scripting.
• Installed, Configured and Administered Production databases for 24x7 availability for monitoring.
• Expert in running Automatic workload repository (AWR)to collect memory statistics and automatic database diagnostic monitor (ADDM) to monitors and analyzes statistics and provides advisory services and Data base performance tuning.
• Good at implementing Oracle Golden Gate replication 10g/11g.
• Extensive hands-on on Oracle Enterprise Manager on installation and troubleshooting.
• Good communication skills with ability to work independently as well as collaboratively in team environment to contribute problem-solving strategies. At ease in interacting with people at all levels, able to work under pressure.
• Excellent interpersonal and analytical skills.

TECHNICAL SKILLS

Operating Systems: Red Hat Linux, Solaris, AIX

Languages: SQL, PL/SQL, Shell Scripting

Databases: Oracle 11g/10g/9i

Tools: Grid Control, Enterprise Manager, TOAD, SQL-Developer, Export/Import, Data Pump,RMAN, Sql loader

Replication: Golden gate 10g/11gDataguard 10g/11gR1/11gR2

Monitoring Tools: Sitescope, Netcool

Ticketing Tool: CA-Service Desk

Domain: Mutual Fund, Payroll, Logistics

PROFESSIONAL EXPERIENCE

Confidential - Indianapolis, IN

Sr. Database Administrator

Responsibilities:

• Configured RMAN Level 0 and Level 1 backup through OEM.
• Troubleshooting and Monitoring RMAN backup jobs.
• Implemented Oracle Physical Standby DataGuard 11gR2 on 2 Node RAC Cluster.
• Monitoring/Troubleshooting Oracle Physical Standby DataGuard.
• Worked on 11gR1 agent installation.
• Installed Oracle Gateway 11gR1 to pull data from MSSQL server.
• Worked on RMAN database cloning for performance issues.
• ASM Storage addition.
• Monitoring alerts/troubleshooting database issues on regular basis.
• Interacting with Oracle for Technical Support.
• Interacting with EMC support for data domain issues.
• Managing tablespaces, users, privileges.

Environment: Linux, Oracle 10g/11g, Oracle 11g Enterprise Manager, RAC Cluster 10g/11g, Dataguard 11g, UNIX Shell Script, Data domain DDboost

Confidential, Roseland, NJ

Sr. Database Administrator

Responsibilities:

• Installed 11gR2 10 Node RAC Cluster on SuSE10/11.
• Implemented Oracle Physical Standby DataGuard (10gR2, 11gR1 and 11gR2) on 3 Node RAC Cluster.
• Proficient in handling storage addition on ASM devices.
• Worked extensively on 11gr1 agent installation, configuring ASM, applying templates and addition and removal of databases from OEM.
• Applying OMS PSU4 patch on all new agents installed.
• Level 0 and Level 1 backup configuration using RMAN.
• Cloning 5 node Prod database to another server (performance database) which does not have access to catalog server using RMAN’s disk backup and RMAN DUPLICATE command.
• Worked on different types of cloning including cold backup/hot backup and RMAN Cloning.
• Tablespace and Disk group monitoring and management, adding storage on ASM if required.
• Handling more than 1000+ OLTP databases (Production, UAT, Test, Dev)
• Was responsible for creating standalone and RAC database (2 or 3 nodes depending upon the requirement), registering database into clusterware and service configuration.
• Registering database, instances and services to OCR.
• Worked on addition of new node to existing database as per the requirement.
• Worked on numerous database upgrades from 9.x.x.x to 10.2.0.4.
• Was responsible to apply Rolling PSU patching twice a year.
• Verifying services at running on preferred node after applying the rolling patch and relocate the services if necessary.
• Worked with Oracle support for resolving Agent Timezone bug and forcefully ending blackouts.
• Written scripts for scheduling exp/expdp and hot backups.
• Used to take Cold Backup of database before database upgrading.
• Written shell scripts for scheduling RMAN Backup.
• Installing Golden gate using datapump and extracts
• Have good troubleshooting skills on Golden gate issues.
• Providing 24 X 7 Production support and monitoring.
• Proactively monitoring the databases using OEM and service desk alerts.
• Proficient in using ticketing tool (CA-Service Desk).
• Daily monitoring space utilization report and doing the remediation.
• Pro-actively monitoring FRA alerts.
• Raising SR and Interacting with Oracle for Technical Support.
• Exposure to monitoring tool (HP- Sitescope).
• Handling outage calls.
• Training junior DBA for general oracle administration and documentation of DBA activity for ramp up.
• Closely worked with application team in multiple deployments.

Environment: Linux/Solaris/AIX, Oracle 11g/10g/9i, Oracle 11g Enterprise Manager, Golden gate 10, 11, RAC Cluster 10g/11g, Dataguard 10g/11g, UNIX Shell Script, NAS/SAN/Data domain Storage Devices

Confidential, St. Petersberg, FL

Database Administrator

Responsibilities:

• Installation of 3 Node Oracle 10g RAC Cluster.
• Handling more than 200 databases (Production, UAT, Test, Dev) Confidential data center.
• Worked on Database creation and RMAN backup configuration setup.
• Worked on database upgrades 9.2.0.4 to 10.2.0.4.
• Implemented Oracle Physical standby Data Guard 10gR2.
• Responsible for doing the backup remediation of failed backups including exp/expdp/hot backup and RMAN backups.
• Applying One-Off Patch Installation.
• Migration of database using DBUA, Export/Import, Data pump & using scripts.
• Database Upgradation using patches (Manual Upgradation).
• Purging of Oracle trace files & trims alert log, listener log files on regular basis.
• Used to take Cold Backup of database before upgrading.
• Written UNIX shell scripts for scheduling RMAN Backup.
• Worked on agent installation and configuration.
• Troubleshooting and fixing OEM alerts.
• Worked on different types of database cloning and refreshes.
• Interacting with Oracle for Technical Support.
• Team Management/Client Co-ordination/Leading all conference call.
• Preparation of minutes of meetings, Monthly/Weekly/Daily status report, Resource utilization report/walkup tracker sheet etc.

Environment: Linux/Solaris/AIX, Oracle 11g/10g/9i, Oracle 10g Enterprise Manager, RAC Cluster 10g, Dataguard 10g.

Confidential - Rotterdam,NL

Database Administrator

Responsibilities:

• Installation & Configuration of oracle database 9i/10g using GUI and silent mode.
• Administration of all database objects, including tables, indexes, views, sequences, packages and procedures.
• User management issues involving control user access to resource and information by allocating the right privileges.
• Managed Space issues involving resizing table spaces, data files.
• Hands on experience with Backups & Recovery using Disk and tape backups.
• Database upgrade from 9i to 10.2.0.4.
• Applying One-Off Patch Installation.
• Database refresh from production to test/UAT/staging environment.
• Hot backup cloning from production to UAT.
• Generating AWR/ADDM reports.
• Migration of database from one server to another using Export/Import, Data pump.
• Raising SR and following up with Oracle for Technical Support.

Environment: - Linux, Oracle 10g/9i & 10g EM Grid control, datapump

Confidential - Rotterdam, NL

Database Administrator

Responsibilities:

• Installing oracle database 9i/10g using GUI and silent mode.
• Monitoring backups and remediating the failed backups.
• Monitoring Tablespace resizing as per standards.
• RMAN Implementation with or without recovery catalog.
• DB Cloning and Refresh.
• Scheduling logical backups.
• Generating AWR/ADDM reports.
• Compiling Invalid objects using utlrp.
• Creating Database Links, writing pl/sql stored procedure, triggers.
• Purging of Oracle trace files alert, listener log files on regular basis.
• Applied CPU patches.
• Worked on corrupted central inventory by recreating it.

Environment: - Linux, Oracle 10g/9i, Toad