Sql Server Oracle
Resume:
Peter M. Florenzano
Concord, NH 03303
*****@*******.***
OBJECTIVE
Senior Database Administrator with over twelve years experience seeking a
challenging position as a database administrator within an Oracle and/or MS
SQL Server environment.
EXPERIENCE
PC Connection - Merrimack, NH Nov 2007 - Present
Database Administrator
. Manage high volume databases within a SQL Server clustered environment
(active-active & active-passive) architecture.
. Manage user security (by SOX standards) on all types of databases,
including VLD's (Very Large Databases).
. Work with end users on various projects.
. Develop backup and recovery strategies
. Diagnosis long running applications on the database level and perform
corrective action with the use of both SQL Server native and third
party performance tools.
. Created Heterogeneous replication strategies with the use of both Omni
View Replicator and native SQL Server replication.
Knights of Columbus - New Haven, CT Feb 2004 - Oct 2007
Sr. Database Administrator
. Develop backup and restore strategies in a development, test &
production environment.
. Manage user security on the databases.
. SQL Server Reporting Services.
. Performance tune databases in development, test & production
environments.
. Import & export data to and from SQL server with the use of the DTS
tool
. Perform MS Access to SQL Server database conversions.
. Create Entity Relationship Diagrams for developers and management
staff.
. Create stored procedures, triggers and user defined functions and
simple to complex DTS/SSIS packages.
. Work with end users on various projects.
. Updated both SQL Server 6.5 & 7.0 environments to SQL Server 2000.
. Develop custom code and reports for my department and user community.
. Developed a recovery plan for all production databases within the
infrastructure.
. Setup high availability is implemented on all production databases,
which consists of replication and log shipping.
. Created both cost and gap analysis for current database
infrastructure.
Taunton Press - Temporary contract Newtown, CT Oct 2003 Feb 2004
Independent Contractor/Database Developer
. Develop stored procedures, functions & structured queries in T-SQL.
. Created SQL Server DTS (ETL) packages in both test & production
environments.
. Assist DBA with backup/recovery strategies and manage both OLAP & SQL
Server roles.
. Create MS Excel pivot tables/reports for post data conversion issues.
Open Solutions Incorporated - Glastonbury, CT July 2000 - Jan 2003
eCommerce Implementations Analyst/DBA
. Created, maintain, import/export, performance tuning and
backup/restore databases using SQL Server 7.0 & 2000 in both a Windows
NT 4.0 and Windows Server 2000 environment.
. Software installation of Oracle 8.i and SQL Server 2000.
. Modified and developed ASP pages and HTML using Visual Studio
Interdev.
. Deployed new release asp pages. Create custom queries, functions and
SQL Server scripts for latest upgrades.
. Created tnsnames.ora files to create a connection to an Oracle
database remotely for real time connectivity (QBT Software, VT Server)
to the SQL Server database.
. Conducted file transfer tests with clients so the client will have up
to date data in their database.
. Trained incoming employees.
Skills Used
SQL Server 7.0 and 2000, HTML 4.0, ASP, SQL Navigator, QBT, SQL*PLUS,
Oracle 7.3.4, Oracle 8.0 and Oracle 8.i., MS Access 2003, MS Word 2003, MS
Excel 2000, MS PowerPoint 2000, Visual Interdev, Windows NT 4.5, Windows
2000 Server, IIS 4.0, Acrobat Distiller, Dreamweaver UltraDev 4.0., HP
Openview, MS Visio & Altiris
Open Solutions Incorporated - Glastonbury, CT Jan 2000 - July 2000
Conversions Programmer
. Designed PL\SQL scripts to create temporary tables within a number of
databases schemas.
. Created PL\SQL stored procedures to load permanent tables with data
from temporary tables with the use of Quest SQL Navigator and/or Quest
T.O.A.D.
. Created an MS Access application to import data from an MS Excel
spreadsheet to temporary tables in MS Access. In turn, the tables in
MS Access will be extracted to Oracle temporary tables with the use of
an ODBC driver.
. Trained incoming employees.
Skills Used
PL\SQL, SQL*PLUS, Oracle 7.3.4, Oracle 8.0 and Oracle 8.i., SQL Navigator,
MS Access 2000, MS Word 2000, MS Excel 2000, MS PowerPoint 2000
Computer Sciences Corporation - Rocky Hill, CT Jul 1997 - Dec 1999
Application Developer
. Developed an Update Telephone Directory with the use of MS Access.
. Redeveloped a Circuit Interrupt Reporting System application for
United Illuminating which consisted of 14 maintenance tables (14
forms), 7 transaction tables (7 forms), coding business rules in
PL/SQL and a total of 18 daily, weekly, monthly, yearly and ad-hoc
reports. This application was developed with the use of Oracle
Designer 2000 and Oracle Developer Reports. This application is used
as an analytical tool for reporting trouble circuits throughout the
state of Connecticut, to determine which circuit is interrupted.
. Developed a Meter Data Integrity application for United Illuminating
which consisted of (9 reports) and the redesign of 2 maintenance
tables (2 forms) stored procedures, functions, packages and coding
business rules in PL/SQL. This application was developed with the use
of Oracle Designer 2000 and Oracle Developer Reports. This application
is used as an analytical tool for reporting on meter data.
. Allocated data sets and modify programs using ISPF editor.
. Performed a series of spreadsheets and newsletters using an IBM
compatible PC.
. Y2K Migration/Renovation. Project, coded and unit/system tested
programs thoroughly.
. Converted OS\COBOL programs to COBOL370 using MHTRAN, on an IBM
mainframe.
. Performed file comparisons (baseline & regression testing) with the
use of Princeton's Version Merger.
. Updated Y2K Repository with the use of MS Access 97.
. Proven ability to communicate with fellow team member's long
distance.
. Developed the Trouble Order Management System application for United
Illuminating which consisted of four CICS on-line screens and one
COBOL target program. This application is used as an analytical tool
for reporting the nature of the trouble circuits. Spoke with the
client on a daily basis.
Skills Used
Oracle Designer 2000, Oracle Developer 2000, Oracle Forms 4.5, Oracle
Reports 3.0, PL\SQL, SQL*PLUS, SQL Loader, SQL Navigator, T.O.A.D, Oracle
7.3.4, Oracle 8.0 and Oracle 8.i., MS Access 2000, MS Word 2000, MS Excel
2000, MS PowerPoint 2000, Windows NT 4.5, Windows 95, Windows 98,
WordPerfect for DOS, Lotus 1-2-3, MS-DOS Editor, DBASE II, OS/VS COBOL, VS
COBOL, COBOL 370, CICS 4.1, MVS/JCL, TSO v2.5, ISPF v4.3, OS/390, Datacom,
Assembler, Abend-Aid, File Aid, Version Merger, EJCK, CA Datamacs/Verify &
Expediter/CICS.
TRAINING
. System Administration for MS SQL Server 7.0 & 2000 & 2005. Self
tutoring SQL Server 2008 until formal training is received.
. Currently studying for my SQL Server 2008 MCITP Implementation and
Maintenance certification.
. Oracle Education - Oracle Designer 2000 first class analysis, design
and generation training.
. Oracle Education - Oracle Developer 2000 Release 2 build reports
training.
. Computer Based Training (CBT).
. Themes - CICS command level programming training.
. Themes - OS/VS COBOL - COBOL 370 differences training.
. Computer Associates - CA Data Macs/Verify.
EDUCATION
. Quinnipiac University Hamden, CT. Sept 1997 - June 2001
. Gateway Community Technical College North Haven, CT. Aug 1994 June
1996
ACTIVITIES
. IT Director of the New Hampshire Off Road Vehicle Association web site
http://www.nhohva.org (Volunteer position)
. New Durham Valley ATV Club member.
Contact this candidate