Professional Summary

• Skilled IT professional with 15 years of experience with Microsoft SQL Server. Strong TSQL, DTS/SSIS ETL development experience. Some development experience with SSRS, SSAS and SSMA converting Oracle 10g Data Warehouse schema to SQL Server as well as the associated PL/SQL loading processes to SSIS packages.
• In-depth performance tuning experience utilizing tools such SQL Server Profiler, SQL Server Management Studio and Performance Monitor.
• Detail oriented individual with excellent interpersonal and organizational skills. Focused on delivering results.

Technical Skills

Professional Experience

Confidential

Sr. Database Administrator

• Migrated a B2B/B2C Access application to SQL Server including its associated Jet SQL queries to TSQL.
• Migrated the CMSI B2B/B2C applications into new Data Warehouse methodology.
• Created TSQL scripts to automate the loading of configuration data for multiple extract files into the new Data Warehouse.
• Designed and created an automated process to keep the Employee Directory database up to date via Active Director, UltiPro and LDAP.
• Assisted the Enterprise Reporting group in writing B2C financial reports for executive staff members.
• Reverse engineered actuals/eliminations SSIS package to resolve out of GL balance issue.
• Designed, coded and tested SSIS packages that reformatted flat file delimiters and checked row counts to ignore those file with no records for importation into the Data Warehouse.
• Reduced Data Warehouse load time from 6 hours and 20 minutes to 45 minutes by converting TSQL load statements to SSIS packages.
• Created MoveIt jobs to purge/archive extract files as well as download/upload to FTP sites.

Confidential

Sr. Database Administrator

• Implemented database changes including TSQL scripts, stored procedures and triggers in DEV, INT, QA and Production environments.
• Created Tivoli Job Scheduler wrappers for full, differential, transaction log backups and maintenance jobs such as index rebuilds and updating statistics.
• Assisted application troubleshooting by utilizing utilities such as Extended Events, Profiler and Estimated Execution Plan.
• Administered SQL Server security across all environments.

Confidential

SQL Developer

• Design, develop and unit test SSIS packages to migrate legacy data to SQL Server databases.
• Create SSIS packages and TSQL scripts to reconcile migrated data.
• Analyzed error logs to determine data migration issues.

Confidential

SQL Developer

• Converted Oracle 10g data warehouse to SQL Server 2008 R2 utilizing SSMS SQL Server Migration Assistant . Analyzed and designed SSIS packages to replace Oracle packages/procedures for ETL.
• Modified SSIS packages that feed data warehouse loading from DB2 databases.
• Analyzed TSQL queries to enhance performance.

Confidential

Database Administrator/Developer

• Migrated SQL Server 2000 production databases to SQL2K8, DTS to SSIS packages and OLAP databases to SSAS.
• Designed, coded, tested and documented SSRS reports for database administration.
• Performed extensive performance tuning of TSQL and indexes utilizing utilities such as Profiler, Blocking Scripts, Index Tuning Wizard and other third party tools.
• Supported multiple production and internal SQL Server 2000, 2005 and 2008 environments to provide maximum availability.
• Designed, coded, tested and documented SSIS packages for database administration functions and ETL processes. This included complex TSQL and VB.Net.
• Participated in On Call rotation to support production environments.
• Created Maintenance Plans and SQL jobs for full, differential and transaction log backups to provide point in time recovery as well as index rebuilding during non-peak hours to ensure maximum availability and performance.
• Supported the SDLC process by providing performance recommendations and keeping
• all environments up to date with the latest database scripts.

Confidential

Database Administrator

• Provided support for SQL Server, DB2 and Sybase relational database platforms.
• Created VB .Net script to collect Recovery Mode information on all production SQL Servers.
• Created VBScript script to collect metrics such as amount of free memory and CPU utilization on all production Windows servers.

Confidential

Database Administrator

• Designed, coded, tested and documented interfaces utilizing DTS packages coded with VB 2005 and VBScript for the importation of acquired company data such as General Ledger, Leasing and Customer Information to mainframes and SAS datasets.
• Coded/reviewed TSQL scripts for performance recommendations and to expedite support functions such as searching for loan numbers, updating loan dates and setting flags for reporting purposes.
• Setup and restoration of SQL Server Log Shipping scenarios between servers for Disaster Recovery.
• Setup and maintenance of Transactional Replication for Disaster Recovery scenarios.
• Modified Disaster Recovery scenario based on detachment, copy and reattachment of databases.
• Created Database Maintenance plans for backup of System and User databases.
• Implemented database upgrades and corrective measures via issue tracker system.

Confidential

Database Administrator

• Created database Maintenance Plans to backup, optimize and reorganize production/development databases.
• Monitored backup jobs daily to ensure point in time recovery.
• Developed the Standard Configuration document to serve as a guideline for installing, configuring and optimizing Microsoft SQL Server 2000.
• Installed/configured and tested Double Take to provide high availability scenario for SQL Server 2000.

Confidential

Database Administrator II

• Provided database design recommendations for performance optimization.
• Created/modified DTS Packages to run from Perl scripts to load exported data from legacy databases.
• Wrote Perl script to import WinRunner test result data from comma-separated files.
• Assisted in creation of staging programs written in Perl to upgrade database.
• Coded SQL to be run from Perl scripts for the purpose of staging databases.
• Executed performance tests via WinRunner and analyzed SQL transaction response times.
• Ran reports against MS-SQL and Informix on NT to compare response time results.
• Analyzed Profiler, Performance Monitor, SQL Error and Blocker logs to determine system bottlenecks and recommended corrective action.

Confidential

Sr. Database Administrator

• Implement physical database designs and write basic stored procedures, views and triggers.
• Provided input to developers for database design.
• Tested bi-directional replication utilizing DataMirror Transformation Server between SQL 7.0 and four AS/400 databases.
• Responsible for the corrective and preventive maintenance on seven MS-SQL servers.
• Upgraded 6.5 to 7.0 and performed database conversion.
• Restored production databases to development and test servers for Development Team.
• Restored test databases to production servers to implement the latest changes.

Confidential

Database Administrator

• Implemented a speech recognition system based on Windows NT 4.0 Servers and SQL 6.5 database.
• Installed SQL 6.5 Client Utilities and configured on 100 clients.
• Performed Service Pack 5A upgrade to MS-SQL 6.5 database and clients.
• Created and scheduled tasks for hourly transaction log and daily, full backups of SQL database.
• Identified corruption in the database by executing DBCC CHECKDB, CHECKALLOC, CHECKCATALOG and then performed repairs.
• Utilized statistics collected from Performance Monitor to tune MS-SQL, which included Procedure Cache percentage, Maximum Asynchronous I/O, Hash Buckets and Locks.
• Designed management reports utilizing Crystal Reports and MS-Query.
• Modified tables in the database via MS Query and ISQL to insure data integrity and allow reports to be uploaded via HL7 interface.
• Utilized the Current Activity window and sp who stored procedure to identify blocking processes in SQL to isolate application problems.