John F

Database Administrator - 15 Years of Experience - Near 30022


Database Administrator

Education Level:


Will Relocate:



Areas of Expertise * Certified Oracle Professional * Problem Resolution * Data Migration * Database Design * Performance Analysis * Product Development * Performance Tuning * PL/SQL Development * Business Analysis * Oracle DB2 SQL UNIX Oracle Enterprise Manager ADDM Oracle Recovery Manager Oracle Dataguard Oracle Application Express Oracle Application Server Database Optimization * Provided Oracle support and improvement, including performance tuning, problem resolution, database monitoring, and product implementation. * Upgraded Oracle databases to latest versions, optimizing operational success. * Designed, built, and implemented the database for "BellSouth Buzz, " a locally focused internet portal, receiving commendation for project management capability. * Managed and directed all upgrade functions, coordinating upgrades for development, test, and production databases. * Built and implemented an Oracle 8.1 database environment, subsequently migrating existing data from a SQL Server database to substantially improve system reliability and increasing capacity. * Setup and implemented OEM Grid Control for management of a web-based auto auction clearinghouse and a university computing center with 20+ databases and 15+ hosts. * Developed a SQL Server production environment and transferred a production Oracle database from a host in California to an Operations Center in Atlanta. * Successfully re-architected and implemented a UNIX-based, credit-related product. Operational Process Improvement * Reduced daily processing times by 75% through revising and expanding PL/SQL procedures for daily maintenance of BellSouth's internet-based product catalog. * Developed a Customer Information System using Oracle Application Express, effectively tracking customer sites, contacts, activity, and VPN access instructions. * Implemented dataset monitoring scripts on multiple database hosts to send notification via email and text messages. * Setup a Disaster Recovery database using Dataguard and a RMAN-based backup and recovery solution to ensure information retention in case of failure. * Substantially reduced query processing times during system testing through effective collaboration with developers to optimize application SQL. * Served as BellSouth representative on the Oracle Application Server Customer Advisory Council to provide superior customer service and ensure satisfaction.





CollapseJob Skills