Sql Server Manager
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