We provide IT Staff Augmentation Services!

Sr. Consultant - Oracle Dba Resume

3.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 recovery 18+ years Oracle database design, admin, & support in UNIX & Window OS environment 22+ years
  • Oracle 5.1.0 - 7.3.4 5 + years
  • Oracle 8.1.0 - 8.1.74 5 + years
  • Oracle 9.0.1 - 9.2.0.8 7 + years
  • Oracle 10.1.0 - 10.2.0.4 6 + years
  • Oracle 11.1.0 - 11.2.0.3 6 + 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 administration and support 4+ years First Watch, MC Service Guard, Sun Cluster, HACMP, VCS, CRS
  • 7+ years Experience with various database HA products and Oracle Confidential (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, IBM 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 Confidential 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.
  • 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

Remote 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 Confidential 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 Confidential 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 Confidential patch management).

We'd love your feedback!