SUMMARY:

• SQL Server Architect/Developer/DBA with 20+ years experience designing, developing, maintaining, monitoring and administering complex database systems and multi - tiered client-server applications:
• Expert in Clustering, SAN, Replication, Very Large Databases (VLDB), Disaster Recovery, High Availability, Fault Tolerant Systems and Business Continuance.
• 15+ years database design and SQL programming with SQL Server, Sybase, Oracle, DB2.
• 10+ years programming with C, C++ and C# data layer programming.
• 5 years as Technical Project Lead.
• Extensive experience with all phases of SDLC including Agile/Scrum and traditional methodologies.
• Outstanding communication, documentation and mentoring skills; teaching and experience.

WORK EXPERIENCE:

Confidential

Senior Database Developer/Architect

Responsibilities:

• Responsible for integrating systems from a company merger (Clear Channel Radio and METRO TTN) for the largest on-air radio company in the USA.
• Coordinated and implemented the migration and integration of METRO Total Traffic Network (TTN) systems into Clear Channel network. Designed, developed and implemented software development and release system for database development.
• Architected the integration of TTN software system with existing VIERO online radio system.
• Lead the database development side of proof-of-concept for integration of 160+ regional systems into a single centralized environment implemented upon an 8 terabyte database (MOONSHOT).

Environment: - MS SQL Server 2005/2008 R bit, T-SQL, SSIS, SSRS, VLDB, Partitioning, Clustering, Replication, EMC SAN, High Availability, Agile/Scrum

Confidential

Senior Database Developer/Administrator

Responsibilities:

• Designed and implemented partition strategy for very large tables (>1 billion rows).
• Wrote stored procedures to maintain table partitions and file groups dynamically over time using sliding-window strategy.

Environment: SQL Server 20 bit, EMC SAN, SSIS, VLDB

Confidential

Database Architect

Responsibilities:

• Re-architected 4 main SQL Server instances with utilizing SAN technology including several VLDB’s. Improved performance by 500% and increased reliability to 4-9’s.
• Implemented standardized database maintenance jobs for all databases on all servers.
• Developed data warehouse for reporting and OLAP.
• Set up and maintained transactional replication.

Environment: SQL Server 20 and 64 bit, Visual Studio 2005, EMC SAN, SSIS, SSAS

Confidential

Senior Database Engineer

Responsibilities:

• Developed database, stored procedures, and SSIS packages for new line of business called Profile Boost, which, among other things, controls the targeting of online ads based upon user experience.
• Developed schema changes and stored procedures for implementing Payment Card Industry (PCI) standard encryption for personal identifying information. System includes online encryption for new/updated credit card numbers and a batch “sweeper” to re-encrypt at user defined intervals.
• Designed, documented and coded SSIS packages, stored procedures and schema changes for multiple other systems for import/export and reporting systems.

Environment: SQL Server 2000/2005/2008 , Visual Studio 2005, SSIS, SSRS

Confidential

Database Developer

Responsibilities:

• Migrated legacy IMS system to new SQL Server 2005 client server system.
• Documented business requirements and technical specifications to migrate business data to SQL Server Relational database system.
• Developed data migration strategy for system migration to SQL Server 2005 and designed tables for temporary storage, validation and transformation.
• Designed, documented and coded SSIS packages, stored procedures and SSRS Reports.

Environment: SQL Server 2000/2005, Visual Studio 2005, SSRS

Confidential

Senior DBA

Responsibilities:

• Developed policies and procedures for new Database Administration group.
• Developed C# applications to gather capacity planning and scheduled task information from all server environments (Production, Staging, Test and Development).
• Developed SSRS reports for Capacity, Job Failure History, and Case Load.
• Diagnosed SQL Server performance problems and instituted best-practice resolutions.

Environment: - MS SQL Server 7/2000/2005, Windows 2000/2003 Advanced Server, T-SQL, SSIS, SQL Reports (SSRS), C#, Clustering, EMC

Confidential

Senior Database Developer

Responsibilities:

• Responsible for developing database upgrade for re-designed Radio Station management system (Viero) for the largest on-air radio company in the USA.
• Upgraded Viero from SQL Server 7 and SQL Server 2000 to SQL Server 2005.
• Developed Data Layer (C#, Stored Procedures) for Radio Fusion, a CRM system for the radio industry.
• Responsible for upgrading Media Enterprise Reporting System (MERS) to new data model and migration from SQL Server 2000 SQL Server 2005.
• Developed and implemented partition swapping (2005 Enterprise Edition) for high speed data import.
• Instrumental in implementing MERS upgrade from a SQL Server Scheduled Task/Linked Server system to a custom Windows Service ETL system.

Environment: - MS SQL Server 7/2000/2005, Windows 2000/2003 Advanced Server, T-SQL, C#, VLDB, Agile/Scrum

Confidential

Senior DBA / Architect

Responsibilities:

• Responsible for maintenance, monitoring and infrastructure of 26 SQL Server installations in one of the top 100 web sites in the world for user volume. 1.7 terabytes of non-redundant data.
• Increased database throughput by optimizing hardware.
• Designed and implemented Enterprise Storage installation.
• Designed and implemented fully redundant site configuration including replication and fail-over.
• Wrote SQL Server Installation Standards (for both single and clustered servers). Wrote replication wrap-around procedures to implement and maintain bi-directional replication.

Environment: - MS SQL Server 2000/2005, T-SQL, VLDB, High Availability

Confidential

Senior DBA

Responsibilities:

• Responsible for maintenance and monitoring of over 50 SQL Server installations in 3 locations: Confidential , Corporate IS and offsite DR.
• Implemented fault-tolerant DBMS monitoring and control system.
• Inventoried SQL Server installations. Stabilized many 6.5 instances that were failing regularly.
• Wrote SQL Server Installation Standards and SQL Server Security Standards documents for internal use; all versions of SQL Server were addressed, as well as internal and 3rd party software installation.

Environment: - MS SQL Server 6.5, 7.0 and 2000, NT 4.0 Server and Windows 2000 Server, Visual C++, T-SQL

Confidential

Consultant

Responsibilities:

• Analyzed Clarify/SQL Server installation to determine causes of problems being experienced. Repaired SQL Server installation. Developed Disaster Recovery Plan for integrated application environment, Application Server and SQL Server. Implemented scheduled maintenance with daily full backup and half-hour incremental backup of SQL Server. Re-wrote DTS packages for a more robust data transfer between SQL Server and AS400 Legacy system.
• Monitored systems from off-site to detect failures.

Environment: - MS SQL Server, Clarify, Tuxedo, AS400, Visual C++, T-SQL

Confidential

SQL Server DBA

Responsibilities:

• Created and tested Disaster Recovery Plan and Guide. Wrote procedures to eliminate SQL Server failures. Mentored more junior SQL programmers in SQL methods.
• Restructured 5 production SQL Server instances. Analyzed system security, server physical environment, SQL Server configuration, and made recommendations.

Environment: - MS SQL Server, MS Project, Erwin, Replication

Confidential

Technical Team Lead

Responsibilities:

• Lead team of 8 technical personnel, interfaced with 5 other Track Leads and up to 20 end users to gather Business requirements for Data Conversion from Legacy Systems, Mentored more junior technical staff in project lifecycle management, and advanced SQL methods.

Environment: - Oracle, MS SQL Server, MS Project, Excel

Confidential

Senior Systems Architect

Responsibilities:

• Designed database and process flow for a new manufacturing eBusiness Product Lifecycle Management (ePLM) system.
• Designed three databases: Product Documentation Management, Workflow and Logistics. Product Documentation Management controlled versioning of all documents related to a product including bill-of-materials (BOM). Workflow included security, expediting and automatic rerouting based upon employee schedules. Logistics included Postal information, Email and physical addresses.
• Modeled data and processes to create database and stored procedures tailored to business processes. Lead a team of three DBA’s to develop portable data structures and stored procedures on Oracle, MS-SQL Server and DB2. Lead a team of two analysts to produce documentation and specifications of product modules. Wrote code generators to create standard stored procedures for all tables.
• Designed and implemented installation routines to maximize compatibility between AS400 Client Access and SQL Server Client Connectivity modules. Created scheduled DTS synchronization between AS400/DB2 and SQL Server.

Environment: MS SQL Server, Oracle, DB2, AS400, Visio, Visual Basic, COM, DTS, N-Tier

Confidential

Database Developer / DBA

Responsibilities:

• Designed and implemented ancillary inventory and bill-of-materials reporting module for manufacturing.
• Set up new server optimized for SQL Server 7. Upgraded and tested server with battery of procedures and data from baseline in development database.
• Trained new DBA (employee) in SQL Server installation, maintenance, security, recovery and SQL language programming.

Environment: MS-SQL Server 6.5/7, MS-SQL Executive/Agent, Replication, Windows NT, Visual Basic, Stored Procedures, ISQL-W, ISQL Command Line, MK (Computer Associates)

Confidential

MS SQL Server DBA

Responsibilities:

• Defined Disaster Recovery procedures, wrote utilities to assist in disaster recovery, and defined and documented disaster recovery drill. Wrote Disaster Recovery Guide (23 instances of SQL Server) for DBA to be able to perform structured disaster recovery drills.
• Wrote System Maintenance Program similar to Enterprise Manager, but more efficient and less invasive. Program is designed to interface with PVCS so that application programmers can perform maintenance programming with the ability to 'roll back' stored procedures to a previous version.
• Defined new infrastructure for SQL Server that included a Backup Server with automated tape library. Designed and tested server optimized for SQL Server that gained 533% performance boost over existing configuration without additional hardware. Wrote analysis of optimizing infrastructure utilizing current hardware with minimal expenditure (Compaq ProLiant SMP, NT, and SQL Server).
• Designed scheduling system to automate maintenance tasks utilizing SQL Executive.
• Assisted in everyday DBA activities, backups, restores, and DBCC. Wrote stored procedures for monitoring space utilization.

Environment: MS-SQL Server, MS-SQL Executive, Replication, Visual C++, Visual Basic, PowerBuilder, Stored Procedures, Enterprise Manager, BCP, ISQL, Windows NT, Compaq ProLiant SMP Servers, RAID5 Disk Arrays

Confidential

Project Manager

Responsibilities:

• Responsible for building the test environment and determining Y2K compliance for existing financial applications. Wrote stored procedures and UNIX Shell scripts for test data creation, batch processing, single issue processing, and compliance verification.
• Wrote test plans and batch run documentation for Year 2000 Compliance. System included 11 databases, 848 tables and 1170 stored procedures.
• Wrote test data generation scripts, copying production data and altering dates to move data back to 1995/1996 and forward to 1999/2000, providing an equal number of days for comparing months.
• Special requirements involved date rollover for 1/1/2000, leap year, and first and second quarter interest calculation.
• Wrote detailed migration plan for converting Sybase 4.92 databases to Sybase 11.

Environment: RS6000 AIX, Sybase, Windows, C, SQL, Stored Procedures, UNIX Shell Scripts

Confidential

Responsibilities:

• Part of a team responsible for the redesign, coding, and implementation of the Payment Process and Payment System for Qualified Generating Facilities. Designed tables, dependencies, and indices within defined normalization and referential integrity rules. Wrote user acceptance documents, technical specifications, and pseudocode. Produced process flows and data flow diagrams. Wrote SQL code and stored procedures, UNIX Shell scripts, and C programs with embedded SQL (PRO*C). Participated in formalized code reviews and unit testing.

Environment: HP UNIX, Windows, Oracle, Sybase, DB2, SQL, Stored Procedures, C, UNIX Shell Scripts, OMNICONNECT.

Confidential

Senior Programmer Analyst

Responsibilities:

• Part of design team that developed the global model for Corporate Data. Corporate Data is gathered from each state and is issued by the Secretary of State for that state. The Global Model provides the capability of having a single detail report for all states.

Environment: SQL, Oracle, PL/SQL, UNIX, C, Korn Shell, C Shell

Confidential

Senior Programmer Analyst

Responsibilities:

• Responsible for designing an active data dictionary with embedded Artificial Intelligence as the basis of a CASE Tool for re-architecting legacy data systems using Oracle, C and UNIX.

Environment: Oracle, Visual C++, UNIX

Confidential

Senior Programmer Analyst

Responsibilities:

• Team member responsible for design, analysis, programming, testing, and implementation on the automated Meter Reading System written in C, PL/SQL, PRO*C, and UNIX. The system was a cross-platform product running on a PC and a UNIX mainframe.

Environment: UNIX, MS-DOS, Oracle, C, SQL

Confidential

Project Manager, Research and Development

Responsibilities:

• Coordinated efforts of the off-site development teams (2 teams in the USA and 1 team in New Zealand) for the company's financial applications and other modules-Shared Libraries.
• Designed new graphic, interactive, Object-Oriented database installation program.
• /Instructional-Developed customization for programmer’s class (advanced), based on the standard SQL to PLATINUM customization class.

Environment: NT, OS/2, Sybase, C/C++, SQL