Oracle Database Administrator

Shweta Shalini

**** ***** ****

Alpharetta,GA

email-id: ******.*******@*****.***

Mob: 470-***-****

ORACLE DBA Consultant

Looking for a challenging and rewarding career in Database Administration and Information Systems which provides challenging opportunities to implement my acquired skills and to acquire in depth knowledge about the profession to contribute for the growth and success of the organization.

WORK EXPERIENCE

Oracle CORE DBA

Capgemini India Private Limited – Bangalore, Karnataka, India – Mar 2014 to Mar 2017

Total Exp: 3.5+ Years

Projects Description: UK-DCS (Multi-client support)

Client Name: Direct Line Group, UBM plc, Anglian Water Services

Database versions: Oracle 10g, Oracle 10gR2, Oracle 11g and Oracle 11gR2,Oracle 12c

Operating systems: HP-Unix, AIX, Linux & Windows

Responsibilities:

3+ years of Extensive Oracle database administration and development of 100+ databases.

Experienced in Installation, Upgrade, Patching, Monitoring, Performance Tuning, Database Backup and Recovery on Unix and Windows environments based on the requirements gathered.

Experienced in Oracle Database cloning, DR-drills, trouble shooting and System Administration.

Good Knowledge of Data Modelling & Data Warehousing Concepts and also possesses a good programming knowledge using SQL*Plus and Oracle.

Create and develop the database objects like Tables, Indexes, Triggers, Stored Procedures etc.

Effective troubleshooting of database for performance problems

Installation of Oracle 11gR2 Grid, Client and RDBMS software on windows machines.

Cloning the production databases using RMAN. Experience with user-managed backup and recovery, RMAN backup and recovery with or without catalog, full back up, incremental backup, cold and hot backup.

Space management (Sizing of Tables, Indexes and Table spaces)

Configuring data guard - Physical stand by in RAC environment.

Experience in using database tools like Oracle Enterprise Manager (OEM) database control, SQL * PLUS, Toad, SQL loader, RMAN

Good knowledge of software development life cycle (SDLC)

Experience in Data Pump, Export, Import, Scheduler, Jobs, Unix CRON and SQL*Loader utilities

Ability to manage multiple project tasks with changing priorities and tight deadlines

A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of Challenges

Strong listening, interpersonal and analytical skills.

Applying Critical Patch Update (CPU) Patch using opatch utility.

Administration of RAC databases.

Performing data cleanup activities (Data Purging)

Creating database links and synonyms for end users.

Monitoring locks, active sessions, sessions per server total sessions etc.

Analysing Tables & Schemas, collecting system statistics, reorganizing tables and rebuilding indexes.

Create Users, restrict access of users via pre-created roles and assigning tablespace quotas and privileges.

Resolving the issues facing by ST/UAT/Development teams which are logged on the Helpdesk portal.

EDUCATION

B.Tech (IT) from Gandhi Institute of Engineering and Technology, Gunupur, India(2013)

D (10+2), Jharkhand, India (2008)

SSC (10) MMGH Jharkhand, India (2006)

CERTIFICATION

OCA 10g - DBA

ADDITIONAL INFORMATION

Skills Summary:

Having 3 years of experience in Planning, implementing, managing and monitoring Oracle databases as an Oracle Certified Database Administrator

Performing Installation of oracle Software on Linux/Unix and windows machines.

Installation of Oracle Cluster ware Software.

Installing and Working on ASM instances

Performing upgrades of the software and Databases to new release levels.

Applying Critical Patch Update (CPU) and SPU using opatch utility.

Migrating Non-ASM database to ASM using RMAN.

Administration of RAC databases.

Checking RAC status and database and instance/node check-ups.

Database cloning using any type of backups.

Involved in User management, creating Roles and assigning privileges, roles to database users.

Experienced in Planning, Implementing the backup strategy using RMAN, Hot backup, cold Backup and Logical Backup.

Implementing the Data guard - Physical standby.

Proactively monitoring the database's health and taking preventive or corrective actions as required.

sage of Data Dictionary views and scheduling the jobs using crontab utility.

Proficiency in performing database recovery using different kinds of backups.

Knowledge on SQL and Memory tuning.

Awareness of AWR reports for tuning of Oracle.

Technical Skills:

RDBMS : Oracle 10g, 11g and 12C

Operating systems : HP-Unix, Linux and Windows

Query Languages : SQL and Basic knowledge of PL/SQL

Oracle Tools : OUI, OEM 12c, SQL plus, SQL Loader, Datapump, TOAD, RMAN, Diagnostic tools

Tools / Utilities : Oracle Enterprise Manager, Toad, Export/Import, SQL*Loaders*PLUS, iSQLPlus, RMAN, Grid Control, DATA PUMP, Shareplex,Goldengate,PUTTY

Programming Languages: SQL, PL/SQL, HTML, C, C++, Java

Engagement Experience: Installation, upgrade and Configuration Architecture and Design, Performance Cloning, Database Maintenance

PERSONAL DETAILS:

Father Name : S N Mishra

Permanent Address : 2434 Tenor Lane, Alpharetta, GA-30009

Date of Birth : 1st Sep, 1991

Gender : Female

Languages Known : English and Hindi.

Regards,

Shweta shalini

Contact this candidate