Oracle DBA Resume

SUMMARY:

To obtain a challenging and rewarding career in an organization, which gives me scope to apply my knowledge and skills in Project Management/software technologies and be a member of a team that dynamically works towards success and growth of the organization.
10 years of experience in IT Industry.
Excellent Knowledge of Oracle DBA, Project Management, Risk Management and ITIL processes.
Knowledge of SDLC/Agile/Waterfall Model.
Excellent communication and interpersonal skills, both written and verbal.
Good exposure to Oracle 12c, 11g and 10g databases.
Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development and Documentation for databases.
Migrating and Upgrading the Databases between different environments and versions.
Possess experience in Software Application Development activities Design, coding testing and Maintenance
Expertise in oracle database, query tuning using OEM and Repository (AWR), Stats pack, PL/SQL and Shell scripting.
Good experience in applying PSU and Critical Patch Update (CPU Patches) using OPATCH Utility on Databases,
Proactive listener, Creative problem solver, quick to learn new technologies.
Extensively worked on Database design, Administration, Implementation and support in Production, System test and Development environments.
Hands on experience in Data Guard Configuration, capacity planning.
Designing the backup and recovery strategies and configuring the same to meet the SLA
Ability to collect, consolidate and report metrics, status reports for project and organizational needs.
Ability to mediate issues and manage conflicts, Experience working with distributed teams
Part of Interview Panel team in Confidential .
Defines project scope and objectives from Database perspective and aligning with other teams.
Provides direction and mentoring to Junior Resources.
Participates in setting and enforces project direction with cross - functional teams.
Familiar with managing through change control and production turnover for end deliverables.
Conduct weekly meeting with Application team for scope, risk and issues.
Work closely with the project team for achieving Technical/Business objectives of the project.

TECHNICAL SKILLS:

Databases: Oracle 12C,11gR2, Oracle 11gR1, Oracle 10gR2

Oracle Products: 10g/11g/12C, OEM 12C, Data guard, Import & Export, Automatic Storage Management,, Oracle 10g/11g/12c (Grid Control), RMAN

Operating Systems: Solaris, Red hat Linux.

Languages: SQL, PL/SQL

Tools: Oracle Grid Control 11g/12c, SQL*Loader, RMAN, DBCA, ASMCMD.

WORK EXPERIENCE:

Confidential

Oracle DBA

Responsibilities:

Providing 24X7 clock support for the critical production databases,
Implementation of disaster recovery solutions for business critical systems, Design and configure backup mechanism for the databases,
Oracle server software installation/uninstallation on unix and windows environments
Creation of oracle databases on UNIX environments.
Implementation of database restore and recover strategies,
Hands on experience in performance tuning using EXPLAIN PLAN, SQL* Trace, TKPROF, SQL Trace Analyzer, SQLHC, SQLTXPLAIN tools,
Upgradation of databases to latest version.
RDBMS software management -installation-de installation-configuration-patching, database creation-decommissioning,
Deployments, Refresh schema/objects in non-production environments from production environments for Developers and Testers.
Created shell scripts for automation of schema refreshes, automation of pre and post tasks of database refreshes, database monitoring, and many more..
Backup of the databases to tape and disks as per the request
Build/rebuild standby databases for the business critical production databases
Configure dataguard broker for the databases in the dataguard
Applying patches/Time zone patches/CPU patches on oracle home
Tune poorly performing SQL queries
24*7 production Support for mission critical production systems
Create normal restore points and guarantee restore points

Confidential

Oracle DBA

Responsibilities:

Oracle software installations, applying security patches on quarterly basis,
Configuration of RMAN disk backups,
Deployments, Data fixes, schema refreshes, User creations, Tablespace creation and management,
Tuning problematic SQL queries, Monitoring alerts etc..
Installation of different versions of Oracle software on UNIX platforms.
Apply patches on the Oracle home.
Applying critical patch updates and patch sets on the oracle home.
On-call support for business critical production databases

Confidential

Oracle DBA

Responsibilities:

Installation of Oracle server software.
Shell scripts to export/import data from oracle database to another database.
Tablespaces creation and assigning quota on tablespaces to users.
Identifying and solving the problems faced by developers
Schemas refresh using Export and import.
Trouble shooting the issues faced by developers.
Creation and managing users and tablespaces.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship