SUMMARY:

• 20 years of experience as Oracle DBA; 17 years of experience at enterprise - level and the last 3 years at project-level.
• Experience with Oracle Installation, Upgrade, Patch, Service Requests, RMAN, Backup, Restore, Point-In-Time and Fast Recovery.
• Good experience with ETL including Import, Export, Migrations, and Transportable Tablespaces and Data Pump.
• Extensive knowledge in using tools such as EM, Configuration Assistance, Net Manager, SQL*Plus, TOAD, SQL Developer and SQL*Loader.
• Limited experience with Cloning, RAC, Data Guard and Clusters.
• 15 years of experience as SQL Server DBA; 12 years of experience at enterprise-level and last 3 years at project-level.
• Experience with Installation, Upgrade, 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.
• Limited experience with High Availability and Clusters.
• General DBA Experience
• Experience with Windows, Linux, Unix and AIX platforms for Production to Development environments.
• Experience with Partitions, Oracle SQL, T-SQL, PL/SQL, Stored Procedures, Packages, Functions, Triggers, Cursors and Views.
• Strong DBA and SQL Performance Tuning skills.
• Evaluation (Install, Configure, Load and Tune) and Training experience with MySQL, PostgreSQL.
• Experience Oracle Forms and Reports development.
• Good experience with SAS programming.
• Extensive experience in leading and coordinating IT support and development projects.

TECHNICAL SKILLS:

Databases: Oracle versions 7 - 11g, SQL Server versions 6.5 - 2014

Operation Systems: Unix, AIX, Red Hat Linux, Windows 95-201 0

Data Base Tools: OUI, OEM, SQL*Plus, Toad, Oracle SQL developer, SQL*Loader, SSMS, SSCM, SSIS, SQL Profiler and SQL Tuning Advisor

Languages: T-SQL, SQL, PL/SQL, Unix Shell Scripting and SAS

Methodology: Agile SCRUM and Traditional Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, Bridgewater New Jersey

Oracle & SQL Server DBA

Responsibilities:

• SQL Server DBA l ower environments; including experience with Performance Tuning, Snapshot and Transactional Replication, Transaction Log Shipping, Backup/Recovery; and some exposure to SSIS, SSAS, SSRS, High Availability, Fail Over and Cluster Configuration.
• Oracle 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.
• Exposure with Oracle 12c and SQL Server 2016 Developer evaluation.
• Evaluation environments for MySQL and PostgreSQL 9. Created and populated DBs with masked versions of limited data to evaluate products.
• Project 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.
• Project management for Personal Insurance application migration, decommissioning, and archiving. Includes data retention, vendor management, and data transfers.
• Application Administration for Confidential policy and rating client-server and web-based applications. Includes mainframe and server applications and data, vender coordination, upgrades and maintenance.

Confidential

Responsibilities:

• Oracle Sr. DBA 8i-10g 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.
• SQL Server Sr. DBA 2008 and 2001 2 for production; including ETL, Backup/Recovery, Replication and Performance Tuning.
• Development Experience with PostgreSQL and MySQL Install/Config/Load for project evaluation and testing.
• Managed IT team of 5, including programmers and systems administrators.
• Project management for Personal Insurance application migration, decommissioning, and archiving. Includes data retention, vendor management, and data transfers.
• Managed data center, including databases, applications, web and file servers.
• Managed IT security, Citrix and VPN access, backup and recovery and disaster recovery.

Confidential, Fort Worth, Texas

Oracle & SQL Server DBA Manager

Responsibilities:

• 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.
• Development Experience with MySQL
• 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.

Confidential, Fort Worth, Texas

Senior Database Administration/Software Development Consultant

Responsibilities:

• Production and Test Oracle 7-8i database administration on HP-UX, SCO-Unix, DG-UX, Linux and Microsoft.
• Oracle database architecture and design.
• Performance tuning and PL/SQL and SQL optimization.
• Database server support including storage array management.
• Oracle backups, restores, install/upgrade/patch
• Unix and Windows Server Administrator
• Oracle utility programming including import, export and SQL*Loader scripts.
• Oracle Developer 2000 Forms and Reports application support.

Confidential, Fort Worth, Texas

Junior Oracle DBA and Application Support

Responsibilities:

• Oracle Forms and Reports Development.
• Oracle project-level DBA support.

Confidential, Austin Texas

Sr. Software Engineer

Responsibilities:

• Clean-room fabrication equipment automation software design and development.

Confidential, Austin, Texas

Sr. Clinical SAS Programmer/Analyst

Responsibilities:

• Lead SAS Programmer on clinical research statistical projects.
• Responsible for training junior programmers and developing programming standards.

Confidential, Austin, Texas

Contract SAS Programmer/Analyst

Responsibilities:

• Contract SAS Programmer in support of wafer fabrication engineering statistics.

Confidential, Fort Worth, Texas

Engineering Planner/SAS Programmer

Responsibilities:

• SAS Programmer in support of aerospace engineering projects.