PROFESSIONAL SUMMARY

• Over 8 years of experience as Oracle Database administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle Software 12c/11g/10g/9i/8i on Sun Solaris, Red Hat Linux, HP-UX, AIX, and Windows Platform.
• Best practices for Oracle Database Infrastructure, Standards and Implementation.
• Implementation of best case scenarios for enterprise wide Database backup/recovery solution analyzing the specific business needs and optimizing the use of existing infrastructure.
• Implementation of Enterprise wide Database Monitoring enabling Oracle 11g Enterprise Manager Grid Control. One stop solution for monitoring every single Oracle Database within the global enterprise.
• Experience in Configuring Single instance, Oracle Real Application Clusters RAC and Automatic Storage Management ASM .
• Good exposure of Oracle DBA tasks like Installation, Patching, Cloning and Upgrade of Oracle Databases.
• Backup and Recovery strategies using RMAN and configuration of Recovery catalog for multiple databases.
• Experience with logical backups of the database using Data Pump Expdp and Impdp .
• Implemented Security administration by creating of roles, views and granting the necessary object/system privileges for users.
• Experienced in SQL Scripting and Shell scripting.
• Performed both cold and hot backups, periodical backups of both full and incremental and restoration, recovery of database using RMAN utility.
• Experience in installing and patching Oracle RAC with ASM on AIX, Solaris and Linux platforms.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application. And Involved in performance monitoring and tuning of the database by fine tuning the database implementation.
• Monitoring of the system, network, database operations, application, and other system components in Grid environment.
• Dexterous in configuring resource allocation, information sharing, and high availability with Real Application Clusters.
• Expertise in setting up Data Guard Fail-Over/Switch-Over/Read-Only scenarios Fabricated multiple CLONING databases using traditional method and RMAN utility.
• Experience in Performance Tuning I/O, Memory SQL Tuning etc by using tools/utilities by Automated Workload Repository AWR , Automatic Database Diagnostics Monitor ADDM .
• Experience in migration, database change management and data management through the various stages of the development life cycle.
• Upgraded OEM management agents to 11.1.0.1 using silent installation and Agent deployment Wizard.
• 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 proprietary change management processes to prevent production disruptions and outages. Cloned Database from Production to Test and Development and from Development to Production.
• Strong working knowledge of development tools like TOAD, SQL Developer, SQL Navigator.
• Experience in managing Very Large OLTP as well as DSS DATA WAREHOUSE Databases VLDB .
• Experience in installation, configuring and managing Golden Gate V10x,V11x on Oracle 10g and 11g with Linux, HP-UX and Windows platforms in Test Environment.
• Supported 24/7 Production databases and responsible for round-the-clock database operations. Offering solutions for Production/Development of database applications.
• Leading, Motivating and coordinating team of developers with excellent interpersonal skills.

TECHNICAL SKILLS

Operating systems: LINUX, SOLARIS, MS-DOS, NT, Windows 95/98/XP/7/ 2000, Windows Advanced Servers 2000/2003. Databases: Oracle 11gR2, 10gR2 RAC, 9i, 8i, SQL Server 2005. Oracle Database Tools: SQL Loader, TKPROF, Toad, OEM, SQL Developer, Grid Control Data Warehouse Tools: SQL and ETL tools for above database environment Tools Utilities: Export/Import, RMAN, Data Pump, Winscp3, ERWIN. Languages: C, C , UNIX shell scripts, PL/SQL Web Tools: HTML and XML, SQL NET, ODBC, TCP/IP

PROFESSIONAL EXPERIENCE

Confidential

Role: Sr. Oracle Database Administrator

Responsibilities:

• Installation, Configuration and maintenance of Oracle 11gR1/11gR2 on Linux, and Solaris.
• Configuration and maintenance of 11g RAC, and Single Instance database environments .
• Installing ASM environment and migrating databases from NON-ASM to ASM.
• Created and monitored Physical standby databases on maximum protection, performance mode using Data guard for Disaster Recovery and High Availability.
• Configured and installed OMS 12c Repository database and installed 12c OEM agents.
• Experience of installing, configuring Golden Gate Replication from OLTP databases to Data warehousing environments.
• Troubleshooting Golden Gate issues in both development and production environments.
• Performed Unidirectional and Bidirectional replication through Golden Gate for zero downtime Database migrations.
• Migrating and upgrading Oracle Database from 10gR1 on Solaris/Windows to 11gR2 on Linux environment using data pump and Golden Gate replication.
• Upgrading Grid Infrastructure and databases from 11.2.0.1/11.2.0.2/11.2.0.3 to 11.2.0.4.
• Upgrading Grid Infrastructure and databases from 11.2.0.4 to 12c.
• Applied patches Patch sets and CPU patches and worked closely with Oracle to make Application environment up to date.
• Worked extensively on RMAN backups and recoveries and database cloning using RMAN Duplicate. Troubleshooting and maintenance of RMAN backups and user managed backups.
• Implemented Backup-using RMAN Recovery Manager as media management layer
• Planning and scheduling Backups, Database Recovery, taking Logical Backups with Exp/Imp and Data Pump Database backup Hot cold .
• Extensive use of performance monitoring tools like STATSPACK and AWR, ADDM reports, Oracle Enterprise Manager, TOAD for the performance tuning at the SQL and database level.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Patching, and upgrading Grid Infrastructure, and Database homes on Exadata machines. Provided support for OS upgrades on Exadata running on linux.
• Provided support for altering hardware on Exadata machines.
• Installation of Oracle Enterprise Manager OEM Grid Control for environment standardization
• Constantly monitoring the performance of the databases and viewing alert log files trace files.
• Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users.
• Involved in Data Modeling by working closely with Data Architects and application developers.
• Worked on revision control tools like SVN/GIT , and Maven for deployment in various environments.
• Created a process using Maven and Shell scripts to build new environments in less than 30 min.
• Write scripts for Creation of users, creation and assignment of roles analyze space requirements and maintain table spaces and other database objects.
• Writing PL/SQL triggers, procedures, and functions.
• Strategic content infrastructure for managing documents, images, rich media files, and records in Management
• End-to-End content lifecycle management from creation to archiving.
• Contacting different teams like developers, data architects, release management for database changes and deployment activities.
• Co-coordinating with on-site counterpart as well as Clients and understanding requirements and providing 24x7on call support for all the production and development databases. Environment: Oracle 10gR1, 10gR2, 11gR1, 11gR2, 12c with RAC, Data Guard, ASM, Golden Gate, SQL, PL/SQL, Erwin, SVN, GIT, Maven, HTTP, F-Secure SSH, F-Secure FTP, TOAD and Oracle Enterprise Manager.

Confidential

Role: Sr. Oracle Database Administrator

Responsibilities:

• Provided 24x7on call support for all the production databases on rotation basis.
• Configured and Upgraded to Oracle 11gR2 from 10g.
• Installed ORACLE Enterprise Manager GRID CONTROL 11g and configured it server targets for a centralized monitoring system.
• Configured and implemented Oracle 11g ACTIVE DATAGAURD for Database Disaster Recovery by using DATA GAURD broker DGMDRL .
• Upgradation of databases applying patches, patch sets and critical patch updates.
• Migration: Duplicated database using RMAN and upgraded it to oracle 10g/11g and applied latest patch set.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• Optimized the query result cache for best performance.
• Troubleshooting RAC ASM and Oracle Cluster ware related issues.
• Proficient with Standby Database, Data Guard and Replication.
• Experienced in dealing with ASM environment such as Installation, taking backup, migration from NON-ASM to ASM environment.
• Extensively used AWR, ADDM for database performance statistics.
• Worked on TSPITR using RMAN.
• Oracle Database and SQL Tuning using EXPLAIN PLAN, TKPROF, AWR and ADDM reports.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, troubleshooting, back-up and recovery, installations and configurations on an as needed basis.
• Written SQL scripting to monitor the extent growth.
• Written SQL, PL/SQL scripts and Shell scripting to monitor table space and extent growth. Space Management, which includes table space creation, adding new data files.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues.
• Solid discipline in providing end-users timely updates on their problems and Installing server software.
• Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.
• Monitor, Maintain/administer existing databases security with Oracle database environment.
• Worked on Load balancing and performance tuning on RAC environment.
• Write scripts for Creation of users, creation and assignment of roles analyze space requirements and maintain table spaces and other database objects.
• Performing automatic product deployments and repeated database maintenance and monitoring tasks.
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Implemented scripts, which monitor database health check at regular interval, upon error, send email to the concerned person.
• Importing of dumps using impdp/expdp utilities.
• Loading bulk data from flat files using sql loader and external tables.

Environment: Oracle 9i/10g/11g/11gR2 databases, Data pump, Export/Import, Physical Backups, Oracle Streams, Solaris 9.0, AIX Windows 2000/XP, HTTP, F-Secure SSH, , F-Secure FTP, Oracle Enterprise Manager, TOAD.

Confidential

Role: Sr. Oracle Database Administrator

Responsibilities:

• Installation, Configuration and maintenance of Oracle 11g/10g database software on RHEL and Oracle Enterprise Linux OEL .
• Configured 3-node Real Application Cluster RAC and monitored RAC instances with Oracle Enterprise Manager Grid Control.
• Configured Physical Standby databases and logical Standby database for ACTIVE DATA GAURD.
• Configuration of Oracle ASM on RHEL and HP-UX and managing disks and disk groups.
• Done migration of non-ASM database to ASM databases.
• Implemented ASM on RAC databases and standalone databases.
• Involved in monitoring the database related activities using Oracle Enterpriser Manager 10g Grid Control and monitoring the backup jobs scheduled in Oracle Enterpriser Manager OEM .
• Performed oracle database refreshes using expdp/impdp from production to test database.
• Done with performance tuning related jobs like general health checks and maintenance of databases using Automatic Workload Repository AWR and Automatic Database Diagnostic Monitor ADDM reports by finding wait events.
• Performed logical backups of schemas and database using DataPump expdp/impdp as per requirement.
• Cloning of Databases using RMAN.
• Written SQL scripting to monitor Tablespaces.
• Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.
• Performed rolling patch upgrades for RAC environment for bug fixing and also involved in applying PSU and CPU patches for Oracle Server.
• Oracle Database and SQL Tuning using STATSPACK, EXPLAIN PLAN, TKPROF, AWR and ADDM reports.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Daily incremental backup and weekly full backup of databases using RMAN.
• Participated in regular on-call support for production databases.
• Importing of dumps using impdp/expdp utilities.

Environment: Oracle 11g/10g, Oracle Enterprise Manager Grid Control ,ASM, Real Application Cluster Loader, Oracle Enterprise Manager OEM , TOAD, Red Hat Enterprise Linux RHEL and Oracle Enterprise Linux OEL .

Confidential

Role: Oracle Database Administrator

Responsibilities:

• 24 7 production databases and handled all day to day database issues, upgrades and enhancements.
• Upgrading an Oracle 9.x databases to 10.x. on Red Hat Linux 4.
• Involved in solving various issues in RAC environment.
• Performance Tuning SQL Queries and PL/SQL Procedures.
• Responsible for Designing creating the databases on Production servers.
• Monitoring of Data-Guard and their Progress by checking the last applied archive log on Standby.
• Database security management by creating users, roles, profiles, granting necessary privileges and auditing.
• Refreshing development/test database from production using Data- Pump, Export/Import to ensure that the latest data is available in the development/test database.
• Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.
• Setup RMAN scripts for Backups.
• Oracle Database and SQL Tuning using STATSPACK, EXPLAIN PLAN, TKPROF, AWR and ADDM reports.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Effectively resolved incident tickets in the production environment.

Environment: Oracle 9i/10g on Sun Solaris 8/9, Real Application Clusters, Data-Guard.

Confidential

Role: Oracle DBA/ Data analyst

Responsibilities:

• Created and maintained Database Objects Tables, Views, Indexes, Sequences, Database triggers, stored procedures .
• Wrote complex SQL queries using joins, sub queries and correlated sub queries for various reports.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Coded and implemented data migration processes using Oracle procedures/packages using PL/SQL .
• Developed and optimized of SQL queries using TOAD Explain Plan utilities.
• Defined indexes on various tables to improve the performance of the queries for reporting purpose.
• Developed and modified PLSQL procedures, functions and package as per requirement.
• Tuned the oracle PLSQL procedures and queries using explain plan and hints to improve the performance of the reports.
• Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.
• Written SQL scripts to monitor table space and extent growth. Space Management, which includes table space creation, adding new data files.
• Optimized SQL queries used in Reports and Stored Programs Procedures, Functions and Packages to improve performance drastically.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.

Environment: Oracle 9i, Sun Solaris, Linux, putty, PVCS