Oracle Dba

Darshna Patel

BS Computer Science

********@*****.*** 267-***-****

Summary

Over 10 years of experience as Oracle DBA in very large Production Environments with Database implementation on UNIX (Linux, HP-UX, IBM-AIX) and Windows.

Extensive experience in databases on Oracle 10g, 11g R2 and 12c.

Upgrade oracle databases from 11g to 12c.

Experience in Installation & configuration of Oracle 11g/12c Real Application Clusters (RAC)

Experience on Oracle Enterprise Manager-Database Control.

Experience in data transfer utilities like Data pump, import/export and rman.

Upgradation of database from Oracle 10g to Oracle 11g (11.2.0.3 to 11.2.0.4) & 12c

Experience in handling recovery issues using rman.

Configured ASM for Oracle databases.

Performance Tuning experience using Explain Plan, Autotrace, TKPROF and Statspack utility and Tuning database using AWR, ADDM.

Proficient in handling databases on Oracle 10g/11g R2.

Experience on Backup & recovery using RMAN and import/export on 10g/11g & 12c.

Extensive experience in database cloning and refreshing. Experience in Toad (Tool for Oracle Application Developers) and PL/SQL DEVELOPER for database maintenance tasks

Additional responsibilities have been Interaction/Communication with Oracle for Technical Support and handling day to day problems, assisting developers and other users in writing complex queries.

Understand Shell Scripting & able to write simple codes for daily repetitive DBA tasks.

Experience monitoring Oracle RDBMS availability, database exports, tablespace, and extents reports.

Automated Storage Management (ASM) for 11g/12c databases.

Experience in setting up Grid Control.

Comfortable with both command-line and GUI interface.

Oracle Backup and Recovery (Cold backup / Hot backup / RMAN backup).

Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import).

Strong experience in OEM (Oracle Enterprise Manager), SQL* Net, and SQL*PLUS, PL/SQL Developer and TOAD.

Proficient in writing UNIX Shell scripts to automate business process & daily backup.

Good knowledge on logical and physical Data Modeling using normalizing Techniques. Created Tables, Views, Constraints, Index.

Developed Complex Database objects like Stored Procedure, Functions, Packages and Triggers using SQL and PL/SQL.

Partitioned large tables using range partition technique.

Good knowledge of key oracle performance related features such as Query Optimizer, Execution Plan and Indexes.

Created Shell Scripts for invoking SQL Scripts and Scheduled them using crontab.

Hardworking, result oriented good interpersonal and communication skills.

Professional Experience

PHILADELPHIA DISTRICT ATTORNEY—Philadelphia, Pa 5/2009 to Present

Oracle DBA/Developer

•Installed 6 Oracle 10/11g software into 3 Linux environments

•Applied Oracle patches to development, Qa, production environments

•Configured Oracle ASM 4 times and non-RAC database on Linux server

•Created, deleted, modified data-files based on usage

•Recreated corrupted control file to revive Oracle in 2 Linux environments

•Hand-coded new tables to support new functionality

•Custom-coded packages containing procedures to retrieve data from ePen tables and distribute data to relevant case management tables

•Modified existing procedures to move data, add new information and convert data formats

•Located slow SQL queries then utilized Used Automatic Database Diagnostic Monitor (ADDM) to get performance recommendations then optimized 15 SQL queries for faster data retrieval

•Assisted java programmer in the creation & modification of 60+ SQL queries for application use

•Used data-pump bi-monthly to refresh all environments and SQL loader utility to load data and performing export as supplement to daily backup

•Setup and managed database security by creating new users, roles, profiles

•Performance monitoring using Oracle Enterprise Manager (OEM) to locate slow queries, data integrity, profile usage

•Setup cron jobs for daily data feeds

•Installed 10g/11g databases and Clients on Linux environments

•Configure ASM packages on Linux

•Installed ASM disks

•Manage ASM disk groups via ASMCMD and database control

•Reconfiguring Services via srvctl utility

•Configured and Administered Oracle 10g/11g RAC high availability on ASM

•Installed and configured OEM Agent

•Upgrading database from Oracle version 10g to 11g and 11.2.0.3 to 11.2.0.4

•Used Export/Import and Data pump utilities for full/partial backup

•Optimal Sizing of Instance memory pools like SGA, DB buffers, shared SQL area, log buffer based on the requirements

•Maintained different homes for Oracle 10g/11g and ASM

•Created and maintained additional ASM disk groups according to the necessity

•Restored & recovered production database via hot backup using RMAN

•Written RMAN scripts for taking backup and deleting archive log files exceeding the retention

•Automated several scripts to monitor various processes, sessions and taking back up’s using crontab

•Monitoring various scripts and alert log files to ensure that database is healthy

•Monitoring and troubleshooting space related issues

•Implementing oracle security as per the company standards

•Monitor production and non-production database through Grid Control

•Optimize queries, startup, shutdown and configure agents to communicate with grid control for various different maintenance tasks

•Designed logical and physical data model for case management system.

•Worked closely with lawyers and paralegals to establish problem specifications and system designs.

•Participated in the development of new PL/SQL procedures, functions and triggers and also updating the old ones based on the change request.

•Extracted data from XML file and loaded it into the database.

PHILADELPHIA DISTRICT ATTORNEY—Philadelphia, Pa 7/2007 to 5/2009

Java Programmer

•Coded over 10 Hibernate entity pages to connect to Oracle tables

•4X productivity increase automating letter generation & standardized

message

•Assisted in 8 requirements gather sessions with internal and external clients to plan, develop and test new functionality

•Updated case management system for processing state petitions

• Utilized Log4j for logging statements during development

• Used Cascading Style Sheets throughout entire application to insure

proper design as well hand-coding a separate print CSS

• Utilize Maven build on Unix platform

• Participated in 7 full System Development Life Cycles (SDLC) projects including

Requirements Gather, Design, Implementation, Testing, Deployment

Skills

Operating Systems:

Windows, Linux

Programming Languages:

SQL, PL/SQL, Unix Shell, Java, JSP, HSQL, C, C++

Framework:

Hibernate

Web Servers/Protocols:

FTP

RDBMS/DBMS:

Oracle 10g, Oracle 11g

Third Party Tools:

ASM, Import Export, Datapump, SQL*Loader, Statspack, AWR, ADDM, Oracle Scheduler, Tkprof, Data Pump, Shell Script, RMAN, AWR, Toad, Cron, Eclipse, Subversion, Maven

Education

BS Computer Science—Guru Ghasidas University—Bilaspur, India 5/2002

Oracle University Training: Oracle Database 10g: Administration, Introduction to SQL, Program with PL/SQL, Adv. Programming with PL/SQL

“I was extremely impressed with her keen ability to understand not only what was needed to move forward in the project, but also her ability to work both independently and as part of a team. Darshna would make a great asset to any organization”

Kimberly (Zelner) Esack

Assistant Supervisor of the Economic and Cyber Crimes Unit, DA’s Office

“She combines those qualities with congeniality and camaraderie which make her a great colleague

with whom to work.”

Varghese Kurian

Assistant District Attorney, DA’s Office

“Darshna is knowledgeable in a vast range of areas including performance monitoring, security, configuration, backups and data migration.”

Joe Murphy

Network Admin, DA’s Office

“She was highly motivated,

educated, eager to learn and contributed whatever she could to make

herself valuable to the group.”

ReVae A. Boyd

Project Manager, DA’s Office

“Darshna is a highly intelligent and ambitious individual. She has proved time and again she's capable of completing and mastering every task assigned.”

Carmen Mak

Server Admin, DA’s Office

Oracle DBA 11g/12c -

Oracle GoldenGate 12c Fundamentals -

NoSQL using Cassandra -

PostgreSQL -

Contact this candidate