Peter M. Florenzano
45 Bog Road, Unit A6
Concord, NH 03303
(603)715-5607
[Send email using form at bottom]
OBJECTIVE
Senior Database Administrator with twelve years experience seeking a challenging
part-time, telecommuting database administrator/architect position within an
Oracle and/or MS SQL Server environment.
EXPERIENCE
PC Connection - Merrimack, NH Nov 2007 – Present
Database Administrator
• Manage high volume databases within clustered environment (active-active &
active-passive) architecture.
• Manage user security (by SOX standards) on all types of databases, including
VLD’s.
• 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 1999 GPA 3.5
• Gateway Community Technical College North Haven, CT. Aug 1994 June 1996
• A.S. Computer Science Technology, GPA 3.3
|
