SUMMARY

• An Oracle OCP 11g with experience in deploying disaster recovery solutions with standby databases in compliant to Oracle maximum availability architecture and more than 10 years of industrial experience in high end Oracle technology starting with Oracle RDBMS version 9 up to 12C. Eight years of which were experience in database administrator in development, test and production environments.
• Skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages.
• Has managed internal databases, from planning and testing stages through implementation, support and has involved in end to end performance tuning, High Availability and Disaster Recovery solutions.
• In - depth understanding of diagnostics of performance issues, security and backup procedures to ensure database integrity.
• Possesses superior skill in communication, presentation, analytical and problem-solving skill. Work well with all levels of business.

TECHNICAL SKILLS

• Data Processes and Migration
• Database Upgrade, Cloning and Consolidation
• Performance Tuning (AWR, ADDM, Statspack & Sql Trace)
• High Availability Solutions (DataGuard, RAC)
• RMAN Backup and Recovery
• Disaster Recovery Planning
• Database Schema & Object Security
• Sql & PL/Sql Tuning, Shell Script (Bash)
• Data Warehousing design
• Oracle Database Upgrade and OPatch
• Data Storage, Data Modeling and Partitioning
• Oracle 9i, 10G, 11G, OEM Cloud control 12c & 13c, GRID control & Exadata.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administration

Responsibilities:

• Oracle Database Administrator, worked with Technical College System of Georgia (TCSG) Banner Enterprise team to ensure client and Oracle database technologies are functioning as efficiently as possible.
• Responsible for patching, upgrade, database trouble shooting and supporting development effort regarding production deployment releases, database schema, role, user, and objects, database hardening and baseline per security policy to improve database security.
• Support includes responding to system management alerts, database maintenance, performance modifications and other database related issues and problems.
• Maintained Database availability 100% of the time for user roles validation and Manage database users at all levels.
• Installed, configured and updated database hardware and software.
• Operated and maintained all integrated systems to support mission critical operations.
• Performed daily application updates and maintenance functions.
• Responded to Tier 3 and Tier 4 trouble tickets. Managed, escalated and resolved issue tickets and calls
• Created, Monitor, and ran audit queries to ensure compliance with the institution’s policies and data integrity.
• Deployed monthly security patches and updates.
• Responded to after-hours trouble calls.

Environment: Oracle Enterprise, UNIX (Linux & AIX), Ellucian Banner, Evisions Argos and VMware.

Oracle Database Consultant/Administrator

Responsibilities:

• Conducted Oracle 11gR2 database classroom instruction and hands-on lab training to give students a firm foundation in basic administration of Oracle Database 11g.
• Oversaw the performance testing and staging / production environment (application / system) performance monitoring activities to ensure that the applications meet the performance objectives in Oracle environment.
• Performed database capacity planning required to create and maintain Oracle databases.
• Created and maintained standards and best-practices for installing and maintaining Oracle database in all environments.
• Built, Installed and tested data Extraction and Replication Using Oracle GoldenGate 12c application on Linux.
• Provided technical leadership to Oracle Implementation Engineers and Oracle Analysts.
• Database Change Management review member for all database applications development and implementation before go-live.
• Performed Oracle RAC design, Oracle DataGuard development, configuration and installation on VMware.
• Installed, setup and deployed OEM Cloud Control 12c tooling to manage and monitor different areas of database administration such as storage, backups, recovery, security, performance.
• Evaluated Oracle features and Oracle related products.
• Collaborated with the backup team to established and maintained sound backup and recovery policies and procedures.

Environment: Oracle Enterprise, UNIX (Linux & AIX) VMware, and Windows Server.

Senior Oracle Database Consultant

Responsibilities:

• Night and Weekend duties along with 24X7 on call to support Oracle database environments.
• Supported system alerts, database maintenance, performance modifications, & other database related events in a reasonable response time.
• Performed database tuning, database health check, created database reorganization procedures, scripted database alerts, and monitored scripts.
• Worked with the Client business and application development to implement change request in the production database.
• A key contributor in the Database Change Management Committee review meetings for all new application development.
• Developed, installed and configured Oracle database. Configured and supported Oracle DataGuard for High Availability in environment
• Supported development team by creating objects (tables, procedures, functions, packages, views, triggers, indexes).
• Implemented backup and recovery methods using RMAN.
• Managed different areas of database administration such as storage, backups, recovery, security, performance and monitoring through the OEM 12c Cloud console tool.
• Implemented database refresh using full export for table level and full database defragmentation, resulting in improved performance and effective space management.
• Cloned, installed and configured database for Oracle Application development environment.
• Performed database maintenance such as upgrades and patches.
• Performed disaster recovery using Oracle Recovery Manager.
• Networked Oracle databases Servers and Client applications using Oracle*Net.
• Migrated Sql Server databases to Oracle using Oracle Migration Workbench.

Environment: Oracle Enterprise, UNIX (Linux & AIX) and Windows Server.

Oracle Database Administrator

Responsibilities:

• Extracted data for testing and analysis.
• Supporting development team by creating objects (tables, procedures, functions, packages, views, triggers, indexes)
• Configured and supported Oracle Standby databases for High Availability in RAC environment.
• Implemented backup and recovery methods using RMAN
• Query performance analysis and optimization.
• Ran reports and translated for decision makers.
• Provided performance related guidance to the application development teams.
• Oversaw the performance testing and staging / production environment (application / system) performance monitoring activities to ensure that the applications met the performance objectives.