Resume

Sign in

Manager Oracle

Location:
Minneapolis, Minnesota, United States
Posted:
January 10, 2017

Contact this candidate

O'Neil Batcha

Oracle Database Administrator

Plymouth, MN

acx7be@r.postjobfree.com - (612)***-****

WORK EXPERIENCE

Oracle Database Administrator

Accenture - Austin, TX - November 2015 to November 2016

• Support functionality and maximum performance and to ensure proper backups of all oracle files.

• Installed, tested, and deployed Oracle patches and Oracle's quarterly Critical Patch Update(CPU) to all development, test, and production instances.

• Performed database health check using OEM 12C.

• Administered and managed an Oracle RAC environment using OEM(Grid Control) and SRVCTL utility.

• Utilized RMAN for recovery purposes as well as for weekly incremental and monthly full database backups.

• Used Oracle Diagnostics tools like Explain Plan, SQL Trace, TKPROF, AWR, ADDM to analyze timing & execution plan for tuning. Also used TOP, VMSTATS, SAR to understand the impact on memory & CPU by processes.

• Performed Installation, security and patch upgrades over successive Oracle generations using OUI and DBCA.

• 24/7 on call support for production and lower environments to ensure maximum uptime and high availability.

• Planned and Implemented Disaster Recovery (DR) and High Availability using RAC, and Data Guard.

• I was part of a team that evaluated current policies to improve SOX compliance implementation.

• Cloned production databases as needed for testing, development using RMAN and Grid Control.

• Supported deployment of Documentation enhancements and bug fixes to the test and production environments.

Oracle Database Administrator

Relsys International - Irvine, CA - June 2013 to September 2015 Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

• Created PL/SQL functions, stored procedures, packages to support reporting.

• Monitored and tuned rollback segment, temporary table space, redo log buffer, sort area size.

• Ran scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

• Worked closely with Application Developers to design/create new Oracle databases/create new schemas/ database objects, as well as making database changes from DEV to PROD, via TEST following requests/ demands from the development team.

• Data migration between databases using both Oracle 11g and 10g export/import utility and Oracle 11g expdp/ impdp data pump.

• Backup of Database using logical and Physical (hot and cold) procedures and also using RMAN for complete and incomplete recovery of database.

• Conducted continuous maintenance, disk utilization assessment, and fine tuning of the Oracle.

• Assisted in SQL tuning and providing consultation such as creating Materialized views, table partitions, adding indexes, dropping unnecessary indexes, using hints wherever possible, amongst others. Oracle Database Administrator

One Wealth Management Financial - Santa Monica, CA - February 2009 to May 2013

• Created and assigned appropriate roles and privileges to users depending on the user activity.

• Assisted in preliminary planning and development of an Oracle RDBMS to manipulate product, manufacturer, shipping and customer data.

• Worked with Oracle Diagnostics tools such as Explain Plan, SQL Trace, TKPROF Used to analyze timing and execution plan for SQL query to tune the SQL statements.

• Administered and supported development Oracle 11g databases by installing, upgrading and configure the Oracle server, creating databases, objects, database backup and recovery, monitoring and optimizing database performance.

• I created Users, Roles and Profiles, Privileges management with role-based security.

• Created primary objects (tables, views, indexes, synonyms, procedures, functions and triggers) to help application developers with the application design.

• Monitored database for performance and optimization using Toad. TECHNICAL APPLICATIONS/TOOLS

• RDBMS: Oracle 10g/11g and 12c

• Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, Ksh, bash and Perl Scripting

• Software/Application Tools: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Agents, Real Application Clusters

(RAC), ASM, Sql Developer, TOAD, Exp/Imp, Data Pump (expdp/impdp), SRVCTL, SQL*Plus, Recovery catalog, Autosys, Crontab, HP Manager,

• Tuning Tools: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

• Web Tools: HTML, XML

EDUCATION

Tourism and Hospitality Management

Eastern Mediterranean University Turkish Republic of North Cyprus ADDITIONAL INFORMATION

Over 10+ years of IT experience as an Oracle database administrator with technical expertise in analysis, design, implementation, and maintenance of high-volume Oracle data intensive systems. Exceptional critical thinking and problem solving skills coupled with meticulous attention to detail with the ability to address complex issues involving service delivery processes, data movement, replication, security and recovery. Proven record of troubleshooting problems, detail oriented planning, and meeting deadlines in a fast paced environment. Accomplished communication, research, and process improvement skills coupled with a great passion for all things data.



Contact this candidate