SUMMARY:

Microsoft SQL Server Database Administrator since 1995. Microsoft certified through SQL Server 2008

SKILL HIGHLIGHTS:

MS SQL Server 4-2014, SSRS, SSIS, MOM 2000-2005, VB.Net, C , Sybase ASE not current , Erwin, ER/Studio, Access, Team Foundation Server.

EXPERIENCE:

Confidential

Senior DBA

Mainly writing SSIS packages to partition and archive data to partitioned tables. Created custom replication scheme to replicate data from SQL Server to Confidential. Using CDC on SQL Server and custom functions and stored procedures to read Confidential change tables and indicate operation as insert/update/delete. Sending that data to Confidential using SSIS conditional split to Confidential command objects to create necessary insert/update/delete statements to run on Netezza. Created integration services catalog on SQL Server 2014 to allow use of sensitive package parameters and multiple environments. Scripted lengthy implementation for eleven servers using PowerShell. Reviewed long C script tasks in SSIS to create performance enhancement recommendations for poorly running SSIS package improving performance by 50 through the use of partitioned indexes, materialized views, reordering of clauses and filtered indexes. General tuning of ad hoc and stored queries

Confidential

DBA Developer/Analyst

Primarily ETL and BI support for upscale retailer Confidential managing freight invoice and purchase order management systems. Although originally dedicated as a development DBA day to day operations require frequent support of production issues such as query tuning, performance troubleshooting, space management, client setup and upgrades and similar tasks. Frequently troubleshooting SQL Server connectivity and performance issues for remote users. Upgraded aging servers from SQL Server 2000 to SQL 2008R2. Migrated SQL 2000 DTS packages to 2014 SSIS. Supporting PERL/AWK BI processes utilizing hundreds of legacy stored procedures in complex ETL flows. Currently working on major SQL 2014 migration of hybrid third party FoxPro application used for managing millions of freight invoices and retail orders.

Confidential

Senior Database Administrator/BI Developer/Analyst

Moved to Confidential to provide production support for Confidential. Supporting Confidential operations of approximately 30 Terabytes of databases. Supporting MS BI stack: SSIS, SSRS and SSAS on SQL 2000 2012 mostly on 2008. Authored development standards for large upcoming Confidential rewrite. Developed SharePoint SQL Server reports for long term collection of various performance monitor counters. Review/Recommend database architecture and modeling using ER/Studio Data Architect. Produced terabyte level capacity planning for multi-terabyte per month SQL Server growth. Wrote 2012 SSIS ETL packages to manage bank credit data movement and archival. Migrating SQL Server 2000 DTS packages to SQL Server 2008 and 2012. Provided SQL Server DBA support for performance and tuning, production troubleshooting of blocking and deadlocking, et al. Provided management input on PCI and PII planning and compliance.

Confidential

Database Administrator/BI Developer/Analyst

Database administrator for rapidly growing Confidential. Initially slated for only operational support but added as BI developer resource for expanding Business Intelligence needs combining data from many disparate sources into local data marts supporting larger data warehouse. Authored project Deliverables Expectations Documents, Design Documents and Operational Support documentation for new and existing SSIS data flows utilizing SQL Server and ftp data sources. BI liaison on SSIS projects requiring coordination from various outside resources including Confidential for movement and correlation of statewide HIPAA data. Reviewed and recommended 3rd party tools for PHI and PII compliance.

Confidential

Database Administrator/Documentation Analyst

Temporary backfill DBA for database architect. Authored SQL Server administration department standards. Authored similar standards for SQL Server development. Provided best practices T-SQL coding examples document. Authored new and participated in continuing development of large group of documentation to be used in upcoming migration. Created design for dynamic migration of hundreds of tables and implemented TFS skeleton database project to run the migration.

Confidential

Database Administrator/BI Developer/Analyst

DBA for dynamic company providing compliance assistance to Confidential schools in the area of mandated reporting. Established backup plans, maintenance plans, off server backups. Installed SQL Server 2008R2 and SSRS. Authored best practices for Confidential coding. Mentored developers in TSQL. Maintained SSIS C scripts to enforce strongly typed data as SSIS packages were intermittently failing to import customer data due to type variances. Maintained CLR stored procedures DLL's written in C . Added C script tasks to SSIS packages to create date stamped error and progress logs for lengthy BI data flows. Created SSRS reports and alerts for database growth as data warehouse size quickly grew to from around 100GB to over 500GB in a few months due to acquisition of new customers. Most existing work was implemented as custom Team Foundation Server TFS projects using scrum. Added TFS standard database projects for new development. Created SSAS cubes for monitoring nightly ETL's. Managed snapshot transaction replication of select databases to reporting servers.

Confidential

Database Administrator

Lead DBA for national mortgage servicing company following Confidential acquisition by Confidential. Confidential Servicing utilizes 40 clustered and stand-alone SQL Servers providing 356x24x7 availability for internal and internet applications. Supported growing enterprise and implemented measures for better standardization and availability. Participated in disaster recovery tests utilizing datacenters across several states. Performed limited mentoring of developers on SSRS, SSIS and T-SQL tuning. Authored growth and database full target date reporting in support of justifications required for space allocation. Collaborated with outside companies during challenging loan servicing period to incorporate data from out of state Confidential Corporation into Confidential. Helped Confidential integrate into Confidential the Sun support model and worked to better integrate Confidential's DBA procedures with Barclays.

Confidential

Database Administrator / Business Intelligence Lead

DBA/Architect on 30 SQL Servers ver. 7, 2000 and 2005 on NT 4 Windows 2000 2003 . Included 5 Windows Server Clusters delivering high availability Confidential to various county applications. Authored departmental database development administration standards. Managed schema changes and database design using Embarcadero's ERStudio and Change Manager. Maintained transactional and snapshot Replication of Confidential on aging servers requiring special attention. Installed and administered several SQL Server Reporting Services sites servicing various county reporting needs. Business Intelligence Lead responsible for leading a team to convert roughly 400 Crystal Reports to SQL Server Reporting Services with process remodeling for about half of these reports. Tuned and administered Microsoft Office Manager MOM including customizations of rules, scripts and events for 87 monitored servers across the enterprise. Served on design and review panels for various projects. Point of contact for ad hoc reporting and research to maintain compliance for federal and state reporting and auditing. Maintained legacy system of 179 interrelated Data Transformation Services packages serving to provide AS400/DB2 to Windows SQL Server database replication. Migrated selected packages to ETL in migration project. Served on team implementing StarQuest Data Replicator to provide more advanced and automated DB2 to SQL Server data replication. Responsible for reviewing and commenting on developer Transact SQL coding. Supporting BI reporting, ETL and data warehousing.

Confidential

Database Administrator

DBA on clustered servers managing high availability Confidential for parent corporation of several radio stations. Created 100's of stored procedures as part of a server update project to isolate table access for internet and remote user access. Wrote and maintained complex Data Transformation Services packages to regularly import Confidential and FTP vendor data. Wrote views and triggers as necessary in support of financial analysis and data lineage tracking of financial data. Created Share Point documentation of DBA procedures and standards. Established off server backups to shore up recoverability. Installed and managed Development, Stage and Production SQL Server Reporting Services and converted Crystal Reports to Reporting Services reports to migrate away from Crystal because of the dramatic increase in Crystals' pricing. Wrote complex financial dispersal tracking application to track user donations for donation-driven business needs. Wrote custom database maintenance scripts because the use of derived columns prevented standard database maintenance jobs.

Confidential

DBA / Senior Developer/Analyst

DBA/Developer for local power company. Created Confidential data models showing multiple views of SQL Server 2000 databases serving SalesLogix 6.01. Created Data Transformation Services packages to regularly import Sybase data into MSSQL. Wrote views and stored procedures as necessary to support Crystal Reports and SalesLogix. Analyzed and prepared documentation for large migration project to Microsoft SQL Server 2000 from Confidential. Wrote data dictionary and created data models to show various aspects of previously undocumented family of VB programs. All previous developers and documentation had been lost so I reverse engineered programs to discover business rules while working with key program users who had subject matter expertise to create documentation for current support and process descriptions for upcoming SAP conversion.

Initially brought on as DBA to troubleshoot and restore down production Sybase servers and re-synchronize servers with automated jobs. Restored production and then analyzed current processes including a rewrite of a customer import process to use ksh/bcp instead of singleton inserts, which reduced the run time from 12 hours to 1 hour. Recommended replacement of aging Sparc10 hardware. Management approved and I implemented Sybase on new SunBlade 100 hardware to establish higher levels of availability, performance and recoverability.

Confidential

Lead DBA / Lead Developer

Lead DBA for Confidential. Mentored 3 DBAs in Microsoft SQL Server and Sybase ASE topics including installation, administration, performance and tuning, stored procedures, triggers and thresholds using a combination of one-on-one instruction and classroom projects. DBA and Lead developer in VB/SQL Server project to track in-house resource usage. Implemented and administered source code control using VSS. Wrote MSSQL DTS packages to extract nightly Sybase data into MSSQL for ASP web reports that I wrote on IIS. Installed managed Apache and IIS web servers for reporting and created reports using ASP Visual Studio on NT SybPerl on Unix. Wrote and implemented DBA standards and procedures manual. Rewrote csh programs in ksh to streamline and use a function library and reduced nightly batch runtime from 7 hours to 3 hours. Upgraded production systems to Sybase ASE 12. Recommended and participated in Sun upgrade project from Sun Sparc Classics to Sun Ultra 10s. Designed and implemented transactional replication to both maintain a backup MSSQL server with production data and to provide a better flow of production data to provide test data for developer use.

Confidential

DBA / Lead VB Developer

Sybase DBA for ASE 11.9.2. Recommended and implemented use of DBArtisan and ER/Win for DBA related tasks. Implemented RI through Declarative Referential Integrity constraints where none existed. Wrote and implemented DBA standards and procedures manual. Upgraded Open Client, ODBC and Sybase SQL servers. Lead VB/Web Developer for three programmers. Wrote and implemented coding standards and DBA procedures, reviewed projects, documentation standards, peer code review process. Moved from VB4-16bit/DAO to VB6-32bit/ADO. Used VSS 6 for source control. Trained lead and backup DBA in Sybase installation, administration, basic performance and tuning, coding of stored procedures, triggers and thresholds.

Confidential

VB / Microsoft SQL Server Developer

Developed and implemented Visual Basic 5 applications using RDO to connect to MS SQL Server 6.5 to manage sales and bonuses for Vision Service Plan contracts. Wrote over 80 stored procedures, views, triggers, and rules to implement Server based structures as the data and rules processor and implemented front end validation using VB. Used PVCS as version control manager to track and release multiple phases of the project. Data input validation was performed by VB but all data manipulation occurred using stored procedures using an n-tier architecture with the tiers strictly defined. Wrote several OCX controls to control common data structures for use in multiple VB forms.

Confidential

Access / Unix C Developer

Developer on C, Oracle Pro C application to take Energy Management Data from Data Control mainframe and insert into Oracle 7.3 on an AIX server. This application was part of a multiple host n-tier solution to allow Access 97 front ends to monitor and predict the distribution and scheduling of power throughout the SMUD operating area.

Confidential

VB Developer

Developed Visual Basic User Interface for Confidential conversion using WinOS2 on NetWare 4.x. Interfacing VB front end with CICS on IBM 3090 / DB2 backend warehouse for a DEC to IBM conversion.

Confidential

DBA

DBA for Microsoft and Sybase SQL Servers. Performed capacity and transaction monitoring and planning. Administered multiple Microsoft 4.2, 6.5 SQL Servers on NT and Sybase System X on HPUX. Designed and wrote Visual Basic front end and Microsoft SQL Server back end to implement new extended warranty service. Traveled with development team over 6 month period to implement the Packard Bell Customer Interaction Tracking Interface PBCITI on SCOPUS for 500 operators on a 365x24x7 help desk. DBA on Manufacturing Control System team to implement greater levels of product tracking through the b

Confidential

MIS Consultant

Worked with development team on the Confidential Management System Confidential . This client server system was implemented with Microsoft Access front ends and Microsoft SQL Server 4.x as the back end. The system utilized a highly normalized relational design of over 200 screens and 150 tables.

Confidential

Analyst/Programmer

Provided statewide support for client server applications, systems analysis and LAN/WAN support. Wrote Visual Basic and Confidential sales and management systems to manage statewide contracts and bidding. Served on committees defining and standardizing the Transportation Department's data processing procedures. Designed Contract Administration Management System CAMS and Contract Administration Program System II CAPSII , which decreased operator time by 5 hours per week.

Confidential

Communications Security Repair

Served 1 year active duty and 2 years guard service in Confidential as Communications Equipment Security Repair Technician. Confidential a lot of deuce and a halves.

Confidential

Operations/Network Support Technician

Provided user support functions for EDS telecommunications network. First level end user contact. Operator for IBM 3090 and Amdahl 5890 subsystems including JES II, TSO, MVS/XA, CICS, IMS, OMEGAMON and custom systems developed by EDS. Worked in highly visible position on data center team to ensure 24-hour service to customers such as GM, Hartford, and DEERS. MVS/XA, JCL, JESII, TSO, IMS, OMEGAMON, IEB Utilities

Confidential

Systems Consultant

Navy Management Systems Support Office. Used Harris, Honeywell, and Wang systems to supervise the implementation of Confidential sites. Automated daily data transactions using Wang PCL and COBOL that reduced daily operator intervention from two hours to ten minutes. Created dBASE III that saved four hours daily in operator intervention. COBOL, PCL, dBASE III , ProComm

Confidential

Quality Assurance Team

Performed quality control testing and analyzed results of POS LASER bar code readers, CRT workstation and reproduction systems for banking applications.