Justin Ruffin - "ASP/C# Developer | SQL Server DBA | 13 Yrs Experience | U.S. Based - Freelance Programmer / Developer, United States"

Hands-on technical experience with numerous DBA functions, including SSIS packages/ETL, DDL scripts, logical and physical data modeling, index tuning/optimizing, queries, with MySql and SQL Server Databases.  Reviewed performance data with the RAID arrays and optimized SQL Server setup to partition data files and separated log files on different arrays.  Responsible for determining the optimal raid levels based on usage and log data.  Responsible for the migration of SQL Server 2000 databases to SQL Server 2005, technical experience includes migrating DTS packages to SSIS packages and changes to stored procedures due to the legacy SQL Server 7.0 SQL statements.  Examined and debugged VB.NET and C# client applications for troubleshooting of business logic and data access layers to assist in bug fixes. 

Responsible for mentoring junior DBAs/developers and reviewing new database designs to verify that the physical database design was designed to enable maintainability, scalability and performance.  Issues addressed were the design of covering indices, index tuning, table placement, and indexed views utilized with horizontally partitioning tables across multiple arrays to increase performance.

Designed and developed highly scalable AJAX enabled web applications, web services, business logic layers and data access layers.  Developed event driven ASP Web User Controls Server Controls which rendered html structures/composite controls, and provided a consistent graphical interface to the end user.  Developed an SQL AD-HOC reporting tool which enabled users to create SQL AD-HOC reports.  The AD-HOC reporting tool replaced a previous utility that did not guard against SQL Server injection attacks.  The tool enabled users to save reports and generate a dynamic GUI interface which enabled the input of custom filter criteria when running reports.

WEB 2.0 and AJAX was extensively used to enable provide thick client functionality to a thin client application.  .  The server controls were fully compliant with the ASP.NET framework/Visual Studio IDE and provided drag and drop usability/IDE visibility to other developers on the team.

Reviewed existing application data access layers and business logic to determine how to be implement enhancements and extend current functionality of the application while maintaining a consistent code base and patterns.  Developed naming standards and best practices to encourage code reuse and improve future maintainability of the C# applications.

Designed and developed web services which were consumed by multiple client applications such as a VB.NET client application and ASP.NET/C# web applications.  The web services utilized SQL Server data access layers with XSD strongly typed data access layer and C#.  Utilized extensive compression modules with web service calls to reduce the amount of bandwidth required and increase performance of the applications.

Consolidated multiple applications and tools into a single web site project to enable and promote reuse with CSS, JavaScript, graphics and master pages.  The master pages included standardized AJAX support and standardized error reporting to the user.

Architected and designed an n-tier web based global application to maintain hardware demand forecasting, budget planning and hardware and datacenter deployment planning for Intel Engineering and Computing globally.  The application is being hosted in a central location but yet accessed globally in multiple countries through Asia, Europe, and the Americas. 

Extensive business requirements were gathered to design the CDPCF(Computing Demand, Planning and Capitol Forecasting) application supports Hardware Demand, Capacity Planning, Forecast, Capitol Budgets and the budget approval process.   The application integrates with SAP purchasing modules for reconciliation and gap analysis for forecasted and approved capitol budgets. 

Performed and reviewed all database development, physical schema design to enforce normalization for efficient OLTP performance, and controlled and selective use of de-normalization through the use of indexed views for increased performance for reporting and grid presentation of web based interfaces.  Planned and performed the migration from SQL Server 2000 to SQL Server 2005.  Reviewed existing DTS packages, and developed new SSIS packages for SQL Server 2005. 

Implemented development standards and best practices for the development team which consisted of 2 Development DBA’s and 4 C# .NET developers.   The development standards included information, such as efficient access to SQL server and standards for stored procedure development and physical schema development.  All application and database development was reviewed by peer collaboration to enforce and promote the coding standards.  All stored procedures in the database are accessed by ADO.Net through a consistent architecture reducing errors and enhancing performance.

Designed and developed a sophisticated Object Oriented architecture.  The project included strong use of C# generic classes and methods to improve performance, thereby reducing boxing and un-boxing of objects.  High use of object oriented design such as the use of abstract and base classes were used to improve overall quality and to further standardize the project to promote consistent development and standards across developers.  The web-based application was built using ASP.NET, C#, Business Objects Crystal Reports and SQL Server 2000 Enterprise Edition and Windows Server 2003 Enterprise Edition.  The application was architected as a scalable n-tier application utilizing a Presentation Layer, multiple business logic layers, and a data access layer to isolate and wrapper all SQL Server calls.  Extensive database performance testing was utilized in the application to integrate with existing CDIS data feeds which contain millions of records.  Web application benchmarking was performed to maintain bandwidth constraints and acceptable response times for usage in emerging countries.

 Server resources were maximized through the use of virtual server for our entire lifecycle development.  We utilized Windows Virtual Server 2005 extensively to manage multiple developments environments, DEV (Development, QA (Quality Assurance), UAT (User Acceptance Testing), Staging (Pre-Production) environments.  This enabled the development group to work on multiple branches of development in parallel.  This enabled us to support critical production bug fixes while enabling the development group to work on releases with significant functionality or feature enhancements.