We provide IT Staff Augmentation Services!

Sr. Consultant - Oracle Dba Resume

5.00/5 (Submit Your Rating)

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).

We'd love your feedback!