SUMMARY:

• A highly skilled Oracle professional with over 15 years experience in IT. I have led or been part of many Software Development projects for the Financial, Health, Manufacturing and Educational sectors.
• I currently work as a Senior DBA on the Confidential project for Confidential .
• Our team manages about hundred (100) databases (Oracle 11g - starting to upgrade to 12c soon) ranging in size from 20GB to 70TB.
• On my previous project, I was an Oracle Subject Matter Expert (SME) on the IRS Confidential project.
• On this project, I worked closely with the development team responsible for very high impact solutions to the US economy providing insight to Oracle Technologies.
• The environment utilized several databases running on single-instance as well as Oracle RAC databases that are over 5TB large in an Agile Development Framework..

TECHNICAL SKILLS:

• Deployed, configured, and managed Windows, UNIX/Linux and Novell Netware
• Extensively used Microsoft Office Suite
• Trained in Visual Basic, C++, BASIC, COBOL
• S-Designer for translating requirements into entities, relationships and constraints
• TOAD for Oracle, PL/SQL Developer, Oracle Enterprise Manager/Grid Control
• Oracle RAC 10g, 11g

WORK HISTORY:

Confidential

Senior Oracle DBA

Responsibilities:

• Act on behalf of DBA Lead when needed
• Mentor other DBAs in our team
• Cordinates workload (through ticketing system) in support of the Development team
• Create and maintain all databases required for development, testing, and production
• RMAN Clonning
• Work closely with the system administration team in performing capacity planning required to create and maintain the databases
• Perform tuning of the database instances including re-organization as required to assist performance and ensure maximum uptime of the database
• Install new versions of the Oracle RDBMS and apply patches as needed
• Plan and implement backup and recovery of all Oracle databases
• Control migrations of database changes, reference data changes through the development life cycle
• Implement and enforce security for all of the Oracle Databases
• Put standards in place to ensure that all application design and code is produced with proper integrity, security and performance. I help to perform reviews on the design and code frequently to ensure standards are being adhered to
• Enforce and maintain database constraints to ensure database integrity
• Administer all database objects, including tables, clusters, indexes, views, sequences, packages and procedures
• Assist with impact analysis of any changes made to the database objects
• Troubleshoot problems regarding the databases, applications and development tools
• Create new database users as required

Confidential

Oracle Subject Matter Expert (SME)

Responsibilities:

• Providing expert support to Operational DBAs during installations, upgrades and deployments throughout the project life-cycle ( from development, testing, through to production)
• Work with responsible teams in providing recommendations for hardware sizing
• Perform tuning of the database instances and queries which sometimes involve about a billion records
• Co-ordinate Oracle parameter changes in all life-cycle environments
• Liase with security teams to ensure system compliance
• Provide technical support to application development team
• Assist with impact analysis of any changes made to the database objects
• Troubleshoot problems regarding the databases, applications and development tools
• Liase between other Project Teams and Operational DBAs as needed

Confidential

Senior Oracle DBA

Responsibilities:

• Create and maintain all databases required for development, testing, and production
• Work closely with the system administration team in performing capacity planning required to create and maintain the databases
• Perform tuning of the database instances including re-organization as required to assist performance and ensure maximum uptime of the database
• Install new versions of the Oracle RDBMS and apply patches as needed
• Plan and implement backup and recovery of all Oracle databases
• Control migrations of database changes, reference data changes through the development life cycle
• Implement and enforce security for all of the Oracle Databases
• Put standards in place to ensure that all application design and code is produced with proper integrity, security and performance. I help to perform reviews on the design and code frequently to ensure standards are being adhered to
• Evaluate releases of Oracle and its tools, and third party products to ensure that we are running the products that are most appropriate
• In collaboration with the Application Developers and System Administrators, I plan to ensure that the introduction of any new product or release upgrade takes place with minimal impact
• Provide technical support to application development team and liaise with Oracle Corporation on their behalf
• Enforce and maintain database constraints to ensure database integrity
• Administer all database objects, including tables, clusters, indexes, views, sequences, packages and procedures
• Assist with impact analysis of any changes made to the database objects
• Troubleshoot problems regarding the databases, applications and development tools
• Create new database users as required
• Manage sharing of resources amongst various applications
• Part of a team with ultimate responsibility for the physical database design

Confidential

Oracle DBA/Teaching Assistant

Responsibilities:

• Installation, configuration and upgrade of Oracle Servers (10g and 11g) and related products
• Extensive development and management of PL/SQL Packages, Triggers and Stored Procedures; also creating and maintaining other database objects
• Maintaining Oracle Security/Audit using tools such as Oracle Enterprise Manager (OEM)
• Enforcing and maintaining database constraints to ensure integrity
• Perform Oracle database, SQL and application tuning and monitoring; analyzing impact of changes made to database objects
• Help prepare students for Oracle Certification

Independent Consultant

Confidential

Responsibilities:

• Directed and partook in the creation of Supply Chain Management Software for a Canned-Tuna Manufacturer - a subsidiary of Heinz - saving them over US$ 2million dollars in quality control penalties. Recently added a Bar-Code option
• Design and review of Oracle Backup and Recovery Strategies for clients in multiple sites
• Developed and implemented Supply Chain Management and Equipment Maintenance Software for multi-million US$ Oil Blending plant
• Led and participated in the design and development of Financial Systems for managing Loans, Financial Instruments (e.g. Bills), general Discount House operations, Human Resource/Payroll, Asset Management, Credit Union System, and Credit Information System for Bankers' Association
• Designed and implemented Logical and Physical Database Architectures for several clients in various industries
• Performed capacity planning of resulting databases by working closely with Systems/Network Administrators; provides technical support to application developers
• Created an Educational software and concept for School Administration and Performance Analysis (with Data Center for processing outsourced schools’ academic records)
• Managed teams with about 100 clients some of which are 1,500+ staff-strong
• Engineered a Hospital System for managing Outpatient Departments
• Used S-Designer and other tools to translate many system requirements into entities, relationships, constraints and attributes

Confidential

Systems Support Executive

Responsibilities:

• Installation, configuration and upgrading of Oracle Servers (versions 6 and 7) and related products internationally
• Deploying, Configuring, and Managing Windows, Unix/Linux, MS DOS and Novell Netware
• Migrating MS SQL*Server/Access databases to Oracle
• Extensively used and trained clients in the use of Microsoft Office Suite and Microsoft Project
• Taught self in the use of Oracle Development tools like Forms, Reports, Discoverer/Query Builder, Graphics, PL/SQL, Designer, WebDB, and XE and have since trained many others