Core oracle dba

PREFESSIONAL EXPERIENCE

Over * years of IT experience with emphasis on Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows, supporting a variety of critical applications with Oracle 10g, 11g and 12c. Proven technical knowledge of infrastructure management combined with outstanding leadership ability and creative problem-solving skills in both strategic and technical areas as well as excellent communication and documentation skills.

AREA OF EXPERIENCE

Installation of Software and Configuration, Database Security, Cloning, CMDB, IaaS, DBaaS, knowledge on Exadata, SQL Servers, Data Warehousing, Troubleshooting, Data Masking, Documentation, Capacity Planning, Backup and Recovery, 12C New Features, Performance Monitoring and Tuning, Maintenance, Migration, Space Management and Database Monitoring.

PROJECTS: Patching and Upgrades, Oracle Golden Gate, Data Guard, and RAC.

TECHNICAL PROFICIENCIES

Operating systems

LINUX, SOLARIS, Windows Advanced Servers 2010/2012

Databases

Oracle 10g, 11g, 12c

Oracle Database Tools

SQL*Loader, TKPROF, Toad, OEM, SQL Developer, Grid Control

Tools & Utilities

Export/Import, RMAN, Data Pump, WinSCP,

WORK EXPERIENCE

Sapient Corporation - Cary, NC

January 2015 – Present. (Oracle DBA)

Strong knowledge in administering the performance of databases

Used CRONTAB and Oracle Scheduler to schedule backup jobs

Monitored several databases of different sizes using OEM Grid Control, Sql Developer and TOAD

Made optimal use of Oracle Support in resolving the SRS (Standard Request Submission)

24 X 7 PROD and DEV database support and administration

Used import/export utilities (traditional method) for cloning/migration of small sized databases and Datapump expdp/impdp utility to move data between 10g and 11g environments

Played integral role in the configuration of GOLDENGATE for real time replication and high availability in a heterogenous Environment. Performed initial load using datapump, golden gate, transportable tablespace and RMAN from source database to target

Involved in query optimization and used of rule-based optimizers and cost-based optimizers

Documentation using SharePoint for feature references

Excellent customer service and communication skills.

Experienced in creating and managing users and privileges in a Multitenant Environment

Provided high skills in configuring, setting up and managing Oracle 11g and 12c databases

Applied patches on 10g versions and upgraded to 11g version

Completed Data Guard switch over and failover in alignment with requirement, utilize data guard broker to monitor the configuration

Expert in creating users, groups, roles, profiles, and granting necessary privileges. Perform advance security measures such as TDE (Transparent Data Encryption), and Data Masking.

Pacific System Inc - Atlanta, GA

March 2011 – January 2015. (Oracle DBA)

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases using the Opatch Utility abd OEM as well

Made optimal use of Oracle Support in resolving the SRs.

24 X 7 Production & Development database support and administration.

Generated AWR, ADDM, Explain Plan, TKPROF, SQLTRACE, reports for Performance tuning. Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements

Essential role played as part of a powerful team for Data Guard, Creation of a physical standby database

Oracle 11g RAC Database administration, configuration and maintenance

Oracle Cluster Resources and host configuration with appropriate cluster service tools, including crs, ocr config, crvctl, and srvctl

Administered 11g RAC environments adding and removing nodes to the cluster and handled performance tuning using AWR and other tools

Installed ASM environment and migrated databases from NON-ASM to ASM

Hands on experience in cloning and upgrading 11g non-container databases to 12c pluggable databases using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature

Implementation of 12C new features such as data redaction, pluggable databases, and the easy restore of table using RMAN

Opportuned to work with Application DBAs and developers hand in hand

Knowledge on PL/SQL to formulate procedures and functions

Work on Database Cloning

EDUCATION

Bachelor’s degree in Computer Science 2008

Oracle Certified Associate (OCA)11g

Certified in Microsoft Office Applications.

Scrum Master Certified.

Contact this candidate