We provide IT Staff Augmentation Services!

Senior Dba Resume

5.00/5 (Submit Your Rating)

SUMMARY:

  • Senior Oracle Professional with over 17 years consulting experience (9 years in Silicon Valley)
  • Specialist in Oracle
  • Real Application Clusters (RAC)
  • Golden Gate Replication
  • High Availability (Data Guard, Golden Gate Replication, iReflect Replication, Oracle Advanced Replication)
  • Database Architecture & Design
  • Performance Tuning
  • General Database Administration
  • Backup, recovery and disaster recovery

TECHNICAL SKILLS SUMMARY:

Databases: Oracle 11g (11gRAC), 10g (10g RAC), 9i, 8i, 8.0, 7.X, 6.X

Application Servers: Oracle 10gR1, 10gR3

Operating Systems: HP - UX, Sun Solaris, Linux (SuSE, RH, OEL), Digital Unix, SCO Unix, AIX, Windows 95/98/NT/2000/XP/Vista/7, DEC VAX/Alpha OpenVMS

High Level Programming Languages & Tools: Golden Gate, CDC/iReflect, Oracle Designer & Developer, SQL, SQL*Plus, PL/SQL, Shell programming (bsh, ksh, bash etc), Pro*C, SQL*Forms, SQL*Loader, C, Pascal, Modula2, Lisp, Scheme, ADA, SmallTalk, SML, GPSS, HTML, Visual Basic, DCL etc.

WORK EXPERIENCE DETAIL:

Confidential

Senior DBA

Responsibilities:

  • Oracle RAC Migration DBA
  • Migration of single instance 9i and 10g databases to 11gR2 RAC. Over 100 databases migrated.
  • Daily operational RAC administration and advanced RAC troubleshooting including performance, NFS storage and OS specific issues
  • Golden Gate Replication DBA
  • Configuration, setup and troubleshooting of active/active Golden Gate replication on 11g RAC between AESO’s 2 data centers. Also responsible for Golden Gate replication feeds from production databases to enterprise warehouse database
  • AESO OID HA Oracle Lead:
  • Implemented a replicated Oracle 10gAS R1 and R3 and Oracle Internet Directory infrastructure across both data centers (via Oracle Advanced Replication)
  • DBA and OAS Administration verall DBA duties included installation, upgrades, tuning, backup&recovery, developer assistance and general troubleshooting for any of the AESO's 150 critical and essential databases.
  • Oracle Application Server Administration for all AESO Oracle application servers. (10gR1 and 10gR3)
  • Re-architected backup and recovery strategy for 4TB eLSI system
  • Hardware and Application Performance Tuning

Confidential

Senior DBA

Responsibilities:

  • DBA and OAS Administration
  • Duties performed include remote troubleshooting of incidents and task completion for various clients who have outsourced their DBA requirements to First4.

Confidential, Dublin, California

Co-Founder

Responsibilities:

  • Helped launch the company and assisted with the design and development of the flagship product, BackupButler, a hardward based appliance for backup, recovery and disaster recovery of Oracle databases.
  • Design and development centered on architecture design at the hardware level, data modeling of the proprietary Oracle tables and Unix development.
  • Business development duties also included marketing, sales and venture capital negotiations.

Confidential, Lafayette, California

Senior DBA

Responsibilities:

  • Solely responsible for performing a complete overhaul of ConWest’s internet database’s reliability, recoverability and availability to ensure a true 24X7 high availability environment.
  • Performed strategic database design & server planning and based on ConWest’s budget and HR limitations, made the database and server recommendations.
  • Technical responsibilities included moving the production database to the new dedicated server, substantial UNIX and database performance tuning, application data model reviews and enhancements, implementation of Recovery Manager for backup and recovery and the creation of a standby database on a remote host for production failover.
  • DBA Team Lead tasked with providing leadership and hands-on training to Neuropace’s database team with regards to the PDMS project high availability requirements for Oracle 9i on SuSE Linux 7.2.
  • Technical responsibilities included architecture design, making system recommendations and designing and implementing a production ready standby database.

Confidential, San Ramon, California

Lead DBA

Responsibilities:

  • Technical duties included designing new schemas and writing code for extracting data from and loading into the SAP data warehouse.
  • Also responsible for mentoring, training and coordinating the efforts of a team of developers not familiar with Oracle development, and managing the performance tuning and change control requirements within Global Lubricants IT.
  • Received a Recognition Award Bonus for exceeding performance expectations.

Confidential, San Francisco, California

Senior DBA

Responsibilities:

  • Lead DBA for HP’s Price Protection database conversion from Informix 7.3 to Oracle 8i.
  • Technical duties included capturing the Informix model, design of the Oracle model, porting of data from Informix to Oracle, conversion of ESQL into Pro*C, conversion of shell scripts, performance tuning and coding of database stored procedures and functions.
  • Responsible for Oracle training of application developers.
  • Lead Oracle DBA in charge of leading the database conversion effort from a Cold Fusion 4.0 to a custom Dynamo 5.0 web application.
  • Responsible for the new Oracle installation on high availability clustered Sun Servers, the design & creation of databases, and configuration of backup and recovery plans via Oracle’s Recovery Manager.
  • Trained the application team on new Oracle 8i features and assisted the Java programmers with the application model design using tools such as Erwin and Oracle Designer.
  • Coordinated, reviewed and delegated work to other DBA team members and conducted interviews for new DBA positions.

Confidential, San Francisco, California

Lead DBA & Senior Systems Architect

Responsibilities:

  • Led Confidential ’s 6 member Oracle and VB team during the successful design and implementation of a robust 24X7 internet Oracle database.
  • Responsible for recommending, purchasing and assisting with the implementation of the Sun server hardware, Oracle software and PC front-ends.
  • SQL*Server database administration
  • Responsible for all Oracle DBA duties including migrating the production database from SQL*Server to Oracle, implementation of backup and recovery plans and rollout of Oracle tools to developers.
  • Senior DBA responsible both for day-to-day DBA duties such as installation, troubleshooting and performance tuning as well as over-viewing and directing 3 other DBA team member’s tasks.
  • Tasked with creating corporate wide database and operational standards for all of NorthPoint’s corporate databases.

Confidential, Hayward, California

Lead DBA

Responsibilities:

  • Responsible for hardware and software recommendations and corresponding installation and setup of hardware and Oracle software.
  • Responsible for creating and enforcing a strict change control processes for development, test and production databases.
  • Reviewed developer’s architecture and application (schema) designs.
  • Technical responsibilities included Oracle installations, upgrades, and troubleshooting of Oracle applications.
  • Responsible for the design and development of Chevron’s Vantive Ad Hoc Reporting Environment (data warehouse).
  • Design duties included interaction with end users to determine data warehouse requirements; implemention of those requirements achieved using Oracle Designer.
  • Development duties included designing and coding database triggers to capture key data changes to the online database.
  • Second major project included interfacing with end-users to define the requirements for the development of enhancements to Chevron’s Vantive Customer Helpdesk and then the implementation of these requirements via the creation of new databases and stored PL/SQL.
  • DBA responsible for the development and support of the AAA Customer Information country hub as part of HP’s CSO Worldwide Customer Information Data Warehouse environment.
  • Created new databases and designed and coded triggers that captured database changes at the country level to be sent to the WW hub

We'd love your feedback!