Database DBA Lead and Architect Resume

Title
Database DBA Lead and Architect

Primary Skills
Oracle 10g, 11g, rac, asm, ocfs2, linux, Ebusiness 11 - R12 90/hr on site - 70/hr remote - Available Now

Location
US-MA-Boston (will consider relocating)

Posted
Nov-08-09

OBJECTIVE
Database Lead DBA/APPS DBA/Architect
TARGET JOB
Using my 27 years expertise in Software, Database Design and Architecture, I can bring some strong leadership and technical skills to your environment. My background is very diverse and will be an asset to any organization. I have extensive Oracle RAC Expertise -- I have been using RAC and OPS for 10 yrs. I am also an E-Business Suite technical Database expert -- 10 yrs expertise all through release 12. I have setup complex environments with 10 node rac clusters and 10 node 11G Application server load balanced systems. Striving in Excellence for your company is my goal.
VMWARE and HYPER-V EXPERT
Technology Summary
Oracle -- 20yrs through 11g RAC -- VCS, HACMP, Service Guard, RMAN,GFS, GPFS, OCFS, ASM, 10g Application Server - Portal
Sybase -- 15 yrs through AS 15
SQLServer -- 12 yrs through Version 2008
UDB -- 10 yrs through 9.0
Mysql -- 7 yrs through 5.1
Database Architect -- 19 yrs
DBA -- 25 yrs
Project Management -- 15 yrs --
Operating Systems -- Windows 3.51 through 2008 server, HP-UX, AIX, Solaris, Linux all flavors -- I have setup and installed all OS's including Clustering and High Availability. Also have setup all flavors of VMWARE for each Operating System.

EXPERIENCE

06/07 -- Present Database Architect and APPS DBA Lead

Sun Microsystems, Burlington, MA

Consultant for Sun's Professional Services Division. Hired for project based work consisting of the following:

Upgrade large financial organization from 11.5.7 to R12.1. Design architecture, put together all technical documentation, mentor dba's during the upgrade process. Implemented Data Guard for standby, migrated existing 9.2. databases to 11g Real Application Clusters. Implement a shared application top for both techstack and appl_top. Customers runs AIX, HP-UX, Linux and Solaris.
Utilized Quest Stat for managing Oracle E-Business patches and version control.

Migration of Ebusiness Suite from HP-UX Itanium to Linux x-64 -- database and application tier -- Shared application tier -- Migrated Database from Oracle 10g to 11gr2 RAC.

Migration of UDB/DB2 8 and 9 to Oracle 10 and 11g. Stored procedures, java code, jdbc calls,
And all cron jobs.


Tuning, migration, upgrade Expert for Sun's Oracle Practice -- I have worked on large scale terabyte databases, redesigning them for RAC and optimal performance. ASM migrations and tuning on All platforms.

Setup and Configured HP-UX Itanium servers with Serviceguard and virtualization. Installed and configured Oracle 11g RAC.

Setup and Configured Solaris 10 servers with Sun Cluster and Sun virtualization. Installed and configured Oracle 11g rac and MYSQL Cluster.

Setup and Configured IBM AIX HACMP and GPFS on pseries servers. Installed and configured Oracle 10g and 11g RAC.

Setup and Configured Redhat Linux Advanced Cluster -- setup active-active and active-passive environments using GFS.

Upgrade Windows 2003 and 2008 Oracle RAC 10g to Oracle Rac 11g. ASM and OCFS2 clusterware upgrade

Installed and setup Oracle 11g Content DB -- used for large web site to retrieve and store documents and upload and parse xml data files


Migrate Large Solaris implementation environment (EMC Corp) to Redhat Linux -- utilized transportable tablespaces to reduce downtime -- also utilized data pump pipe techniques to reduce downtime .

Upgraded Peoplesoft Financials from version 8 to 9 for State of Missouri. Installed software, migrated database, helped migrate applications and automate maintenance tasks.

Setup 4 node Oracle Application Server Cluster -- 10gias -- shared binaries -- customized Portal and Oracle Collaboration Suite.

Configured 4 node Windows 2003 and Windows 2008 Rac Cluster -- 10g and 11g -- provided tuning and scaling for ASM and OCFS2 file-systems as well as native NTFS.

Migrate HP-UX 11i implementation to Solaris 10. Utilize Domains for Real Application Cluster database. Migrate application tiers from Linux and HP-UX to Solaris.

Migrate Oracle 10g Database to MYSQL 5.1 -- setup 3 node Cluster -- redesigned schema for optimization -- provided all tuning and setup tasks

Utilize Erwin, PowerDesigner, and Rational for Relational and Object modeling.

Install and Configure Oracle 11.5.10 and R12 on AIX 5.1 using HACMP. GPFS. Setup 5 node RAC HACMP AIX 5.2 Cluster using GPFS,

Upgrade and install Sun Cluster on multi-node Rac -- Upgrade 9i Rac and 10g Rac to 11g RAC.
Install Dataguard for Reporting and failover for DR.

Oracle 10g and 11g RAC Expert -- Implementing 2-6 node rac's on HP-UX, Windows 2003 server, Linux, AIX, Solaris -- San storage expert on Hitachi, EMC, Sun, Dell. Multiple Oracle 10g to 11g database upgrades on solaris, linux, hp-ux, aix and windows. Hacmp, GPFS, Service Guard, Polyserve, ocfs2, sun cluster 3.2, Veritas Cluster Server

Implement Grid based monitoring solution for large scale show manufacturer. Client has over 800 databases running Oracle 7 through 11g.

Setup RMAN solutions for all Oracle Databases -- created rman repository, wrote scripts for backup, integrated rman with OEM and GRID, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery

Provide Performance tuning and performance analysis for large oracle datawarehouse. Oracle 11i, R12 -- database and application tiers. Recommend best practices for partitioning, scaleability and monitoring.

Installed and configured multi-tier Oracle Collaboration Suite 10g, 3 nodes install on Solaris and Linux. Setup Oracle Files, Web Conferencing, SSO, integration with Ebusiness. Automatic startup and shutdown with RMAN backup -- RAC backend on Store and mid tier.

Clients included -- International Paper, Core Army Engineers, Jcrew, Morgan Stanley, University of Phoenix.


10/05 -- 05/26/07 Database Architect and Technical Lead

Oracle Corp, Boston, MA

? Upgrade Major Titanium Company - Global NLS Oracle 11.5.10 mult-tier application to R12CU4. Migrated database to Oracle 10.2.3, upgraded all custom code and configure for 10G ASM RAC with dataguard and TAF.
? Part of Oracle's Swat Team -- Duties include -- tuning of systems, redesigning application schemas, upgrading and migrating systems.
? Migration of Ingres 6 & 7 databases to Oracle 10g. Also modified all scripts and logic.
? Managed Team of 25 DBA's and 7 developers. Assigned tasks, provided mentoring, schedules and performance monitoring
? Installed Oracle 11.5.10.2 and R12 on Linux,AIX ,Windows 2003 Server, HP-UX and Solaris-- Multi-tier split 10GR2 RAC clustered environment using GPFS,OCFS2,Sun Cluster 3.0 ASM, utilizing PCP and FAL. Setup San, installed and configured ASM disk array layout. Designed cloning strategies for 10 different tier environments. Provide Grid monitoring for Environment. Migrate existing Rac databases from veritas cluster server to ASM.
? Migrated Client from Peoplesoft 6 to Peoplesoft 8. Client was moving from Solaris to Redhat Linux.
? Migrated multiple Clients from AIX, Solaris, Windows, HP-UX, Linux to different platforms with Oracle 11i, R12, 10g, 9i, 11g.
? Performed several re-implementations of fresh install of E-Business Suite.
? Oracle 10g and Oracle 11g 4 node Windows 2003 Rac install -- setup san, ASM disks, used Mercury load runner to test performance
? Oracle 11g Rac installation on linux -- 10 node to test new features. Upgraded several 10g rac clustered databases to 11g
? Implemented Sox and Oracle Advanced Security for Core of Army Engineers Project that involved monitoring of troop activity in Iraq.
? Configured EMC San Storage -- Symmetrix and Clariion -- Created Logical Volumes and installed and configured devices.
? Migrated over 150 Oracle 8i, 9i databases from Aix, Solaris, Hp-Ux to Oracle 10g on Linux, Aix, Solaris, HP-UX and Windows
? Migrated Split architecture of HP-PA Risc and HP-Titanium to Linux 32 and 64 bit with RAC and ASM on 64 BIT Tier. Configured Service Guard on HP and Veritas Cluster server on AIX.
? Workflow and BPEL configuration of legacy database feeds utilizing SOA technologies.
? Workflow Mailer configuration and automation.
? Installed and Configured Oracle RAC on Windows 2003 Server -- 4 node cluster with ocfs2 and ASM. Upgraded 9i on Windows 2003 to 10g RAC.
? Installed and configured Discoverer 10g with SSO. Upgraded existing EUL from Discoverer 4i.
? Set up Oracle R12 across Vmware environment. Configured Operating System, provided tuning and load balancing techniques for Vmware.
? Provided all SnapClone and FlexClone techniques for Netapp Appliances.
? Configured High Availability with Dataguard and setup RMAN for backups.
? Provided Client with Security Best practices for Oracle 10g. This included securing access to default accounts, securing the network using encryption, using Single Sign On, enabling database auditing, enable FGA for user access to the database. Document all security practices and create daily managements reports.
? Installed and configured multi-tier Oracle Collaboration Suite 10g, 3 nodes install on Linux and Aix. Setup Oracle Files, Web Conferencing, SSO, integration with Ebusiness. Automatic startup and shutdown with RMAN backup -- RAC backend on Store and mid tier.





03/04 -- 10/05 Database Technical Lead

(DELL) Austin, TX

? Database Lead for Dell Professional Services Migration team specializing in upgrades, migrations and complex installations of Oracle Applications 11i.
? 11.5.10 Clustered Rac configuration with MRP and PCP -- provided all architecture decisions on shared file system and DMZ security.
? Migrated 30 SQLServer 2000 and 2005 Databases to Oracle 10g -- All stored proc's, shell scripts and jdbc programs
? Migrated DB2 and Oracle Databases to Mysql 4.2. Migration consisted of over 40 databases.
? Installed and upgraded several 10.7 and 11.5 ERP Systems to 11.5.9 and 11.5.10.
? Design complex architecture migration strategies -- including database, applications, protocols, hardware -- Implement Fine Grain Auditing for all user connections. Encrypt network sql access.
? Migrated over 20 Sybase System 10 and 11 systems to Oracle and SQLServer.
? Installed and configured SunCluster 2.2 and 3.0 for Oracle RAC 5 node database.
? Installed and Configured multi-tier OCS 10.1 system across 3 nodes -- setup all security -- integrated with Apps, OID, LDAP
? Oracle RAC installs and setup on Windows 2003, AIX, Solaris and Linux. CFS, GPFS, PolyServe, CMS, OCFS.
? Configure Complex database schemas for multi-global applications such as Oracle ERP, Peoplesoft, SAP and Siebel.
? Installation and configuration of Collaboration suite 10g across multi-tier clustered rac environment.
? Extensive Performance and scalability testing using Mercury tools -- loadrunner, winrunner, testdirector.
? Perform Migrations of large database systems from Companies such as International Paper, JCrew, RedCross, NYDCJ -- SQLServer, Oracle, DB2, Sybase, Informix -
? Install, tune and configure complex clustered database environments. Install and setup SAN, NAS, ISCSI, Oracle 10g RAC, ASM, OCFS, Dataguard, Veritas Cluster, Sun Cluster, HACMP, GPFS, AIX, Solaris, HP-UX, MSCS, Windows 2000, 2003, Vista and SQLserver 2005.
? Clients included J.P. Morgan NYC, JCrew, USPS, U.S Government, EPA

03/03 -- 03/04 Database Technical Lead

(DELL) Austin, TX

? Database Lead implementing Proof of Concepts for Dell professional services and EMC.
? Install Oracle 10g, RAC, SAN's, RMAN
? Install and Configure UDB 8.1 and 8.2 on HP-UX, AIX, Linux and Windows 2003.
? Migrate Sybase AS 12.5 to Sybase System 15.
? Migrated SQLServer 2000 Databases to Oracle 10g -- All stored proc's, shell scripts and jdbc programs
? Install and Maintain Oracle Pharmaceuticals 4.5 -- migrate existing clinical systems to Oracle Clinical.
? Configure OCFS, ASM, and PolyServe on redhat linux.
? Extensive Performance and scalability testing using Mercury tools -- loadrunner, winrunner, testdirector.
? Setup disaster recovery and High Availability Architecture with dataguard, EMC Snapcloen and Snapview.
? Install Oracle 11.5.10 clustered linux implementations
? Upgrade Oracle Applications 10.7 to 11.5.10, 11i to 11.5.9 -- migrate from windows, hp-ux, Solaris and aix to linux.
? Worked at EMC doing a migration from 11.5.8 to 11.5.10 from Solaris to Linux -- did all the work myself.
? Migrate Oracle to Linux from HP-UX PA-RISC and ITANIUM RAC Environment using ServiceGuard and ASM, Windows, AIX and Solaris



03/02 -- 03/1/03 Database Lead

Oracle Corp - Andover MA


? Hired as Database and Oracle Applications DBA Lead to implement a multi-architecture and Global deployment of 11.5.10. System consisted of several HP-PA Risc Application Servers and RAC based HP-UX Itanium servers. Installed and configured the hardware, OS, raid and LVM setup -- Installed 11.5.9 and ported it to a RAC environment on AIX, SUN, HP and REDHAT Linux AS.
? High availability Architect for Standby and DR center..
? Migrated Oracle 11.5.9 to 11.5.10 on Linux, AIX, Solaris and HP-UX.
? Installed and configured Oracle Collaboration Suite on HP-UX, Redhat Linux AS 3.0 and Windows 2003 Server. Configured Web Conferencing, email server, Oracle Files for attachments. Multi-server and single node installs.
? Setup SSO for Oracle collaboration suite, Applications and Discoverer. Migrated Apps users to OID using native tools. Setup SSL security.
? Extensive tuning and scalability benchmarking of various environments at the Operating system and Database level for AIX, HP-UX and Solaris.
? Developed all E-Business cloning routines, backup and startup scripts to be used across all of the various servers.
? Migrated data from an existing legacy based manufacturing and financial system to Oracle apps using Oracle's Data pump and Brio.
? Installed RMAN and TMS for backups with Dataguard for high availability reporting instance.
? Provided all database tuning to existing systems using my 20+ yrs of RDB expertise.








01/00 -- 2/25/02 Oracle Applications DBA/Architect

Oracle Corp, Ft Lauderdale


? Migrated MDR from a Legacy based financial package that ran on VAX/VMS to Oracle 11.5.2 ERP and CRM. Installed and configured QA, Development and Production instances on Windows 2003 Servers, Linux and AIX servers. Provide all tuning, cloning, 24 X 7 support for production environment.
? Installed Oracle Collaboration suite on Linux AS 3.0. Configured Email, Web conferencing, Files, Voice Conferencing. Integrated with SSO and Oracle applications.
? Migrated all application and database servers to AIX 5.1 and RedHat AS 3.0 Linux running Oracle 10gRAC and 10g Application servers. Linux servers running OCFS 2.1. And Redhat Advanced server 2.1 and 3.0.
? Installed a split-architecture configuration of Oracle Applications 11i using HP PA-RISC as the application server tier and HP-Itanium for the database tier.
? Utilized Veritas DBAC software to manage raw partitions and clustering on the HP-UX systems.
? Database tuning of Ebusiness suite using Quest spotlight and statspack. Cloning and patching. We have 6 instances running.
? Setup standby database and rman backup database on AIX platforms.
? Several Installations of Oracle RAC on Linux using SAN and EMC disk arrays. Also setup demo's using firewire shared cluster.
? Mentor and lead a team of 12 Junior DBA's and 5 developers. Provide guidance and training on a monthly basis to DBA's and developers on different subjects related to database performance, sql tuning, EJB and stored procedure design.
? Ported several Sybase AS12.5 database servers to Oracle 9i RAC, ported stored procedures, java stored procedures, XML code.



05/94 -- 12/99 Database Applications DBA/Architect
Oracle Corp
Manhattan, NYC

My primary role has been Oracle and UDB/DB2 Database Guru and Architect. In this role my responsibilities were architecting, implementing and managing all of the middle tier and back-end database related tasks.

My daily tasks consist of the following duties:

? Worked as Primary Lead DBA for a team of 8 Junior DBA's on the migration and Implementation of the EPA Superfund System. Worked alongside Dr Rod fonticelli from Booz Allen and Hamilton to create the infrastructure and Database Layout

? Database Architect and Lead DBA for over 5 implementations of UDB EEE 6 & 7 on AIX, Solaris and HP/UX Platforms. Migration of existing DB2 Databases on MVS platforms to UDB AIX.
? Installed Oracle E-business Suite 10.7 NCA version on AIX and Solaris. Provided all patching, cloning and tuning expertise to staff.
? Assisted in migrating data from legacy systems to Oracle Applications
? Convert Oracle Databases from version 7 to 8, 8 to 9.
? Utilized Cognos ETL Tool's to load and clean data.
? Installed and configured Oracle 10.7 and 11.0 for several clients. Installations configured for Parallel and Rac environments.
? Installed and configured Oracle Parallel server on Sun, RS6000 and HP9000 environments.

10/1990 - 05/1994 Database Consultant Lead Engineer
Sybase
Burlington, MA

Sybase's technology practice specializes in large scale system implementation for fortune 500 companies. The technology team's work usually consists of about 15-20 engineers and business analysts. These are some of the most dedicated people in the business. There will work as many hours as needed to meet all deadlines. I never missed a deadline and learned to be a team player.

My role was to work along with business analysts and end users to define and architect the business flow as it relates to a relational model. I would learn the customers business and start to design some logical business diagrams using various modeling tools that would change based on the customers needs. From the logical models, I would design the physical implementation of the database. When the engineers started to code, I would work side by side with them to provide SQL knowledge. When Java first came on the scene, I learned to write JDBC code so that I could help when needed with development.

My daily tasks varied from project to project, but all of them had these similar duties:

? Lead Database Architect. It was my role to head the database team and make all final decisions concerning design and modifications to the schema. We used Erwin, Rational Rose and Powerdesigner for modeling tools. Was the lead Java developer and DBA on over 5 ERP and CRM implementation of Oracle.
? Installed and maintained Websphere for several clients. Migrated data, installed application servers, migrated legacy code.
? Lead Database Administrator. It was also my role to act as the primary database administrator. All performance tuning and database tasks would be signed off by me. Many of the projects involved supervising a staff of 6 to 10 DBA's. I was also the chief technologist for all database performance tuning and implementation. Some of the databases we worked on were several hundred gigabytes to terabyte financial systems.
? Technologies used were Java, Oracle, PowerBuilder 5 & 6,PL/SQL, Sybase 11.5, DB2 7.0, and SQLServer 6.5. Designed several large data warehouses in DB2 Warehousing and Oracle Express.
? Convert Sybase 11.5 Environment to Oracle 8 and DB2 7.0. Stored procedures, shell scripts, JDBC code.



1/1988 - 10/1990 Database Consultant
Massachusetts Institute of Technology
Cambridge, MA.


My primary duties at MIT consisted of the following:

? Developed several prototype cross-platform GUI applications using Omnis 7, MPW and Uniface. These applications were designed using Kerberos authentication (the technology would later be used 10 yrs later as the authentication for Windows 2000).
? Designed and Architected MIT's first implementation of Sybase and Oracle. Sybase was running on a pair of Clustered Vax 780's, Oracle was installed on a prototype version of the Digital Alpha processor.
? Installed and configured several Ingres Database implementations on Vax Ultrix and OSF. MIT was one of the first institutions to use Ingres as its database.
? Provided database support for initial implementation of Peoplesoft. MIT converted all of its home grown applications to Peoplesoft HR.
? Installed and configured Gemstone database. Used Parc Place visualworks Smalltalk to design and OO interface for a facilities management project.



1/1982 - 1/1988 Principal Database and Systems Engineer
Digital Equipment Corp
Acton, MA.

Digital Equipment Corporation was a pioneer in the field of database technologies. Vax RDB was one of the first relational databases designed after DB2. The minicomputer (vax) was the driving force behind the technology.

Worked on the design and development of Vax RDB from conception. My role as Database Engineer allowed me to utilize all of my knowledge that I learned during my college years.
Wrote several underlying interfaces and custom reports using C and Vax Basic.

The Vax/RDB team consisted of 25 of Digital's brightest engineers. They were hand selected from a variety of schools at the time.

Relational technology was just beginning to be understood. Digital had been developing several products using a hierarchical database called DBMS-32. Although very effective, the push was to deliver a relational product.

My primary duties at Digital consisted of the following:

? Started out as a Software Engineer working on Project Athena. Designed an advanced Message Queuing System using Vax C and Digital's RDB.

? Promoted to Principal Software Engineer and re-assigned to work on Digital's internal database development team that designed Vax RDB. Worked on designing the internal metadata dictionary and SQL interface to Vax RDB. Developed the interface using Vax C.

? Worked on Vax Cluster technology (the predecessor to Oracle 9i RAC). Provided design and installation techniques for clustering and performance tuning.




REMOTE DBA EXPERIENCE

NIKE -- Portland Oregon
05/2008 -- 04/2009

Provided Remote DBA and Database Architect expertise for Nike's database operations team. Installed and configured multiple Oracle 10g and 11g databases on Linux, Windows and Solaris. Provided tuning and scalability expertise. Installed and configured 6 node Oracle 11g RAC database environment. Setup all VMWARE ESX and managed vmware environment. Provided OS Upgrades and tuning

EDS -- New York
04/2007 -- 04/2008

Remote DBA for EDS Database Services. Managed Oracle, Sybase, DB2 and sqlserver databases. Installed and configured over 100 databases on a variety of platforms. Upgraded all databases. Provided Tuning and wrote many scripts for backup and monitoring

CSC -- Burlington, VT
03/2006 -- 12/2007

Lead Applications DBA for CSC for large government firm in Burlington, VT
Upgraded Oracle 11.5.10 to R12 on Linux and HP-UX. Setup Rac clustering and provided all tuning and 24 X 7 support.


DCC Services -- Austin Texas
02/2004 -- 03/2006

DCC also known as smartdog -- provides on demand remote dba services. I was the lead applications dba for them. Handled over 10 customer accounts, many Oracle ERP applications. Performed migrations, upgrades, tuning, support 24 X 7.


EDUCATION

06/1984
Massachusetts Institute of Technology
Cambridge, MA
B.S. Computer Science

06/1990
Massachusetts Institute of Technology
Boston. MA
M.S. Computer Science.

Affiliations

OAUG Charter Member
IBM Developerworks Partner
Quest Oracle Consultant Partner
Embarcadero Partner
BMC Development Partner
Microsoft 64 Bit Beta tester.

Oracle 8i,9i,10g,11g Certified
Dell EMC SAN RAC Certified
MSCE, OCM

Certifications
Oracle 8i-11g
EMC SAN
Oracle OCM
Netapps


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Boston, MA | Resumes in Massachusetts

View other Database DBA Lead and Architect resumes, Database Administrator resumes