DataBase Analysis/Administration
Responsible for the design, development and administration for SQL Server databases.
* Designed, architected and successfully migrated all databases from SQL Server 6.5 to 7.0 and 7.0 to SQL 2005. Specifically analyzed all data structures, tables and triggers, verified compatibility, manipulated data to fit the new schema, as well as rewrote incompatible stored procedures, triggers, and tables.
* Migrate all customer data from third party applications into current databases.
* Provide tier 3 SQL 6.5/7/2000 support for the Product Deployment department.
* Design and develop VisionAIR's SQL Administration training courses and procedures.
* Design and develop scripts to implement VisionAIR's SQL recommended backup procedures and database integrity checks.
Systems Development/Engineering 6/03 to Present
* Design and develop Crystal Enterprise Reports for internal and external use. Utilize Crystal Enterprise version 9/10 and Crystal Reports 7,