Manager Oracle

*

Ms. Ankita Mehani

Cell: +61-041*******)

SUMMARY

• 2+ years of on-site experience with proven expertise in supporting and performance optimization of Database.

• Proficient Oracle Database Administration and RAC installation, maintenance and administration.

• Installed configure 10g Grid control manageability monitor for RAC and Non-RAC databases.

• Working experience in performance tuning using Grid control, and AWR.

• Experience in Disaster recovery support using Data Guard.

• Oracle 11g/10g/9i - Installation & Configuration of Oracle databases on Unix, Linux, Solaris and Windows.

• Worked with Large Live Databases (10TB Plus) management with zero down time.

• Provided 24/7 Production support, Performance Tuning & Query Optimization of SQL statements

• Successfully utilized performance enhancements features of Oracle to optimize the batch processes.

• Experience in installation, configure and administration of Oracle Golden gate for real time replications.

• Experience implementing Streams on Oracle 10g server.

• Strong in using tools such as SQL*Plus, TOAD, SQL Developer and SQL*Loader.

• Experience in schema structure design and involved in estimation and optimization of data storage.

• Experience in utilizing newer Oracle tools and methods like the use of External Tables, merge statement, Pipelined functions and 10G features.

• Working experience with TKPROF, RMAN, SQL*Loader, Data Pump utility and EXPORT/IMPORT.

• Experience in different phases of Software Development Life Cycle, which include Analysis, Design, Development and Testing.

• Good knowledge of logical and physical data models.

• Sound working knowledge in UNIX Shell Scripting (KSH, AWK, SED).

• Exceptionally Good Team Player and ready to learn the business Logic and new skills.

• Excellent communication skills with active participant in meetings related to Business and IT groups.

• Knowledge of Designing, Implementing and Supporting Oracle data warehouse, Star and Snowflake.

• Knowledge of handling big data using Hadoop’s Pig and Hive.

• Knowledge of working with Non-relational database, i.e. Mongo DB.

• Knowledge of data visualization using R-studio and Tableau. TECHNICAL SKILLS

Databases: Oracle9i/10g/11g, Big data – Hadoop Pig and Hive Programming Languages: SQL, PL/SQL, UNIX Shell Scripting (KSH), C, C++, R (Computing Language) Operating Systems: MS-DOS, UNIX, Linux, Solaris, WINDOWS 95/98/2000/XP Query Tools: TOAD, SQL*PLUS, SQL Developer

Other Tools: Informatica PowerCenter 8.1, SQL*Loader, Erwin, MS-Office, MS-Visio, MS-Project, AutoSys

CERTIFICATIONS

Masters in Information Technology (Monash university – Australia) Completing in Nov/2015 9i Oracle Database Administrator Certified Professional (OCP) Bachelors in Computer applications (Jodhpur National University – India) MASTERS AT MONASH UNIVERSITY

• Participated in Artificial Intelligence Project using various search algorithms such as BFS, DFS, A*, UCS, Alpha-Beta, Min-Max.

• Accomplished distinction in Project Management with Project using Customer relationship manager and Enterprise resource planning.

• Distinction in Big data with project including oracle database, Hadoop’s Pig, Hive and Java framework.

• Completed Industry experience and Professional practice using agile methodology in a team of four.

• Received distinction in a project including use of govt. open dataset, Storing in MONGO DB, and visualizing it using R-studio (R Language) and Tableau.

2

PROFESSIONAL EXPERIENCE

CA Technologies, Sunnyvale, CA Oct ’11 to Oct ‘12

Oracle DBA, Operations Group

CA Technology is a Credit card authorization company with critical and challenging customer facing application, which cannot support any downtime.

Responsibilities:

• Worked exclusively on Golden Gate Unidirectional and Bidirectional replication

• Used DATA PUMP/Export-Import using flashbackscn for initial loading of Goldengate

• Planned and applied strategies like sequence jumps to avoid collisions in bi-directional replication

• Installed Oracle Database 11g with Real Application Cluster (RAC) with ASM in Linux environment

• Worked on various 11g features like Interval partitioning, Active dataguard, invisible indexes etc.

• Tuned databases for memory tuning by adjusting SGA, Redo log Size and prioritizing oracle processes

• Used and Working on 10TB of databases

• Involved in performance fine-tuning of the queries/reports using PL/SQL and SQL Plus

• Worked on development of PL/SQL stored procedures, Triggers

• Performed Daily Monitoring of Oracle instances using Oracle Enterprise Manager

• Monitoring and maintenance of multiple databases for production, development, testing and Staging purposes using utilities like OEM and Toad

• 24 X 7 on call support of all production environments in --group supported by our team

• Administered Technical support to users, troubleshooting database performance and availability issues

• Written Shell & Perl scripting which monitors the server’s performance and logs output on periodic basis to database Environment: Oracle 11g/10g, RAC, Oracle Golden Gate, DataPump, Toad, DB Artisan, SQL developer, RMAN, Red Hat Linux, Shell scripts, HP-Unix.

Wells Fargo, San Leandro, CA Oct ’10 to Oct ’11

Oracle DBA, WholeSale Group

This was the most Challenging Application in the Entire Wholesale Wells Fargo Group. It was a customer facing app and could not support any downtime. It was an integration project and I was involved in a lot of performance tuning. Responsibilities:

• Installed Oracle Database 11g with Real Application Cluster (RAC) with CRS and ASM in SOLARIS environment

• Configured RAC Physical standby database for RAC primary using ASM file system

• Worked on creation and deletion of RAC resources like listener/instance and database

• Tuned databases for memory tuning by adjusting Buffer cache size, log switches and reducing check pointing, increasing sort area sizes, shared pool area, prioritizing oracle processes and increasing SGA overall

• Working on 4TB of databases

• Setup, Implemented and documented Data Guard Fail-Over/Switch-Over/Read-Only scenarios in RAC

• Performed Extensive Replication and Migration Using Oracle Golden Gate

• Created (Dataguard) physical standby database as DR Solution for production database using RMAN create standby database command, also setup Data Guard Broker to manage data guard environment

• Planned, Implemented and documented the RMAN backup strategy for new and Existing RAC and Non RAC databases by configuring channels, allocating space for Backup Sets

• Used DATA PUMP/export import to instantiate SCN to avoid conflict at destination, created different rule sets to propagate and apply process

• Involved in performance fine-tuning of the queries/reports using PL/SQL and SQL Plus

• Worked on development of PL/SQL stored procedures, Triggers

• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, monitor users, table spaces, memory structures, rollback segments, logs and alerts

• Monitoring and maintenance of multiple databases for production, development, testing and Staging purposes using utilities like OEM and Toad & Automation of production tasks

• 24 X 7 on call support of all production environments in --group supported by our team

• Administered Technical support to users, troubleshooting database performance and availability issues

• Written Shell & Perl scripting which monitors the server’s performance and logs output on periodic basis to database Environment: Oracle 11g/10g/9i/8i, RAC, SharePlex Oracle Golden Gate, DataPump,Toad,DB Artrisan,Veritas, Volume manager, SQL Developer, RMAN, Solaris 8/10,Shell scripts, HP-Unix.

Contact this candidate