Sr. Consultant - Oracle Dba Resume
SUMMARY:
- IT experience providing full - lifecycle technical support and administration in various industries 26+ years DBA Leadership and/or Management role, excellent leadership and mentoring skills 8+ years Oracle performance tuning and backup recovery18+ years Oracle database design, admin, & support in UNIX & Window OS environment 22+ years
- Oracle RAC 9iR2 3+ years Oracle RAC 10gR2 3 years Oracle RAC 11gR1 & 11gR2 8+ years Oracle ASM
- 5+ years Oracle OEM 9i, Grid Control 10g & 11g 5+ years Oracle RMAN (8i, 9i, 10g, 11g) 10+ years Oracle Stand-by database
- 4+ years Oracle Data Guard, Data Broker 6+ years Golden Gate 6 months UNIX and UNIX Shell Scripting (csh, ksh, sh, bash, awk, sed)18+ years UNIX/Linux system administrationand support
- 4+ years HA/Cluster Tech: First Watch, MC Service Guard, Sun Cluster, HACMP, VCS, CRS
- 7+ years Experience with various database HA products and Oracle MAA (implementing and supporting)
- 7+ years Experience with various SAN technologies: EMC, NetApp, and Hitachi; and blade technologies 6+ years
SKILLS:
DB Technologies: SQL*Plus, Import/Export, SQL*Loader, DBArtisan, ER/Studio 4.0, Erwin 3.5.2, Oracle Database Designer, Oracle RMAN, Tivoli, Quest-Spotlight, BMC Patrol, Patrol for Oracle, Patrol for Sybase, SQL*BackTrack, SQL Navigator, Oracle Apps 11i; 9iRAC, 10gRAC (CRS), Tivoli Storage Manager, VERITAS Net Backup, Legato, OEM, Oracle SQL*Net, Oracle Data Guard, STATSPACK, Oracle Active Data Guard, Data Pump, Oracle AQ, OEM, GRID Control, OID, OIM, ASM, AWR, Flashback Database, OPatch, Golden Gate
Databases: Oracle 5.X, 6.X, 7.X, 8.X, 8i, 9i,10g,11g; Sybase 9.X, 10.X,11.X, & 12.X, Informix 5.X On-Line, Informix 9.2, 10
Productivity Tools: Microsoft Word, Excel, Power Point, Visio, Internet Explorer, Outlook, Project, Access, Reflections, SSH, SFTP, Cygwin, & VNC Viewer
Hardware: Sun SPARC, HP9000, Confidential Blades, Confidential Power Systems, EMC Symmetrix 3830, EMC CLARiiON FC4700, CX600 Dell/EMC, Dell, Compaq
Operating Systems: UNIX, SunOS 5.X, Solaris x86 2.9 - 2.10, Solaris SPARC 2.4 - 2.10, Confidential -UX 9.X, 10.X, 11.X; AIX 4.2 - 5.3, LINUX RedHat 7.2, 8.0, ENT 3, 4, SUSE Linux 9.X, 10.X, 11.X; DOS, Windows NT, Window 2000, Windows XP, Windows 7, MAC OS
Languages: SQL, PL/SQL, Bourne, Korn, Bash
WORK EXPERIENCE:
Confidential
Sr. Consultant - Oracle DBA
Responsibilities:
- Implement and support Oracle database servers (Oracle 9.2.0, 10.2, 11.1, 11.2) in Solaris & LINUX OS environments.
- OLTP and OLAP (DSS/DW) database types with ASM and Standalone HA..
- Perform Oracle databases Infrastructure Health Checks for various accounts.
- Identify and provide feedback improvements for Confidential standards and Oracle database best practices.
- Assess impact, risk, probability, urgency of each risk/gap and categorize appropriately, and develop recommendations. Install and configure OEM Cloud Control 12cR4 Design, install, configure, and support several prod/qa/dev Oracle 11gR2 RAC database environments (2 & 3 nodes) in Solaris, LINUX, & Confidential OS environments.
- Apply current PSU patches on various Oracle 11g database environments (prod/uat/qa/dev).
Confidential
Sr. Consultant - Oracle DBA
Responsibilities:
- Provided performance and tuning improvements on Oracle 9i database in AIX environment.
- Create and run scripts to purge database tables.
- Implemented and supported Oracle (300+ TB) database server (Oracle 9.2.0) in AIX environment
- Wrote UNIX csh, ksh, and sh shell scripts to monitor and maintain the OS and database.
Confidential
Sr. Consultant - Oracle DBA
Responsibilities:
- Provided performance and tuning improvements on Oracle 9i database in AIX environment.
- Performed Oracle 9i database (patch) upgrade 9.2.0.1 to 9.2.0.8.
- Fixed Oracle database memory issues, also tuned at database and system level.
- Wrote UNIX csh, ksh, and sh shell scripts to monitor and maintain the OS and database.
Confidential
Team Lead, Sr. Consultant - DBA
Responsibilities:
- Implemented and supported Oracle (6 TB) database servers (Oracle 9.2.0, 10.2, 11.1, 11.2) in Solaris & LINUX OS environments.
- OLTP and OLAP (DSS/DW) database types.
- Configured and implemented Oracle 11gR2 RAC test and prod database environment (Solaris & Linux).
- Provided Technical Lead support to DBA staff, also coordinate and assign work as needed.
- Fixed Oracle database memory issues, also tuned at database and system level.
- Provide 24x7 production support.
- Established a best-practices approach to ensure security and develop SOX metrics for database auditing.
- Worked in a cross-functional team environment of 100+; which used an Agile and RAD Methodology SDLC (public sector focus).
- Migrated/upgraded Oracle 9i, 10g, and 10gR1 databases to 11gR2 database.
- Developed database standards for Oracle & SQL Server databases.
- Managed and tracked the progress of various projects various Oracle & SQL Server project implementations (Primavera, RAC, SharePoint, Esri ArcGIS, and OEM Cloud Control 12cR2).
- Performed ASM configuration and support. Managed team of 5 (Oracle DBAs (2), Oracle Developer (1), and SQL Server DBAs (2)).
- Evaluated work assignments and performance of staff; also responsible for staffing the department.
- Wrote UNIX csh, ksh, and sh shell scripts to monitor and maintain the OS and database.
Confidential
Sr. Consultant, Oracle DBA
Responsibilities:
- Audited and created an audit document for the Oracle database environments.
- Performed performance and tuning for (Oracle 10.2, 11.1, 11.2) in LINUX RedHat and Confidential Itanium environments.
- OLTP and OLAP (DSS/DW) database types.
- Wrote proposal for a HA/DR solutions for the current Oracle DB environments.
- Defined and implemented Oracle database monitoring with OEM and Nagios.
- Installed, configured, supported Golden Gate 11g and 11g.
Confidential
Technologist, Sr. Oracle DBA
Responsibilities:
- Installed, configured, and supported Oracle database servers (Oracle 9.2, 10.2, 11.1, 11.2) in LINUX RedHat environments. - OLTP and OLAP (DSS/DW) database types.
- Supported 5-node 11gR2 RAC cluster in Linux 5.5- 64 bit environment.
- Performed ASM configuration and support. Performed current PSU patching for RAC and stand-alone 10g & 11g databases.
- Wrote UNIX csh, ksh, and sh shell scripts to monitor and maintain the OS and database (Oracle 10.2, 11.1, 11.2).
- Wrote Oracle DB documentation. Migrated/upgraded Oracle 8i and 9i databases to 11gR2 database. Worked in a cross-functional team environment of 100+; which used a Scrum Agile Methodology SDLC with Sprint Tasking. Created and generated reports and presentations. Ran SQL scripts against Dev/Test and Prod databases.
Confidential
Sr. Consultant, DBA Mgr
Responsibilities:
- Installed, configured, and supported Oracle database servers (Oracle 10.2, 11.1, 11.2) in LINUX RedHat environments.
- OLTP and OLAP (DSS/DW) database types.
- Designed, installed, and configured 3-node 11gR1 RAC cluster in Linux 5.4- 64 bit environment.
- Performed ASM configuration and support.
- Performed current PSU patching for RAC and stand-alone 10g & 11g databases.
- Wrote UNIX csh, ksh, and sh shell scripts to monitor and maintain the OS and database (Oracle 10.2, 11.1, 11.2).
- Participated in on-call pager duty every other week. Installed, configured, patched and supported OEM Grid Control 10g and 11g.
- Wrote and maintained Oracle DB and DBA documentation. Led database upgrade project of 3-Node 10gR2 RAC cluster to 3-node 11gR1 RAC cluster.
- Worked in a cross-functional team environment of 100+; which used an Agile Methodology SDLC with Sprint Tasking.
- Managed a team of 4 (Oracle DBAs (1) & SQL Server DBAs (3).
- Installed, configured, supported Golden Gate 10g and 11g. Established a best-practices approach to ensure security and develop SOX/PCI metrics for database auditing.
- Evaluated work assignments and performance of staff; also responsible for staffing the department.
- Tracked licenses and support agreements for Oracle and SQL Server products.
- Resolved intra-department conflicts and information technology service issues.
- Communicated status of activities with the team, peers, management, and end-users.
- Established database standards with best-practices approach to ensure the stability of database environments.
Confidential
Sr. Consultant, Oracle DBA
Responsibilities:
- Installed, configured, and supported Oracle (10 TB) database servers (Oracle 10.2, 11.1, 11.2) in Solaris, LINUX, zLinux, & AIX OS environments.
- OLTP and OLAP (DSS/DW) database types.
- Designed, installed, configured, and support several prod/uat/qa/dev Oracle 11gR1 & 11gR2 RAC database environments (2 & 3 nodes) in Solaris, LINUX, zLinux, & AIX OS environments. Wrote UNIX csh, ksh, and sh shell scripts to monitor and maintain the OS and database.
- Participated in on-call pager duty every 3 weeks.
- Worked in a cross-functional team environment of 100+; which used a Scrum Agile Methodology SDLC with Sprint Tasking.
- Migrated/upgraded Oracle 9i, 10g, 11gR1 databases to 11gR2 database.
- Installed and configured 10gR2 (10.2.0.5) Grid Control Agent on LINUX, zLinux, & AIX OS environments.
- Installed, configured, patched and supported OEM Grid Control 10g and 11g. Performed ASM configuration and support.
- Managed and tracked the progress of various projects various Oracle project implementations (RAC, upgrading, and PSU patch management).
Confidential
Full-time Instructor
Responsibilities:
- Taught a variety of CIS classes (Oracle10g/11g SQL, Database Administration, Backup Recovery, & Performance Tuning; & UNIX/Linux Administration, UNIX Shell Script Programming (SUSE 10.3, 11.1, Red Hat, Fedora 9, 10), System Analysis and Design, Database Management.
- Taught a variety of CIS (Operating System Concepts, Computer Concepts, Windows Operating Systems) Maintained CIS computer labs Oracle 10g & 11g database and Linux machines.
- Wrote UNIX csh, ksh, and sh shell scripts to monitor and maintain the OS and database; and demonstrate to students the UNIX shell scripting concepts.
- Performed ASM configuration and support.
- Built, installed, configured, implemented, and supported (20+) Oracle database servers (Oracle 10.2, 11.1, 11.2) in Windows, Open Solaris, and LINUX OS environments.
- Used Angel Learning System.
- Taught a variety of CIS classes (Oracle9i/10g SQL, Database Administration, Backup Recovery, & Performance Tuning; & Linux Administration (SUSE 10.3, Ubuntu 7 & 8, Red Hat, Fedora), System Analysis and Design, Database Management.
- Teach a variety of CIS (Microsoft Office, Computer Concepts), BUS (Accounting, Economics, Marketing, and Merchandising).
- Maintained CIS computer labs Oracle 9i, 10g & 11g database and Linux machines.
- Wrote UNIX csh, ksh, and sh shell scripts to monitor and maintain the OS and database; and demonstrated to students UNIX shell scripting concepts.
- Built, installed, configured, implemented, and supported (20+) Oracle database servers (Oracle 9.2, 10.2, 11.1) in Windows and LINUX OS environments.
- Used Blackboard, WebCT, and/or Angel Learning System.
Confidential
Sr. Consultant, Oracle DBA
Responsibilities:
- Wrote UNIX csh, ksh, and sh shell scripts to monitor and maintain the OS and database.
- Built, Installed, implemented, configured, and supported Oracle database servers (Oracle 10.2) in an LINUX OS environment.
- Built, Installed, implemented, configured, Oracle GRID Control (10.2.0.4) in an LINUX environment.
- Supported Oracle database servers (Oracle 10.2) in an AIX and Solaris OS environment.
Confidential
Sr. Consultant, Technical Lead Oracle DBA
Responsibilities:
- Implemented and support Oracle (4 TB) database servers (Oracle 9.2.0, 10.1, 10.2, 11.1) in Solaris, LINUX, & AIX OS environments.
- OLTP and OLAP (DSS/DW) database types.
- Configured and implemented RMAN 9i/10g in (UNIX) environment to disk and tape (VERITAS Netbackup).
- Configured and implemented Oracle 10g RAC test and prod database environment (Solaris & Linux).
- Provided prod/qa/dev design and support or Oracle 10g RAC database environment (LINUX RedHat and SUSE).
- Provided prod/qa design and support Oracle Data Guard 10g database environment (LINUX RedHat and SUSE, Solaris).
- Provided Technical Lead support to Junior DBA staff 5+ Oracle DBA’s, also coordinate and assign work as needed.
- Wrote UNIX csh, ksh, and sh shell scripts to monitor and maintain the OS and database.
- Migrated/upgraded Oracle 9i and 10g databases to 11gR1 database.
- Worked in a cross-functional team environment of 100+; which used an Agile Methodology SDLC with a public sector focus.
- Performed ASM configuration and support.
- Managed and tracked the progress of various projects various Oracle project implementations (Data Guard, RAC, and RMAN).