Chaz Ackerman

Experience

• 

  OSI Consulting

  Jun 1996 - Jun 1999

  Oracle Applications DBA

  Worked as an on-site consultant for two companies:1) Unocal 76 Products Division- Provided 24x7 DBA support for Oracle Financials (Rel 10.5/10.7, 120GB), a marketing data warehouse application (90GB), Order Capture and a Pricing applications on Sequent and Sun platforms that served over 3,000 global users- Created a Concurrent Manager job-queue assignment process which significantly increased the throughput of jobs and the productivity for the entire company- Audited, automated and monitored all of the hot, cold and archive log backups; created scripts to do hot backup image copies in parallel to tape and disk- Automated the cloning of the database and EBS environments from production to dev/test (before RapidClone)- Developed an object-oriented, proactive monitoring environment to notify the on-call DBA when there were problems with key components of Oracle, EBS and UNIX- Worked with developers on custom forms, reports, packages; migrated code changes to production- Split the Concurrent Managers to run on multiple servers to distribute the load2) NET Corporation Show less

• 

  SiteLite

  Jul 1999 - Jul 2004

  Senior Oracle and Oracle Applications DBA

  SiteLite provided Network, Unix, Windows, Oracle and E-Business Suite (EBS) remotely managed services for over 300 clients; a key component of their services was a proprietary monitoring and alerting system================Application Developer================- Key participant in the design and development of their proprietary monitoring and alerting system; designed and implemented scaleable infrastructure solutions to handle the explosive growth of the company- Designed and implemented a multi-tiered, modular, load-balanced methodology to collect and load the hundreds of thousands of application performance data metrics that were collected hourly- Developed modular scripts to automate and simplify many common Oracle and EBS DBA tasks and to extract information about the EBS environment from the key EBS tables and views=====================Oracle and Oracle EBS DBA=====================- Managed the SL Oracle databases which included an OLTP alert processing application (50GB, 24x7, Solaris) and a performance stats data warehouse (80GB) load balanced across 4 Linux servers; tested the DB failover plans by switching to the stand-by DB every other month- Created an automated method for cloning the EBS 11.0.3 environment prior to the introduction of the Rapid Clone technology- Provided expertise for Oracle backup and recovery planning, configuration and implementation using RMAN, DataGuard, replication, image copies, export/import and automated scripts; configured RMAN duplication for creating standby and non-production databases- Performed SQL & PL/SQL query analysis for performance tuning- Provided EBS support and consulting services in EBS versions 11.0 through 11.5.9; this included production support, troubleshooting, installing, patching, upgrading and EBS environment cloning- Upgraded databases from 8i to 9i and then to 10g; created standby databases using Dataguard Show less

• 

  Mercury Technology Group

  Feb 2005 - Nov 2005

  Oracle and Oracle Applications DBA

  MTG provides Managed Hosting Services- Provided 24x7 Oracle and Oracle Applications consulting and support services for their clients- Performed cross platform EBS upgrade - Windows/11.0.3 to Linux/11.5.10.2- Automated the 11.5.10.2 cloning process using the EBS rapidclone tools and UNIX scripts - Installed Oracle Enterprise Manager to allow for more efficient management and monitoring of the hosted clients- Installed a new Oracle Application Server (10g iAS) implementation for OID and SSO Show less

• 

  OSI Consulting

  Dec 2005 - May 2006

  Oracle and Oracle Applications DBA

  OSI provides Oracle and Oracle E-business Suite managed hosting services and consulting- Audited, organized, automated and documented many critical policies and procedures like backups and cloning that were previously done manually- Implemented DR sites using Data Guard for multiple clients- Implemented RMAN backups instead of image copies- Audited, organized and documented the policies and procedures for all Netbackup backups- Created a CVS repository to help manage the scripts and files used to support their clients- Provided process improvements and documentation for their Oracle EBS Managed Hosting group- Organized, Automated and documented the EBS cloning procedures Show less

• 

  NextWave Broadband

  May 2006 - Dec 2009

  Oracle Applications DBA

  Nextwave Broadband was a startup company that aspired to design and manufacture wireless communication devices and chips- Provided 24x7 on-call support, troubleshooting, patching, cloning, backups, tuning, code migrations for an Oracle 11i EBS instance (11.5.10.2)- Performed performance tuning, capacity planning and problem resolution as needed- Supported the rollout and implementation of these modules: HR, AP, AR, GL, FA, INV, PO, PA, PJM, iExpenses, OSFM/BOM/ENG/WIP- Played a key role in the financial integration of 2 international companies: (1) wrote scripts to add functional configuration data using the APIs (2) wrote scripts to create users, responsibilities and profile options for the new business; (3) created scripts to load configuration data using Dataloader- Performed the EBS Noetix Reporting S/W installation, implementation and management; designed scripts using the Noetix APIs to create and modify the Notetix roles- Upgraded Discoverer from version 4 to version 10.1.2; designed Discoverer reports and managed the Discoverer EUL repository using the Disco Admin GUI tool- Implemented and documented SOX access control and security policies using Apps and DB profiles and created monitoring scripts to check for potential access violations Show less

• 

  PacketVideo

  Jan 2010 - May 2013

  Oracle and Oracle Applications DBA

  Packet Video designs software for wireless communications companies.- Provided 24x7 on-call support, troubleshooting, patching (CPUs/PSUs), cloning, backups, tuning, code migrations for an Oracle 11i EBS instance and a separate Oracle 11gR1 24x7 application- Performed Oracle EBS upgrade from 11i to R12.1.3 using the Maintenance Wizard- Performed the DB upgrades from 9.2.0.8 to 10.2.0.4 and then to 11gR2- Installed and configured OEM DB control and used it for monitoring multiple DBs- Configured RMAN for backups and DB duplication (cloning)- Configured 11gR2 Clusterware/ASM/RAC in a test environment- Installed OEM 12c to evaluate its operational usefulness Show less

• 

  Mercury Technology Group

  May 2013 - Dec 2018

  Senior Developer Business Continuity
• 

  Velocity Technology Solutions

  Jan 2019 - Jan 2021

  Senior DevOps Engineer

  Velocity was acquired by Navisite

• 

  Navisite

  Jan 2021 - Jan 2024

  Senior DevOps Engineer

  Navisite was acquired by Accenture

• 

  Accenture

  Jan 2024 - now

  Senior DevOps Engineer