SUMMARY:

• Over 8 years experience in Software Development Life Cycle
• In depth knowledge on AGILE methodology and using JIRA
• Over 6 years of experience, designing and creating applications in APEX and PLSQL
• Over 8 years of experience, including implementation and managing Oracle Databases
• Performing database backups and disaster recovery plans, day - to-day DBS jobs for managing Production/ Development databases.
• Over 6 years of experience in SQL, PL/SQL, APEX Configuration and Setup, Performance Tuning and good understanding of relational database concepts
• Over 6 years working knowledge of HTML and AJAX framework
• Over 6 years of experience with JQuery, JavaScript Library, XML
• Developing both mobile and desktop APEX 5.0 applications
• Developing both mobile and desktop APEX 4.2 applications
• Setting up security measures on APEX, database security, application security and system security
• Developed over 20 applications using Oracle APEX, set various security measures on all applications
• Experience in creating PL/SQL packages, stored procedures, functions, Cursors, triggers to enforce business rules
• Developed an interactive Student Planner Application in Oracle APEX using PLSQL for Cal State San Bernardino as my masters project
• Experience using Oracle Developer 9i, 10g for forms
• Experience using Oracle forms and Reports
• Experience using BI Publisher
• Experienced with OEM, RMAN, ASM, AWROCA
• Developing reports using Oracle Reports
• Proficient in Oracle Application Express 4.0, 4.2, AJAX, XML, CSS, XML,JAVASCRIPT,JQUERY, SQL, and Oracle 11g/12C
• Experienced with Oracle Warehouse Builder(OWB) 11g for ETL
• Experience in system and data analysis and application development
• Strong technical, analytical, logical, and documentation skills
• Experienced with Oracle Business Intelligence Enterprise 11g, for reporting and query analysis
• Skilled in data reporting and working in advanced technical environment
• Experience in Oracle SOA Suite, using JDeveloper to develop Oracle BPEL projects
• Over 10+ years of programming experience
• Understanding and administering different kinds of database policies

TECHNICAL SKILLS:

OPERATING SYSTEMS: Windows, Unix, Linux, Windows Server

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

LANGUAGES: SQL, PL/SQL, JAVA, C, C++, XML, UNIX Shell Scripting, Windows Batch, HTML, JAVASCRIPT, JQUERY, AJAX, CSS

TOOLS: /UTILITES: Oracle Enterprise Manager(OEM), SQL Developer, TOAD, Recovery Manager (RMAN), ASM,AWR, RAC, Oracle APEX, Ms Visual Studio, Oracle Reports, Oracle Business Intelligence Enterprise 11g, Oracle Warehouse Builder 11g

PROFESSIONAL EXPERIENCE:

Confidential, DALLAS TX

Oracle Apex/PLSQL Developer

Responsibilities:

• Migration of several APEX applications to different platforms using Software Development Life Cycle (Waterfall and Agile)
• Fixing bugs and Compatibility issues on several applications.
• Understanding of Business Requirements and Implementing into applications.
• Debugging Apex applications and PLSQL codes
• Used SVN for all code modification, by creating a working directory, creating tags, updating trunks, merging, checking out and committing any changes
• Creating business users reports based on their requirements and adding functionalities to new and existing APEX Applications
• Creating applications tables, packages, functions, procedure, triggers and most database objects in Oracle database 11g
• Managed different working environments, including DEVELOPMENT, IST databases for development purposes and successfully delivering applications live into PRODUCTION to meet customer needs
• Using TOAD and SQL Developer for Database Analysis
• Creating PLSQL Packages, Functions, Procedures
• Writing APEX codes for Business needs
• Integrating and using BI Publisher with APEX for reports

Oracle Apex/PLSQL Developer

Responsibilities:

• Migration of several APEX applications to different platforms using Software Development Life Cycle (Waterfall and Agile)
• Fixing bugs and Compatibility issues on several applications.
• Understanding of Business Requirements and Implementing into applications.
• Debugging Apex applications
• Used SVN for all code modification, by creating a working directory, creating tags, updating trunks, merging, checking out and committing any changes
• Creating business users reports based on their requirements and adding functionalities to new and existing APEX Applications
• Creating tables and record in Oracle database
• Managed different working environments, including DEVELOPMENT, IST databases for development purposes and successfully delivering applications live into PRODUCTION to meet customer needs
• Using TOAD and SQL Developer for Database Analysis
• Creating PLSQL Packages, Functions, Procedures
• Writing APEX codes for Business needs
• Integrating and using BI Publisher with APEX for reports

Environment: Oracle 11g, Windows, UNIX, SQL, TOAD, SQL Developer, Oracle databases.

Oracle DBA/ Apex Developer

Responsibilities:

• I developed a customer tracker app in Oracle APEX using PLSQL, for the frontend software.
• Installed 11g, applied patches in various environments and upgraded database
• Designed Oracle 11g database to keep records of customers and their orders.
• Developed forms and reports using Oracle Developer Suite 9i and 10g
• Set up, configured and maintained oracle data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Used Oracle Business Intelligence Enterprise 11g for reporting and query analysis
• Performed database backups and disaster recovery plans.
• Developed and implemented all APEX security measures on application
• Investigating suspicious database activity using Auditing.
• Performed all performance tuning metrics
• Manage users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Experience in Oracle SOA, using JDeveloper to develop BPEL projects

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, Oracle APEX

Oracle DBA / Developer

Responsibilities:

• Creating forms and reports using Oracle 9i
• Migrating and upgrading the databases to higher versions.
• Managed the 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 the entire database using import/export utility.
• Monitored the 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 the 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.

Oracle Database Administrator/ Developer

Responsibilities:

• Supported more than 200 databases for more than 20 production servers for 24/7 support.
• Installed and configured new Quarterly ORACLE HOMES for the 10g and 11g versioned servers.
• DBA for 17 databases including DEV/TEST/PRODUCTION on 11g
• Part of the team for database upgrade from 10.2.0.2 to 10.2.0.4 with logical and physical standby in place.
• Developed forms and reports using Oracle 9i
• Database Tuning - Tuning Applications, Memory Tuning and Tuning Disk Usage.
• Partitioned large tables to increase the performance.
• Managed the 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.
• 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 with physical and logical standby databases.