Marvin D.

## BIO * Migrated database environment from SQL Server 2000 to SQL Server 2005 * Performed all requirements of the Database Administrator to include tuning, backup and security functions * Set up and deployed snap shot and transactional replication to distribute data across multiple databases * Designed and utilized Common Language Runtime (CLR) stored procedures greatly increasing large scale data import operations * Implemented partitioning of large tables over numerous file groups to improve read/write performance * Set up and managed groups within Active Directory to maintain SQL Server Security * Developed ad-hoc queries to retrieve requested information * Developed and deployed SSIS Packages for SQL Server 2005 utilizing SQL Server Business Intelligence * Developed DTS packages to load and run statistical reports * Created stored procs, procedures and functions * Designed, created, deployed and maintained very large databases in excess of 150 gigabytes each * Performed all requirements of the Database Administrator to include tuning, backup and security functions * Set up and deployed snap shot and transactional replication to distribute data across multiple databases * Designed and utilized Common Language Runtime (CLR) stored procedures greatly increasing large scale data import operations ## Area of Expertise MS Sql Server 2005 MS SQL Server 2000 MS Access MS Excel VBA VB ASP