IT Experience Summary: |
Eleven years experience in Microsoft SQL Server database administration, architecture and development in client-server and n-tier Internet environments. Four years in enterprise ERP system implementation and customization. Seven years in IT / Professional Services management positions. |
Client Operating Systems: |
Microsoft Windows 9x, NT 4.0 Workstation, Windows 2000 Professional, and Windows XP |
Database Platforms: |
Microsoft SQL Server 4.21a – 2000, IBM DB2/400, Microsoft Access |
Network Operating Systems: |
Windows NT Server 3.51 and 4.0, Windows 2000 Advance Server, and Novell Netware 3.1x. |
Lead a team of database administrators and developers responsible for all SQL Server database architecture, development and administration for one of the world’s largest domain registrars and hosting companies. |
|
Manage multiple SQL2000 database servers in development and production environments with databases as large as 500GB. The environment is high volume 24x7 OLTP for both e-commerce and account management. |
|
Develop application requirements and designs in support of quickly changing business needs. |
|
Design and create tables, views, triggers, and stored procedures in TSQL for both SQL7 and SQL2000 in support of several dynamic, high-change-activity applications. |
|
Architect high performance data access using ADO and XML from both presentation tier ASP and middle tier objects used in a high-concurrency Internet-based application. |
|
Monitor SQL Server performance for excessive blocking, locking, and inefficient stored procedures and queries. Rewrite procedures and modify database schema as necessary to resolve application bottlenecks. Reduced run time and SQL Server resource requirements for some processes by more than 80%. |
|
Create and implement disaster recovery and replication strategies for multiple high availability SQL Server 2000 environments including automatic updating of warm spare servers and automated security synchronization. |
|
Responsible for planning, implementing and maintaining SQL2000 virtual servers over Windows 2000 Advanced Server clusters including Network Appliance SAN and NAS storage solutions. |
|
Mentor developers from other application tiers in the creation of SQL Server objects with high quality and performance. |
Responsible for managing the database team tasked with the creation and maintenance of the MS SQL Server-based data tier for a hosted, n-tier CRM application based on the ASP delivery model. |
|
Held overall responsibility for database tier architecture for multiple applications in support of new development, application enhancements and feature changes. |
|
Performed duties as primary database administrator in MS SQL Server 7.0 / 2000 environment. |
|
Maintained over 100 subscriber databases for multiple applications across eight server lines supporting development, quality, sales and production environments. |
|
Managed migration of SQL Server 7.0 environment to SQL Server 2000 including task planning, code testing and TSQL code updating to correct problems associated with the migration. |
|
Provided overall database team management including both personnel mentoring and project management. |
|
Worked as part of product management group to set application enhancement priorities and product architecture directions. |
|
Performed hands-on work at all levels of application database tier design, development, testing and implementation. |
|
Developed and maintained a patent-pending TSQL stored procedure generator and underlying schema to drive the application "virtual object system," the mechanism to dynamically control VB based middle and ASP based presentation tier operation. |
|
Monitored all SQL Server application in all environments for performance issues and provide suggested solutions to performance bottlenecks. |
|
Created application reporting using Crystal Reports. |
Had responsibility for supporting external customers in all aspects of implementation, maintenance and operation of Platinum ERA and e by Epicor, Windows NT / MS SQL Server based client-server ERP software packages. |
|
Performed MS SQL Server 6.5 and 7.0 DBA functions. This was comprised of SQL installation, configuration and performance tuning. Creation of views, triggers, and stored procedures utilizing both static and dynamic Transact SQL along with troubleshooting and correcting of blocking and deadlocking issues were also included. |
|
Provided project management for both new implementation and post implementation support engagements. |
|
Led and mentored staff consultants. |
|
Executed business process review efforts, assisting clients with software installation and configuration. |
|
Utilized MS Transact SQL and VBA to modify standard package or create custom functional modules. |
|
Used Crystal Reports to assist customers in custom report generation. |
Managed the Information Systems group of a corporation focused on natural gas utilities and propane distribution. |
|
Acted as MS SQL Server 4.21 and 6.5 DBA. |
|
Developed strategic direction and plans in response to a dynamic business environment. |
|
Designed, implemented and maintained Novell and Windows NT-based networks utilizing various LAN and WAN technologies including Ethernet, Token Ring, T-1, Frame Relay, TCP/IP and IPX/SPX. |
|
Supervised the operation and maintenance of IBM AS/400 midrange computer. |
|
Implemented new financial package bringing all operating entities onto a single system. |
|
Designed, implemented and maintained corporate Internet strategies and acted as web master. |