Database Administrator Oracle
Resume:
Griffin Ray Willard
Sr Engineer DBA/Sr Oracle DMA(Exadata)
**********@*****.***
https://www.linkedin.com/in/griffin-willard-921290a/
Griffin Willard has 20 years of experience as an Oracle Database Administrator with the past 21 years focusing on Oracle Exadata v1,v2,X3.X4.X5.X6.X7,X8.x9 with RAC 9i,10g,11g,12c,18.,19,20 He has been the SR. Lead DBA on many global implementations and engagements on all major database, iAS, RAC,Exadata products. His duties included, but were not limited to, performance tuning, architecture design with an emphasis on high availability, disaster recovery, upgrades to 9i,10g,11g,12c,18c,19c.20c Databases and Tech Team Lead on the Exadata Pre,Post Production Installs and Configuration on over 300 Installs
Professional Experience
Sr Principal Exadata DBA/DMA 09/2023 – 05/2024 KP
Duties and tasks are standard with some variation. Completes own role largely independently within defined policies and procedures. Experience supporting relational databases as a DBA, with multiple distributed relational DBSM's or a depth and focus in Oracle and related tools. Exposure and practice at using the DBMS to optimize performance of large databases for enterprise use is preferred
Skill Set Core DBA
Core DBA skills - Database Administration, Server Installation, Upgrades and Migrations, Logical and Physical Database Design, Backup and Recovery Strategy Oracle 7,8i,9i,10g,11g,12c,18c Database, Engineer System – Exadata
. 24x7 tier 3 support to production
, Sr lead on the Exadata Engineering Systems and the Training of other Oracle Engineers
. Technical Onsite/Account Management role
. Tar management for client
. Identify and remove roadblocks to problem resolution
. Managed escalations across multiple lines of business within Oracle
. Prepare business justifications for escalations/one-off patches
. Coordinated Tar Management conferences calls
. Prepare TAR/MOS reports (including research, annotation, and distribution)
. Create Support Plans annually
. Facilitated customer with prioritization of issues
. Problem research (troubleshoot functional and technical issues)
. Studied and analyzed present business processes of the client
. Creation Test Case Scenarios
. Replicate the problem faced by clients in Oracle environment
. Provided performance assessment
. Tar Creation on business critical issues
. Provided proactive upgrade analysis
. Formulation of 11i Implementation Project Plan
. Operate Oracle helpdesk fielding technical and non-technical questions
. Patch and Impact Analysis (for solving problems and avoiding problems)
. Provided whitepapers on new functionality with each major application release
. Business Critical and Technical Assessments
. Owning and resolving technical issues of the Customer
. Strong fundamentals and hands-on working experience in the following areas
- Oracle Database Installation and Upgrade
- Oracle Real Application Clusters (RAC)
- Database Performance and Tuning
- Database Backup & Recovery (Including RMAN)
-
Sr Principal DBA 08/2023 – 09/2023 SC Inlet Ports
Duties and tasks are standard with some variation. Completes own role largely independently within defined policies and procedures. Experience supporting relational databases as a DBA, with multiple distributed relational DBSM's or a depth and focus in Oracle and related tools. Exposure and practice at using the DBMS to optimize performance of large databases for enterprise use is preferred
Skill Set Core DBA
Core DBA skills - Database Administration, Server Installation, Upgrades and Migrations, Logical and Physical Database Design, Backup and Recovery Strategy Oracle 7,8i,9i,10g,11g,12c,18c Database
Sr Principal Exadata DBA/Onsite/IRE/DMA 03/13/2002- 042/28/2024 Oracle USA
Duties and tasks are standard with some variation. Completes own role largely independently within defined policies and procedures. Experience supporting relational databases as a DBA, with multiple distributed relational DBSM's or a depth and focus in Oracle and related tools. Exposure and practice at using the DBMS to optimize performance of large databases for enterprise use is preferred
Skill Set Core DBA
Core DBA skills - Database Administration, Server Installation, Upgrades and Migrations, Logical and Physical Database Design, Backup and Recovery Strategy Oracle 7,8i,9i,10g,11g,12c,18c Database, Engineer System - Exadata
Exadata V1,V2,X2,X3,X4,X5,X6,X7,X8,X9 Install and Configuration, Weblogic
Onsite Engineer
Skill Set
The skill set of an Onsite Engineer consists of the Core DBA skills and
Following! are the list of Duties and Tasks exercised and required to perform as an
Onsite Engineer.
. 24x7 tier 3 support to production
, Sr lead on the Exadata Engineering Systems and the Training of other Oracle Engineers
. Technical Onsite/Account Management role
. Tar management for client
. Identify and remove roadblocks to problem resolution
. Managed escalations across multiple lines of business within Oracle
. Prepare business justifications for escalations/one-off patches
. Coordinated Tar Management conferences calls
. Prepare TAR/MOS reports (including research, annotation, and distribution)
. Create Support Plans annually
. Facilitated customer with prioritization of issues
. Problem research (troubleshoot functional and technical issues)
. Studied and analyzed present business processes of the client
. Creation Test Case Scenarios
. Replicate the problem faced by clients in Oracle environment
. Provided performance assessment
. Tar Creation on business critical issues
. Provided proactive upgrade analysis
. Formulation of 11i Implementation Project Plan
. Operate Oracle helpdesk fielding technical and non-technical questions
. Patch and Impact Analysis (for solving problems and avoiding problems)
. Provided whitepapers on new functionality with each major application release
. Business Critical and Technical Assessments
. Owning and resolving technical issues of the Customer
. Strong fundamentals and hands-on working experience in the following areas
- Oracle Database Installation and Upgrade
- Oracle Real Application Clusters (RAC)
- Database Performance and Tuning
- Database Backup & Recovery (Including RMAN)
. Oracle Applications 11i DBA skills in the areas of
- Installation and Architecture
- Patching and AD Utilities (including Autoconfig)
- Applications System Administration tasks including CCM administration, Users
and responsibility management)
IRE - Immediate Response Engineer
The IRE Job requires the Skill Set of the Core DBA, Apps DBA
and the Onsite Engineer-DBA
*Provided leadership and technical expertise in all aspects of administration and support for clients implementing Oracle products, primarily Oracle Database Server and its components and Oracle application server and its components on a global scale.
*Responsibilities included software installations, upgrades, client training, production architecture design, performance tuning, high availability and disaster recovery, backup strategy, sizing and configuration on various UNIX servers, HP, Linux, Sun and Windows client platforms.
*Recently has performed as DBA/Function Analysts for an on-going WebLogic/Yantra/Wmsdev implementation of an CRM/WAREHOUSE Application with a Oracle 8.1.7 database. Documented the Oracle Database and CRM Application. Performed a Oracle analysis of the Production, Test, Development instances. Created the UAT and SIT Documents and assisted in the Training of clients IT.
*As Field Support Analyst/Sr. DBA for Syntel implementation of an oracle CRM 11.51 - 11.54 Application. Provide proactive and reactive support for Oracle8I, Oracle8, to the Humana Inc business unit which provides production support to it's Healthcare customers.
*Performed and recommended on a strategic move for future software and equipment. Documented all the Oracle Database installation and
.Supporting 3rd party products need to run an Oracle Database while at Air Tours Created a short term instructional on the theory of a logical and physical Oracle Database, and SQL, PL/SQL and other aspect's of the Oracle Database. Performed an analysis on 3 party products to maintain the Oracle environment for performance and backup and recovery.
Created and setup RMAN backup procedures and documented the
procedures for the clients Support Personnel.
*Performed the analysis for installation of Automatic Dispatch Services(used to automate the Workflow Management of clients request for Utility Gas service). Responsible for maintaining OFA operational standards and setting naming conventions.
*Developing and testing back-up (Hot, Cold), Apps Tuning
Recovery (Disaster recovery, and full database exports),
*Maintain purge and re-index scripts for all databases
(PROD (3) and DEV (3), TEST (3), QA (2)) on all Unix machines and NT Boxes.
*Install Oracle Enterprise Manager and Oracle Management Server for DATABASE MONITORING
*Schema management for all Database Models.
Responsible for analysis, equipment procurement, installation and upgrade of Oracle databases (7 to 23c)
*Installing all tool products (BMC Patrol, SQL BACKTRACK, TOAD, SPOTLIGHT),
*Installing and training all personnel on Oracle Reports, Oracle DMS, Oracle Developer2000, Designer MS Project2000).
*Training of Jr. DBA's and all personnel on the use of SQLPLUS and other Toolsets.
*Responsible for analysis of all Production Databases for Performance and tuning.
*Experienced with all versions of Oracle Database Server from release 7 to 23c, Oracle Application Server 9i,10g tech stack for clients needs
03/ 97 - 04/98
AHOLD Inc. Greenville, SC
Sr. Lead Database Analyst
Responsible for maintaining OFA standards and naming conventions, back up and recovery scripts for all operational databases on AIS machines, and ensuring that the archive manager worked. Supervised 3 senior DBAs. Responsible for analysis, equipment procurement, installation and upgrade of Oracle databases and tool products. Handled several other projects in addition to those delegate to others. Was individually for 400 Oracle instances on F30/40/50s and J30/F40/F50s, NT40 in both Production and Development environments. Also responsible for the conversions from 7.x to 8.x running Oracle.
Technical Environment:
Oracle DB 7.1.4, 7.2.2, 7.3.2, 7.3.2.3, 7.3.3, 7.3.3.4, 7.3.3.5, 8.01 – 8.0.4, 8.1.5 – 8.1.7 (8i) AIX OS F30, F40, 50,J30, J
Skills Summary
Oracle Products
SKILLS HIGHLIGHT
Oracle Products:
Oracle 12c,18g,19c,20c,21c,11gR,10g-9i,8i,8,7,6, Enterprise Manager, PL/SQL, SQL*Plus, SQL*Loader, Export/Import, Recovery Manager, Enterprise Backup Utility, Data Guard, OID,9i,10g AIS(version 1,ver 2) Oracle Exadata Engineer Systems versions V1,V2,X2,X3,X4,X5,X6,X7,X8,X9
RAC Server 12c.18g,20g,21g,10g,11g,12c,18c,Exadaa v1-V2,X2-X7,X8,X9Oracle 7.1.6 through 8.0,8i(815- 817), 9iASi,10g Oracle Portal,Oracle OEM9i – 10g EM grid Control, Development Tool Set, Forms 3.0/4.0/4.5, SQL, PL/SQL, SQL Reports, 2.0,
Languages:
UNIX Shell Script (sh, csh, ksh), Pascal, perl, PL/SQL,Clipper, DBASE
Other Software/Tools:
Microsoft Office, Netscape Communicator, Internet Explorer, FTP, E-Mail
Other Databases:
Clipper, Access, DB2, QMF
Other Applications:
FLA Software Banking Systems DB2, QMF, Languages manufacturing Package JIT, JAD, BEA Weblogic, YANTRA, YUCENTRIC, SCT Banner, TOAD, ERWIN, DBARISAN, TOAD
Communications/Networking:
Net8, 9,10, SQL*Net, TCP/IP, Oracle Names,9i AIS
Operating Systems:
UNIX (MP-RAS, HP-UX, Solaris, Linux OS ver 1 - 7), Sun OS VMS, Windows 95/NT/2000/2003/XP, Redhat v2-7,IBM(4331,4381,3990)
Specialty:
Oracle 7,8i,9i,10g,11g,12c.18c,19c.20c,22c Database, Database Administration, Server Installation, Upgrades and Migrations, RAC 10g,11g
Logical and Physical Database Design, Backup and Recovery Strategy. 10.7.11.5.3 - 11.5.10 Apps tuning
Management/Leadership Skills:
Project Manager
Life Cycle Expertise/Methodologies:
Requirement Analysis, Business Process Modeling(Functional requirement Definition), Data Modeling(ER Modeling, Physical and Logical Database Design), Database Creation, Data Definition Creation, Application Development, Testing, Data Conversion & Migration, Database Administration, Database Performance Tuning & Optimization
Hardware & Operating Systems
*AIX (4.3 – 5.3)
*HPUX (11.0 – 11.11)
*Oracle Linux, Sun
*SuSE
*Redhat AS(2.1 – 8
*Solaris (2.6)
Engagement Experience
*Capacity Planning
*Portal Applications Development
*Data Conversion
*Fit/Gap Analysis
*Project Management
*Database Administration
*Database Performance
*Tuning & Optimization
*Business & Technical Process Reengineering
*Database Creation,
*Data Definition Creation
*Application Development
*End User Training
*Conversion
*Configuration
*Physical and Logical Database Design
*Testing
Other Accomplishments
Education
May 1994 SUNY Institute of Technology Utica/Rome, NY
B.S. Degree, Computer Information Science
Training
*Oracle 10g,11g,12c,11g.12g,18,19,29,21,22
*V1,2,3,X3.X4.X5.X6.X7>X8.X8,X9 Exadata DBM
*9,10,13 OEM
*Oracle 11,12,18,19, 20,21 New Features
*Oracle 11g,!2c,18g,19g.20g,21g
*Extadata V1-V2,X2-X7,X8,X9
*RAC 9i,10g.11g,12c,18c,19c,20c,21c/222c
*Dataguard 9i,10g,11g,12c.18c
*Oracle Application Server 9i,10g,Portal,OID,SSO
*Linux 2-8
*Designer/2000 Workshop.
Certifications & Associations
ITIL V3, Oracle OCI Associates Foundation
Recognition & Awards
References
Myron Landry.
*****.*******@******.***
Steve Montgomerie
*****.***********@******.***
Keshaw Joshi
******.*****@******.***
Contact this candidate