oracle DBA/Security Specialist

DONALD G. SWYERS

*** ****** ****, ********, ** **062-1089

860-***-**** / email *******@*****.***

“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.

- Charles Nichols, Manager Oracle DBA Unit; MetLife

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

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)

TECHNICAL SUMMARY

HARDWARE: SUN, IBM 3090, IBM PC, IBM RS6000 (AIX), HP, Imperva Appliance

SOFTWARE: Unix, AIX, Solaris, Linux, HP-UX, Oracle 10.2G. Oracle 10G, Oracle 9i, Oracle 8i, Oracle 7.3, MVS, NT, Windows (dos thru XP), DB2, ERWIN, Toad, iMPERVA SecureSphere DXG, MS Office Suite , SYBASE, ETI*Extract, DBArtisen, SQLServer, Informix, RMAN, Oracle database management tools

EXPERIENCE

SELF EMPLOYED –Independent Consultant Northampton, MA (11/2005 – present )

EMC - Westbrough, MA Part of a team from OpenSky consulting,a specialty security consulting(10/09-12/09)

 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.

 Created rules to monitor sql databases in multiple RDBS ( MSSQLServer, Oracle). Made sure databases adhered to Sarbanes Oxley audit rules.

MassMutual Financial Group– Springfield, MA INFORMATION ASSURANCE CONSULTANT (02/08- 08/09)

 Information Security/Compliance Responsibilities- Worked as a Security Specialist supporting their 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.

 Reviewed application code as part of an application penetration testing team.

 Created rules to monitor sql databases in multiple RDBS (DB2, Sybase , MSSQLServer, Oracle). Made sure databases adhered to Sarbanes Oxley audit rules. Used tcpdump to identify traffic going to database server.

 Was a System Administrator (sysadmin ) on the Linux machines

 DBA Responsibilities- Tasks included working with the Oracle 10.2g databases. Defined/created tables, processed SQL backup restore via export import.

 In a special project worked 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).

AMDOCS – Champaign,IL DEVELOPMENT ORACLE DBA (07/07- 02/08) Worked as a DBA supported their development environments.

 Tasks included working with development areas to turn logical models into physical databases.

 A number of database imports and exports were done to move data from one machine to another. Extensive creation of shell scripts for database monitoring and DBA task automation.

 This is a 24/7 international environment headquartered in Israel with major development centers in India. Used ClarifyCRM along with an in-house written application to control Change and Trouble tickets.

Eli Lilly – Indianapolis, IN PRODUCTION ORACLE DBA (01/07- 04/07)

Worked as a DBA supporting their production environment.

 It included account management, application object management, backup management, common scripts enhancement, installation, and rollout (scripts in .sh;.ksh;.pl), 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.

 This is a 24/7 environment with RAC, Datagard and standby databases (both physical and logical). Used Remedy system to control Change and Trouble tickets.

IBM - Application Services – Northampton, MA TECHNICAL ORACLE DBA (02/06-08/06) Work at home for NISource IBM account.

 It was a new account (for IBM) that needed the software put on a number of machines. Installed Oracle 9.2.0.6 database and client software from vendor CD’s NFS’ed to appropriate machine.. Executed data refreshes, build new databases and space monitoring (Tablespace expansion).

METLIFE, Formerly Citigroup – Travelers Life & Annuity, Hartford, CT

INFORMATION ENGINEER – TECHNICAL ORACLE DBA (07/2002 – 11/2005)

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 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.

INFORMATION ENGINEER – APPLICATIONS ORACLE DBA (06/1999 – 07/2002)

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.

LOGAN/BRITTON, INC, Houston, TX

CERTIFIED ETI (EXTRACT MASTER) CONSULTANT (08/1997 – 05/1999)

Developed code with the ETI tool that enabled the creation of data warehouses

• Worked on largest datawarehouse in North America – saved client $50 million per year.

• Datawearhouse gave large insurance company the information to pursue $200 Million lawsuit.

Previous to working at LB I was an employee of ACT Consulting, Aetna and Xerox.

EDUCATION

 Master of Business Administration – Corporate Finance, The University of Hartford, West Hartford, CT

 Bachelor of Science – Management Science Minor in Computer Science

State University of New York At Geneseo, Geneseo, NY

Contact this candidate