SUMMARY:

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.

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

PROFESSIONAL EXPERIENCE:

MS SQL SSIS developer / Database Administrator

Confidential, Lansing, MI

Responsibilities:

• Converted Oracle 11g database to MS SQL Server 2012
• Using SSMA tool
• 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.
• 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.
• Reviewing, approving, deploying, and maintaining database code designed by our in-house development team.

SR MS SQL Database Administrator

Confidential, Philadelphia, PA

Responsibilities:

• 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 SSIS developer and Database Administrator

Confidential, Pittsburgh, Pa

Responsibilities:

• 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 SSIS developer and Database Administrator

Confidential, Cleveland, Ohio

Responsibilities:

• 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 SSIS developer and Database Administrator

Confidential, Pittsburgh, Pennsylvania

Responsibilities:

• 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 SSIS developer and Database Administrator

Confidential, Pittsburgh, Pennsylvania

Responsibilities:

• 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 SSIS developer and Database ADMINISTRATOR

Confidential, Philadelphia, Pennsylvania

Responsibilities:

• 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 SSIS developer and Database Administrator

Confidential, Mount Laurel, New Jersey

Responsibilities:

• 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

Confidential, Reading, Pennsylvania

Responsibilities:

• 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 SSIS developer and Database Administrator

Confidential, Pennsylvania

Responsibilities:

• 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.