database administrator

KOMALDEEP KAUR

************@*****.***

DBA ' 647-***-****

Brampton, ON

OBJECTIVE

To seek career as Oracle Database Administrator in a progressive company.

HIGHLIGHTS

* *****’ experience as Oracle DBA.

Well versed with 11g and 12c features

Upgraded 11.2.0.4 database to 12.1.0.2 Database using PDB/CDB concept.

Good knowledge on Oracle Database Architecture and good troubleshooting skills

Performance Tuning with AWR, ADDM, Explain Plan, ASH, SQL Plan Management, SQL Tuning advisor.

Oracle Database Upgrades from 11.2.0.1 to 11.2.0.4 to 12c

Well versed in Database Cloning, Patching and User Management.

Comfortable to work on any Operating System like LINUX, WINDOWS.

SKILLS

ORACLE Skills

Other Technical Skills

Database Creation, Maintenance, Troubleshooting

DB’s: Oracle11g /SQL Server

Administration of 11g/12c and Oracle Database on any OS.

ERP: Oracle E-business 12C/11G

Cloning – Hot/Cold, Duplicate using RMAN & ASM/Non ASM.

OS: Solaris, AIX, HP-UX, Linux Windows

Oracle 11g features like Data pump, Flash-Back Recovery (Query, Transactions, Versions, Database) and ASM

Database Tool: Toad, OEM, Crontab & Foglight

Backup and Recovery of Database using OEM/RMAN.

Languages: PL/SQL, UNIX Shell Script, C#.

Upgrade and Migration of Oracle database releases (11g,12c)

Tool: Putty, Hummingbird Connectivity

Patching Application and Database(online/offline) using Opatch.

EDUCATION, TRAINING & CERTIFICATIONS

Oracle Certified Professional in 11g

Bachelor’s Degree in BSC(IT)- 2012

Master’s in computer science MSc(IT) correspondence

LatitudeITP consulting (SEP 2012 – DEC 2015)

My Responsibilities involve

Supporting PROD /DEV / TEST / UAT environment.

Upgraded oracle 11.2.0.1 to 11.2.0.4, 11.2.0.4 to 12.1.0.1.

Taking the Cold/ Hot backups, Differential backup using RMAN.

Analysis DB Quarterly PSU patches including and one-of patches.

Management of ASM instances

Creating Database links.

Granting Privilege/role/profiles to users.

Monitor alert logs, space and object growth related problems in the databases.

Planning and managing database backups.

Analysis of trace and log files to determine and resolve potential problem areas.

Creation and sizing tablespaces and setting tablespace attributes

Knowledge of resolving the performance issues AWR/ADDM, STATSPACK, and Explain plan, TKPROF, SQL Trace, Analyze Tables and Indexes.

Maintaining archive data on appropriate storage devices.

Analyzing and validating database objects.

Applying database changes/Code Migrations to multiple environments.

On call support 24x7.

Actively participated/scheduled meeting with onsite clients.

PERSONALITY TRAITS

Good written and verbal communication skills.

Ability to produce the best result in pressure situation.

Ability to work in team and as individual.

Good Documentation Skill.

References are available on request

Contact this candidate