Resume

Sign in

Manager Oracle

Location:
Philadelphia, PA
Posted:
March 04, 2019

Contact this candidate

Resume:

Richard L. Taylor

Philadelphia, PA *****215-***-**** • ac8oc4@r.postjobfree.com

PROFESSIONAL SUMMARY

Multifunctional professional with over 7+ years of strategic leadership and performance-based management experience. Proven track record of unceasingly exceeding administrative goals. A proactive, driven individual recognized for bringing value to situations disregarded and lacking functional probability. Experience in:

10g, 11g, 12c Database Administration

11g Real Application Cluster (RAC) on ASM installation

Data Guard/Active Data Guard Administration

RMAN Backup and Recovery

Operating Systems: Microsoft, Windows 2000, 2003 & 2008 Advanced Server, Red Hat (Linux), UNIX, VM Ware, OBI KPI’s, MSSQL Server 2012,2017

Networking Topologies / Protocols: Ethernet, TCP/IP

Programming Languages: SQL, PL/SQL, SQL*PLUS

Software Applications/Tools and Utilities:

Data Migration-Export-Import, Backup & Recovery Performance Tuning-SQL-Loader, Data Guard.

PROFESSIONAL EXPERIENCE

Oracle Database Administrator 09/2012 to Present

Neway IT Solutions, LLC

Maintained an 11g database security using encryption, and Fine Grain Access Control.

Configured, audited, granted privileges, restricted access, created users, profiles, roles and monitored quota on tablespaces in line with resource planning guide.

Managed multiple databases and instances using Data Guard, RAC in a real time production, testing, and development environment.

Used Enterprise Manager DB console to monitor performance, clone databases, tuning and maintaining optimal performance.

Used Oracle Grid control on UNIX/Linux and Windows to maintain a 500Gb database with a group of DBAs in a 24/7 365 production environment involving technical proficiency.

Used DataPump for migration, Remapping, SQL*loader, import and export of database/schema/Tablespace.

Generated Reports and preparing memo to communicate progress and providing early alerts for major updates.

Used a hot and cold backup and recovery using RMAN.

Used Enterprise Manager to schedule backups.

Used Data Guard to perform both switch over and failover exercises.

Configured and managed database backups (full and incremental), restores, cataloguing, and migrations on primary servers and across servers within a project.

Performed SQL tuning and object management.

Used SQL*Plus, iSQL*Plus, Oracle SQL Developer, Putty, PL/SQL, Command-line tools to accomplish projects.

Advanced troubleshooting using trace files, alert log

Developed and enforced database related policies, standards, naming conventions, operating procedures and best practices.

Generated reports.

Executed database backup and recovery strategies.

Monitored thresholds in relation to the FRA.

Monitored database security by controlling and monitoring user access

Created and monitored roles and profiles.

Created and maintained database structures and objects.

Experienced and managed Oracle database partitioning (Range, List, Hash and Composite)

Patched and installed Oracle software.

Supported and troubleshot to detect and correct problems.

Setup brand new machines including Oracle software installation, Oracle side configuration, third party backup software troubleshooting and backup testing.

Fixed restore and backup errors.

Experienced in working with DBMS automation scripts, and deploying scripts.

Handled disaster testing.

Cloning and creating new databases using operating system commands.

Configured and monitored the TNS/Listener using NetCA, NetMgr.

EDUCATIONAL BACKGROUND

SQL Fundamentals I Certification OC1743357 2017



Contact this candidate