Summary:

Don has consistently demonstrated excellent organizational and coordination skills that have resulted in the smooth functioning of the DBA area. He is a creative problem solver and has outstanding technical and people skills. He is experienced, enthusiastic and conscientious.

Career Profile Sr. oracle DBA/Security Specialist

Extensive experience in design, development and implementation of relational databases. Proficient in database tuning, application support, data warehouse support, Security and data conversions. Strong analytical and communication skills. Recognized for exceptional customer service skills. A US Citizen.

Qualifications include:

• Dedicated to understanding the full task at hand
• Excellent communication skills, proficient in handling multiple projects at once
• Capable of working under difficult and ambiguous situations
• Strong organizational and coordination skills with ability to adapt easily to new situations
• Excellent technical knowledge both deep and broad

Experience Summary

• I have 10 years as an Oracle DBA Installation, configuration, creation, upgrades Oracle environments 8i/9i/10g/11g/11.2g using UNIX. I am very strong with operating systems knowledge in a production and application environment. I have used RAC at a number of locations. I have performed day to day DBA tasks in test, QA and production environments including Hot Backup / Restores using RMAN, SQL Backtrack and other backup software. I have extensive Oracle knowledge query tuning and PL/SQL. Also was a DBA for SQL Server 7,2000,2003,2005,2008 ,Sybase 12.5 and 15 , MYSQL 4.0,5.1 and DB2 Releases 1.1-8 .I have secured data using Imperva
• Hardware/software 5,6,6.2,7.0,8.0,8.5 . Currently working as a remote DBA. Solid experience with Database Administration, Configuration, Monitoring, and Performance Tuning. I also managed a number of technical projects and was a director before tackling Oracle.

Technical Summary

Experience

Confidential

Oracle DBA

• Worked with RMAN installing catalogs and setting up backups to tape in both Oracle 11.2G and 9.2. saving the client of having to use costly online DASD.
• Recently worked as a remote DBA for a number of new accounts new for Oracle that needed the software put on a number of machines. Installed Oracle 11.2 database and client software from vendor downloads or NFS'ed to appropriate machine..
• Created new instances loaded vender tables for 3 party non Oracle software. Executed data refreshes, build new databases and space monitoring Tablespace expansion .
• For current Oracle installations ran 'health checks' making sure correct patches have been applied. Investigated current datawarehouse implementation and made recommendations.
• Worked in a RAC environment. Provided Remote on call nighttime support.
• Implemented new backup strategy saving the company 56 of backup resources and reducing recovery time by 20 hours.
• Worked on a number of projects with multiple companies installing Imperva software/hardware for database security.
• Completed a number of data security evaluations for SOC or HIPAA

Confidential

Oracle DBA

Responsibilities

• Supported a Development team for all DBA tasks including turning logical models into Physical schemas and export/import of data.
• Automated a number of tasks by writing Unix scripts. scripts in .sh .ksh .pl reducing needed DBA resources by 18 .
• Worked with Oracle 11.2 G on XML tables creating scripts and SQL .
• Used AGILE as project management methodology.. Stored code via SVN, used Rally to manage project. Proficient at Microsoft Project.
• Hired to set up 3rd shift onsite Indianapolis, IN DBA support so business would have ability to have staff work through the night to better use resources but have onsite support.
• Created detail plans to implement a number of Oracle tasks. Created new instances, upgraded existing instances and applied patches to environment. Worked with RAC databases.
• Managed a special project to move a system from SQL2000 to SQL2005.
• This included not only the database upgrade, but movement of the old DTS packages Data Transformation Services-MS sunset this product not supporting packages created in SQL2000 in SQL2005 to new IBM Tivoli Directory Integrator packages ITDI .
• A number of database imports and exports were done to move data from one machine to another
• Provided support for a 24/7 international environment headquartered in Israel with major development centers in India.
• Used Clarify CRM along with an in-house written application to control Change and Trouble tickets.
• Moved data from production environment while scrambling any PII Personally Identifiable Information
• Preformed day to day DBA tasks that included account management, application object management, backup management, common scripts enhancement, installation, and rollout, migrating data between database environments, database creation, moving a database from one server to another server, monitoring database activity and performing database tuning as required, database recovery using RMAN and database retirement.
• Preformed all DBA related tasks for MYSQL
• Supported a number of 24/7 environments with RAC, Datagard and standby databases both physical and logical .
• Used Remedy system to control Change and Trouble tickets.

Information Security/Compliance Responsibilities-

• Worked as a Security Specialist supporting production environment.
• Used the iMPERVA SecureSphere tool extensively to comply to SOX and HIPAA audits.
• Specialized in Data Loss prevention and mediation of SQL Injections.
• Created rules to monitor SQL databases in multiple RDBS DB2, Sybase , MSSQLServer, MYSQL, Oracle . Made sure databases adhered to Sarbanes Oxley audit rules.
• Used tcp dump to identify traffic going to database server.
• Was a System Administrator sys admin on the Linux machines
• Processed SQL backup restore via export/import.
• Built infrastructure to allow monitoring of tables for SOX compliance.
• Completed investigations to determine financially sensitive data. Assisted in creation of operational model for financial data. Used the iMPERVA SecureSphere tool to monitor financial tables in Oracle Financials.
• Created rules to monitor SQL databases in multiple RDBS MSSQL Server, Oracle . Made sure databases adhered to Sarbanes Oxley audit rules.
• Created method so a company could identify financially significant tables to monitor them to address access to tables for quarter end for Security and Exchange Commission report.

Environments:

SUN Solaris5.1 IBM AIX HP Unix,Linux HPUX,Oracle7/8I/9I/10G/10.2G/11G,11.2G Oracle RAC numerous releases , Tortoise SVN, Remedy numerous releases , Imperva 5,6,6.2,7.0,8.0,8.5.-Linux TOAD numerous releases TOAD for Oracle 10, Windows server 2003, SQL Server 7,2000,2003,2005,2008 , Sybase 12.5 and 15 , MYSQL 4.0,5.1 DB2 Releases 1.1 - 7 Clarify e

Confidential

Information Engineer Technical Production DBA

• Created and maintained the technical infrastructure of the test, QA and Production environments. Created a number of new instances on UNIX platforms for application tools. Assisted with database design and performance tuning. Provided on-call rotation, 24/7 support of on-line very large systems. Troubleshot systems problems. Took part in the upgrade to Oracle 9.2.0 and upgrade of Sun hardware. Created databases from logical designs, .Increased the audit ability of the database to insure compliance with Sarbanes Oxley reporting requirements and coordinated implementation across the entire technical infrastructure.
• Migrated Oracle to new UNIX hardware within the Citigroup environment to comply with corporate standards and secure appropriate support.
• Created and maintained backup/recovery processes and procedures to insure business continuity in the event of a disaster.

Environment: IBM-AIX,SUN Oracle 8I/9I ,Remedy, DBARTISEN, TOAD, SQL Loader, PL/SQL, ETL , SQL Server 7/2000/2003, GUPTA SQL Base 4, Informix 9

Confidential

• Maintained and developed application databases to support the Life Annuity area. Completed database design and access to the data. Supported MS-SQL Server databases. Acted as liaison between the ETL vendor and company, active member of user group ETI, product manager working within corporation to coordinate tool use and vendor upgrades to have the tool meet corporate standards.
• Participated in the upgrading to Oracle 8I and Sun hardware to ensure better and faster database processing and adherence to company's standards.
• Worked with application areas to migrate to new UNIX boxes and set up their batch processing to fail over to a backup allowing quicker computer system recovery from a disaster.
• Used ETL tool to transport data from DB2 mainframe allowing for easier access and significant cost reduction for processing within departments.
• Wrote policies and guidelines for Travelers use of the ETI tool, allowing a shorter learning curve and better observance to guidelines for new applications.
• Supported as a DBA a MYSQL environment to support the business and keep within corporate standards.