Resume

Sign in

Sql Server Manager

Location:
United States
Posted:
March 12, 2018

Contact this candidate

Resume:

nicholas michael bucelli

** *** *** **, *******

MICHIGAN, 48906

BUCELLIFAMILY.COM

215-***-**** [CELL]

OBJECTIVE

•Obtain a position with a well-established organization with a stable environment where I can maximize my development and administrative abilities, utilize my mentoring skills, and be actively involved in the growth of the company leading to a lasting relationship in the IT field.

EDUCATION

Information Technology, March 2003 – December 2005

Kaplan University, Davenport, Iowa

GPA 3.9/4.0

Studies focused in IT with a concentration in Database Management.

EXPERIENCE

Database Administrator May 2016 – July 2017

Michigan Court of Appeals, Lansing, MI

Maintained user logins/passwords for Oracle databases.

Converted Oracle 11g database to MS SQL Server 2012

Using SSMA tool

Performed database refresh between Oracle Production database to Oracle test database for updated development use.

Created and maintained SSIS packages for data load and extraction

Responsible for database code promotion between test, qa, and production environments

Backup/Restore of Oracle 11g Production databases.

Troubleshooting poor performing code using sp_who2, perfmon, SQL Profiler

Deploying and maintaining successful maintenance plans (some of which include log shipping. Designing, developing, maintaining and troubleshooting DTS and SSIS packages.

Provided performance support of Oracle test and production databases.

Reviewing, approving, deploying, and maintaining database code designed by our in-house development team.

SR MS SQL Database Administrator July 2013 – April 2016

Federal Reserve Bank of Philadelphia, Philadelphia, PA

Created/modified stored procedures and triggers

Created and maintained database security

Created and maintained SSIS packages for data load and extraction

Responsible for database code promotion between test, qa, and production environments

Backup/Restore of production databases.

Backup/restore of Oracle 12c Treasury Direct database.

Created and maintained users and security for Treasury Directly Oracle 12c database

MS SQL Database Administrator July 2012 – July 2013

PNC Bank, Pittsburgh, Pa.

Created/modified stored procedures and triggers

Created and maintained database security

Created and maintained SSIS packages for data load and extraction

Responsible for database code promotion between test, qa, and production environments

Backup/Restore of production databases.

MS SQL Database Administrator (contract position) June 2012 – August 2012

TEKSystems, Cleveland, Ohio

Created/modified stored procedures and triggers

Created and maintained database security

Created and maintained SSIS packages for data load and extraction

Responsible for database code promotion between test, qa, and production environments

Backup/Restore of production databases.

MS SQL Database Administrator(contract position) October 2011 – December 2011

West Penn Allegheny Health Systems, Pittsburgh, Pennsylvania

Responsible for converting MySQL databases to MS SQL 2008 databases.

Created/modified stored procedures and triggers

Created and maintained database security

Created and maintained SSIS packages for data load and extraction

Responsible for database code promotion between test, qa, and production environments

MS SQL Database Administrator April 2010 – August 2011

Pittsburgh Board of Education, Pittsburgh, Pennsylvania

Responsible for production databases, mainly RTI database and data requests for the Pittsburgh School District.

Write and maintain T-SQL scripts for data extraction and loading, as well as verification and troubleshooting SQL jobs and handle the backup and log-shipping of production databases.

Backing up of production databases.

Restoring of qa databases with scrubbed production data.

Aiding the development database administrators with various dba tasks.

Monitoring and troubleshooting database performance issues.

Deploying and maintaining successful maintenance plans (some of which include log shipping. Designing, developing, maintaining and troubleshooting DTS and SSIS packages.

Working closely with project management and development on various projects from a database administrator capacity.

Setting up secure linked servers to support cross database server code.

Created federal, state, and end user reports using SSRS 2005.

Troubleshooting poor performing code using sp_who2, perfmon, SQL Profiler, and Microsoft Operations Manager.

Comparing data and schemas between environments.

Setting up new SQL Server 2005 environments on stand-alone servers and dual node active-passive clusters.

Experimenting with AWE and PAE switches in order to allocate more memory to the SQL Server engine (in a test environment).

Working closely with our system administration team to spec out new database server equipment for various initiatives and projects.

Working with our help desk and product support teams in a Level III support capacity.

MS SQL Database ADMINISTRATOR April 2005 – December 2009

PHARM/Dur, Philadelphia, Pennsylvania

Responsible for 2 database redesigns and migrations to meet growing business demands.

Backing up of production databases.

Responsible for maintaining production databases.

Created and ran data loads using third party ETL product and SSIS.

Created and maintained client and in-house reports utilizing SSRS 2005.

Created and maintained end user and client reports using Crystal Reports.

Upgraded company created reports in Crystal to SSRS 2005.

Created maintenance and data retention policies and ensured company adhered to policies.

Maintained approximately 75 databases ranging in size from 10 MB to 750 GB.

Created/modified stored procedures for ease of tasks and developer needs.

Performed upgrade from SQL 7 to 2000 and also from 2000 to 2005.

Restoring of qa databases with scrubbed production data.

Monitoring and troubleshooting database performance issues.

Deploying and maintaining successful maintenance plans (some of which include log shipping. Designing, developing, maintaining and troubleshooting DTS and SSIS packages.

Reviewing, approving, deploying, and maintaining database code designed by our in-house development team.

Setting up secure linked servers to support cross database server code.

Troubleshooting poor performing code using sp_who2, perfmon, SQL Profiler, and Microsoft Operations Manager.

Comparing data and schemas between environments.

Setting up new SQL Server 2000 environments on stand alone servers (as opposed to clustered servers).

Setting up new SQL Server 2005 environments on stand alone servers and dual node active-passive clusters.

Experimenting with AWE and PAE switches in order to allocate more memory to the SQL Server engine (in a test environment).

Working closely with our system administration team to spec out new database server equipment for various initiatives and projects.

MS SQL Database Administrator February 2004 – April 2005

Commerce Bank, Mount Laurel, New Jersey

Responsible for all branch servers including database upgrades and maintenance.

Created and utilized Active/passive clusters to ensure branches were always operational.

Created and maintained SQL snapshot replication from back office to branch servers.

Backing up of production databases.

Restoring of qa databases with scrubbed production data.

Monitoring and troubleshooting database performance issues.

Deploying and maintaining successful maintenance plans (some of which include log shipping. Designing, developing, maintaining and troubleshooting DTS and SSIS packages.

Working closely with project management and development on various projects from a database administrator capacity.

Setting up secure linked servers to support cross database server code.

Troubleshooting poor performing code using sp_who2, perfmon, SQL Profiler, and Microsoft Operations Manager.

Comparing data and schemas between environments.

Setting up new SQL Server 2000 environments on stand alone servers (as opposed to clustered servers).

Experimenting with AWE and PAE switches in order to allocate more memory to the SQL Server engine (in a test environment).

Working closely with our system administration team to spec out new database server equipment for various initiatives and projects.

Setting up jobs that email daily reports of failed database jobs and log shipping synchronization to my team.

Working with our help desk and product support teams in a Level III support capacity.

MS SQL Database Administrator June 2002 – February 2004

Sovereign Bank, Reading, Pennsylvania

Created and maintained SQL snapshot replication from back office to branch servers.

Responsible for all branch servers including database upgrades and maintenance.

Created and utilized Active/passive clusters to ensure branches were always operational.

Backing up of production databases.

Restoring of qa databases with scrubbed production data.

Monitoring and troubleshooting database performance issues.

Deploying and maintaining successful maintenance plans (some of which include log shipping. Designing, developing, maintaining and troubleshooting DTS and SSIS packages.

Working closely with project management and development on various projects from a database administrator capacity.

Setting up secure linked servers to support cross database server code.

Troubleshooting poor performing code using sp_who2, perfmon, SQL Profiler, and Microsoft Operations Manager.

Comparing data and schemas between environments.

Setting up new SQL Server 2000 environments on stand alone servers (as opposed to clustered servers).

Working with our help desk and product support teams in a Level III support capacity.

MS SQL Database Administrator January 1999 – June 2002

Ceridian, Exton, Pennsylvania

Served as senior level support for call center.

Created and performed training curriculum for techs in call center on product line and enhancements.

Served as 1 of 4 members that was available for onsite client support.

Performed upgrade from SQL 6.5 to SQL 7.0.

Monitoring and troubleshooting database performance issues.

Designing, developing, maintaining and troubleshooting DTS and SSIS packages.

Working with our help desk and product support teams in a Level III support capacity.

.

Skills

MS SQL Server versions 6.5 to 2008

Pervasive SQL 2000

MS Office versions 7 to 2010

WMI Scripting

Windows Server versions NT to 2008

SSRS/SSIS

ActiveX Scripting

Configuring Windows Server Security

Windows Shell scripting

SQL

MySQL 5.5

XML

Business Objects Data Integrator ver 11.7

MS Access versions 7 to 2007

Writing/Troubleshooting T-SQL

MS Windows versions 3.1 to XP

Informix RDMS

Sybase RDMS

DTS

Q&A

Transact SQL

Server administration

Database programming

Performance and optimization techniques

Transactions and record locking

Database design

Relational database design

Database permissions

Database migration

Data analysis

Report creation

Mentoring

Clustering

Log shipping

Replication

Troubleshooting

Oracle 11g

Oracle 12c



Contact this candidate