Senior database architect/developer/administrator, responsible for the administration of production, pre-production, testing, development, and reporting database servers running SQL Server 2000 on Windows 2000.

Lead database developer for a six month project to rebuild the core production web environment (consisting of SQL DB, C#, and ASP.Net). Designed, developed, and implemented the following modules for this system: Data Dictionary, Clients, Users, Groups, Promotions, Activities, Actions, Transactions, Shopping, Email, Lottery, and Reporting. These modules encapsulated the following attributes:

• Hierarchal recursive tables (automatically tracking the hierarchy and level of parent/child relationships).
• Vertically partitioned tables (divided by date ranges for large volume tables).
• A central ID generator for all primary keys to allow for the easy migration of data from DEV to QA to STAGING and to PROD environments.
• Unlimited custom properties for all major objects (allowing internal and external clients to easily add new indexed properties of most any data type to the system via an administrator interface).
• Double entry transaction system (to maintain the integrity when moving funds).
• Replication of commonly requested meta data to MSDB servers running on the web servers to alleviate the load on the production server.
• The ability to replicate all data to read-only servers for load sharing if needed (including a system that tells the web pages to pull from PROD if their data is out of date for a given user).
• A read-only mode that can be turned on for a user, client, sproc, or everything that will prevent any data writes from occurring while allowing all reads (which is very useful when doing maintenance or when migrating clients/users from one system to another).
• A verbose logging mode that can be turned on for a user, client, sproc, or everything that will cause all database writes to be logged at the sproc level. A verbose level can be chosen to limit the logging based on the severity level (ERRORS/WARNINGS/INFO/DEBUG).
• An XML template based email system for sending custom emails.
• Flexible shopping system with multiple catalog/item sources (both internal and external) which are combined into custom virtual catalogs for clients. This enables a user to shop with multiple fulfillment centers at the same time using one cohesive interface. Full Text Indexing was used for searching item descriptions. Most of our fulfillment is handled by Amazon via this automated system.

Designed and developed a generic survey/test system that asks questions, controls allowable answers, and records responses, scores, number of attempts, pass/fail status, etc.

Designed and built an email system that generates custom newsletters for users based on their properties and group affiliation. This system currently sends out 150,000 custom emails in a 4 hour period.

Wrote a system that copies the production databases to a reporting server every night from the daily backups. It sets up permissions for internal users to access the databases via their windows logins. It uses detach and attach methods so downtime is less than a minute.

Senior team member responsible for the administration of six primary (read/write) and forty secondary (read-only) SQL Server 2000 running on Windows 2000 Advanced Server with RAID 5 in 3 data centers across the country.

Lead developer for many database projects primarily dealing with developing key financial database models, table/view design, stored procedures, users/roles/permissions, etc.

Planned, initialized, and continuously monitored transactional replication between various primary and secondary servers. I have also used snap-shot and merge replication and I am very knowledgeable in replication design, tricks, and limitations.

Migrated schemas and data from an SQL Server 6.5 (Windows NT) based environment to an SQL Server 7.0 (Windows 2000) based environment.

Migrated schemas and data from an SQL Server 7.0 (Windows 2000) based environment to an SQL Server 2000 (Windows 2000) based environment.

Periodically diagnosed and fixed database related issues on the fly that were causing production site problems or downtime. I have often needed to perform emergency data changes to the production database and I am able to work well under that kind of pressure.

Periodically needed to handle restoring key production servers after hardware failure caused the servers and parts of the site to go down. I am able to keep myself calm and controlled while working efficiently and logically to recover damaged databases and as much lost data as possible in the shortest amount of time.

Designed and built a Perl based data load pre-processing system that based on a schedule fetched various data feeds (via FTP or HTTP), time stamped them, archived them, uncompressed them, and prepared them for loading. The system currently handles approximately 100 feeds per day.

Designed and developed Visual Basic based data loader modules that load data daily from flat-file and XML feeds into our production databases.

Designed, developed, and upgraded through 3 versions the MarketWatch User registration and Portfolio tracking system. The system was designed with speed and expandability as a primary concern. This was achieved using vertical partitioning of both schema structure and physical servers with the ability to easily expand both as needed.

Developed a Lipper mutual funds data system that loads, archives, and queries Lipper's extensive mutual fund information.

Team leader on a four-month project to design, develop, implement, and support a Business Intelligence interface to allow the analysis and reporting of our registered user information. Replicating our production data into a ROLAP model data warehouse on the back-end, and using the MicroStrategy product for the front-end user interface successfully accomplished this goal.

A technical lead in developing a Boeing On-line Assembly Tracking System to track the documents used in aircraft assembly in accordance with FAA standards.

Co-developed the relational database model using Oracle 7.3.4.

Developed in Oracle Forms 5.0 for the front-end client and PL/SQL for the back-end procedures, functions, and triggers.

Received a Certificate of Recognition for outstanding job performance, in phase I of the Boeing On-line Assembly Tracking System.

Developed an Access database and front-end application for submitting and tracking project bug reports.

Systems Administrator for 3 clustered Sequent servers running DYNIX/ptx 4.4.2 and Oracle 7.3.4.

Performed OS upgrades and coordinated Oracle upgrades with DBAs.

Responsible for nightly backups of Unix file systems and RAW Oracle volumes using Alexandria Backup and Oracle hot and cold backup scripts.

Performed general administration tasks: volume allocation, maintenance, and mirroring; ufs and nfs mount points; user accounts; system security.