SUMMARY

• More than 9 years of experience in Oracle DBA both implementation and support level
• Hands on experience in all aspects of Database Administration such as installation, patching, cloning, backups, database security management etc.
• Experience as a production DBA, maintaining and troubleshooting large databases, during off hours and weekend support, and maintaining multiple instances in a 24/7 Production supports.
• Experience in High Availability solutions with Oracle 10g,11g RAC, ASM and Standby (DATAGUARD)
• Good Experience on Golden gate implementation
• Experience in installation, configuration and administration of Web Logic Server 8.x/9.x/10.x and 11g in various environments
• Experience on Performance tuning, application issue/resolution and identify solutions.
• Experience in OEM Configuration on Oracle 11g.
• Good Experience on Shell scripting
• Good Experience on Restore and recover the database for Oracle
• Experience on Design/Data model experience on logical and physical using Erwin tool
• Experience in Data guard broker Configuration
• Experience on Oracle Migration from Solaris to Linux
• Experience on Upgrade the Database From 11.2.0.3 to11.2.0.4
• Experience on Upgrade the Database From 11.2.0.4 to12c
• Experience on validate data sharing and disk partitioning
• Extensively used DBA Utilities, RMAN, Oracle Enterprise Manager, SQL*Loader, Backup & Recovery, AWR, ADDM, TKProf and Performance Monitoring.
• Implemented and enforced security for all of the Oracle Databases
• Experience on Data Dictionary, Migration, load testing, proactive performance tuning and partitioning the tables.
• Experience in Administering all database objects, including tables, clusters, indexes, views, sequences, packages and procedures
• Experience in cloning using Cold and Hot backups
• Experience on applying security patches to the databases
• Experience on Data guard physical standby on R12 on 11g database.
• Experience in the switchover and failover activity for oracle 11g
• Experience on RMAN restoration, recovery and Cloning in 11G
• Good Experience on security & Auditing for Oracle 11g
• Good Experience on migrating existing Oracle databases into Exadata
• Good Experience on maintained the on Real application clusters.
• Ensuring security by creating and managing profiles for DB users.
• Refreshing database from production to test environment as per application team requirement

TECHNICAL SKILLS

Operating Systems: Windows NT / 2000, Linux, HP - Unix, Solaris, AIX

Tools: OEM, TOAD, PUTTY

Protocols: TCP/IP, SNMP, SSH, FTP and Telnet

Oracle DB utilities: OEM, DBCA, Oracle Net Manager, EXPDP/IMPDP, RMAN, Exp/imp, Tkprof, Lsnrctl, SQL*Plus, Opatch

RDBMS: Oracle 11g,10g,12c

Utilities: AD utility, RMAN

Application Server: Weblogic server 10g, 11g

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Oracle DBA Lead

Responsibilities:

• Creation of Databases, Instances for Test, Development, Stage and Production Servers.
• Involved on Design/Data model experience on logical and physical using Erwin tool
• Monitoring and managing day-to-day operations, Managing schema objects, such as tables, indexes, and views
• Experience on Performance tuning, application issue/resolution and identify solutions
• Created database users, security maintenance by assigning quotas, roles, privileges, profiles and providing database access to users as per the policy standards.
• Applying CPU and PSU patches on RDBMS.
• Collecting statistics through AWR, ASH and ADDM Report
• Involved in the Oracle database auditing & Security
• Implemented PL/SQL scripts for changes in the user applications
• Actively performed Disaster Recovery drills for Oracle
• Implemented the Oracle Migration from Solaris to Linux
• Implemented the Upgrade the Database From 11.2.0.3 to11.2.0.4
• Implemented the Upgrade the Database From 11.2.0.4 to12c
• Implemented validate data sharing and disk partitioning for Oracle
• Implemented the Golden gate implementation
• Implemented the Active Data guard for Oracle Database
• Ensuring security by creating and managing profiles for DB users.
• Implemented the Shell scripting for Oracle database
• Good Experience on Restore and recover the database
• Refreshing database from production to test environment as per application team requirement
• Implemented the RMAN and Hot Backup Cloning
• Implemented the OEM Configuration on Oracle 11g.
• Implemented Restore and recover the database for Oracle
• Configured the Physical standby on 11g Oracle.
• Implemented on RMAN restoration, recovery and Cloning in 11G
• Implemented in the switchover and failover activity for 11g oracle.
• Maintenance of file system and taking appropriate backups for security and consistency.
• Monitoring alert log and trace files for errors.
• Monitoring the cpu,memory usages on the server
• Maintaining traditional backups of database
• Monitoring table spaces and we add the space whenever it required

Confidential, Columbus

Oracle DBA

Responsibilities:

• 24*7 support with rotational on call duty
• Responsible for planning, coordinating and implementing security measures to safeguard the databases;
• Implemented the RMAN and Hot Backup Cloning
• Implemented the Design/Data model experience on logical and physical using Erwin tool
• Test programs or databases, correct errors and make necessary modifications
• Work as part of a project team to coordinate database development and determine project scope and limitations
• Implemented the Oracle Migration from Solaris to Linux
• Implemented the Upgrade the Database From 11.2.0.3 to11.2.0.4
• Implemented the Upgrade the Database From 11.2.0.4 to12c
• Implemented validate data sharing and disk partitioning for Oracle
• Implemented the Golden gate implementation
• Implemented the Active Data guard for Oracle Database
• Performed data refresh, data reorg, space management issues, Index rebuild, connections using database links
• Implemented the Oracle Migration from Solaris to Linux
• Implemented the RMAN restoration, recovery and Cloning in 11G
• Capacity planning for new Production, Development and Test databases.
• Created primary objects (tables, views, indexes) storage structures(Tablespaces) once application developers have designed the application
• Have expertise in activities like maintaining instances, maintenance of file system and taking appropriate backups for security and consistency.
• Applying CPU and PSU patches on RDBMS.
• Implemented the OEM Configuration on Oracle 11g.
• Implemented Restore and recover the database for Oracle
• DR Planning, Implementing and testing for production databases.
• Installation of Oracle RDBMS software and OEM agent software as per the Standard run book.
• OEM agent configuration, adding targets to OEM repository, setting up credentials and blackout when needed.
• Monitoring Dev, QA and Prod database issues through 10g OEM.
• Responsible for database backup and recovery using Exp/imp, Data pump, RMAN
• Co-coordinating with Oracle support for any technical assistance and work till the solution implementation
• Senior member of the DBA team, and had proactively taken the responsibility of cross and mentoring the new team members with the process knowledge.
• Daily monitoring the database alert log files & trace files for any error messages,
• Created the database, tables, table spaces, and data objects, setting privileges, User logins and passwords.

Confidential - MD

Oracle DBA

Responsibilities:

• Creation of Databases, Instances for Test, Development, Stage and Production Servers.
• Monitoring and managing day-to-day operations, Managing schema objects, such as tables, indexes, and views
• Created database users, security maintenance by assigning quotas, roles, privileges, profiles and providing database access to users as per the policy standards.
• Applying CPU and PSU patches on RDBMS.
• Implemented the Upgrade the Database From 11.1.0.7 to 11.2.0.3
• Collecting statistics through AWR, ASH and ADDM Report
• Implemented PL/SQL scripts for changes in the user applications
• Actively performed Disaster Recovery drills
• Ensuring security by creating and managing profiles for DB users.
• Refreshing database from production to test environment as per application team requirement
• Configured the Physical standby on 11g Oracle.
• Maintenance of file system and taking appropriate backups & restoe for security and consistency.
• Monitoring alert log and trace files for errors.
• Monitoring the cpu,memory usages on the server
• Maintaining traditional backups of database
• Monitoring table spaces and we add the space whenever it required

Confidential, TX

Oracle DBA

Responsibilities:

• Created the database, tables, table spaces, and data objects, setting privileges, User logins and passwords.
• Ensuring security by creating and managing profiles for DB users.
• Refreshing database from production to test environment as per application team requirement.
• Scheduling and Managing Logical backups - export, and physical backups - RMAN.
• Applying CPU and PSU patches on RDBMS.
• Checking the alert log and trace files for errors
• Monitoring the CPU, Memory usages on the server
• Monitoring table spaces for space.
• Analyze queries using AWR, ADDM, ASH reports

Confidential

Oracle DBA

Responsibilities:

• Support and Administration of Production and Test Instances.
• Applying CPU and PSU patches on Oracle RDBMS.
• Ensuring security by creating and managing profiles for DB users.
• Checking the alert log and trace files for errors
• MonitoringTablespaces for space usage and adding required space whenever it reaches threshold.
• Refreshing database from production to test environment as per application team requirement.
• Raising SR’s and searching and downloading patches from Metal ink and applying them.