Served as a key corporate resource of over 100 multi-vendor, high-volume Production, Development, and Test databases for the World’s largest retailer of musical instruments with revenues exceeding $2 billion annually, with 309 retail outlets in 43 states, and Musician’s Friend Inc., (North America’s largest volume web, and catalog databases.)
•Collaborated with cross-functional team managers to complete over 15 Oracle, MySQL, Essbase, and Netezza Production database upgrades with no impact to production timelines.
•Planned and installed corporate-wide Oracle 10.2.0.4 software patches and applied Critical Patch Updates to meet PCI compliance for Musician’s Friend Production databases.
•Revitalized visibility of MySQL Shipping Order Fulfillment system.Upgraded database, stabilized parameters, streamlined I / O, and developed High Availability solution.
•One of two DBA members entrusted with the implementation of Oracle 10g Grid Control deployed as Corporate-wide Database Management System.
•Recovered several Production Oracle RAC 10g and 9i instances after power outage caused system and database crashes.
•Installed Oracle Database Vault for PeopleSoft Payroll system to satisfy SOX requirements.
•Provided input for DBA Group during weekly Change Management meetings.
•Maintained High-level performance tuning, and troubleshooting of less than obvious performance problems.
•Provided DataPump, Export, and Import Production data refreshes to non-production databases for development purposes.
•Managed Metalink service request, opened, logged, and closed Technical Assistance Requests (TAR), to resolve software bugs and production database issues.
Environment:AIX, SUN Solaris, UNIX, Red Hat Linux, Windows, Oracle 11g, 10g, 9i, 8i, Oracle 10g, 9i RAC, Oracle 10g Grid Control, Oracle Enterprise Manager, DataPump, Recovery Manager (RMAN), Oracle Application Express (Apex), Oracle HTML DB, Oracle Database Vault, MySQL, Hyperion Essbase, Netezza, VPN, Status and Change Management.