Professional Summary:

• Over 9 years of Oracle Database administration experience in Oracle 8i,9i, 10g 11g.
• Oracle certified Professional OCP DBA.
• Implemented an efficient IT infrastructure including Budget Planning, Project management and implementation of LAN, data centers, ERP, enterprise email solutions and backup and recovery systems.
• Experience in Installation of Oracle Real Application Cluster RAC with ASM and manage RAC instances using CRSCTL and SRVCTL Utility.
• Experience in Installation, Configuration and Monitoring of Oracle Server on Linuxand Windows Environments.
• Analyzing database performance and tuning database on Oracle using Real Application Testing RAT
• Experience with database monitoring tools such as AWR, ASH, OEM.
• Experience in Implementing BACKUP and RECOVERY strategies using RMAN.
• Installation and configuration of Recovery Catalog for multiple Databases.
• Experience in taking logical backup of the database using DATAPUMP Expdp/Impdp .
• Experience in applying Oracle Patching and upgrades.
• Experience in SQL tuning using Explain Plans, Hints and developing ad-hoc queries.
• Experience in Configuring Oracle Golden Gate for replications.
• Experience in performing database related activities using Oracle Enterprise Manager Grid.
• Expertise in Database and Application performance tuning.
• Expertise in SQL, PL/SQL programming and debugging and performing batch script on windows and Linux environment.
• Expertise in diagnostic, analytical and problem solving skills.
• Created and maintained Packages, Store procedures and Functions.
• Expertise in doing various Oracle Database Administration tasks like new software installation, database setup, database upgrade, database patching, database cloning, performance tuning etc.
• Granted and Revoked user privileges and roles as per requirement and killed blocking session and performed database refresh for test, development Production environment using RMAN cloning and Exports and imports.
• Have hands on experience in creating physical standby databases, and involved in converting physical to snapshot standby, and also Active Data-guard.

TECHNICAL SKILLS:

Databases : Oracle 11gR2, 10g, 9i, 8i

Oracle Products : Oracle10g Grid Control , OEM Oracle EnterpriseManager , RMAN,Import and Export EXPdp/IMPdp , ASM, TKPROF, SRVCTL,SQL Loader.

Operating System : WIN NT/2003/2008, Linux

Languages :SQL, PL/SQL, UNIX Shell Scripting.

Other Tools/ERP : Putty, SQL Developer, ERP Baan SAP , D2K, SQL-PL SQL, LotusDomino, MS-office, LAN, VPN, SAN, Tableau desktop, Data analysis, Data visualization and data cleansing.

PROFESSIONAL EXPERIENCE:

Confidential

Role: Oracle DBA Developer

Responsibilities:

• Supporting 24X7 most critical production databases and environments towards achieving high availability and performance.
• Performed database migration/upgrade from 10g to 11gR2.
• Performed troubleshooting for configuration related problems in Oracle RAC environment for Oracle Clusterware, ASM, and RAC.
• Configured and Maintained Data Guard and Active Data Guard.
• Provided support in Installation and configuration of Oracle Golden Gate.
• Devised and implemented strategies for database backups and recovery using RMAN.
• Installed and configured OEM Grid Control.
• Performed SQL tuning using Explain Plans, Hints and developing ad-hoc queries.
• Developed shell scripts for Oracle DB, Session, Process, Deadlock, File system monitoring, free space in the table spaces, Free Space in ASM Disk groups and free disk space in Archive log destination for production databases. Shell Script creation to automate the data loading process.
• Installation and Configuration of Oracle ASM Automatic Storage Manager on Oracle 11gR2.
• Involved in configuration of parameter files for extract process in primary and replica process in standby using Golden Gate.
• Created databases in RAC environment using DBCA and involved in moving databases from NON ASM to ASM environment.
• Reviewed debug existing batch scripts, PL/SQL programming, functions procedures.
• Developed Oracle stored procedures, packages, functions, and triggers in support of new applications being deployed.
• Worked on Data modeling Using Oracle SQL Developer Data Modeler
• Monitored database performance, generating explain plan and using them for performance tuning.
• Implemented Disaster Recovery DR using RAC and Data Guard.
• Configured parameters for the Bi-directional replication using Golden-Gate.
• Extensively implemented and used 11gR2 Data-guard new features.
• Implemented Disaster recovery for production databases using Data guard.
• Have hands on experience in creating physical standby databases, and involved in converting physical to snapshot standby, and also Active Data-guard.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster RAC Databases.

Environment: Oracle 11gR2/11g/10g, Unix, SQL, PL/SQL, OEM,RMAN, RAC, DATA GUARD

Confidential

Role: As Oracle DBA

Responsibilities:

• Create and evaluate migration methods for different data sets to Oracle 11g.
• Worked on characterset conversions with application teams to plan successful migration.
• Performed project management, budget planning, implementation and financial tracking controls and project reporting to stakeholders
• Used SQL Loader to migrate Data from non Oracle data sources.
• Performed capacity planning and Installation and configuration of Oracle Databases in line with business needs.
• Carrying out export and import operations on Oracle Database.
• Engagedin requirements definition, data modelling and logical/physical design
• Applied and upgraded Oracle servers with Oracle patches.
• Installed, and configured Oracle 11g Oracle Enterprise manager Grid Control
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases.
• Developed Oracle procedures, functions, and triggers in support of applications.
• Refreshed databases using RMAN backups.
• Utilized automated workload repository reports for Database and Application tuning.
• Performance tuning various applications after migration.
• Scheduling and configuring database backups.

Environment: Linux, 11g, RAC, Data Guard, RMAN, OEM, SAN.

Confidential

Role: As an Oracle DBA

Responsibilities:

• Performed DBA functions such as database creation, tuning/reorganization, backup/recovery,user and security management, auditing, general troubleshooting, and configuring servers.
• Configured the physical logicalstructures of the database such as creation of database, table spaces, tables, indexes, listeners, settings up privileges and user logins for production/development/test databases and Involved in gathering requirements from end users.
• Wrote database Functions, Procedures, Triggers for maintaining data consistency.
• Designed and implemented backup and recovery strategies. Performed Logical backups using full/ partial export/import and Data Pump. Effectively used RMAN for backup and recovery with/without catalog.
• Monitoring the Oracle Instances, Users, Tables, Tablespaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.
• Upgraded the Oracle 9i database to 10g version and also applied patch set and interim patches whenever required to make the database software up to date.
• Generating explain plan and using them for performance tuning.
• Monitored space utilization and growth, tablespace usage and extents allocation and planning of disc storage, modifying database structure
• Supported backup and recovery of databases. Configure RMAN backup of databases and archive logs.
• Supporting Oracle databases with experience including requirements definition, data modelling and logical/physical design
• Moved databases from one RMAN catalog to new RMAN Catalogs.
• Restored old RMAN backups on new server for customer to recover old data.
• Involved in SQL tuning by generating explain plan, ADDM, AWR and TKPROF.
• Configured RMAN retention policy, archive log deletion policy for Production databases.
• Maintained catalog server and registered databases in catalog server. .

Environment:Oracle 8i/9i 10g, Import/Export, Windows 2000/2003

Confidential

Role: As Oracle Application Developer

Responsibilities:

• Developed an in house using developer 2000 Form 6i Reports 6i for managing business transactions.
• Designed Forms, Menus, Reports queries.
• Performed DBA functions such as database creation, tuning/reorganization, backup/recovery,user and security management, auditing, general troubleshooting, and configuring servers.
• Migrated Data from FoxPro to Oracle database and performed functions such as database imports/exports, data conversion data loading, master data creation.
• Provided End user Training and support in performing their day to day functions using Oracle application.
• Wrote database Functions, Procedures, Triggers for maintaining data consistency.
• Creation of Users and granting them the required Roles and Privileges.

Environment:Oracle 8/8i, SQL, PL/SQL, SQL plus, Forms 6i Reports 6i, Import/Export, Windows NT/2000