Summary:

• About 10 years of experience as ORACLE Infrastructure DBA with 12c,11g,10g, 9i, 8i on Unix environment - Red Hat Linux, Zlinux, SUSE Linux, HP-UNIX, Sun Solaris, AIX, and Windows 2000/NT.
• Managed complete life cycle of projects on database infrastructure. Gather requirement, design, installation, documentations, monitoring, backup and recovery.
• Experienced to design enhancements of database infrastructure architecture to support business growth.
• Experienced with Planning, Design, Implementation, and support of large Oracle database environments.
• Installed and configured multi node server side load balancing RAC Real Application Clusters databases on Solaris, AIX, HP UNIX and Linux on ASM,NETAPPS and EMC storage.
• Extensive knowledge on Migration/upgrade database on Cross version and cross platform
• Experience in installation, upgrades, patches other duties included database creation, backup/recovery, tuning/reorganization, cloning, user and security management, general troubleshooting, auditing, and configuring servers.
• Experienced with full conversion process from single instance to Real Application Cluster RAC database instances.
• Extensive knowledge on setting up Backup and Recovery strategies using RMAN, EMC Replication Manager, NETAPPS SMO GUI, export/import and Data Pump.
• Configured and implemented Oracle Golden gate, Oracle Streams Advanced Replication , Shareplex replication for high availability.
• Implemented disaster recovery physical standby database using Data Guard broker.
• Experienced with database switchover and flashback.
• Experience in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.
• Experience in SQL query optimization using explains plans, TKPROF reports, and gathering statistics.
• Troubleshoot Database performance issues using Automated Workload Repository AWR , Automatic Database Diagnostics Monitor ADDM and Active Session History ASH .
• Experience with Data modelling, reverse engineering data model, repository creation.
• Provided support to application team to solve all database related issues. Excellent troubleshooting techniques.
• Partitioned appropriate tables to optimize performance and simplified maintenance work.
• Knowledge on Oracle Internet Directory OID for EMP.
• Experience with Oracle Business Intelligence Enterprise Edition OBIEE.
• Supported system 24x7. Ability to work beyond regular hours. Carried primary and secondary support roles with pager rotation to support during weekends, Holidays and beyond regular hours.
• Experienced with oracle advanced Security and Oracle Internet Directory OID .
• Experience in maintaining and monitoring databases By Oracle Enterprise Manager OEM 11g, 12c.
• Experience with OEM agent, GRID control Installation and configuration.
• Managed and design data warehouse ETL process on business requirement.
• Experience with FTP, SFTP, PSFTP, SCP files on cross platform.

Technical Skills:

Professional Experience:

Confidential

Sr Oracle DBA

Roles and Responsibilities:

• Managed complete life cycle of so many projects on database infrastructure. Gather requirement, design, installation, documentations, monitoring, backup and recovery.
• Experienced with Planning, Design, Implementation, and support of large Oracle database environments.
• Installed and configured 2, 4 and 6 nodes Oracle RAC on 11g,12c databases on oracle Linux, Solaris On ASM, NETAPPS,EMC storage.
• Supported database platform are AIX, Red hat Linux,Oracle Linux, Solaris, Suse, window.
• Creation and configuration of Oracle database of various sizes in Dev, ITG, Model and Production environments. Include very large databases VLDB .
• Upgraded databases from 9i to 10g, 10g to 11g, 11g to 12 c version.
• Worked on Backup,restore and Recovery using RMAN, Replication Manager and SMO GUI.
• Configured and implemented Golden Gate replication.
• Created disaster recovery standby database with data guard broker.
• Involved in performance monitoring and tuning of the database using OEM,AWR,ADDM,ASH reports.
• Worked on Oracle database' s Auditing and security.
• Monitor and Configured Oracle 9i, 10g and 11g databases using OEM 11g, 12c. Used Other monitoring tool like
• Lab 128, Hp Open view. Fog light.
• Worked with oracle objects like tables, Functions, Procedure, triggers, synonyms, views, sequences and profiles.
• Created and Managed user, tablespaces, datafiles and archive log.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Gather requirement and design Data model include physical and logical model using embarcadero.
• Reverse engineering to create data model from DDL and database using toad data modeler.
• Worked on Oracle Internet Directory OID for EMP.
• Experienced with Oracle Business Intelligence Enterprise Edition OBIEE
• Experienced in Loading flat different types of files data into tables using Oracle SQL Loader Utility.
• Experienced on creation, rebuild Indexes and moved it across different tablespaces.
• Worked on Database refresh request using production database backup.
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
• Experienced with Data pump, Export/Import, Transported tablespaces data exports from production and staging databases.
• Applied CPU patches as released on PROD and NON-PROD databases.
• Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by
• Database growth, performance generated from snapshots taken at the peak business hours.
• Managed and design data warehouse ETL process on business requirement.
• Experienced with Shell scripting.
• 24x7 production level 3 support by ON CALL rotation.

Environment: Oracle 12c,11GR1/2, 10G, 9i,Oracle linux, AIX,Solaris, RHEL, Golden Gate, Data guard, SMO Gui, Replication manager, RMAN, SQL, PL-SQL, OEM grid control.

Confidential

Sr Oracle DBA 2011

Roles and Responsibilities:

• Installed and configured 2, 4 and 6 nodes Oracle RAC on 11g databases on Solaris with ASM and Data Guard.
• Supported database platform are AIX, Linux, Solaris.
• Creation and configuration of Oracle database of various sizes in Dev, ITG, Model and Production environments.
• Upgraded databases from 10g to 11g versions.
• Lead troubleshooting and remediation activities for a poorly performing and undersized database server.
• Involved in performance monitoring and tuning of the database by fine tuning the database implementation.
• Identified process to capture and report on infrastructure performance data when standardized tools did not meet project needs
• Worked on Backup and Recovery using RMAN.
• Worked on Auditing and security with Oracle databases.
• Created standby database and worked with data guard to provide high availability.
• Monitor and Configured Oracle 9i, 10g and 11g databases using OEM.
• Worked with Functions, Procedure, triggers, synonyms, views, sequences and profiles.
• Created and Managed user, tablespaces, datafiles and archive log.
• Created and assigned Roles. Grant and revoked Privileged
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Developed the PL/SQL codes on the basis of the requests for the change.
• Configured and Monitored Shareplex replication for high availability.
• Experienced in Loading flat different types of files data into tables using Oracle SQL Loader Utility.
• Experienced on creation, rebuild Indexes and moved it across different tablespaces.
• Worked on Database refresh using production database backup.
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
• Experienced with Data pump, Export/Import, Transported tablespaces data exports from production and staging databases.
• Applied CPU patches as released on PROD and NON-PROD databases.
• Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.
• Experienced with Shell scripting.
• 24x7 production level 3 support by ON CALL rotation.

Environment: Oracle 11GR2, 10G, 9i, Solaris, AIX, RHEL, RMAN, SQL, PL-SQL, OEM grid control,

Confidential

Sr Oracle Database Administrator 2010-2011

Roles and Responsibilities:

• Installed and configured 2, 4 and 6 nodes Oracle RAC on 10g, 11g databases on Solaris, Aix, Hp-Unix, Linux with ASM and Data Guard.
• Experienced in Upgrade databases from 9i, 10g to 11g versions.
• Monitor and Configured Oracle 10g databases using OEM.
• Worked with Functions, Procedure, triggers, synonyms, views, sequences and profiles.
• Gather requirement and design Data model include physical and logical model using Erwin.
• Reverse engineering to create data model from DDL and database.
• Created and Managed user, tablespaces, datafiles and archive log.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Developed the PL/SQL codes on the basis of the requests for the change.
• Worked on Backup and Recovery using RMAN.
• Worked on oracle Public and Private Database Link.
• Experienced in Loading flat different types of files data into tables using Oracle SQL Loader Utility.
• Experienced for Delete bad data from the Tables and maintain Data Integrity
• Experienced on creation, rebuild Indexes and moved it across different tablespaces.
• Worked on Development and Testing Environment Database refresh using production database backup.
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
• Experienced with Data pump, Export/Import, Transported tablespaces data exports from production and staging databases.
• Applied CPU patches as released on PROD and NON-PROD databases.
• Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.
• Managed and design data warehouse ETL process on business requirement.
• Experienced with all standard request tools.
• Experienced with UNIX Shell scripting.
• Involved in installing repository and Portal databases.
• Troubleshoot Database performance issues using Automated Workload Repository AWR and Automatic Database Diagnostics Monitor ADDM .
• Worked on standard production release implementation. Worked after hours.

Environment: Oracle 11G, 10G, 9i, Solaris, AIX, HP-UNIX, RHEL, RMAN, SQL, TOAD, GRID control, PL-SQL.

Confidential

Sr Oracle Database Administrator 2010

Roles and responsibilities

• Installed and configured 4 nodes Oracle RAC on 11g databases on Linux with ASM and Data Guard.
• Supported database platform are AIX, Linux, Solaris.
• Creation and configuration of Oracle database of various sizes in Dev, ITG, Model and Production environments.
• Upgraded databases from 10g to 11g versions.
• Worked on Auditing and security with Oracle databases.
• Created standby database and worked with data guard to provide high availability.
• Monitor and Configured Oracle 10g databases using OEM.
• Worked with Functions, Procedure, triggers, synonyms, views, sequences and profiles.
• Created and Managed user, tablespaces, datafiles and archive log.
• Created and assigned Roles. Grant and revoked Privileged
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Developed the PL/SQL codes on the basis of the requests for the change.
• Involved in performance monitoring and tuning of the database by fine tuning the database implementation.
• Worked on Clone the databases.
• Worked on Backup and Recovery using RMAN.
• Resolved daily production problem tickets in MAXIMO ticket system.
• Worked on oracle Public and Private Database Link.
• Experienced in Loading flat different types of files data into tables using Oracle SQL Loader Utility.
• Experienced for Delete bad data from the Tables and maintain Data Integrity
• Experienced on creation, rebuild Indexes and moved it across different tablespaces.
• Worked on Development and Testing Environment Database refresh using production database backup.
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
• Experienced with Data pump, Export/Import, Transported tablespaces data exports from production and staging databases.
• Applied CPU patches as released on PROD and NON-PROD databases.
• Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.
• Experienced with all standard request tools.
• Experienced with UNIX Shell scripting.

Environment: Oracle 10G, Oracle9i, Solaris 10, HP-UNIX, AIX, Linux, windows 2003, RMAN, SQL, PL-SQL.

Confidential

Sr Oracle Database Administrator 2008-2009

Roles and Responsibilities:

• Installation and configuration of Oracle Database Software 10g on Zlinux, AIX in development, integration, Production Environment.
• Creation and configuration of Oracle database of various sizes 300 GB, 2TB in ITG and Production environments.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Implement DBMS SQLTUNE to fine tune the database
• Worked with Flash Recovery Area.
• Schedule jobs in cronjob including RMAN backup and other memory maintenance, security jobs. Worked on DBMS SCEDULER.
• Worked on 4 node RAC databases on AIX servers
• Created standby database and worked with data guard to provide high availability.
• Partitioned appropriate tables to optimize performance and simplified maintenance work.
• Migrated databases from Oracle 10.2.0.2 on window 2003 to Oracle 10g on ZLinux development, integration, production environment using Import/Export.
• Auditing and security with Oracle databases.
• Install OEM agent on widow 2003 servers and z linux Servers
• Monitor and Configured Oracle 10g databases using OEM.
• Created and Managed user, table spaces, datafiles, archive log.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Involved in performance monitoring and tuning of the database by fine tuning the database implementation.
• Backup and Recovery using RMAN.
• Written Stored Procedures and Triggers, functions, cursor for database maintenance and management using PL/SQL.
• Applied CPU patches and other patches as required.
• Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.
• Support application team to solve any issues in Production Environment.
• UNIX Shell scripting for backup and monitoring of databases.
• Provided 24x7 on-call production supports.

Environment: Oracle10G, Oracle9i, Solaris 10 , windows 2003 Server, Zlinux, AIX OEM grid, RMAN, SQL, PL-SQL.

Confidential

Oracle Database Administrator 2007-2008

Roles and Responsibilities:

• Installed and configured 4 node server side load balancing Oracle RAC Real Application Clusters 9i, 10g databases on Solaris, AIX and Linux with ASM and Data Guard.
• Production support database on 9i, 10g with standalone and RAC environment on UNIX, Linux and on Window 2003.
• Converted single instance to Real Application Cluster RAC database instances.
• Supported database platform are AIX, Hp-Unix, Solaris, REHL and Window.
• Creation and configuration of Oracle database of various sizes 200GB, 400 GB, and 2TB in Dev, ITG, Model and Production environments.
• Upgraded databases from 9i to 10g.
• Migrated databases from Oracle 9.2.0.8 on window 2003 to Oracle 10g on Solaris 10 development, integration, production environment.
• Table created with Daily Range partition and script automated which add/remove partition as per client requirement.
• Worked on Auditing and security with Oracle databases.
• Created standby database and worked with data guard to provide high availability.
• Monitor and Configured Oracle 10g databases using OEM.
• Created and Managed user, table spaces, datafiles and archive log.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Involved in performance monitoring and tuning of the database by fine tuning the database implementation.
• Worked on Backup and Recovery using RMAN.
• Worked on creation, rebuild Indexes and moved it across different tablespaces.
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.
• Transported tablespaces and data exports from production and staging databases.
• Applied CPU patches and other patches as required.
• Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.
• Experienced with all standard request tools.
• UNIX Shell scripting for backup and monitoring of databases.
• 24x7 support by ON CALL rotation.

Environment: Oracle 10G, 9i, Solaris, LINUX, AIX, RMAN, SQL, PL-SQL, Foglight.

Confidential

Oracle Database Administrator 2006-2007

Worked on DCC Data center Consolidation . Migrate and Upgrade more than 5000 Databases on cross platform.

Roles and responsibilities

• Installation and configuration of Oracle Database Software 10g on AIX with 2 nodes RAC with ASM in development, integration, Production Environment.
• Creation and configuration of Oracle database of various sizes 300 GB, 2TB in ITG and Production environments.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Implement DBMS SQLTUNE to fine tune the database
• Configured Oracle Streams Advanced Replications and exchanged data between two databases in remote locations.
• Created 10g databases using DBCA on HP-UNIX , ZLinux platform.
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs. Worked on DBMS SCEDULER.
• Created standby database and worked with data guard to provide high availability.
• Partitioned appropriate tables to optimize performance and simplified maintenance work.
• Migrated databases from Oracle 10.2.0.2 on window 2003 to Oracle 10g on ZLinux development, integration, production environment using Import/Export.
• Auditing and security with Oracle databases.
• Created and Managed user, tablespaces, datafiles, archive log.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Involved in performance monitoring and tuning of the database by fine tuning the database implementation.
• Backup and Recovery using RMAN.
• Written Stored Procedures and Triggers, functions, cursor for database maintenance and management using PL/SQL.
• Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.
• Support application team to solve any issues in Production Environment.
• Resolved daily production problem tickets in Peregrine ticket system.
• Provided 24x7 on-call production supports.
• UNIX Shell scripting for backup and monitoring of databases.

Environment: Oracle10G, Oracle9i, Solaris 10, windows 2003 Server, AIX, Zlinux, HP-Unix OEM grid, RMAN, SQL, PL-SQL.

Confidential

Oracle DBA 2003-2005

Roles and Responsibilities:

• Installed and configured Oracle 9i 9.2.0.1.0 Database on HP-UNIX and Linux advance Server on Development, Test and Production Systems.
• Created and maintained Databases and their objects like tablespaces, tables, indexes, views.
• Partitioned appropriate tables to optimize performance and simplified maintenance work.
• Monitored and tuned rollback segment, temporary tablespace, redo log buffer, sort area size.
• Implemented security protocols for the database.
• Tested and Implemented different physical and logical Backup and Recovery methods like point in time, Media recovery, Full/partial export/import.
• Performed database cloning to create Test and Development environments from Production.
• Upgrading database from Oracle version 8i to 9i and migration of data.
• Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs. Physical standby database for High Availability.
• Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Statspack report generated from snapshots taken at the peak business hours.
• Performance tuning for Oracle Day-to-day maintenance and management of the several different databases in development, test, regression and production environments proactively monitoring production environment for any exceptions/ issues.
• Optimized performance, allocated system storage and planned future storage requirements, configured the Database of clients in client-server mode.
• Provided 24x7 on-call supports. Willingness and flexibility to work beyond regular hours based on business demands.

Environment: Oracle 9i, 8i, HP-UNIX, Toad, RMAN, Sql-Loader, UNIX Shell Programming, PL-SQL.