SUMMARY

• 8 years of experience in Oracle Database Administration encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modelling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control, Golden Gate and Enterprise Manager.
• Installation and administration of Oracle 12c/11g/10g/9i on OEL, RHEL, Windows, HP - Ux, IBM-AIX and Sun Solaris in OLTP and OLAP environment.
• Knowledge on Exadata Smart Scan technology which improves query performance by intensive query processing and data mining scoring to scalable intelligent storage servers.
• Monitoring Databases on EXADATA in testing environment to test database performance.
• Experience of Oracle Golden Gate installation, configuration and troubleshooting GoldenGate EXTRACT and REPLICAT issues.
• Performed Migration and Upgrade of databases from 10g/11gR1 to 11gR2 and 10g/11g to 12C
• Database refresh from 2 Node RAC to 5 node RAC, 3 node to 5 node RAC using RMAN active cloning and using RMAN backup and restore strategies.
• Database refresh for SAP databases over 12TB size using RMAN active cloning.
• Upgradation of databases applying patches, patch sets and critical patch updates.
• As a DBA we use to give permissions to access the LDAP databases.
• Installation and configuration of Oracle Server 11g RAC with ASM on multi node systems, 11g, 10g and 9i in different operating systems for OLTP environment on Very Large Databases(VLDB).
• Experience on Oracle 11g/ASM/RAC and up gradation of standalone databases to 11g RAC environment
• Configuration of Automatic Storage Management (ASM)
• Configuration and Management of Data Guard on RHEL, OEL and Windows.
• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
• Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control
• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Golden Gate.
• Regular database synchronization for test database environments through automation.
• Installation and configuration of RMAN with and without Recovery Catalog.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import.
• Migrating the databases from one platform to another platform.
• Implementation of Flashback Technology
• Extensive experience using SQL* Loader, External Tables for data loading.
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Monitoring and Optimization of database performance through database tuning, system tuning and application tuning.
• Experience in SQL Tuning, Optimization, cost based optimization and Hints
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, and SQL TRACE.
• Proficient in INDEX REBUILDING and INDEX TUNING.
• Table and Index partitioning using online redefinition on tables of size over 200G.
• Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
• Experience working with Database Resource Management
• Working experience in creating materialized views.
• Proficient in writing PL/SQL Procedures, Functions and Triggers.
• Experience using Erwin as a Data Modelling tool.
• 24*7 on-call production database support and maintenance including remote database support
• Assisting in implementation of change control process in production.
• Ability to work in a team as well as to take individual responsibility.

TECHNICAL SKILLS

Operating Systems: OEL, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x, HP-UX 10.x, 11.x, Sun Solaris 9.0/10.0, AIX 5.1, 5.2 and Windows 98/NT/2000/2003.

Data Bases: Oracle 11gRAC/10gRAC/10g/9i, SQL Server 2008, MYSQL, Vertica

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

Tools: /Utilities: RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, TOAD, Patch Management, SQLNET, ODBC, Export/Import, Data pump, DataGuard, VERITAS Net Backup, VMware, Logminer, CronTab, EXADATA

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

Terminal Emulation: Putty, Telnet, FTP, MobaXterm

PROFESSIONAL EXPERIENCE

Confidential, Houston TX

Oracle Database Administrator

Responsibilities:

• Installed Configured and Managed Tier 0 Application databases. Configured on 5node RAC cluster, refreshed from 2Node RAC to 5 node RAC.
• Applying PSU 22 on 11gR1 on various platforms HP-UX (Itanium & RISC), LINUX by creating scripts which automate the patch apply process.
• Installed 12c multitenant on lab environment for testing.
• Upgraded 10g/11g databases to 12c lab environment and converted them to pluggable databases.
• Plugging and unplugging databases from container.
• Managing 12c databases using CDB views.
• Golden gate installation and performed Golden gate and Database upgrades.
• Experience on Data Replication using Snapshot, Materialized views and Oracle Golden Gate.
• Configured Golden gate Uni-Directional and Bi-Directional Table Replication.
• Configured various Extracts, Pumps, and Replicats depending upon the client’s requirement to replicate data across all markets.
• Worked on the High availability of golden gate creating the golden gate VIPs and creating services for RAC Databases.
• In case of one node getting failed Golden gate will be failover to other node.
• Tested and Performed data guard switchover and failover tests using DGMGRL and manually.
• Installed Configured 30TB database on 2 node RAC cluster and provide support in performance tuning.
• Performance tuning issues with long running queries and tuning reports for Mission Critical databases.
• Installed, configured, and maintained Oracle 11g R2 on HP UX and also Upgraded from Oracle 10g to 11g.
• Refresh SAP Databases using RMAN active cloning above 12TB size and use of BRTOOLS.
• Upgradation of Grid Infrastructure and Oracle Databases from 11.1.0.7 to 11.2.0.3 on 3 node RAC environment.
• Database upgrades from 11.1.0.7 to 11.2.0.3 and applying patches on oracle and grid home using OPATCH utility
• Database refreshes from 2 Node to 3 Node RAC, 3 Node to 5 node RAC using Rman active cloning and RMAN backup and restore strategies.
• Production DDL’s changes through tickets on Mission critical databases.
• Database Refresh using rman for Dev databases and ITG environment too.
• EXPDP/IMPDP Schema backups and restore on DEV databases.
• Building standby databases for Mission Critical and Tier 0 databases.
• Implemented Data guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.
• Performed conversion Non RAC single instance to 2 Node RAC database instances.
• Daily Health Check Up of the Database using AWR, ADDM.
• Table and Index partitioning using online redefinition on tables of size over 200G
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• RAC S2S Metro cluster, where the database will be failover from site1 to site2 using service guard package.
• Configured Emcli setup for databases, which relocates the OEM targets when failover is done on S2S metro cluster.
• Daily monitoring of Active ITG and ACTIVE PRO OEM dashboards, resolve down targets issues.
• Production databases Support shifts which includes monitoring OEM dashboard, solving tickets with performance issues and backups.
• Solving failure backup issues tickets and configuring backup for new databases
• Standard report check for new databases and maintain the database with standards.
• Performed day to day administrative tasks by analysing the database like checking for failed processors, verifying the query for particular issues and validating disk space.
• Created Users with limited rights as per specific module under specific client. Granting roles and profiles as per system study to users.
• Performed CRS and Database Upgrades from 11.2.0.2 to 11.2.03.
• Replication of tables to cross platform and Creating Materialized Views.
• Configured and Implemented Cold/Hot Backups refresh.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.

Environment: Linux, HP-UX, Sqlserver R2 2008/2012,Golden Gate,Toad,Oracle 9i/10g/11g/12C Oracle RAC 10g/11g,OEM 12c

Confidential, Tulsa, Oklahoma

Oracle Database Administrator

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Up gradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.2 on 3 node RAC environment.
• Database Refresh from one version to another version.
• Focused on Exadata administration. With nodes ranging from 2 to 8 and incorporating Exadataclusters for maximum availability.
• Worked on X2-2 machine where backups, restores are run across all database instances in Exadata system with two or four RMAN channels allocated per instance.
• Involved in Hybrid columnar compression improving the performance on EXADATA.
• Manually monitor cell statistics with the help of CELLCLI.
• Installation and Configuration of EM 12C grid control.
• Migration of database from one server to another server.
• Responsible for setup and implementation of 2 Node RAC on Linux in 10g and 11g R2.
• Implemented Data guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Installed, Configured and Administered Golden gate.
• Configured parameters for the Bi-directional replication.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Done migration of non ASM database to ASM database.
• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.
• Used cross platform transportable table space (TTS) to transport table spaces across platforms.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
• Performed patching on Oracle Database Server 10g and 11g using Opatch utility.
• Daily Health Check Up of the Database using AWR, ADDM.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for particular issues and validating disk space.
• Created Users with limited rights as per specific module under specific client. Granting roles and profiles as per system study to users.
• Replication of tables to cross platform and Creating Materialized Views.
• Configured and Implemented Cold/Hot Backups.
• Also configured database cloning using RMAN.
• Develop and enforce both database and OS-level security policies for data protection. Administer all databases in the areas of maintenance, tuning, performance, and troubleshooting.
• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Developed Scripts for transferring data from production server to testing/development servers.
• Shell scripting and PL/SQL programming to resolve business problems of various natures.

Environment: Oracle 10g, 11g, Linux 4/5, OEM, DBUA, RMAN, Golden gate, Grid, RAC, ASM, Exadata X2-2, Data guard, SQL*LOADER, AWR, ADDM, ASH, Data pumps, Exports/Imports.

Confidential, Bethpage, NY

Oracle Database Administer

Responsibilities:

• Installed and Configured 2node RAC on Linux.
• Working Knowledge of installation and configuration of GOLDENGATE in Unix environment
• Done Installation and configuration of golden gate on 11g database for the replication.
• Implemented Bi-Directional replication in golden gate from target to source and source to target.
• Configured Golden gate Uni-Directional and Bi-Directional Table Replication.
• Having hands-on experience on implementing, upgrading and configuring the Golden Gate software for Oracle Database.
• Resolving the conflicts between the target and source database.
• Configuring parameters for DDL support in golden gate replication
• Installed and Configured and maintained oracle 10g and 11g.
• Oracle Grid Control 11g Installation and Configuration.
• Involved in supporting 50+ production and development databases on RHEL.
• Refreshing the Database from one version to another version.
• Configuration of Physical Standby database for maximum performance mode - Oracle Data Guard
• Installation, Configuration and Maintenance of Oracle RDBMS and Client software in various environments.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities
• Performed rolling patch upgrades on RAC environment for bug fixing
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import
• Daily incremental backup and weekly full backup of databases using RMAN
• Involved in migration of applications of the clients.
• Loading data into database tables using SQL *Loader
• Implemented Materialized views, database links
• Regular database management on 10g and 11g OEM
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Table space monitoring, Performance monitoring and tuning for performance improvement
• Creating batch files and automating the tasks
• Granting roles and privileges to end users
• Managing, troubleshooting and resolving oracle database and application issues.
• Daily health check-up of the database using TKPROF, AWR, ADDM.
• Monitoring alert log/system log and managing Database Locks and blocking sessions
• Defragmentation of tables and indexes for improved performance and efficiency.

Environment: Oracle 10g, 11g, SQL, PL/SQL, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, Red Hat Enterprise Linux, ASM, HTML

Confidential, Atlanta, Georgia

Oracle Database Administrator

Responsibilities:

• Installed and Configured Oracle 10g databases on Linux and also Upgraded Oracle databases from 10g to 11g
• Maintenance of around 20 databases combined on all the production, development and testing environments.
• Install and configured Oracle databases on windows server 2003 and 2008 platform.
• Implemented Oracle Database 10g Two node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Configured Oracle Data guard for Oracle Disaster recovery.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data pumps Exports/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Performed automated backups and scheduling using scripting.
• Responsible for migration of databases.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL; UNIX Shell Scripts for backups.
• Worked with Data pump to take the logical backups of databases.
• Experienced in performing Point in time recovery using RMAN.
• Used oracle configuration assistants like DBCA(Database Configuration Assistant) for Creating databases, DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA(Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.,
• Involved in designing logical and physical data models using Erwin.
• Working Experience with Latest TOAD having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, and SGA Trace.
• Created indexes to facilitate easy user interface implementation and tuning.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Involved in gathering requirements from end users.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Estimate growth of database size by detail analysis of the company’s future policies and generating reports for the management to act in advance.

Environment: Oracle 11g/10g/9i, Red Hat Enterprise Linux 4.x and 5.x, AIX 5.2, Windows 2003/2008, OEM, Oracle 10g RAC, TOAD, Erwin, STATSPACK, EXPLAINPLAN

Confidential

Oracle Database Administrator

Responsibilities:

• Installed and implemented 2 node 10g RAC on RHEL/UNIX and worked on ASM features of Oracle.
• Configured ASM disk groups to store Data files, redo log files, and control files.
• ASM Management using RAC utilities like SRVCTL, OCRCHECK, OCRDUMP and CRSCTL.
• Used RMAN to Migrate the Non-ASM Database to ASM Database.
• Installation, Configuration and Maintenance of Oracle RDBMS software.
• Installation, Configuration and Maintenance of Logical/Physical standby databases in Data guard.
• Data refresh from Production to Test and Development environments using RMAN duplicate database.
• Up gradation of databases applying patches, patch sets and critical patch updates.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import.
• Performance tuning and debugging SQL/PL SQL involved in Application development.
• Designed optimal architecture for database environment.
• Diagnosed and Performance tuning of highly update intensive applications.
• Mentor Development and QA team needs.
• Design and Developed Web applications and Content Management Systems.
• Installation and configuration of Oracle software 10g version.
• Upgraded Oracle 10.2.0 to Oracle 11.2.0.
• Created databases, allocated system storage and planned future storage requirements for the database.
• Installed Oracle and related tools, upgraded the database and applied patches as and when required.
• Configured and maintained Standby Databases in OLTP environment to automatically synchronize with production database.
• Configured the Data guard for switchover and failover and thereby providing high availability.
• Coordinated operating system setup/upgrades and infrastructure troubleshooting in partnership with system administrators.
• Performed Hot Backups and maintained database availability to support non-stop Business operations.
• Implemented Cloning to migrate data from PROD to Test and Dev databases.
• Performed Capacity planning and storage management.
• Estimation of database growth and analysis.
• Reorganization of tables and rebuilding of indexes.
• Maintained a disaster recovery site and planned and instituted disaster recovery process.
• Coordination with the team and ORACLE Support for troubleshooting the database issues.
• Developed UNIX Shell scripts to backup and recover the Oracle databases.
• Modified shell scripts for backup and recovery, Imported and exported procedure, implementing transportable table spaces.
• Worked as a team member to provide 24x7 on-call production database support.

Environment: Oracle 9i/10g/11g, LINUX, Windows 2003 server, OEM, Shell Scripting, PL/SQL