Ankita

Senior Oracle DBA

908-***-****

PROFESSIONAL SUMMARY

Oracle DBA with more than 6 years IT experience in Oracle products on multiple platforms and environments spanning Finance, IT, Insurance, Communication and Tech sectors.

Experience as On-Call24x7productionDBA support, application/development DBA.

Extensive knowledge on database administration for Oracle 8i, 9i, 10g, 11g and 12C with experience in very large scale database environment and mission critical large OLTP and OLAP systems.

Experienced in Oracle installations, upgrades, migration, configuring logical/physical architecture, SQL, Tuning, database access and Security and auditing.

Extensive knowledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/ incremental / cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).

Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable tablespaces.

Have great experience of database recovery methods like PITR (point-in-time-recovery), TSPITR (Tablespace-PITR).

Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.

Extensive experience in Data guard configuration, implementing and monitoring standby databases.

Implemented FSFO (Fast start failover) on databases and configuring disaster recovery. Also proficient with new 11g features such as Active Data guard and Snapshot standby database.

Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status via DGMGRL and GUI.

Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Stats pack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzed SQL trace dumps for 9i/10g/11g.

Experience in database cloning with RMAN, Capacity Planning, Database Refresh and patch management.

Good experience in applying PSU and Critical Patch Update (CPU Patches) using OPATCH Utility on Databases, Application Servers and Middle Tiers.

Installation and maintenance of Golden gate 11g.

Extensive experience in configuring and implementing ASM(Automatic Storage Management) and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology, Log Miner.

Responsible for Loading Data on different databases using SQL*Loader .

Extensive knowledge and experience on Data Warehouse using ETL.

Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers and extensively used TOAD for querying databases etc.

Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) / Network

Proficient with UNIX Shell Scripting, Partitioning, Rebuilding Indexes,Gathering Statistics, Logical and Physical database design.

24*7 production database support with Support to developers & end-users.

TECHNICAL SKILLS

Databases

Oracle 12C,11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i,8i, MYSQL, SQL Server 2008

OracleProducts

Oracle Real Application Cluster 10g/11g/12C, OEM 12C, Data guard, Import & Export, Data pumps, Data Masking, Automatic Storage Management, Oracle 10g/11g/12c (Grid Control),Golden gate, Oracle Fail Safe, RMAN, Transparent Data Encryption.

OperatingSystems

Oracle Linux, HP UNIX 11i, Red Hat Enterprise Linux (RHEL) 4.x, 5.x, 6.x, Sun Solaris 5.8, 5.9, 5.10, Windows XP/2003/2008

Languages

SQL, PL/SQL, Unix shells scripting, PostgreSQL 8.0+

Tools & Utilities

SQL Trace and SQL tuning Advisory, SQL* plus, ADDM, DBCA, Log Miner, TKPROF, AWR, ASH, Toad, Putty, ETL tool, DBUA, DBCA, OPATCH, Statspack,DB Verify, SRVCTL,CRSCTL, ASMCMD, ADRCI, SQL Loader.

Education Details:

Bachelor of Computer Engineering, Gujarat University, Gujarat, India

Diploma in Computer Engineering, Gujarat, India

TRAINING & CERTIFICATION

Oracle certified SQL expert.

Database Administrator Workshop : Oracle Database 10g Administration -I

Database Administrator Workshop : Oracle Database 10g Administration -II

PROFESSIONAL EXPERIENCE

Cisco, Richardson, TX Mar 2013 – May 2016

Oracle DBA

Cisco Systems, Inc. is an American multinational technology company headquartered in San Jose, California, that designs, manufactures and sells networking equipment. It is the largest networking company in the world.

Responsibilities:

Experience in Design, Creating and maintaining Oracle Databases 9i, 10g and 11g from the scratch on UNIX, LINUX, AIX and WINDOWS environments.

Installed Grid Infrastructure Software on new Linux Servers for 2 node and 3 nodeRAC and Failover environments.

Installed 10g & 11g 2 Node RAC &Cluster ware installation on RHEL 5.x server.

Upgraded oracle database from 11.2.0.2 to 11.2.0.3 and from 11.2.0.3 to 12.1.0.1.

Extensively worked in setting up physical standby database using Data guard.

Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases.

Configured Oracle Data guard(ADG) for Oracle Disaster recovery on standalone databases using11g ACTIVE DUPLICATION.

Setup the standby via OEM cloud control 12c for several databases.

Performance tuning of queries consuming Excessive Resources or slow running queries by providing Required Hints to the Query.

Daily Health Check Up of the Database and SQL Queries using OEM, Statspack, AWR, ADDM andTKPROF.

Applied necessary Patches during installation and also in up-gradation of databases on Oracle database versions 10g and 11g.

Experienced in managing Daily Online backups (Level-0 and Level-1) and Archive Backups using RMAN.

Cloned 10g and 11g databases using RMAN duplication (with and without backup).

UsedDatabase Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle10gR2 to the latest Oracle 11gR2 and applied patches as required.

Handy in utilizing datapump tool for exporting and importing the data between databases.

Migration of databases from 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.

ASM Disk storage and user Management.

Real time data integration using Golden gate 11g.

Having good exposure in user management, table space management, session management, undo management issues.

Experience with remedy ticketing tools for resolving the tickets.

UNIX shell scripting as and when required based on the requirement

Provided 24x7 support and On-Call rotation when needed for very large databases.

Environment: Linux, Solaris 10, Hp-Unix, OEM 12c, Oracle 9i,10g,11g,12C, Shell Scripting, OEM, SQL*Plus, PostgreSQL 8.0+,XMing, Putty, Data Pump, RMAN, OPATCH, ASM, Data Guard, Oracle streams, AVAMAR.

Simplex Services Limited, India July 2012 – Jan 2013

Oracle DBA

Simplex Solutions was incepted with the objective of enabling organizations to effectively manage their IT infrastructure Simplex is the brainchild of a group of like-minded individuals who bring with them extensive experience in the IT and Business space

Responsibilities:

Supported different Oracle 10g and Oracle 9i Databases of Production, Testing, Staging and Training.

Installed and configured 2 NodeRAC on 10gR2.

Installed 13 standalone servers on ASM and migrated databases to ASM environment.

Configured Oracle Data guard on 10G for Oracle Disaster recovery. Worked on both Physical standby and Logical standby databases and resolved issues in DR environment.

Converting Physical standby to Snapshot standby for testing purposes.

Achieved High Availability, Data Protection and Maximum performance by maintaining both physical and logical standby databases.

Implemented Oracle database backup & recovery solutions using RMAN and export/import.

Restored and Recovery of databases at the times of occurrence of critical failures.

Performed cloning and refresh of Database from production environment to test environment using RMAN Duplicate database and Data pump import export.

Upgraded databases using Database Upgrade Assistance (DBUA).

Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.

Involved in optimizing SQL statements using Indexes and Hints.

Created and modified PL/SQL objects like Packages, Stored Procedures and Triggers.

Responsible for configuring and taking level 0 and level1 incremental RMAN backups and resolving issues arising out of those.

Rebuilt indexes for better performance of Oracle database.

Oracle SQL*LOADER, Oracle Export/Import Tools and utilities.

Responsible for Data load on different databases using SQL*Loader.

Developed PL*SQL stored procedures, Indexes, cursors and database triggers to implement business rules.

Managing table spaces, user profiles, indexes, storage parameter’s.

Developed UNIX shell scripts to perform the above tasks efficiently.

Responsible to provide 24 x 7 database administrative activities.

Environment: Oracle 9i/10g, Sun Solaris, windows NT/2000/2003, RHEL, RMAN, DBCA, Data guard, Oracle Enterprise Manager, EXPLAIN PLAN, Export/Import, Cloning, OEM, STATSPACK, TKPROF, Putty, PL/SQL, TOAD7.5, Shell Scripting, HTML, Stored Procedures, Triggers.

HDFC, India May 2010 – June 2012

Oracle DBA

HDFC is an Indian banking and financial services company headquartered in Mumbai, Maharashtra. HDFC Bank is the second largest private bank in India as measured by assets. It is the largest bank in India by market capitalization as of February 2016. It was ranked 58th among India’s most trusted brands according to Brand Trust Report

Responsibilities:

Installed ORACLE 10g database and grid architecture in Linux 64 bit server.

Monitoring all the databases using Enterprise manager 10g.

Worked in troubleshooting 2node and 4node RAC and implemented 11g New ASM features.

Extensively worked in setting up physical standby database using Data guard and implemented new 11g feature such as Active Dataguard and Snapshot standby database.

Implemented switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases.

Creating and managing user accounts, locally managed tablespaces .

Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.

Extensively worked with ASMCMD for managing ASM.

Performed DR drill activity for testing.

Applying patch set and interim patches using OPATCH for upgrading the binaries.

Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.

SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF, SQL Tuning Advisory.

Installed SQLTXPLAIN (SQLT) Tool that helps to diagnose SQL statements performing poorly.

Used Oracle 10g/11gAWR & ADDM to monitor database activities and performance tuning.

Performed Range Partitioning as a cause to improve the performance of the database.

Proactive performance monitoring, and capacity planning for future database and server growth using OEM.

Applied necessary Patches during installation and also in up-gradation of databases on Oracle 11g database versions.

Extensive Experience with Change Control Management for all database changes.

Performed Cross platform migration using transportable table spaces and RMAN.

Data Refresh from Production to Development and Test environments using Data Pump export/import

Involvement in space management, rectification of lock problems, user management.

Supporting Application developers with various performance, connectivity and security related issues on various projects.

Scheduled Jobs and Backups using windows scheduler.

Experience in backups and recovery using RMAN shell Scripts.

Involved in 24 7 Production Support with on-call pager.

Environment: Oracle 10g, 11gr2, HP-UX, REDHAT LINUX, SUN SOLARIS, IBM AIX, OEL 5.8, OEM12c, RAC, Oracle Fail Safe 3.x, RMAN, EXPDP/IMPDP, Partitioning, ASM, DBFS, Data guard including DGMGRL, Performance tuning, OPATCH Utility, TOAD, DB Artisan, SQL Developer, Shell Scripting.

Contact this candidate