Banner Image

All Services

Programming & Development

Database Administration

$5/hr Starting at $25

PROJECTS & EXPERIENCE Client : MasterBrand Cabinets Inc • Rebuild the SQL SERVER for parity between Stage and Production • Developed Views, Procedures and Triggers according to business rules • Tune the database using SQL PROFILER and Performance Monitor • Devloped DTS packages for extracting and transforming data Client : City and County of Evansville Software : SQL Server 2000/ 2005, MS-Access 2003 • MS-Access database had been converted ADP project keeping the database in SQL Server for better performance. • Designed and created the normalized MS-Access database by analyzing the requirements. Created the data entry form to easily input the data into tables. • Linked the MS-Access databases to SQL SERVER and set up the appropriate privileges to the users. • Created appropriate DTS packages to export all the tables from Animal Control Database into CODE ENFORCEMENT DATABASE to keep the existing records and to insert the new records.

About

$5/hr Ongoing

Download Resume

PROJECTS & EXPERIENCE Client : MasterBrand Cabinets Inc • Rebuild the SQL SERVER for parity between Stage and Production • Developed Views, Procedures and Triggers according to business rules • Tune the database using SQL PROFILER and Performance Monitor • Devloped DTS packages for extracting and transforming data Client : City and County of Evansville Software : SQL Server 2000/ 2005, MS-Access 2003 • MS-Access database had been converted ADP project keeping the database in SQL Server for better performance. • Designed and created the normalized MS-Access database by analyzing the requirements. Created the data entry form to easily input the data into tables. • Linked the MS-Access databases to SQL SERVER and set up the appropriate privileges to the users. • Created appropriate DTS packages to export all the tables from Animal Control Database into CODE ENFORCEMENT DATABASE to keep the existing records and to insert the new records.

0 Reviews

This Freelancer has not received any feedback.