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 Modeling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control, Oracle Streams.
• Installation and administration of Oracle 12c/11g/10g/9i on OEL, RHEL, HP - UX, Windows, UNIX and Sun Solaris in OLTP environment.
• Managed Databases in the range from 50GB to 60TB.
• Performed Migration and Upgrade of databases to 11g and 10g.
• Up gradation of databases by applying patches, patch sets and critical patch updates.
• 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).
• Extensive experience on Oracle 11g/ASM/RAC and upgradation of standalone databases to 11g RAC environment
• Experience in Configuring Automatic Storage Management (ASM).
• Developed database monitoring/health checkup alerts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance and maintenance.
• Extensive experience in configuring and managing Dataguard on RHEL, OEL and Windows.
• Configuration of dataguard broker on RAC.
• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
• 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 Streams.
• Regular database synchronization for test database environments through automation.
• Installation and configuration of RMAN with and without Recovery Catalog on Oracle 11g/10g/9i.
• Having knowledge on EXADATA.
• Upgrading and migratingOracle11gR2 RAC Databases running on legacy infrastructure toOracle 12CPluggable Databases running on the latest platforms.
• Introduction to 12C Pluggable databases - Architecture, Installation and the basic concepts associated with 12C database.
• 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, export/import, expdp/impdp.
• Extensive experience in migration of databases with export/import, expdp/impdp, RMAN.
• Implementation of Flashback Technology.
• Experience of installing, configuring Golden Gate and troubleshooting Golden Gate issues.
• Experience in Uni-directional and Bi-directional replication through Golden Gate.
• Extensive experience using SQL* Loader, External Tables and Oracle Application Express 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, SQL TRACE.
• Proficient in INDEX REBUILDING and INDEX TUNING.
• Development and implementation of Relational Database and Data Warehousing Systems using IBM Data Stage 8.0.1
• 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 Modeling tool & Designing the ETL processes
• 24*7 on-call production database support and maintenance including remote database support.
• Ability to work in a team as well as to take individual responsibility.

TECHNICAL SKILLS

Operating Systems: HP-UX10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10,IBM-AIX, Windows 2000/XP, Red Hat Linux RHEL 3.x, 4.x, 5.x.,6.x, Suse Linux, OEL

RDBMS: Oracle 11g,10g/9i, Oracle 10g and 11g Real Application Cluster (RAC)

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

DB Management: TOAD, OEM 11g grid control

Tools: /Utilities: RMAN, OEM, Oracle Management Server, SQL*Loader, SQL Server, Export/Import, TOAD, Data pump, Query builder, Net Backup, VB, Crystal Report, MS Access.

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

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Oracle DBA

Responsibilities:

• Implementation of Oracle Virtual Directory for obtaining centralized authentication.
• Install, configure and maintain Oracle 12c grid and database software.
• Creation and maintenance of oracle 12c Container database.
• Creation of pluggable databases for the container db's and maintained them.
• Install, Configure and maintain of 2&3 node 11g Real Application clusters.
• Implementation and validation of VNCR (Valid Node Checking Registration) to avoid listener poisoning.
• Build and maintain Disaster recovery databases and actively participated in the DR drills.
• Build and maintain of Active Data Guard machines.
• Configuring DG-BROKER for the maintenance of data guard.
• Used the Data guard Broker to perform switchback and switchover.
• Upgradation of both database and grid software from 11gr2 to 12c and 10g to 11g.
• Migration of databases from 11g to 12c.
• OEM Cloud Control 12c Agent installations, plug-ins installations and adding targets to OEM. Monitoring the databases using OEM 12C.
• Tuning of data guard to keep the primary db in sync with the standby database
• Tuning of the slow running databases and avoiding the business loss
• Used Golden Gate for data replication and zero downtime migration.
• Monitoring and optimization of database performance through database tuning, system tuning and application tuning.
• Used and analyzed the AWR, ADDM reports to improve the performance of the database to avoid the response times.
• Implemented online redefinition technique to move the table from one tablespace to another and to partition of tables .
• Used the clufvy utility and applied the bug fix patches.
• Applying of patch set update and interim patches whenever required to make the database and grid software up to date.
• Maintained the Oracle Internet Directory.
• Performed the health check of the databases.
• OEM Cloud Control 12c Agent installations, plug-ins installations and adding targets to OEM. Monitoring the databases using OEM 12C .
• Created database objects like tables, views, indexes and partitioned them.
• Created Materialized Views and configured jobs to refresh them.
• Configured new connections and services to the listeners and DB.
• Performed Security Management and accessibility control by managing OS and password file authentication, creating profiles, privileges and roles.
• Used RMAN cloning technique to refresh the DB and build new db’s.
• Creation and maintain of database services.
• Used Datapump utility to take the hot and cold backups of the database and to restore the db.
• Automated backups are configured using the RMAN incremental backup.
• Finding the RCA (root cause analysis) and tuning the database and SQL tuning using AWR, ADDM etc. reports.
• Modify the bash shell and pearl shell scripts according to the need.
• Used the scheduling tools like Cron tab and Autosys to schedule the jobs based on the needs.
• Configured the jobs to monitor the databse and hosts.
• Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.
• Worked with oracle support in critical situations and solved the issues in time.
• Provided 24/7 production support and was on-call for the production database maintenance.

Environment: Oracle 12c/11g/10g, Sun Solaris, Red Hat Linux, Suse Linux, TOAD, RMAN, SQL server, RDBMS ASM, RAC, Data Guard, Golden Gate, OEM, Grid Control, STATSPACK, AWR, Explain Plan, MySql.

Confidential, Warren, MI

Sr. Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle 11GR2 Real Application Cluster (RAC) 2 node RAC on Linux Environment.
• Migrating single Instance Databases to 2 Node RAC environment.
• Upgraded databases from 10g to 11g.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases on Vmware environment.
• Involved with installation and maintenance of ORACLE RAC 2 node and adding a node to this cluster database for high availability.
• Have Good knowledge in R-Config utility (Databases from Non-Rac to Rac).
• Created custom services for RAC database for distribution of load across the nodes.
• Installation and maintenance of Oracle 10g, 11g Data Guard.
• Implemented 11g new features in data guard i.e. Active Data guard for Database Disaster Recovery.
• Installed and maintained STANDALONE servers on ASM, Red hat LINUX
• Hands on experience inGoldenGateinstallation and troubleshooting.
• Have implemented ORACLE Golden Gate for replication
• Have implemented ORACLE Hetrogeneous replication using Golden Gate.
• Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager.
• Worked on configuration of OEM 11g Grid control.
• Migration of databases from non-rac to RAC environments.
• Migrated the Database from Non-ASM to ASM.
• Upgrading databases toOracle 12cfrom Oracle 11gr2
• Performed Data Centre Migrations from Suse Linux to OEL
• Data Guard using physical standby database, Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI.
• Involved in the error checking and testing of theETL procedures,worked withETL groupfor understating mappings for dimensions and facts.
• Used the Data guard Broker to perform switchback and switchover.
• Backup and recovery using RMAN.
• Automated backup strategy using full, incremental backups and cumulative backups using RMAN and OEM.
• Daily health checkup of a database using AWR,ADDM.
• Provided backup/recovery, problem diagnosis, performance tuning, and database upgrade support.
• Providing technical support to Application Support team for performance and database related issues.
• Performed Security Management and accessibility control by managing OS and password file authentication, creating profiles, privileges and roles.
• UNIX shell scripting as and when required based on the requirement.
• Verify and notify for the success of whole migration process and make live production databases.
• Installation, Configuration and Maintenance of Oracle RDBMS Software.
• Creating and maintaining the Oracle databases.
• Createdand managing the database objects such as tables, indexesand views.
• Creating Table Partitioning, creating Index Organized tables, Creating Locally managed Table spaces.
• Created Oracle Tables, Table partitions and Materialized views.
• Logical data modeling using ERwin tool.
• Applying patch set and interim patches whenever required to make the database software up to date.
• Installation of patches, analyzing the issues and proposing solutions.
• Creation of new scripts to automate the procedures to generate statistics on database space management, performance and for proactive monitoring.
• Database Sizing, Table space Management and Rollback Table space Management, Transaction Management and Security Administration.
• Migration of the databases to ORACLE from different RDBMS databases like SQL server,Mysql.
• Performed Transition of Databases from oracle to Solaris.
• Performed cross platform zero down time migration of databases using golden gate.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Involved in I/O tuning by moving data files and redo log files to faster disks.
• Performed Explain Plan analysis for Query Optimization and SQL tuning.
• Performed Database and SQL tuning by using various Tools like AWR, TKPROF, EXPLAIN PLAN, and optimizer hints.
• Effective Production Support and off hour support, support handover, off-shore co-ordination.
• Worked with Metadata Definitions, Import and Export of Datastage jobs using Data stage Manager.

Environment: Oracle 11g/10g, Sun Solaris, Red Hat Linux, Suse Linux, TOAD,ERwin RMAN, SQL server, RDBMS ASM, RAC, Data Guard, Golden Gate, OEM, Grid Control, STATSPACK, AWR, Explain Plan, SQL SERVER 2008, MySql.

Confidential, San Jose, CA

Sr. Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle 11GR2 Real Application Cluster (RAC) 2 node RAC on Linux Environment.
• Migrating single Instance Databases to 2 Node RAC environment.
• Upgraded databases from 10g to 11g.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases on Vmware environment.
• Involved with installation and maintenance of ORACLE RAC 2 node and adding a node to this cluster database for high availability.
• Have Good knowledge in R-Config utility (Databases from Non-Rac to Rac).
• Created custom services for RAC database for distribution of load across the nodes.
• Installation and maintenance of Oracle 10g, 11g Data Guard.
• Implemented 11g new features in data guard i.e. Active Data guard for Database Disaster Recovery.
• Installed and maintained STANDALONE servers on ASM, Red hat LINUX
• Hands on experience inGoldenGateinstallation and troubleshooting.
• Have implemented ORACLE Golden Gate for replication
• Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager.
• Worked on configuration of OEM 11g Grid control.
• Migration of databases from non-rac to RAC environments.
• Migrated the Database from Non-ASM to ASM.
• Upgrading databases toOracle 12cfrom Oracle 11gr2
• OEM Cloud Control 12c Agent installations, plug-ins installations and adding targets to OEM. Monitoring the databases using OEM 12C
• Performed Data Centre Migrations from AIX to Linux
• Data Guard using physical standby database, Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI.
• Backup and recovery using RMAN.
• Used the Tivoli Store Manager tool to store the Backup's for Databases to Tapes.
• Automated backup strategy using full, incremental backups and cumulative backups using RMAN and OEM.
• Monitoring and optimization of database performance through database tuning, system tuning and application tuning.
• Daily health checkup of a database using AWR,ADDM.
• Provided backup/recovery, problem diagnosis, performance tuning, and database upgrade support.
• Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.
• Providing technical support to Application Support team for performance and database related issues.
• Performed Security Management and accessibility control by managing OS and password file authentication, creating profiles, privileges and roles.
• UNIX shell scripting as and when required based on the requirement.
• Verify and notify for the success of whole migration process and make live production databases.
• Installation, Configuration and Maintenance of Oracle RDBMS Software.
• Creating and maintaining the Oracle databases.
• Createdand managing the database objects such as tables, indexesand views.
• Creating Table Partitioning, creating Index Organized tables, Creating Locally managed Table spaces.
• Created Oracle Tables, Table partitions and Materialized views.
• Logical data modeling using ERwin tool.
• Applying patch set and interim patches whenever required to make the database software up to date.
• Installation of patches, analyzing the issues and proposing solutions.
• Creation of new scripts to automate the procedures to generate statistics on database space management, performance and for proactive monitoring.
• Database Sizing, Table space Management and Rollback Table space Management, Transaction Management and Security Administration.
• Migration of the databases to ORACLE from different RDBMS databases like SQL server,DB2.
• Performed Transition of Databases from oracle to Solaris.
• Performed cross platform zero down time migration of databases using golden gate.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Involved in I/O tuning by moving data files and redo log files to faster disks.
• Performed Explain Plan analysis for Query Optimization and SQL tuning.
• Performed Database and SQL tuning by using various Tools like AWR, TKPROF, EXPLAIN PLAN, and optimizer hints.
• Effective Production Support and off hour support, support handover, off-shore co-ordination.
• Designed and Developed Data stage Jobs to Extract data from heterogeneous sources, Applied transform logics to extracted data and Loaded into Data Warehouse Databases.
• Worked with Metadata Definitions, Import and Export of Datastage jobs using Data stage Manager.

Environment: Oracle 11g/10g, Sun Solaris, Red Hat Linux, TOAD,ERwin RMAN, SQL server, RDBMS ASM, RAC, Data Guard, Golden Gate, OEM, Grid Control, STATSPACK, AWR, Explain Plan, SQL SERVER 2008, Data Stage.

Confidential, Columbus, OH

Oracle DBA

Responsibilities:

• Installation, configuration, upgradation and maintenance of Oracle databases of Oracle 10g & Oracle 11g on RHEL.
• Configuring and maintaining of a Two node RAC on Oracle 10g & Oracle 11g.
• Managed users and maintained security, populated databases of Oracle 10g & Oracle 11g on RHEL, Solaris and Windows 2003.
• Upgraded databases from 10g to 11g.
• Implementation of Data Guard for disaster recovery on both 10g & 11g.
• Migration of databases from Solaris to Linux.
• Involved in migration of applications of the clients.
• Configuring ASM with normal and external redundancy.
• Restoring databases from Critical failures.
• Developed backup, restore and recovery strategies, batch processing, performance monitoring, log maintenance and automating functions wherever possible.
• Responsible for scheduling backups.
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters.
• Responsible for logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation, high performance, replication & failover.
• Taking Incremental backup using RMAN.
• Creating tables, tablespaces, users, views and related objects.
• Used SQL*Loader to load data into database tables.
• Implemented procedures to detect the poor database performance, collecting required information, root cause analysis, successfully tuned and improved the performance of the database.
• Tuning performance using Advisors, AWR, ADDM, SQL tuning etc.
• Performed Online and Offline backups with RMAN, export/import and expdp/impdp.
• Implemented Point in time recovery using RMAN.
• Configuration and implementation of Oracle Streams (Advanced Replication) for high availability.
• Working experience in data replication using Golden Gate.
• Performed Schema as well as Table level Replication using Oracle Streams.
• Implemented downstream capture at the destination database using Oracle Streams.
• Installed and Configured Oracle OEM (Oracle Enterprise Manager) Grid Control.
• Tuning SQL queries when the performance is poor.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Implementing backup procedures using Cron Tab.
• Worked on activities such as Query Optimization, Database Consistency Monitoring.
• Used Shell Scripting to backup database.
• Physical and logical data modeling using Erwin tool.
• Responsible for granting required privileges and roles to users.
• Duplication of production databases.
• Renaming and resizing databases.
• Migration of the application data from different RDBMS to ORACLE Databases.
• Migration of databases from non-rac to RAC environments.
• Configuration of Multiple Listeners in the server and Net Service Names for the target databases using NETCA and NETMGR.
• Responsible for Space management and resolving dead lock issues.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF
• Managing table spaces, user profiles, indexes, storage parameters.
• Involved in developing and implementing PL/SQL stored procedures and triggers.
• Involved in PERL for reporting purpose
• Responsible to provide 24 x 7 database administrative activities over different database servers.
• Provided all kinds of DBA support to development teams as well as production support to various applications.

Environment: Oracle 10g, Oracle 11g,Linux, Solaris 10, Window 2003, Oracle Enterprise Manager Database Control, RDBMS, TOAD, SQL*Loader, PL/SQL, UNIX Shell Scripting, PERL, ASM, Data guard, Golden Gate, Oracle Streams, Oracle primavera.

Confidential, Bethpage,NY

Oracle DBA

Responsibilities:

• Worked on Performance Tuning Oracle DBA (10g) on Solaris 10, AIX 5.2.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Installed and upgraded Oracle 10.2.0.1 database to 10.2.0.4.
• Developed a bunch of Index monitoring scripts in order to sort out the unused space occupied in table spaces.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance. Modified and updated the Performance tuning scripts.
• Used Shell Scripting to backup database.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Expertise in creating Oracle tables, Table partitions and Materialized views.
• Managed and monitored the Oracle Real Application Cluster (2 node RAC) running on VERITAS storage.
• Golden Gate installation and maintenance.
• Created custom services for RAC database for distribution of load across the nodes.
• Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers via Toad.
• Creation of materialized views and fine-tuned them for better performance.
• Working Experience with latest TOAD having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace, Query Builder.
• Tuning SQL statements using Explain Plan and STATSPACK.
• Automated data exports and imports using batch files, PL/SQLscripts, SQL*Plus, andSQL*Loader.
• Daily health check up of database health using TKPROF,AWR,ADDM.
• Modified SQL*Loader control scripts to eliminate while spaces generally used for data loading.
• Installed & managed 10g R3 OEM grid monitoring solution and deployed agents.
• Performed Logical backup using and full/partial export/import and Data Pump.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Monitor Database Performance by scanning the Oracle Data Dictionaries for each day and know the problem SQLs.
• Created bit-map Indexes for data warehouse databases.
• Configured Physical and Logical Standby database for reporting environment.
• Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Clear documentation was prepared on all the processes like program specification, bugs fixing log & change requests for future reference.
• Proactively managed the databases; set up notifications, alarms using shell scripts for managing any exceptions in day to day management of the databases.

Environment: Oracle 10g, Solaris, UNIX RDBMS, VERITAS, OEM, EXPLAINPLAN, TKPROF,, SQL PLUS, AIX, Oracle 10g RAC, Data Guard TOAD, Golden Gate

Confidential

PL/SQL Developer, Jr. Oracle DBA

Responsibilities:

• Installation and maintenance of Oracle 9i/10g on Linux OS
• Installed, upgraded and patched Oracle installations.
• Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.
• Worked on user management mainly on grants, privileges, roles and profiles.
• Designing and developing SQL procedures, query performance tuning.
• Performed hot and cold backup and recovery using RMAN and UNIX Scripts
• Monitored database and SQL performance using Stats pack, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
• Monitored database and system performance.
• Configured the Event Manager to notify support personnel.
• Worked on application and database security (data access, passwords, network, etc).
• Handled daily production problems/change requests with Oracle.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).
• Proactively managed the databases; set up alarms for managing any exceptions in day to day management of the databases; pre-empted and prevented issues, disasters from happening.
• Monitoring tablespace issues, creating tablespaces and adding datafiles.
• Involved in session management and monitored the critical wait events, blocking sessions in the database.
• Use ofSQL*Plusto run batches of PL/SQLscripts
• Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.
• Tuning test and production database by altering the parameters.
• Export and Import of database objects to copy from one database to another database.
• Investigating suspicious database activity using Auditing.
• Involved in query optimization and using rule based optimizers and cost based optimizers.
• Used Shell Scripting to backup database.
• Detecting and correcting instance performance problems. Locating and tuning SQL statements.

Environment: Oracle 9i, Window NT/2000/2003, Linux, Unix, Oracle Enterprise Manager, MS SQL Server 7/2000, RDBMS, VERITAS Net backup, PL/SQL, TOAD 7.5, Shell Scripting, HTML, SQL PLUS, Stored Procedures, Triggers.