Professional Summary

Experienced, reliable Oracle Database Professional with 10 years experience which includes logical and physical database design, disaster recovery, DBA development and support of Oracle 9i/10g/11g databases in production, development, and user acceptance environments. Excellent problem solving and user interaction skills. Solid Project Management skills encompassing all aspects of software development life cycle.

TECHICAL SKILLS

Languages: PL/SQL, SQL

Scripting: Korn Shell scripts

Database:

Oracle Enterprise Edition versions 9i/10g/11g

SQL Server 2008

Tool/Technologies: Microsoft Visual Studio 2008 and 2010, Oracle Designer, ERWin, Logical/Physical Data Modeling, Embarcadero DB Optimizer, ER Studio Data Architect, Oracle Enterprise Manager Grid Control, 12c ,SQL Loader, Data Pump, Import/Export, RMAN, Cron, Oracle Data Guard, Oracle Streams, Oracle Golden Gate, Partitioning, Database cloning, Toad, SQL Server Management Studio, TKProf, SPViewer, , vi, OEM Monitoring

Platforms: Unix- Sun Solaris 10, Windows, Red Hat Linux 6.x, Oracle Enterprise Linux

Professional Experience/Accomplishments

• Created disaster recovery strategy for primary support databases based on service level agreements and budget
• Implemented and supported failover/switchover capability in production environment using Oracle Data Guard
• Created documentation for disaster recovery failover for planning, testing, and implementing purposes
• Maintain database and system availability
• Proactively monitor and fine-tune inefficiencies
• Design, implement, and maintain back-up and recovery processes
• Provide expertise on database analysis and design and implement
• Created Logical and Physical Data Models for developers
• Created Entity Relationship Diagrams and explained the business rules and relationships to IT and business groups
• Contribute to troubleshooting activities for data, database, or application issues
• Collaborate with development teams to deploy and enhance application code, data structures, queries, and stored procedures
• Enforce Data standardization, naming conventions, Change Control, processes, and security standards
• Performance tuning using explain plan, statspack, AWR, and ADDM reports to determine bottlenecks, locks, and other performance issues
• Conversion of 2 Oracle RAC databases to 30 Production stand alone DB's using Oracle Golden Gate technology
• Installed Oracle RDBMS and kept current with upgrades and patches to leverage stability with new technology and security
• Delivered 24x7 on-call database support and performed maintenance and production deployments during maintenance hours to ensure fully functioning database and application performance

Confidential

Senior Oracle DBA, SQL Server 2008

Responsible for maintenance and administration of production and development 11.2 databases running on Oracle Clusterware and RedHat Linux. Duties include monitoring, SQL tuning, backups, executing change requests, writing scripts to automate tasks.Utilize NetApp storage cloning utilities and assisted in writing scripts to provide full copies of the databases for use in production support, off site backups and dry runs prior to production rollouts. The time required to refresh dev environments was reduced to less than 3 hours from 2-3 days using the cloning technology.Wrote various scripts to automate the scrubbing of DBs when refreshed from prod to protect sensitive data.Used Oracle Golden Gate technology to convert 2 huge Oracle RAC databases to 30 stand alone databases in production environment.Developed OEM reports and monitoring extensions within the Grid Control tool to facilitate timely monitoring and dissemination of information.Assisted development and project teams with process redefinition and controls. Created logical and physical data models for various IT groups. Created and enforced naming conventions, standardizations, audit considerations, and data dictionary. Explained and demonstrated how the model would function and how data could be stored and retrieved to maximize database performance. Continued to revise the model with new application enhancements.

Confidential

Oracle 9i/10g/11g DBA, SQL Server 2008 Oracle DBA for Oasis project which is the principal software/database for Kirby Corporation. This mission critical database is the core of Kirby's business. Tuned and enhanced SQL, database, and database objects to enhance performance. Wrote and automated scripts to refresh databases to support both development and production support. Designed physical and logical data model for Barge Maintenance application main application for Kirby.Created and enforced naming conventions, standardizations, audit considerations, and data dictionary. Explained and demonstrated to both developers, business groups, and various IT groups how the model would function and how data could be stored and retrieved to maximize database performance.Created and supported SQL Server 2008 Databases through the development to production cycle. Wrote and enhanced ETL packages extracting from Oracle, Excel, and SQL Server databases to Operational Data Stores and Data Warehouse environments.

Confidential

Independent Consultant Oracle DBA, Disaster Recovery Specialist

Team lead position responsible for leading a team of DBAs to create detailed database disaster recovery plans for 60 business critical trading databases. Databases included Sybase, SQL Server, Oracle, and Oracle RAC. Most Disaster Recovery solutions included Oracle Data Guard and worked with DBA's to have a standard failover/failback approach. Each database DRP was tested for accuracy and completeness.

Confidential

Independent Consultant Oracle DBA

Oracle 10g Database Administrator for nERGIZE group which involved support and development of windows and Unix based Oracle databases. Provided development support to the dev teams and tuning support for the production databases. Performed database refreshes for production support issues. Rehosted databases on different machines to support business testing. Created logical and physical data models for the nERGIZE project. Created and maintained data dictionary. Created and deployed DDL scripts in development, QA, and UAT environments.

Confidential

Oracle 9i/10g DBA Administrator for global Credit Infrastructure group which involved support and development of over 100 Oracle databases. Provided 24x7 on call support rotation of production databases. Performed database refreshes, release management, backup and recovery, monitoring, and performance tuning of both SQL code and database. Created disaster recovery strategy based on Service Level Agreements and budgets. Authored disaster recovery documents to create, test, and implement disaster recovery. Created Data Guard standby databases for disaster recovery purposes and performed failover and switchback testing scenarios.

Confidential

Data Architect/Application DBA

Created where used documentation for executives to understand the migration of product data as it traversed through the BMC enterprise in both custom and purchased applications. Created Entity Relationship Diagrams depicting subject matter models. Designed and implemented an Item Management model to make physical the intellectual property being sold to customers. This model allowed BMC to automate the ability to create, relate, and track all tangible items shipped to a customer. Incorporated all business rules within the model to allow the application to rely on the business rules contained in the database and making business enhancements with no downtime to application or database reconfigurations. Created logical and physical models to support business rules and requirements. Worked with business analysts and developers to create and enhance models.

Confidential

Sr. Programmer Analyst

Awarded Texaco's highest award the Texaco Star Ambassador award and flown to corporate headquarters in White Plains, NY to be presented with the award by the CEO for designing and creating the first data warehouse for Texaco containing financial data in an Oracle 7 database using UNIX shell scripts to load the data from DB2 to Oracle. Mapped the data elements from target to source and provided all transformations and conversions. Supported and enhanced 6 IBM Mainframe DB2 financial applications for Texaco Exploration and Production Department. Programming languages included COBOL and PL/1. Taught technical training classes to new IT recruits.