Shital Modi

GC – Permanent Resident

Contact: 214-***-****

Email id: acsbeb@r.postjobfree.com

Address: **** ********** ******,

Apt#1325, Richardson, TX 75081

CAREER OBJECTIVEs

I am looking for a challenging position as an Oracle DBA that will allow me to utilize my experience and knowledge and be an essential part of a team. I bring forth new and innovative ideas for growth and management within the organization.

PROFESSIONAL SUMMARY

Around 4+ years of Experience as Oracle 10g/11g/12c and MSSQL 2005/08/12 DBA providing support to Production, Test and Development Instance environment.

RDBMS knowledge.

Administered databases on AIX/Linux and Windows platform.

Experience in Installation, Configuration and Re-Configuration of Oracle Database on AIX, Red hat Linux 4/5/6 and Windows servers.

Strong Trouble-shooting, Problem solving, Analytical & Design Skills.

Design, Creating and Maintaining the Database.

Capacity Planning and Space Management.

Online and Offline backups and recovery.

Backups and recovery using RMAN and Scripts.

Experience using RMAN with Catalog database.

Planning and Scheduling Backups.

Experience in Logical backups using Original Export/Import and Data Pump utility.

Involved in recovery of datafiles, redologfiles and control files.

Experience in Performance Tuning of SQL statements and Database using tools/ reports like Explain plan, ASH/AWR/ADDM.

Experience in Configuring, managing and monitoring both Physical standby and Logical standby databases using Data Guard.

Experience in Migration from oracle databases to MS SQL database.

Expertise in Alert Monitoring and Ticketing.

Experience in working with a Team size of 4 to 32 DBAs.

Expertise in PL/SQL programming.

Experience in backup/restoration using native/TSM/Light speed.

Experience in deploying, executing package using SSIS and BIDS.

Set up replication SSMS.

Worked as a part of team in 24x7 production environment and provided on-call and day-to-day support

Have Strong interpersonal skills with the ability to interact with end-users, managers, technical personnel, etc. Excellent work ethics and team oriented with strong analytical and leadership qualities.

TECHNICAL SKILLS

Database

Oracle Database Server (9i, 10g,11g,12c) administration,MS SQL Server 2005/08/2012,BIIDS

Operating System

Windows XP / 2003 / 2008 / 7 / 8, Red Hat Enterprise Linux, IBM AIX

Oracle Utilities / Reports

SQL* Loader,Exp/Imp, Data Pump Exp/Imp, External Tables,ADDM,ASH,AWR,STA

Tools

SQL*Plus, Toad 9/10, Oracle SQL Developer,SSMS 2005/08/12, Basic SSIS,Light speed,BIDS

Software Applications

MS Office Suite, Adobe Suite, FileZilla,BMC Blede Logic

PROFESSIONAL CERTIFICATIONS

Oracle 10g OCP Certified – May 2010

Oracle 10g OCA Certified – April 2010

Oracle 10g SQL Expert Certified – February 2010

ACADEMIC BACKGROUND

Master of Computer Application (MCA) - June 2009

VEER NARMAD SOUTH GUJARAT UNIVERSITY – Surat, India

Bachelor of Sciences in Mathematics – April 2005

VEER NARMAD SOUTH GUJARAT UNIVERSITY – Surat, India

PROFESSIONAL EXPERIENCE

Blue Cross Blue Shield April 2015- Present

Projects: BA, RETAIL, ARIAL, MS 2012 UPGARDE

Database: Oracle Database Server 11gR2, MSSQL 2005/08/12

Position: Oracle\MSSQL DBA

Environment: Linux/Unix, WINDOWS 2005/08/12

Working on ticket system for day to day trouble shooting.

24x7 on call DBA support for DEV/TEST/PROD environment.

Database admin copy using data-pump.

Backup / Restoration MSSQL database using SSMS/Light speed.

Take Native, Light speed and LSTSM backups.

Schedule backup and maintenance jobs.

Remove tables, Procedure from replication.

Deploy/Execute packages using SSIS/BIDS.

Export/import tables in different environment.

User, schema and space Management.

Capgemini April 2014-November 2014

Client: P&G, USA

Database: Oracle Database Server 11gR2 /12c

Position: Oracle DBA

Environment: Linux/Unix

Role & Responsibilities:

Worked HP ticket system for day to day trouble shooting.

Performing daily and weekly health checkup of Production, QA and Development database to ensure 0% downtime.

Involved in Database Upgrade activity.

Involved in troubleshooting activities like working on ORA- alerts which are generated from OEM/alert logs & if required working with ORACLE SUPPORT to resolve the issue.

Involved in DBA activities like Index rebuilding, analyzing objects, table rebuilding, tablespace monitoring, cloning.

Interacting with client to help them to resolve their database related issues.

Used Data pump for exporting and importing tables, schemas and table spaces.

Performs ongoing tuning of the database using tools/ reports like Explain plan, ASH/AWR/ADDM reports.

The DBA will carry out the daily, weekly and monthly tasks as specified

•Daily Tasks

•Verify that all the databases/services are up and running.

•Verify success of database daily backups (export/hot/archive log).

•Verify database resources like…

•Tablespace Management.

•Rollback or Undo Segment Management.

•Temp Tablespace Management.

•Archive Log/Redo log Management and

•Disk Space Management to ensure sufficient disk space.

•Weekly Tasks

•Look for any Security Policy Violations.

•Archive all alert logs to history.

•Trace files management.

•Weekly backups(COLD/Tape backups)

•Weekly on call support.

•Monitoring/supporting weekend maintenance window.

The Surat District Co-op. Bank Ltd March 2013-April 2014

Project -1: Bank CBS, MIS and DR Database server

Database: Oracle Database Server 11gR2

Position: Oracle DBA

Backup Environment: TSM

Environment: IBM AIX-6

Role & Responsibilities:

Supporting 24/7 Production databases along with Logical –MIS and physical –DR standby database (Data Guard).

Installation, configuration of oracle database server on windows platforms in test environment.

Performing daily and weekly health check.

Basic database environment troubleshooting.

Scheduling and managing batch job.

Patching databases on various platforms.

Upgrade and migration of database.

Managing users and security by creating roles and profiles.

Ensured database security using appropriate roles and privileges.

Creation and Maintenance of schema objects such as tables, indexes, and views.

Performing backups using RMAN and Import / Export Utilities based on defined policies.

Periodically checking physical backups by restoring on Test database.

Interaction with Oracle Support Services to resolve mission critical issues.

Implement and maintain the methodology and procedure standards for the effectiveness in the access, backups and recoveries.

Creation of various database objects as per requirement.

Interacting with Clients / Application Developers to fulfill their database requirements.

Monitoring database objects and auditing as per defined policies.

Project -2 RTGS and DR database

Client: RBI

Database: Oracle 11g R 2

Position: Oracle DBA

Environment: Windows 2008 64 bit

Role & Responsibilities:

Capacity Planning and Space Management.

Supported Production and Physical Standby-DR databases to make them available 24x7.

Daily and weekly backup using original export/Import and RMAN as per defined policies.

V2 solutions Pvt. Ltd. August 2012-March 2013

Client: Allenlund, USA

Database: Oracle 10g R 2

Position: Oracle DBA

Environment: RHEL

Role & Responsibilities:

Installed 10.2.0.4 database on TEST Environments.

Regular Monitoring of Alert Log Files on Day-to-Day Basis.

Creating database users, granting roles and privileges to users.

Communicating with management, development teams, vendors, systems administrators and other related service providers.

Database backup & Recovery for no archive and archive database using RMAN.

Used Data pump for exporting and importing tables, schemas and table spaces.

Configuration of Listener and Net Service names using NETCA and NETMGR.

Taken database, schema and database level backup using Data pump utility.

XDuce Infotech Pvt. Ltd. June 2010-July 2012

Client: GIDC (Gujarat Industrial Development Corporation)

Database: Oracle 10g R 2 Node 2

Position: Oracle DBA

Environment: Windows

Role & Responsibilities:

Installed 10.2.0.2 database on TEST Environments.

Providing process driven support to end users and application developers. This involves troubleshooting user problems, handling Tickets and Change request using internal service Desk.

Regular Monitoring of Alert Log Files on Day-to-Day Basis.

Creating database users, roles and responsibilities.

Involved in recovery of datafiles, redologfiles and control files on the test environments.

Logical backup using export/import and Data pump.

Configuration of Listener and Net Service names using NETCA and NETMGR.

Mudra communication Pvt. Ltd. December 2009-May 2010

Database: Oracle 10g R 2

Position: Oracle PL/SQL developer

Role & Responsibilities:

Implemented stored procedures, procedure, function, triggers as per requirements.

Data loading using External tables.

PL/SQL and SQL tuning.

Uploading flat file data using Oracle utilities.

Contact this candidate