OracleDBAConsultant Resume Gaithersburg, MD - Hire IT People

TECHNICAL SKILLS:

Areas ofExcellence: Data Science, Data - Driven Analysis, Machine Learning, Deep Learning, Business Intelligence, Business Analytics, Tensorflow

Technical Skills: A/B testing, Data Mining, Decision Tree, Clustering, Statistical Analysis, Predictive Analytics, Data Visualization, Neural Network, PostgreSQL

Tools: andProgramming Languages: BIGDATA SQL*Plus, Linux Shell Scripting, PL/SQL, PHP, MySQL, HTML5, APACHE, CSS, XML, Java, JavaScript, Visual, C, C++.: Putty MobaXterm, SQL Developer, TOAD, Eclipse (Android Developer), NetBeans, JCreator, GitHub.

Operating Systems: LINUX - Red Hat Enterprise, Linux Ubuntu, MAC OS X, Windows - NT 2000, Windows 2003, Windows XP, Windows Vista, Windows 7.

PROFESSIONAL EXPERIENCE:

OracleDBAConsultant

Confidential, Gaithersburg, MD

Administering a 600GB development database environment on single instance servers hosting12C (12.1.0.2) database on Red Hat Linux (RHEL 6.5) operatingsystems.
Administeringa500GBQAenvironmentwithsingleinstanceOracledatabaseserverson12C(12.1.0.2)on Red Hat Linux (RHEL 6.5) operatingsystems.
Create, implement and manage custom Oracle databases on Linux and windowsplatforms.
Creating and maintaining Oracle database objects (schemas, tables, indexesetc.).
ProvidingOracledatabaseadministrativesupport tovarioususergroups(applicationdevelopers,data managersetc.)
Creating a database recovery catalog and registering databases to the recovery catalogdatabase.
PerformingbackupandrecoverytasksonOracledatabaseusingRMANIncrementalbackupandhot backup, cold backup. Using shell scripts forall.
Scheduling backups using the crontabutility.
Performing capacity planning in terms of memory and disk usage, establishing benchmarks for business and technicalperformance.
Using RMAN to restore and recover control and data filesrespectively.
Performing a flashback and point in timerecovery.
Supportedsystemadministrationgroupswithmaintainingoracledatabaseserversandinpre-production, test, training, and developmentenvironments.
Analyzing and tuning voluminous SQLcode.
Tuningdatabaseobjectstorunsmoothlybyanalyzingquerypaths(creatingexplainpathtables)andusing efficient indexing.
Control and monitor user access to the database using roles andprofiles.
Performingdatamigrationfromadatabaseinoneservertoadatabasehousedonanotherserverusing databaselink.
Migrating data using the data pump export (expdp) and import(impdp).
Creatingnon-defaultlistenersfordatabase,registeringdatabaseandlistenerstoOEMCloudControl12C.
Perform Patch Set Updates(PSUs).
Experience in Dataguard implementation and maintenance: Both Physical & Logicalstandby.
Experience in managing Oracle 11gR2 RACenvironments.
Upgraded 11G databases to12C.
24/hr support provided during on-callrotation.

OracleDBAConsultant

Confidential, Bowie, MD

Managed a half-terabyte sized production databaseenvironment.
Supported system administration groups with Oracle database server maintenance and in pre-production, test, training, and developmentenvironments.
WorkedinanOracle11gr2(11.2.0.3)and12C(12.1.0.2)databaseenvironmenthostingWebLogic applicationservers.
Providing 24/7 database administration support in both development and productionenvironments.
Provided Oracle database administrative support to various user groups (applicationdevelopers, datamanagers,etc.).
Implemented and enforced database security by creating users, roles, andprivileges.
Created and maintained Oracle database objects (schemas, tables, indexes,etc.).
Database monitoring and extensive performancetuning
Analyzed and tuned SQLcode.
Tuned database objects to run smoothly by analyzing query paths and using efficientindexing.
Wrote shell scripts to automate and perform backup and recovery tasks on Oracle databasesusingRMAN backups (Incremental backup), hot and coldbackups.
Performed capacity planning in terms of memory and disk usage, established benchmarks for business and technicalperformance.
Using RMAN to restore and recover control and data filesrespectively.
Migrated data using the data pump export (expdp) and import(impdp).
Scheduled backups using Linux’s crontabutility.
Performed flashback and point in timerecoveries.
Experience in Dataguard implementation and maintenance: Both Physical & Logicalstandby.
Experience in managing Oracle 11gR2 RACenvironments
Performed Patch Set Updates(PSUs).
Created database recoverycatalogs.
Effectively migrated databases within the same downtimewindow.
Creatednon-defaultlistenersfordatabasesbothmanuallyandusedOracleNetConfigurationAssistant (NETCA).

We provide IT Staff Augmentation Services!

Oracledbaconsultant Resume

Gaithersburg, MD

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship