DBA Resume

Brian E. Dick
11 Wedgewood Drive
Cumberland, RI 02864
401-334-4064
bdick@cox.net

To see the details of my career click on one of these links for my full resume. Doc PDF

Skill Summary

Date	Company	RDBMS			Language			OS
Date	Company	SS	Syb	Ora	PB	C++	Java	Win	Unix	Other
07/01 to Pres	E Crane Computing				X	X		X
03/02 to 12/02	Veristat									X
03/01 to 10/01	Sonus Networks			X			X		X
02/00 to 02/01	Network Engines	X	X	X	X	X		X	X
07/99 to 01/01	Intel		X				X	X
03/98 to 07/99	John Hancock		X		X	X		X	X
07/97 to 02/98	Healthcare Automation			X	X			X
09/96 to 07/97	Waveland Software				X	X		X
06/96 to 09/96	Hasbro		X					X	X
12/95 to 02/96	Fidelity Investments	X			X			X
04/94 to 08/95	Fidelity Investments		X		X			X
02/93 to 03/94	Pepsi-Cola	X			X	X		X
11/92 to 01/93	Boston Edison		X		X			X
01/92 to 10/92	Textron Financial		X		X			X
09/91 to 12/91	Fidelity Investments		X		X			X
04/91 to 07/91	The New England	X			X			X
11/89 to 05/90	Exxon									X
07/81 to 08/89	Exxon									X

SS - Sql Server Syb - Sybase Ora - Oracle PB - PowerBuilder Win - Windows

Experience

I seek a position as a database administrator. I design, implement, tune and support database systems. I also develop efficient database queries and stored procedures. I am a valuable asset to a project team as a consultant, mentor, technical lead, designer and developer.

I have been in the IT industry for over twenty years and have a broad background in several industries and with many technologies. My career has been equally divided between DBA and application developer. Whether I build systems from the ground-up or whether I enhance existing systems, I build systems that work.

In the last couple of years, I have had two contracts as an Oracle DBA. At Sonus Networks, I provided development DBA support for about a half dozen Oracle databases and production DBA support for several of their customers. These systems collected configuration and performance counters for telephone switching devices. My duties included installation, backup/recovery, database design, and data loading.

At Network Engines, I developed a new database product for their line of network appliances. I implemented the TPC-C database benchmark with Oracle, Microsoft SQL Server and Sybase. Our goal was to find the right database configuration for a particular hardware configuration, so I spent a lot of time loading data, tweaking parameters and running benchmark tests. However, due to the crash of the dot-com market, they canceled the project before we had a chance to bring it to market.

Prior to the above contracts I did some Sybase DBA work for Intel and John Hancock. One project at Intel was similar to the Sonus job above. We implemented a database to capture configuration and performance counters for telecommunication devices. Another project provided the security configuration database for Intel's VPN solution. The Intel job included maintaining their database schema design, writing scripts to migrate data between database versions, and writing stored procedures for reports.

For John Hancock I provided production support and performance tuning for a 40GB Sybase document tracking system. When I started, this system was experiencing several outages per week due to database performance problems. After a month of reactively correcting performance problems, the system stabilized to the point where I could proactively tackle the performance issues. I analyzed nearly 1000 stored procedures and proposed an indexing plan for the 100 plus tables in the system. After implementing my plan, outages due to performance issues totally disappeared.

In 1997 I contracted as the lead application designer at Healthcare Automation in Providence. This application used Oracle as its database. Relational databases were a new technology for the staff at Healthcare Automation, so in addition to my application design duties, I spent a substantial amount of time teaching relational database design and SQL.

Before Healthcare Automation I had several application development positions using Sybase and Microsoft SQL Server. Two of the positions had policies allowing only stored procedure access to their databases. So, I became very proficient at stored procedure writing. And because of my vast experience in relational databases I was often asked to consult on other projects for database design and performance tuning.

At Textron Financial I designed a call center and time keeping Sybase database. The database model was patterned after Microsoft Project. This system replaced an existing application, and I spent a lot of time developing data migration stored procedures.

In 1991, I contracted as a relational database consultant for The New England. They asked me to review their database design for Microsoft SQL Server. I analyzed their design and made a few recommendations for improvements. However, I spent most of my time writing stored procedures for reports.

While working for Exxon in Houston back in 1983, my department was a beta test site for a new IBM product called DB2. I played an instrumental part in developing the first relational database systems for DB2. I design much of the database and performed index and query tuning for the database. I continued working with DB2 through the end of my Exxon employment in 1989.

Free counters provided by Andale.