DAVID GOSS

* ****** ******

SOMERVILLE, MA, *****

617-***-****

acgjwn@r.postjobfree.com

OBJECTIVE: Seeking full-time employment in Database Administration that utilizes previous 17

years? experience in Oracle database administration.

PROFESSIONAL EXPERIENCE

Insight Global Inc. Weston, Ma

Senior Oracle Database Administrator June 2013 ? Present

Installed and configured Oracle 11gR2 Rac databases on Redhat Linux Servers

and administered the same. Administrated Production databases hosted at AT&T

cloud.

Installed, configured and monitored Oracle Audit Vault to monitor pre and

production databases.Installed and configured Data Guard for High Availability,

Data protection and disaster recovery. Extensive use of Datapump for database

cloning and refresh

Successfully closed all Trackit Tickets for development databases as well as

Production databases hosted on AT&T Servers.

Created stored procedures and packages to meet specifications provided by

program Managers

Completed Mongodb for DBA?s training to take over ownership of the

development and production Mongodb instances .

Installed and configured confio Ignite for dev and test racdb environments.

Created process for CPMS archiving utilizing Oracle Partitioning using range

based partitions.

Sql tuning of queries in SDI, CPMS, and IOD databases

Successfully completed all duties as assigned.

INTEGRATED DATA SVCS INC. HANSCOM AFB MA

Senior Database Administrator September 2001 ? June 2013

? Migrated 5 databases from Oracle 10g to Oracle 11R2 on Virtual

server to facilitate the use of the new Web enabled CCaR program.

Constantly performing performance tuning of all Databases accounting

for less than 1% downtime. Completed all Oracle upgrades and patch

loading. Created a SQL Training Power Point Presentation for new users.

Handled issues relating to CCaR Application including, but not limited

to, Network Issues, Data Integrity and Interfaces. Interviewed DBAs for

Wright Patterson, Warner Robbins, DTRA and Pentagon AFBs.

Performed monitoring and troubleshooting of Advanced Replication

environment. Created multiple customized reports for clients. Setup and

loaded new database instances at the Pentagon. Migrated 17. databases

to Oracle 10G from Oracle 9I. Completed CCaR System Administrator

certification.

EXE TECHNOLOGIES INC. NORWOOD MA

Database Administrator March 1996 - September 2001

? Installed Oracle 7.x/8/8i on NT/2000, Sun-Solaris, and EC-Alpha

servers and configured the clients using SQL*NET / NET8 and using

TCP/IP protocols or networking. Analyzed and resolved issues related to

the Oracle database performance. Tuned Oracle database Logical objects

(Tables, Views) and application SQL code as needed. This included

creating indexes, analyzing schema and creating views. Resulting in a

15% increase in productivity. Tuned Oracle database Physical objects

(data files, redo logs) by distributing data files and optimizing rollback

and redo log segment and file sizes. Created Table spaces and defined

storage parameters. Carried out the performance tuning of Oracle

Databases starting from application or SQL tuning. Memory tuning, I/O

tuning, Disk and latch contention tuning using various monitoring tools

including SQL TRACE, SQL Navigator, Spotlight On Oracle, and by

querying various V$ views. Supported an extensive client list including

Drugstore.COM, Estyle.COM, Streamline.COM and Peapod.COM in the

DOTCOM industry as well as traditional clients such as Chrysler,

Eveready, and NEC Electronics. Administered multiple client production

instances via VPN and Dial-up access remotely. Converted over 200

stored procedures from SQL Server to Oracle PL/SQL

EDUCATION

ORACLE CORPORATION WALTHAM MA

? PL/SQL Programming DBA1 Database Administration DBA2

Performance Tuning Backup and Recovery

BOSTON UNIVERSITY CONTINUING EDUCATION BROOKLINE MA

? C/C++ Windows Programming

COMPTIA SOMERVILLE MA

? Security + certification

Additional Skills

? PL/SQL Programming 17 years

? Advanced Replication 5 years

? Performance Tuning 17 years

? Real Application Clusters (RAC) 4 years

? Windows 2008, Unix, Linux Scripting 5 years

? REF cursors 7 years

? DOD Secret Security Clearance 12 years

Contact this candidate