SUMMARY

• I do not require supervision as I make sure I’m aware of SLA’s and deadlines and know what it takes to meet them. I do everything I can to meet them and get done early if possible.
• I work well in a team, always willing to help team members if they need an extra hand or have a question or need help with an issue.
• I believe it is very important to keep customers and end users happy. I have received a ton of positive feedback from customers and end users for my dedication to helping them resolve their issues.
• 17 years’ experience as a Solaris Systems Administrator.
• Strong knowledge of Oracle Installation, Administration, Monitoring, Performance Tuning, RMAN Database Backup, Dataguard and Database Recovery.
• Efficient in Installing/Creating databases on Solaris, RHEL, OEL and AIX in Virtual Environments and Installing/Creating databases on Solaris, RHEL, OEL, AIX and HPUX in standard server Environment
• Physical and Active Oracle Data Guard.Oracle RAC
• Strong with Oracle RMAN.

TECHNICAL SKILLS

Software: Oracle 7.0 - 12c (RDBMS), Oracle Enterprise Manager, Oracle OVM-MOS Database installs, Oracle SQL and database tuning, Oracle RMAN, Oracle RAC, Oracle Data Guard, Perfstat, AWR, NetBackup, TOAD, Golden Gate, SharePlex, Veritas Volume Manager, Veritas File System, Veritas Cluster, Linux Native Clustering, Exceed, MySQL, Postgres, PL/SQL, SQL Plus

Scripting Languages: Csh, Ksh, Borne, Bash

Operating Systems: Solaris 2.4 - 10, RHEL 4.x-6.x, OEL 4.x-6.x, HPUX, AIX, Windows Server 2003-2012

PROFESSIONAL EXPERIENCE

Sr Oracle, MySQL Contract DBA

Confidential

Responsibilities:

• DBA made sure that SLA's were met for any database on any platform for production, test, develop, staging and UAT databases for software group
• Installed software, created databases, upgraded, patched, created clones and refreshes of different databases on mostly different platforms
• Created and modified database objects in production databases
• Worked with new and current customers in a to determine the best process for migrating data from local databases to their new database in the SunGard hosted environment
• Production DBA in charge of meeting up-time SLA's for production, test and develop databases for SunGard customers
• Met project timelines no matter what it took to accomplish
• Performed installations, upgrades, maintenance and patches on customer's Oracle databases
• Tuned Oracle databases
• Regularly performed tuning at the system level for production databases
• Helped to improve poorly performing SQL queries
• Scripted many customer RMAN scripts for database backups
• Performed refreshes and clones from production when requested. Used RMAN restore and recovery, import/export and data pump
• Did systems administrative work for prepping servers for Oracle installs
• Lead DBA engaged on the MySQL Product launch at SunGard. This included designing, implementing, testing and documenting Implementation Strategies, Backup Strategies and Support Models for SunGard and installing MySQL (Mariadb) in an OFA directory structure with no MySQL (Mariadb) being installed in the root directory

Confidential

Sr. Oracle DBA

Responsibilities:

• Helped to migrate their old database to Oracle
• Located a used Sun server for the new database
• Production DBA in charge of maintaining production, test and development databases
• Performed necessary production database maintenance, including upgrades, applying patches and tuning
• Refreshed non-production databases from production periodically to provide developers with current data
• Migrated, cloned and moved databases as needed.
• Tuned production databases using Perfstat, 10046 tracing and OEM

Confidential

Sr. Oracle DBA

Responsibilities:

• Production DBA in charge of maintaining production, test and development databases
• Performed refreshes, new clones and other database moving and creations from RMAN backups, Net backup and exports
• Performed upgrades, patches, maintenance, and system, Oracle and SQL tuning for production databases
• Migrated data, SQL*Loader, imported and exported triggers and set up publish and subscribe options replication and SQL generated. Also to flat files or Excel using SQL to generate the files. Data scrubbing scripts were also written and sanity checks were used to verify the validity of the data while it was being extracted and inserted.
• In charge of the daylight savings time project. Responsible for the implementation document on the planning of the entire project (for the DBA’s) including when to do patches, finding databases that had to be patched, ones that could be done at a later date and ones that really did not need it at all. Kept track of all patches and documentation that Oracle kept changing. Worked closely with the System Administrators so the databases could be patched when the servers were down for system patches (and many extra patches that they piggy backed to the DST patch). This also included relinking the databases and validating that the new links did not have any errors. Worked with the application owners and middleware owners to make sure that they had the patches they needed if any and when to install them and to make sure that what their software vendors said had to be patched in Oracle for their software was done.
• Tuning Siebel databases (and other production database problems as time permitted) using OEM, Statspack. Explained plan, truss, vmstat, iostat, sar, top, mpstat (if Solaris os) and 10046 tracing oracle users and tkprof..

Confidential

Oracle DBA

Responsibilities:

• Production DBA in charge of maintaining production databases for custom applications.
• Created data dumps for customers, in different types depending on the customer.
• Responsible for refreshes, new clones and other database moving and creations.
• Performed upgrades, patches, maintenance, and tuning for all production databases.
• 24x7 on call support for any production related issues.
• Searched for new ways to tune the databases, make backup and recovery faster and more reliable, tested disaster recovery, always tried to find new ways to be proactive and not reactive.
• Production DBA and development DBA.

Confidential

Oracle DBA

Responsibilities:

• Production DBA in charge of maintaining production databases for PeopleSoft and other applications
• Created data downloads for loading into Excel spreadsheets.
• Responsible for database refreshes for the development, testing and training groups from the different production databases.
• Performed upgrades, patches, maintenance, tuning for all production databases.
• 24x7 on call support for any production related issues.
• Modified SQL scripts for new parameters.
• Performance tuning using Perfstat for tuning production databases and also using RoboDoc for tuning databases and other database problems and 10046 tracing.
• Responsible for proactive work, looking for ways to make the database perform more optimal, faster with fewer problems to be able to find problems before they happened.
• Doing this on databases with multiple companies on different servers using Win XP, Win NT, AIX, Linux, Solaris and HPUX.

Confidential

Oracle DBA

Responsibilities:

• Production DBA in charge of maintaining production databases for PeopleSoft applications and development DBA helping PeopleSoft consultant and developers.
• Created data downloads for loading into Excel spreadsheets.
• Responsible for database refreshes for the development, testing and training groups form the different production databases.
• Performed upgrades, patches, maintenance, tuning for all production databases.
• 24x7 on call support for any production related issues.
• Modified SQL scripts for new parameters and performance tuning.
• Used Perfstat, 10046 tracing and OEM for tuning production databases.

Confidential

Oracle DBA

Responsibilities:

• Production DBA in charge of maintaining production databases for Sonus and Ipunity and development DBA.
• Created data downloads for loading into Excel spreadsheets.
• Ran monthly data loads (LERG, etc).
• Modified live data in the production environment (updates, inserts and deletes) with back out plans.
• Performed upgrades, patches, maintenance, tuning for all production databases.
• 24x7 on call support for any production related issues.
• Backup and recovery using scripts that came from Sonus and Ipunity.
• Modified SQL scripts for new parameters and performance tuning.
• Performance monitoring on both Sonus and Ipunity and made changes to the Ipunity database. Made recommendations for the Sonus databases and monitoring the server health.
• SA support on the Oracle Unix servers.

Confidential

Oracle DBA

Responsibilities:

• Production DBA in charge of maintaining production databases in a direct marketing environment.
• DSS support.
• Purged and created data partitions.
• Off loaded data for a data warehouse.
• Performed upgrades, patches, maintenance, tuning for all production databases.
• 24x7 on call support for any production related issues.
• Backup and recovery with RMAN and standby databases.
• Periodically refreshed the test and development databases from production and verification that all applications still worked properly.
• Ensured that all of the production databases were in sync using OEM Change Manager.

Confidential

Sr. Database Administrator

Responsibilities:

• Data architect for all Databases in support of Clarent’s VoIP (voice over IP) software. Databases supporting Clarent’s VoIP included Oracle 8i, 9i and MSSQL Server 2k. Normalizing or de-normalizing (to improve database performance) data for the developers
• Provided support for the QA department.
• Upgrades to databases and OS and verified that all applications still functioned
• Development liaison for all Database support needs.
• Provided Database support for multiple other departments as well.
• Helped with the Systems Administration of all Oracle servers to allow the System Administrative team to focus on other systems
• Performed capacity planning for all of Clarent’s customers ranging anywhere 6 months to 2 years.
• Excelled in tuning of databases and database servers.
• Specialized in designing, testing and implementing back-up and recovery scenarios for clients using RMAN and SQL-BackTrack
• Improved the performance of development code through the tuning of the developers SQL, PL/SQL and TSQL code.
• Monitored all connection code looking for performance problems.
• Wrote scripts to verify the install of Oracle replication; this includes running any PL/SQL install scripts if they had not been run. In addition, I wrote a how-to-document and scripts that any client DBA’s could read and edit to setup the replication if needed.
• Conducted stress testing and tuning to achieve required TPS goals on oracle and MS SQL and made configuration recommendations to customers.
• Created and maintained PL/SQL script to install or upgrade the Clarent Command Center database objects in Oracle and MS SQL.
• Designed and wrote SQL Loader scripts to add developer data to new schemas and to load customer data for testing of upgrades using live data.
• Worked with Rational for source code control.
• Maintained the Oracle back-end for Rational as well.
• 24x7 on call support for all production databases.
• SA support on the Oracle servers Unix and Windows (NT and XP).

Confidential

Manager of Data Systems

Responsibilities:

• Tech lead for DBA's and SA's acting as a buffer between my employees and my manager. I attended meetings, did project management, employee performance reviews, interaction between my group and the end users, handled employee problems and disputes. Also had to do remote management for DBA out of state.
• Provided support for both production databases and development databases.
• Provided Oracle support for development team
• Maintained the Oracle databases for NetExpert (by Agilent formerly OSI) and BridgeWater - Radius application.
• Designed and built an Operational Datastore and Data Warehouse for a statistical application to help sort downstream alerts in NetExpert application.
• Initially after starting, spent the first six months cleaning up and reorganizing all the production databases.
• Designed backup and recovery processes based on each end user’s SLA and testing to ensure that all processes implemented, worked correctly.
• Managed hardware sizing, system growth projections, disaster recovery, and data security for systems running Oracle databases and Sybase databases and/or database applications.
• Database troubleshooting and performance tuning for Oracle and Sybase.
• Responsible for the People Soft applications (Finance, HR, etc.) that were used.
• 24x7 on call support for all production databases.
• SA support on the Oracle servers.

Confidential

Oracle Database Administrator / Oracle Applications Administrator / System Administrator

Responsibilities:

• Instrumental in the successful conversion from an HP300 legacy system running Management Systems for Distributors software on an Image database to Sun open systems environment running Oracle databases and Oracle Applications.
• Installed, upgraded, maintained and administered all Oracle databases, custom database systems and Oracle Applications.
• Developed, enforced and maintained data integrity procedures, performance tuning (both RDBMS and systems), user security, data security, and system environment planning.
• Instrumental in the capacity planning for all systems running Oracle for up to a year in the future.
• Monitored network and system performance and tuned when it affected the database performance.
• Wrote and maintained scripts to automate tasks with crontab (retrieving and loading legacy data into the production instances).
• Enhancements to Legacy System: Simplified the nightly procedures to one command eliminating the need for a night operator
• Provided support for both production databases and development databases.
• Provided Oracle support for development team SA support on the Oracle servers.