OBJECTIVE

• To work in a learning and challenging environment, utilizing my extensive technical skills and noledge as an Oracle Database Administrator, to contribute positively to my personal growth as well as growth of teh organization, by halping teh organization in teh accomplishment of its goals.

SUMMARY

• Over 8 years of experience, including implementation and managing Oracle Databases in both RACand Clients production environments.
• Configure teh Oracle network environment and managing database storage structures, experienced in Oracle upgrades
• Skilled in designing and implementing complete client servers and database applications wif various development tools and languages.
• Manage internal databases, from planning and testing stages through implementation and support.
• Implementing user and Oracle database security and backup procedures to ensure database integrity.
• Performing database backups and disaster recovery plans, day - to-day DBS jobs for managing Production/ Development databases.
• Performance management, database infrastructure enhancements and moving data efficiently.
• Very efficient wif OEM, on both 11g and 12c.
• Over 2 years of experience, designing and creating applications in APEX
• Configured shell scripts for job/process automation.
• On call DBA and provides 24X7 supports for production problems.
• Excellent experience in moving databases to different servers and schemas to different databases.
• Developed an interactive Student Planner Application in Oracle APEX using PLSQL for Cal State San Bernardino as my masters project
• Excellent experience in managing space for tablespaces wif physical and logical standby databases in place.
• Experienced wif OEM, RMAN, ASM, AWR

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows, Unix, Linux, Windows Server

RDBMS: Oracle 12c/11gR1/11gR2/10g/9i/, SQLServer2005.

LANGUAGES: SQL, PL/SQL, JAVA, Pro*C, C, C++, XML, UNIX Shell Scripting, Windows Batch

TOOLS: /UTILITES: Oracle Enterprise Manager(OEM), SQL Developer, TOAD, Recovery Manager (RMAN), ASM,AWR, RAC, Apex, Ms Visual Studio

HARDWARE: HP-UXB. 11.23.0409 (Itanium2), HPServiceguard A.11.16, SunFire6900, IBM eServer p5 Model 590.

PROFESSIONAL EXPERIENCE

Confidential, CA

Oracle DBA

Responsibilities:

• Developed a customer tracker app in Oracle Apex using PLSQL, for teh frontend software.
• Installed 12c, configured teh various environments
• Installed 11g, applied patches in various environments and upgraded database
• Designed Oracle 11g database to keep records of customers and their orders.
• Set up, configured and maintained oracle data guard(primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Performed day-to-day DBA jobs for managing Production/Development databases.
• Provided 24X7 supports for production problems.
• Management of table spaces for different users by granting quota on Default & Temporary tables paces.
• Administered multiple instances of Oracle 10g and 11g databases running on teh UNIX and Linux operating systems
• Managed teh networking infrastructure, Designed and managed databases.
• Configured teh Oracle network environment
• Managed database storage structures,
• Performed database backups and disaster recovery plans.
• Export and Import of database objects to copy from one database to another database.
• Investigating suspicious database activity using Auditing.
• Manage users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.

Environment: Export Import, ASM, Upgrade, Migrate, SQL, PL/SQL, SQL Tuning, Instance Tuning, SQL Developer, Windows, TOAD, RMAN, Troubleshooting Skill, OEM 11g. 2 servers, databases of 120GB

Confidential, CA

Oracle DBA

Responsibilities:

• Migrating and upgrading teh databases to higher versions.
• Managed teh networking infrastructure
• Utilized SQL*loader and data pump import to load data into tables.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.
• Database Administration and Planning including logical design, physical design, backup & recovery.
• Took a logical backup of teh entire database using import/export utility.
• Monitored teh various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability
• Designed and managed databases.
• Designed an oracle 11g database to keep records of customers and their orders.
• Configured teh Oracle network environment.
• Managed database storage structures
• Performed database backups and disaster recovery plans.

Environment: Oracle 11g, Windows Servers, Oracle Enterprise Manager, SQL, TOAD, AWR, ASH, ADDM, from oracle to oracle databases.

Confidential

Oracle Database Administrator

Responsibilities:

• Supported more TEMPthan 200 databases for more TEMPthan 20 production servers for 24/7 support.
• Installed and configured new Quarterly ORACLE HOMES for teh 10g and 11g versioned servers.
• Primary DBA for 17 databases including DEV/TEST/PRODUCTION on 11g
• Part of teh team for database upgrade from 10.2.0.2 to 10.2.0.4 wif logical and physical standby in place.
• Database Tuning - Tuning Applications, Memory Tuning and Tuning Disk Usage.
• Partitioned large tables to increase teh performance.
• Managed teh internal databases
• Performed planning and testing stages through implementation, and support for banks, insurance companies.
• Performed database backups and disaster recovery management both client and RAC environment for banks in Ghana: GT bank, Unique Bank, Ecobank, Zenith Bank.
• Performed database backups and disaster recovery management both client and RAC environment for these companies in Ghana: Vanguard Insurance, Star life, Ghana Port.
• Monitoring database alert log files & Sun Solaris OS Error logs.
• Backup/Restoration, scheduling Backups, taking Logical Backups
• Setup backup, recovery and testing backups and procedures using RMAN.
• Set up Grid Control to monitor databases.
• Export and Import of database objects to copy from one database to another database.
• Investigating suspicious database activity using Auditing.

Environment: Oracle 9i / 10g, Oracle E-Business Suite, Windows NT/2000, Sun Solaris 10, SQL, RAC, data guard wif physical and logical standby databases.