Resume of Oracle DBA

Title
Oracle DBA

Primary Skills
Oracle DBA

Location
US-GA-Atlanta

Posted
Apr-04-07

Wesley has over 10 years of experience in all phases of design, development, and implementation in the IT arena. He has worked within the banking, government and insurance industries as well as in the retail industry. He has expert experience in planning, designing, installing and maintaining Oracle Database technologies (10G, 9i, 8i, 7.x ) on multiple nodes in the UNIX/Linux, Apple MAC, Windows and clustered environments. He also has experience in cold-failover configuration on Sun Clusters with 10G databases. He has also implemented various database solutions such as 10G RAC, 9i RAC, Data Guard,Oracle Grid and Oracle Streams. His areas of expertise include RAC installations, high availability, performance tuning and he is highly proficient in writing functions and procedures using PL/SQL.

Database Versions
Oracle (7, 8i, 9i, 10G), SQL Server (6.5 , 7.0, 2000), MySQL, Adabase, DB2
Operating Systems
UNIX AIX (4.3, 5L, 5.2), Linux (Redhat 6.0 -8.1, Suse ), Sun Solaris, Windows NT/2000,Apple MAC, HP-UX, OpenVMS
Tools/Applications
PeopleSoft, EMC Powerpath, EMC Replication Manager, Seibels,BMC SQL Backtrack,
BMC Patrol, Quest SQL Navigator/Lab, Quest Spotlight, SQL Loader,
OEM, RMAN, Erwin, TOAD, Microsoft Office, Remedy AR, Dimensions PVCS
Languages
Korn Shell, C shell, C, PL/SQL, Oracle Forms, Perl, COBOL, CICS, Natural


Experience:


7/05- Present
Principal Consultant, Oracle Corporation

· Configured, implemented 10GR@ RAC with ASM disk on Linux servers· Performed several RDBMS upgrades from 8i to 9i, 8i to 10G, 9i to 10G and 7.x to 8i on AIX 32 bit and 64 bit platforms· Expert in 10G Oracle RDBMS installation on Linux platforms (32 and 64 bit), upgrade, configuration, backup, recovery, archiving & purging activities· Used stats pack report to tune materialized views by creating materialized view logs to enable fast refreshes on master tables.· Created physical standby database from hot backup of primary database· Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration· Created logical standby database from hot backup of primary database· Resolved gaps between primary and standby databases (Gap Resolution)· Designed, documented, implemented, and maintained all disaster recovery procedures · Setup physical standby on a 9i database to protect mission critical from any failures, errors or corruptions· Configured a cold-failover for 9i and 10G database using Sun clusters 3.1
· 10G RAC switchover and failover configuration,implentation, and testing· Installed Oracle 10G RAC on Linux platform using ASM for a storage manager· Provided performance tuning on a 10G RAC database on a Linux platform· Installed Oracle 9i RAC in a Unix environment for multiple nodes· Configured a 10G database in a non RAC environment using Sun clusters· Tuned 10G RAC on MAC platform using ASM on JBOD (just bunch of disks)· Installed 10GR2 RAC with ASM on a 4 node linux cluster


11/99-7/05
Database Administrator, Ahold Information Services

· Support over 2500 databases across multiple platforms with sizes ranging from 500MB to 2TB
· Develop RMAN scripts for backup and recovery of databases.
· Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98% of the time.
· Provide development and production support including on call requirements
· Database design/architecture experience using both logical and physical modeling using Erwin Tools
· Excellent communication skills and the ability to work independently or in a team environment
· Design, document, implement, and maintain all disaster recovery procedures which result in no data loss while saving the company over 500k
· Perform daily operational duties/security for all users of the databases
· Develop, implement, and provide operational support of distributed application point of sale (POS) programs in a production environment
· Administer, maintain, develop and implement policies and procedures for ensuring the security and integrity of the company databases.
· Resolve database performance issues, database capacity issues, and other distributed data issues (OLTP).
· Ability to work in stressful environment while handling demanding internal and external clients


1/99-11/99
Technical Consultant (Programmer/Analyst), Transaction Information Systems (Food Lion)
· Designed and implemented korn shell programs to implement Walker Financial system.
· Developed and maintained interfaces for payroll systems using Natural/adabase.
· Worked on complex system analysis and programming assignments
· Developed , completed, and evaluated UNIX based System Test Plans.
· Used problem determination skills (i.e., reported problems, on-call).
· Experienced with both centralized and distributed data management technologies

12/97-1/99
Technical Consultant (Programmer/Analyst), Business Control Systems (Bank of America)
· Production Support for financial applications on multiple platforms
· Identified and developed procedures for system backup and disaster recovery.
· Constructed C programs embedded with SQL in accordance to shop's standards.
· Designed effective programs that manipulated tables for reconciliation accounts.
· Experienced with life cycle methods and critical business applications
· Experienced in working in both a team and individual environments.
· Strong ability to handle multiple projects simultaneously through completion.

5/96-12/97
Programmer/Analyst Policy Management Systems Corporation (PMSC)
· Mainframe/Client Server programmer- coded complex programs from specifications given.
· Concentrated on insurance applications development, maintenance and support
· Y2K projects- changed date fields in preparation for the year 2000.
· Demonstrated proficiency is using structured systems development methods and techniques
· Developed specifications for new and existing programs.
· Actively tested and debugged COBOL and CICS modules.


Education:
BS Professional Mathematics /Computer Science. May 1996
South Carolina State University Orangeburg, SC

Oracle Training-
· Oracle Deep Dive RAC training (Oracle University)
· Oracle Internals (Oracle University)
· Oracle 10G New Features for Administrators (Oracle University)
· Oracle 9i New Features for Administrators (Oracle University)
· Oracle Database 10g: Real Application Clusters (Oracle University)
· Oracle Database 10g: New Features for Administrators (Oracle University)
· Oracle Database 10g: SQL Tuning Workshop (Oracle University)
· Oracle Enterprise Manager 9i (Oracle University)
· Oracle9i Performance Tuning (Oracle University)
· Advanced Backup and Recovery for Oracle9i (Oracle University)
· Oracle 8i Backup and Recovery (Oracle University)
· Oracle 8i Performance Tuning (Oracle University)
· Oracle 8i Architecture and Administration (Oracle University)
· Oracle 8i Network Administration (Oracle University)
· Introduction to Oracle: SQL and PL/SQL (Oracle University)

Certifications
Oracle Certified Professional


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-GA-Atlanta »
View all resumes in US-GA »

View other Oracle DBA resumes, Database Administrator resumes