Senior Oracle Database Administrator

Posted on: 2008-10-16

Experience: Dish Network Atlanta, Georgia Senior Oracle Database Administrator 4/2008 to 8/2008 • Responsible for maintenance and 24x7 Support of multi-terabyte databases (Oracle 8i, 9i, 10g) in production, testing and development environments hosted on Unix servers (HP, Linux) and Windows servers. • Responsible for RMAN backups of production databases. • Responsible for refreshing and cloning of databases per customer requirements using RMAN, Data Pump, and hot backup scripts. • Responsible for consolidation of several production, test, and development multi-terabyte databases by migrating from HP-UX Unix environments to HP-UX Itanium Virtual Partitions (vPars). • Troubleshoot and resolve database and/or application problems encountered by end users. • Installation, upgrade and patching of databases from Oracle 8i, 9i to Oracle 10g. • Support of databases using High Availability Packages such as HP Veritas Clustering. • Monitor database performance via STATSPACK, Automatic Workload Repository, Database Control, and Quest Tools. • Participation in design reviews for upcoming application enhancements. • Provide on-call support in adherence to specific business and customer Service Level Agreements Unisource Worldwide Norcross, Georgia Senior Oracle DBA 7/2003 to 4/2008 • Responsible for maintenance, tuning and 24x7 support of Production, Development and Staging instances of Oracle Version 8i, 9i ,10g in HP-UX Unix environments. • Led the DBA team in upgrading databases from 8i and 9i to 10g. • Implementation of daily, weekly, and monthly DBA checklists for each environment. • Maintain terabyte Data warehouse Oracle database in 24x7 Production Environment. • Excellent skills in troubleshooting Oracle Database and query issues. • Install and administer OEM Grid Console. • Refresh and Clone Databases as per customer requirements. • Ensuring successful and periodical Backup, Restoration & Tuning of databases. • Implemented backup and recovery using RMAN in development environment. Documented the process for implementation in production and staging environments • Write PL/SQL and UNIX shell scripts to automate database functions, • Plan for system growth and monitor capacity usage for new hardware or software requirements and communicate these capacity requirements to management. • Works directly with software developers to develop and enhance applications and data conversions. • Support database High Availability Packages such as HP Service Guard Clustering. • Provide Business Intelligence support to Crystal Enterprise 10 users. Responsible for design, maintenance, debugging, and execution of Crystal Reports in Development and Production Environments. • Provide hands-on Crystal Reporting Support to the Finance and National Accounts Departments. • Provide on-call support in adherence to specific business and customer Service Level Agreements Robins Air Force Base Robins AFB, GA Oracle DBA (CONTRACTOR) 10/2002 to 7/2003 • Daily management, maintenance, monitoring, tuning and support of Oracle 8i and 9i databases in Unix environments (Sun Solaris, Linux Redhat 7.2), and Windows NT platforms. • Maintain multi-terabyte Data warehouse Oracle database in 24x7 Production Environment. • Configuration of Oracle 8.1.7 standby database. • Configuration and support of Oracle Enterprise Manager and customized U.S. Air Force software (CENTRA). • Implementation of backup, recovery and disaster recovery procedures. • Data Loading using SQL*Loader • Technical documentation of Oracle 8i and 9i databases, hardware, and custom applications. • Installation and maintenance of Oracle 9iAS in pre-production environment. • Implement database backups using VERITAS Net Backup 3.4.1 and Hot Backup scripts. • Provide on-call support in adherence to specific business and customer Service Level Agreements American Intercontinental University Technical Oracle DBA/Consultant 12/2001 to 12/2002 • Provide 24x7 Oracle technical assistance to Professors and Faculty at American Intercontinental University per specified Service Level Agreements. • Provide 24x7 assistance to students at American Intercontinental University in installation and troubleshooting of Oracle 8.1.7 and 9i on Windows NT/2000/XP/Linux(Unix); Oracle Designer and Repository 6i, and Oracle Developer Forms and Reports. • Create technical Installation Guides to assist students with installation of Oracle 8i and 9i, Oracle Designer and Repository on multiple platforms. • Perform data loading using SQL*Loader, import/export techniques. • Create customized user interfaces using Oracle Forms 6i, PL/SQL and Unix shell scripts. • Implementation of backup & recovery procedures and disaster recovery procedures. • Management, maintenance, monitoring, and tuning of database operations and data. . Stonebridge Technologies (formerly Tactics) Atlanta, GA Oracle DBA/Consultant 4/1998 to 4/2001 • Provide 24x7 on-call support for remote clients per specified customer and business Service Level Agreements. • Installation, testing, and documentation of Oracle 9iAS for Research and Development department. • Installation of Oracle 7.3.4, 8.0, 8i, 9i on multiple platforms (Unix and Windows) for various customers. • Daily management, maintenance, monitoring, and tuning of database operations and data for Oracle databases on multiple platforms. • Installation and configuration of Oracle Designer 6i repository and client software. • Provide documentation to customers detailing Oracle database creation, Oracle Designer 6i installation, repository creation, and data loading procedures. • Create monthly databases reports for sales and infrastructure managers with recommendations and summary of tasks performed during the month. • Provided Oracle expertise with EMC storage implementation. • Assist developers in creating client specific customized (OPTICS) financial application at Bellsouth Small Business. • Implementation and documentation of disaster recovery and data load procedures. • Used Import, Export, SQL*Loader, Legato and other tools to load and backup data. • As Lotus Notes Administrator, generated reports from Lotus Notes and SalesLogix to assist sales and telemarketing departments in contacting potential customers. • Per the sales department’s request, contacted potential clients via telephone to further explain Oracle services and answer technical questions. Education: B.S. Computer Information Systems, October, 1999 – DeVry University, Atlanta, GA SECRET security clearance – 1992-1996 References: Available upon request