Scott Jones Email Address

Director, Data Warehouse

Computer Sys Design Srvcs

Senior IT Database Developer/Analyst with Data Warehouse ETL & Architecture, Database Administration, Development, Report Development and Technical Support/Maintenance skills. Core support responsibilities include: backup/restore, disaster recovery, routine maintenance and database consistency, monitor database growth and capacity planning as well as performance tuning and query optimization including index creation and resolving issues. Write stored procedures, views, triggers and functions in support of applications. Strong grasp of ACID principles, locking and transactions. Table design, normalization, triggers, views, indexes and user defined functions. Develop custom Access/VBA applications; Develop custom DTS and SSIS 2014 packages. Develop complex business reports using T-SQL stored procedures and views using Crystal Reports XI and SSRS 2014; Administration of Reporting Environment. Perform data migration and SQL Server upgrades. Excellent communication, analytical and interpersonal skills with all levels of the organization Specialties: Data Warehousing, ETL, Database Development, Design, Administration, Reporting, Tuning & Optimization