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 2012
• Pervasive SQL 2000
• MS Office versions 7 to 2010
• WMI Scripting
• Windows Server versions NT to 2012
• 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 2010
• 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

EXPERIENCE:

MS SQL Database Administrator

Confidential, Philadephia, 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
• Created backup plans for databases and tested backups on periodic basis
• Backup/Restore of production databases.
• Set-up and monitored SQL Server Active/Passive clusters
• Installed and configured GoldenGate for SQL on Federal Reserve/Treasury Cash System
• Member of disaster recovery team. Performed multiple BRT tests throughout year for compliance purposes
• Performed database architecting and SQL code review for in house created applications
• Performed database upgrades from version 2005 to version 2012
• Implemented transactional replication for high use databases in Research and Audit departments
• Created data archive solution via TSQL for high use Research database
• Responsible for performing SAFR Security lockdowns on SQL databases

MS SQL 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 and tested backups on periodic basis
• Installed SQL Server Active/Passive and Active/Active clusters
• Implemented snapshot replication and log shipping

MS SQL 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 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 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 Database ADMINISTRATOR

Confidential, Philadelphia, Pennsylvania

Responsibilities:

.

• Responsible for 2 database redesigns and migrations to meet growing business demands including re - architecting databases both times
• Implemented Disaster Recovery program for database availablility
• 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

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 Database Administrator

Confidential, Exton, 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.