We provide IT Staff Augmentation Services!

Senior Oracle Dba/system Architect Resume

Washington, DC

SUMMARY:

  • Over 20+ years of progressive technical experience in Information Technology Solutions specializing in database management of Oracle database systems.
  • Oracle experience includes development in SQL, PL/SQL, logical modeling, physical database design, disaster planning, high availability system design & capacity planning.
  • Performed Unix System Administration duties in coordination with Oracle DBA responsibilities.
  • Experienced Senior System Architect/Database Administrator, routinely performing tasks such as installation, administration, tuning, backup and recovery strategy design, replication, high availability design & implementation, troubleshooting, upgrades, storage capacity planning, application design and implementation.
  • Very strong team oriented skills with proven success at meeting customer requirements within budget and time constraints.
  • Experience includes: full life cycle development methodology; database standards; conversion and modernization; prototyping; hardware and software integration; and evaluation of database concepts.

COMPUTER EXPERTISE:

Hardware: IBM p795, IBM XIV storage systems. Sun v490/v890, f4800, e2900/e6900, t5240, t2000 & e20k running Sun Solaris 10, HP 9000 rp & Superdome series servers running HPUX 11i, EMC Symmetrix disk arrays storage solutions, Netapp FAS arrays, HP ProLiant servers running windows, and Dell servers running Linux.

Software: Oracle rdbms v12c, v11g, & 10g, Oracle12c/11g RAC, Oracle12c/11g ASM, Oracle12c Goldengate, Oracle10g Designer, Oracle10g application server, BEA weblogic application server, MS IIS 4.0/5.0/6.0 web server, Netscape Web server, Sql*Plus, PL/SQL, Lawson HR/financials, Siebel, Quest Shareplex Replication, Oracle11g Enterprise Manager, Oracle11g dataguard, Oracle11g RMAN, Oracle10g streams, oracle9i advance replication, Oracle11g grid control, Apache Web server v1.3, Veritas Volume Manager v 4.0 & Business Objects XI 3.

EXPERIENCE:

Confidential, Washington, DC

Senior Oracle DBA/System Architect

Responsibilities:

  • Perform the roles and responsibilities as a lead technical resource on database administration, physical database design, system architecture, implementation, database tuning, capacity planning, system/database backup and recovery strategy, data architecture, high availability design, reporting database design, troubleshooting performance problems via identifying the root cause, creating solution action plans, performing database upgrades and providing production support.
  • Responsibilities include developing, implementing and administering multiple DHS biometric Oracle Databases at sizes of 525+Tb and 19+Tb running 7/24 nationwide mission critical Applications on IBM AIX p795 servers with IBM XIV storage arrays using Oracle11g rel2 RAC with dataguard physical standby databases.
  • Developed step by step plan for migration of production databases to a new data center using Oracle11g dataguard technology.
  • Developed, engineered and tested Oracle database migration plan to migrate Oracle11g RAC database from one data center to a second datacenter onto different target server platform using Oracle12c Goldengate software.

Confidential, Washington, DC

Senior Oracle DBA/Systems Architect

Responsibilities:

  • Served as senior Oracle DBA for development, test and production platforms.
  • Perform the roles and responsibilities as a lead technical resource on physical database design, system architecture, implementation, database tuning, capacity planning, system/database backup and recovery strategy, data architecture, high availability design, reporting database design, troubleshooting performance problems via identify the root cause and creating solution action plans and provide production support.
  • Responsibilities include developing, implementing and administering multiple IT Oracle Databases 7/24 nationwide mission critical Applications on Sun servers with Netapp storage running Oracle10g RAC and Oracle11g RAC with physical standby databases.
  • These applications include: a) Remedy7 - Data center migration of application to new data center.
  • Develop Oracle10g Logical Standby reporting database to meet 7/24 real time reporting requirements.
  • Developed Oracle database upgrade analysis and tasklist/execution plans to upgrade multiple applications: NFTS, Claims4, CRIS, Efiling, and VIS to Oracle11g rel. 2 RAC architecture.
  • Upgrades include analysis and development of the database migration strategy to new Stennis data center and database synchronization to minimize downtime to clients.
  • Responsible for planning and development of tasklist/execution plans for Oracle Database platform builds at Stennis data center.
  • Performed installation and configuration of Oracle11g rel 2 CRS/ASM and Oracle11g rel 2. RAC software on a 4 node grid Sun T5240 cluster.

Confidential, Reston, VA

Senior Oracle DBA/Systems Architect

Responsibilities:

  • Served as senior Oracle DBA/Systems Architect team leader responsible for developing and implementing multiple IT Oracle Database Applications on Sun servers with EMC and Netapp storage.
  • These applications include: a) CDMA CDR data warehouse, designed, developed, & implemented a 157tb data warehouse using DataStage ETL tool, oracle10g RAC/oracle10g ASM with projected growth to 300+tb.
  • Duties include physical database design, partition table design, performed storage analysis & capacity planning, designed/created plsql packages to support large data volume loading of fact tables using multi-thread processes meeting the SLA of 60m records/hr and achieving data loading of 1.5B records/day, designed & evaluated database backup/recovery strategy using EMC recoverpoint, EMC mirrorview & Netapp snapshot, implemented database tuning to meet SLA objectives, developed oracle dba runbook for application transition to production oracle dba support, & implemented Business Objects XI application platform.
  • Duties include performing storage analysis & capacity planning, resolved data loading issues, established backup and recovery solution using EMC recoverpoint.

Confidential, Chantilly, VA

Senior Oracle DBA & Unix Systems Administrator

Responsibilities:

  • Served as Oracle DBA/Unix Sys Admin engineer responsible for creating the Dept. of Customs Data Center Disaster Recovery Implementation Plan for 25 production Sun unix servers running Solaris 7&8 and VLDB Oracle8 & 8i databases on Hitachi 7700E disk storage arrays using Veritas Netbackup via Brocade Fibre switch SAN architecture.
  • Constructed technical flowchart to lay out disaster systems recovery procedures of Sun servers and Oracle8 & 8i databases.
  • Produced a technical detail step by step Sun server and Oracle8 & 8i database system recovery test plan.

Confidential, Herndon, VA

Senior Oracle DBA & Unix Systems Administrator

Responsibilities:

  • Served as senior Oracle DBA team leader, Unix Systems Administrator, and Lawson Financials Administrator at Confidential responsible for 18 production Oracle databases running 24x7 on Oracle8i & 7.3.4 on HP and SUN unix servers with EMC Symmetrix disk arrays storage solutions and on WIN NT 4.0 Compaq Proliant & Dell 6300 servers.

Confidential, Reston, VA

Senior Oracle Database Administrator & Unix Systems Administrator Consultant

Responsibilities:

  • Served as Oracle DBA and unix systems administrator for Oracle rdbms v. 7.1 & 7.3 on HP 9000/800 K series servers.
  • Responsible for managing and administering 7 production databases running on HP K series servers for client/server operation.
  • Three production databases involved with performing advanced symmetrical replication of data.
  • One production database involved in snapshot implementation of data for heavy end user query applications.

Confidential, Washington, DC

Senior Oracle Database Administrator & Unix Systems Administrator

Responsibilities:

  • Served as Oracle DBA and unix systems administrator for Oracle rdbms 7.2 running on Pyramid Nile 100 & 150 unix OS, Oracle 7.3 on Sequent OS, and Oracle 7.1 on Sun Solaris 2.4., and Oracle 7.3 on HP 9000/800 K series servers.
  • Responsible for Oracle Database Installation/Upgrade, Database tuning, Implementing Database Security, Managing Users and Resources, Controlling User Privileges and Roles, Auditing Database Use, Managing Distributed Databases, Troubleshooting, providing technical support to the application development (IDENT, ENCATS, ENFORCE, CLAIMS, NATS, FOIA, DATS)

Hire Now