Oracle and SQL Server DBA, App Solution Engineer and IT Team Manager

Professional Experience

Allianz SE, Bridgewater New Jersey, Novato and Petaluma California

Oracle & SQL Server DBA, Applications & Systems Admin, January 2003 – present

Allianz Global Corporate and Specialty, 2014 - present

oSQL Server Project DBA 20012 and 2014 on lower environments; including experience with SSIS, Performance Tuning, Snapshot and Transactional Replication, Transaction Log Shipping, Backup/Recovery; and some exposure to SSAS, SSRS, High Availability, Fail Over and Cluster Configuration.

oOracle Project DBA 10g-11g on lower environments on Windows; including experience with RMAN, Fast Recovery, Disaster Recovery, Performance Tuning, Upgrades, Patching; and some exposure to Data Guard and RAC.

oExposure with Oracle 12c evaluation.

oEvaluation environments for MySQL and PostgreSQL 9. Created and populated DBs with masked versions of limited data to evaluate products.

oProject management for Personal Insurance data center application and data server consolidation, migration, and decommissioning. Included migration to virtual servers, firewall configuration, VPN services, networking between data centers, and application configuration and testing.

oProject management for Personal Insurance application migration, decommissioning, and archiving. Includes data retention, vendor management, and data transfers.

oApplication Administration for North American Personal Insurance policy and rating client-server and web-based applications. Includes mainframe and server applications and data, vender coordination, upgrades and maintenance.

Allianz New Jersey Auto and Fireman’s Fund Insurance, 2003 – 2014

oOracle Sr. DBA 8i-9i for production and lower environments on AIX, Linux and Windows; including experience with RMAN, Fast Recovery, Disaster Recovery, Performance Tuning, Upgrades and Patching, application integration, and Data Warehousing.

oSQL Server Sr. DBA 2008 and 20012 for production; including ETL, Backup/Recovery, Replication and Performance Tuning.

oManaged IT team of 5, including programmers and systems administrators.

oProject management for Personal Insurance application migration, decommissioning, and archiving. Includes data retention, vendor management, and data transfers.

oManaged data center, including databases, applications, web and file servers.

oManaged IT security, Citrix and VPN access, backup and recovery and disaster recovery.

CGI Inc. (formerly Inspire Insurance Solutions), Fort Worth Texas

Oracle & SQL Server DBA Manager, Through December 2002

Managed production Oracle 7-9i and SQL Server 6.5-2000 database administration team.

Manager of DBA Client Services outsourcing team. Responsible for DBA services for multiple clients.

Production and Test Oracle 7-database support on AIX and Microsoft servers, Oracle Applications 11i DBA, and MS SQL Server.

Database architecture, design review, and data conversion and modeling.

Performance tuning, SQL and T-SQL optimization, PL/SQL procedure code review, and performance analysis.

Backups, restores, disaster recovery planning, implementation and exercises.

Database and server security planning and implementation.

Server, Database, and client software installations and upgrades.

Unix shell and script programming.

Oracle and SQL Server utility programming including import, export, SQL*Loader, BCP, DTS and DBCC scripts.

Oracle 11i Financials (AR, AP, GL, Receivables, Purchasing, iProcurement, Projects, and Contracts) single-node environments on shared servers. Tasks also included patches, cloning and tuning.

ADP Oracle EHRMS (PeopleSoft) databases and web/application multi-tier environments installation and support.

DBA Client Services management including Oracle databases, application servers.

TekSystems for Carter & Burgess, Fort Worth Texas

Senior Database Administration/Software Development Consultant

Contracted at Carter & Burgess civil engineering to provide database and application support.

Production and Test Oracle 7-8i database administration on HP-UX, SCO-Unix, DG-UX and Microsoft.

Oracle database architecture and design.

Performance tuning and PL/SQL and SQL optimization.

Database server support including storage array management.

Legato backups and restores.

Oracle database and client software installations and upgrades.

Oracle utility programming including import, export and SQL*Loader scripts.

Oracle Developer 2000 Forms and Reports application support.

Verizon Wireless/US Cellular, Westlake Texas

Junior Oracle DBA and Application Support

Brooks-PRI Inc., Austin Texas

Sr. Wafer Fabrication Automation Software Engineer

PPD Pharmaco, Austin Texas

Sr. Clinical SAS Programmer/Analyst

Butler Service Group for IBM, Austin Texas

Contract SAS Programmer/Analyst at IBM Austin

Lockheed-Martin Aerospace, Fort Worth Texas

Engineering Planner/SAS Programmer

Education and Training

Texas State University, San Marcos, Texas

B.B.A., Computer Information Systems; Graduated

Oracle (through Oracle 11g) Database courses and training

Microsoft SQL Server (through SQL Server 2016) courses and workshops

MySQL, NoSQL, PostgreSQL 9 courses

Rackspace CloudU Certification

Oracle Applications DBA courses and workshops

SAS and JCL interaction, SAS Processing, SAS/ACCESS, and SAS/Macro training

Contact this candidate