Resume

Sign in

Oracle DBA with 6 years of experience

Location:
Lowell, Massachusetts, United States
Salary:
65 per hour
Posted:
August 20, 2018

Contact this candidate

Resume:

Kwame Asenso

469-***-****

ac6fot@r.postjobfree.com

Professional Summary:

* ***** ** ****** *** experience with Oracle 12c, 11g, 10g on UNIX, Sun Solaris, AIX and Windows.

Experienced in planning and implementation of Backup and Recovery strategy, used physical backup and logical backup using export/import, Expert in disaster recovery.

In-depth knowledge of setting up RMAN backups using control file and Recovery Catalog, and maintaining catalog schema. Proficient in creating auxiliary and duplicate databases using RMAN.

Extensive knowledge in implementing PL/SQL features like nested tables and collections for high performance of stored procedures.

Hands on experience in Oracle WebLogic server 11g (10.3.6), 12c (12.1.3) installation, maintenance, patching and troubleshooting.

Strong knowledge in Migrating Oracle 11g to 12c.

Proficient in Installation, Troubleshooting, Maintenance and Technical Support for Oracle (12c, 11g and 10g) Databases, Oracle Enterprise Manager Grid Control.

Installation and configuration of Oracle WebLogic Server 12c/11g

Installation, configuration and administration of Fusion Middleware

Deploying various J2EE and enterprise applications on managed servers.

Experience in Performance Tuning such as tuning of application, shared pool, buffer cache, I/O distribution, rollback segments, and redo mechanisms.

Experience of Auditing, Oracle Security, OEM, SQL Navigator and TOAD

Highly skilled in Oracle DBA - Installation, Administration, Creating Backup & Implementing Recovery Strategy, Performance Monitoring/Tuning and Database Security for Databases having more than 300+ users.

Maintenance and development of database objects like Queues, Tables, Indexes, Stored Procedure, Constraints, Triggers, Table & Index Partitioning, DB Links, Users, Roles, Profile and SQL NET and Listener.

Strong attention to details, technical and analytical skills with excellent interpersonal and communications abilities.

Technical Skills

Operating Systems AIX, Windows

RDBMS Oracle 12c, 11/10g, 9i, SQL Server 2005 / 2008

High Availability RAC, ASM

Languages SQL, PL/SQL, UNIX Shell scripting, T-SQL

Tools RMAN, OEM, ERWIN, TOAD

Tuning Tools TKPROF, EXPLAIN PLAN, STATSPACK, SQL Advisor, performance analyzer

Professional Experience

Oracle DBA

Uptime Systems Inc.

April 2014 – Present

Performing database upgrades from Oracle 11.2.0.1 to 11.2.0.4 to 12.1.0.1 to 12.1.0.2.

Responsible for backup and recovery using RMAN, Flashback Technology and user managed backups.

Performing regular health checkup of production and test databases and performance of Oracle application system.

Carry out Database or Schema level refreshes using the traditional export/import and Data pump or backup utilities.

Managing and performing Tablespace Management, Undo Management, Redo log management, Control file management, online Redo log management and user privilege management.

Administer and manage the Oracle Instance using custom scripts and 10g Oracle Enterprise Manager (OEM) database control and Grid Control.

Performs Database tuning such as memory tuning, Application tuning using tools like tkprof, explain plan, hints, ADDM and AWR Reports.

Performs database physical and logical design and procedures for Production, Development, Q&A, Test and Training servers.

Proactively tuning databases using SQL scripts, ADDM and AWR reports.

Assist with Installation, maintenance and tuning of Oracle 11g RAC databases including ASM.

Responsible for installation and configuration of Oracle Fusion Middleware applications including, but not limited to Oracle WebLogic Server (11g/12c), Oracle Business Intelligence (12c), Oracle HTTP Server.

Work with Oracle support for resolution of critical issues and report progress and project activities to team members/Project Manager on a continuing basis.

Support Data Guard databases, performs failover and switchover from primary to standby databases when needed.

Performs database backup and recovery using RMAN auxiliary method.

Perform logical backups such as tables and schema backups using Oracle Data pump export and import utilities.

Creating and managing database objects, creating Regular views, sequences, partitions, and refreshing Materialized Views as needed by the development team.

Participates after hours On-call database support.

Environment: Oracle 9i, 10g, 11g, 12C, Unix shell script,\, Oracle Linux, SQL*Plus, Toad, Various 10g and 11g Advisories

Oracle DBA

12AM Solutions Inc.

May 2012 – March 2014

Created and configured database by making changes to the Initialization Parameters in parameter file and dynamically in session.

Performed backup and recovery using Oracle user managed backup such as automated or manual cold backup and hot backup procedures.

Wrote scripts for informing the DBA's regarding the status, performance and Space Management of the Database.

Upgraded database from 10g to 11g database using Database upgrade assistant, export/import utilities and using oracle scripts. Managed and monitored hot standby database using (Data Guard) as well as monitoring primary database by using Unix Shell scripting.

Performed tuning such as database tuning, SQL tuning such as query optimization.

Prepared and reviewed database specifications, testing and changing control management programs migrations. Upgraded the database from 10g to 11g database and applied database patches (CPU).

In depth knowledge of setting up RMAN backups and recovery, RMAN tuning, and maintaining catalog schema. Proficient in creating auxiliary and duplicate database using RMAN.

Wrote several ad hoc scripts for daily DBA activities such as backups, user creations, granting roles and privileges, archiving of alert logs, verifying error entries and checking for space usages/overages.

Environment: Windows2000, Oracle 9i, PL/SQL, Oracle DBA Enterprise Manager, SQL*Loader, Shell scripts



Contact this candidate