Oracle Quality Assurance

DAVID B. MARCUS

Edison, NJ *****

732-***-**** http://www.linkedin.com/pub/david-marcus/1/407/bb1

*********@*****.***

PROFILE

Management Information Systems Professional with extensive experience

providing software and database analysis, design, development,

implementation, and maintenance, with 14 years' Oracle database

administration skill.

. Oracle database administration duties include: Physical design and

implementation; database configuration; backup and recovery, performance

tuning, including Oracle server tuning and application tuning, data

modeling, and PL/SQL.

. Support, communicate, and assure standards and procedures regarding

database usage.

. Install, upgrade, and maintain development and production databases and

servers.

. Convert specifications into design and convert design into deliverables

on schedule. Perform quality assurance on all deliverables.

. Effectively communicate technical issues one-on-one and in group

situations.

. Demonstrate customer focus while assuring business value perspective.

TECHNICAL SKILLS

Software: Oracle V7, 8i, 9i, 10g; 11g; SqlServer 2000, 2005;Oracle

Utilities; SQL, PL/SQL, SQL *Plus, SQL Server, COBOL 2, MS

Office

Hardware: HP, Sun SPARC, and Windows Servers; PCs

Platforms: MS Windows, UNIX, HP-UX

PROFESSIONAL EXPERIENCE

HP & HP FINANCIAL SERVICES, Murray Hill, NJ 2000 - 2010

(Formerly Compaq Financial Services)

Senior Database Administrator (in Oct. of 2008, function was merged into

the Global Database Group of HP)

Assisted in the design of applications, helped debug and tune scripts and

stored procedures. Worked with developers to understand, toubleshoot, and

document procedures and workflows. Worked with end users to explain the

application and set expectations. Worked with the team performing

migrations of Oracle 10g databases to Oracle 11g. Created, designed, setup

OEM, RMAN Backups for 11g Oracle Rac and Dataguard databases following HP

GDBA procedures and quality assurance. Worked production support on a 7x24

basis, with a rotating primary contact and secondary contact. Assisted in

tuning Oracle databases, indexes for optimal performance. Maintained,

backed up, monitored, and tuned 75 Oracle databases worldwide. Created

test, development, and user acceptance testing environments. Installed,

monitored, and employed Business Objects and Informatica applications.

. Upgraded 10g Oracle databases to 11g. Completed numerous SQL Server

installations and have run SQL Server scripts against SQL databases.

. Participated in Sarbanes-Oxley audit on Oracle databases. Created control

document. Interfaced with internal/external auditors, ensuring smooth and

successful completion. Ran scripts against the Oracle databases and

assigned tasks to SQL Server DBAs.

. Contributed to HP Data Center Consolidation program, moving Oracle

databases from local Windows servers to remote UNIX servers outside

normal business hours. Completed with no impact to user base.

. Played key role in development of comprehensive Disaster Recovery Plan.

Established procedures to assure essential recovery. Installed 9i and 10g

Oracle and SQL Server 2005 databases in 2 days at remote location,

recovering 23 databases and proving the DR plan.

. As Production Support Lead, coordinated DBAs' activities in managing

Oracle and SQL databases to assure peak performance and issue resolution.

. Managed High Performance File System datafix process. Created releases,

assigned change requests to DBAs, monitored, and closed releases on daily

basis. Devised standards and code templates in Oracle and SQL Server.

DAVID B. MARCUS

Page Two

732-***-**** http://www.linkedin.com/pub/david-marcus/1/407/bb1

*********@*****.***

DMR CONSULTING GROUP, Edison, NJ 1997 - 2000

Oracle Financial Applications

Senior Database Administrator

Worked in teams and independently to install, support, test, evaluate and

upgrade financial applications, assisting array of organizations. Example

projects included:

. PR Newswire: Implemented pilot room test using Application Quick Install

process. Supported test.

. PSCU Financials: Migrated Interbase database to Oracle 8i. Database

created from ERWin datamodel. Used data partitioning feature of Oracle 8i

to create database. Trained junior DBA.

. DMR: Provided in-house support of Oracle Financials R11.0.3 and Oracle

CRM development database RDBMS version 8.0.4.2 in Sun SPARC environment.

Installed and evaluated Oracle Darwin Data Miner, Discover 2000, and

Oracle Enterprise Manager.

. AT&T: Worked in the Oracle Center of Excellence in Piscataway NJ,

Supported Oracle Financials R10.7 production database RDBMS version

7.3.3.4 in NCR/UNIX and Sun SPARC environments. Led team for multiple

installations and upgrades of Oracle Financials R10.7 worldwide.

Installed, configured, and executed Oracle Enterprise Manager. Member of

Oracle Center of Excellence.

. Intracorp: Migrated and upgraded Oracle applications database RDBMS

version 7.1.3.4, Oracle Financial R10.4.1 from DEC Alpha to Sun SPARC

database, RDBMS version 7.3.3 Oracle Financial R10.7. Created, exported,

imported, and upgraded database.

BELLCORE, Piscataway, NJ 1995 - 1997

Oracle Database Administrator

Managed Oracle Financial 100 gigabyte-database running on HP T500 and HP

K4000. Installed applications included General Ledger, Accounts Payable,

Fixed Assets, and Project Accounting.

. Upgraded development database to 7.3.2.3 and Financial application to

R10.7

. Planned, tested, and implemented upgrades to Oracle database version

7.1.6 and Financial Applications to R10.6.1, in development, integration,

and production. Migrated numerous databases between test and production

machines.

. Installed, tested, and evaluated Platinum suite of products, specifically

DBvision and TSreorg, resulting in approval and purchase.

. Trained developers on SQL tuning product SQLab.

EDUCATION

MS, Management Systems, (12 credits completed);

BS, Management Science, Kean University, Union, NJ

MILITARY

Served in the US Navy, Nuclear Fast Attack Submarine USS Shark, Secret

Clearance (Inactive), Honorable Discharge

Contact this candidate