SUMMARY:

• IT professional with 9 years of Oracle DBA experience which includes designing, developing, deploying, administration, managing, and tuning Databases (11g, 10g, 9i) on various Platforms
• Experience in Installation, Configuration and Maintenance of Oracle 11gR2/10g RAC with ASM and single instance database.
• Experience in configuration and administration of Golden Gate.
• Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods
• Experience in taking Hot Backup and Cold Backup as well as logical backup by using oracle utility exp/imp and Data Pump
• Used Oracle backup utility RMAN to implement Oracle backup and disaster recovery, Experience in advanced recovery methods like PITR and TSPITR
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration
• Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring the performance of the database
• Having experience in performance tuning issues using AWR and ADDM Reports
• Experience in managing security through grants, roles, privileges and profiles
• Excellent problem solving skills, Quick learner, dynamic team player with experience of managing projects and teams
• Expert Skills in time management, prioritizing tasks
• Excellent communication skills coupled with very positive user interaction & team spirit

TECHNICAL SKILLS:

Database: Oracle 11g/10g/9i/8i, RAC 11g/10g

Operating System: Linux, HP - UX 11/11i, Sun Solaris, AIX and Windows NT/2000/2003

Languages: SQL, PL/SQL, C++, C, UNIX Shell Scripting

Tools/Utilities: SQL*Loader, DataPump (Export/Import), OEM, RAC, RMAN, TOAD, AWR, ADDM, STATSPACK, TKPROF

PROFESSIONAL EXPERIENCE:

Confidential (NJ)

Programmer Analyst (Oracle DBA)

Responsibilities:

• Installed and administered Oracle Real Application clusters (RAC 11gR2) on a 2 node Linux cluster.
• Configuration and administration of Golden Gate.
• Creation of Objects as per Data warehouse Standards.
• Planning, Monitoring and Tuning of initial load and daily process for Data warehouse.
• Involved in partition of tables and creation of Materialized views in Data warehouse system.
• Involved in designing and implementing Oracle backup and recovery methods and disaster recovery methods using RMAN.
• Successfully Implemented key RMAN 11g features such as block change tracking, use of flashback recovery area and taking incrementally updated backup to meet backup and recovery goals
• Writing shell scripts for daily database activities.
• Communicate and coordinate with Oracle Support for major database issues/ problems; apply the required patches, test (unit test/ system test) and roll out and implement the patches into production
• Managing multiple aspects of database analysis and database administration
• Maintaining sound backup and recovery policies and procedures (RMAN)
• Daily review Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) report for proactive performance tuning & monitoring.

Environment: Oracle 11gR2, RHEL 4, Golden Gate, RMAN, OEM.

Lead Oracle DBA

Responsibilities:

• Installed and administered Oracle Real Application clusters (RAC 10g) on a 4 node Linux cluster using Oracle Cluster File System (O.C.F.S) and Automatic Storage Management (ASM).
• Adhered to Optimal Flexible Architecture during Oracle installation and database creation.(Oracle 10g & 11g)
• Involved in designing and implementing Oracle backup and recovery methods and disaster recovery methods using RMAN
• Successfully Implemented key RMAN 10g features such as block change tracking, use of flashback recovery area and taking incrementally updated backup to meet backup and recovery goals
• Performed Block Media Recovery and Previous Incarnation Recovery
• Tuning of RMAN to improve backup performance
• Writing shell scripts for daily database activities.
• Actively involved in upgrading the Oracle Database from 9.2.0.8 to Oracle 10.2.0.3. Manually.
• Enhanced end users' understanding of database systems by delivering group and individual sessions.
• Communicate and coordinate with Oracle Support for major database issues/ problems; apply the required patches, test (unit test/ system test) and roll out and implement the patches into production
• Managing multiple aspects of database analysis and database administration
• Maintaining sound backup and recovery policies and procedures (RMAN)
• Maintaining Physical Standby Database using Data Guard
• Daily review Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) report for proactive performance tuning & monitoring

Environment: Oracle 11g/10g/9i/8i, HP-Unix 11i v3, Solaris 10,RHEL 4, AIX 5.2, RMAN, OEM.

Confidential

Senior Oracle DBA

Responsibilities:

• Installed and Administered Cluster Ready Services (CRS) and the Oracle Database 10gwith Real Application Clusters (RAC) on a 2 node Linux cluster using Oracle Cluster File System (O.C.F.S) and Automatic Storage Management (A.S.M).
• Setup of High Availability of the database using RAC, Standby, Dataguard
• Designed and implemented backup and Disaster recovery strategies with RMAN.
• Used EXPORT/IMPORT to do table level and full database defragmentation.
• Involved in Oracle partitioned tables and applied patches as per the requirements of the client and upgraded the Oracle and DBMS software.
• Upgraded the database from Existing Oracle 9i to Oracle 10g.Tune the application queries and identify the resource, database and design issues. Modify and implement new changes without affecting the functionality of applications and end-users for reporting server.
• Involved in the Migration of database from 9.2.0.6 to 10.2.0.3.
• Database administration activities including Tablespaces allocation, user enrollments and database re-organization.
• Extensively worked on identifying high load sql statements and troubleshooting to find underlying causes and took appropriate actions to improve performance.
• Ensuring that adequate recovery procedures are in place, based on: Database backups being done and verified.

Environment: Oracle 11g/10g/9i, HP-Unix 11i v3, Solaris 10, AIX 5.2, RMAN, OEM

Confidential

Senior Consultant

Responsibilities:

• Migrating Oracle 9i databases to 10g.
• Installation and configuration of Oracle Database Software 10g.
• Production support for oracle database.
• Performing physical and logical Backup and Deciding Backup Strategy.
• Growth Planning for database and file system.
• Cloning of Database for application development.
• Modifying the database structure, as necessary to support activities of application developers. Handling production databases Terabytes in size for Telecom Domain.
• Configuration of Datagaurd and Administration.
• Extensively used Materialized View for Replication between database servers.
• Responsible for project planning, conducting requirement analysis, development and maintenance of the application.
• Involved in Issue resolution, User communication and interactions and regular support activities.
• Responsible for Quality assurance of the project, Metrics collection and analysis, estimation of new requirements and allocation of resources.
• Installing and troubleshooting Red Hat Enterprise Linux 5.0 for Oracle 9i and 10g.

Environment: Oracle 10g/9i, HP-UX 11i v3. IBM AIX, Sun Solaris. Windows server 2000

Confidential

Junior Oracle DBA

Responsibilities:

• Installed Oracle 9i, database creation, and user management
• Responsible for trouble shooting backend production problems.
• Created logical and physical system designs.
• Implemented physical design and created DDL scripts for database creation.
• Developed different database schemas and objects like tables, views, etc.
• Troubleshooting errors in different databases.
• Installed Oracle 9i, database creation, and user management
• Responsible for unit testing, and documentation of the interfaces.
• Responsible for trouble shooting backend production problems.
• Created logical and physical system designs.
• Implemented physical design and created DDL scripts for database creation.
• Developed different database schemas and objects like tables, views, etc.
• Providing in technologies like C, C++, Oracle SQL, PLSQL and database administration.

Environment: Oracle 8i, Windows 95 clients, Sun Solaris, PL/SQL, SQL*Loader