Sql Server Data

Paul Richardson

**** ******** ** ~ Clearwater, FL 33763

cell 727-***-**** ~ *.*.************@*****.***

Database administrator and architect

Database Administrator with twenty years’ experience developing, supporting and tuning both OLTP and Data Warehouse systems on various RDBMS platforms, operating systems and versions. Technical specialist providing support, benchmark and validation tools using automated SQL and OS scripts. Extensive experience in advanced SQL and tuning, including training materials, books, papers and lectures. Experienced in logical and physical design, working with application teams to understand the business needs, ensure data integrity and leading teams to deliver high performance solutions. Solutions-focused, team oriented with broad-based experience on a diverse range of systems including HIPAA, cellular fraud detection, Wall Street risk systems, bank reporting systems, ratings reporting systems and Airport security systems. Team and technical lead with responsibilities for training junior staff members.

Main accomplishments

•Presented at Sybase Techwave 2006 on the Sybase IQ Optimizer/Tuning.

•Published articles for the Database Programming and Design magazine on Sybase 11/SQL Server Optimizer/Tuning.

•Wrote 2 chapters in Sybase 12.5 Performance and Tuning.

•Wrote server comparison software for Sybase ASE and SQL Server 2000.

•Wrote server release software for Sybase ASE, Sybase IQ and Oracle 9i

Technical Skills

Linux/Unix Windows 9x/NT/2000/XP/Vista Sybase ASE/IQ SQL Server Netezza Oracle DB2 Azure Hadoop AWS Redshift Greenplum MySQL SQL Unix Shell C C++ Javascipt HTML XML MS Office DB Artisan Power Designer ERWIN Relational modeling Dimensional modeling Data vault modeling Master data dictionary

Professional Summary

Citigroup, Tampa, FL 2010/01 - 2016/09

Senior DBA/Architect and Sybase SME

Work within database group to support application RDBMS’s and help DBA’s and Developers with SQL Performance and Tuning, Design techniques and how to use database products efficiently.

Extracted and reviewed critical legacy financial system data models in Power Designer.

Modified physical data models in structure and indexing to significantly improve performance by 3x to achieve SLA’s.

Performed data and systems migrations from Solaris and AIX to Redhat Linux. This involved custom ETL code and endian data migration to meet the production migration SLA’s. Migrations involved OLTP, OLAP and data replication components.

Stabilized several Sybase systems working to resolve application and vendor software bugs.

Designed security access models for Sybase IQ.

Designed Unix/Linux/SQL benchmark tools for Sybase ASE, Sybase IQ, SQL Server and Netezza.

Designed Sybase IQ/ASE benchmark, monitoring and alerting tools.

Designed Sybase IQ/ASE Designed global error handling templates.

Designed 6 level login security and audit for Sybase IQ, modeled in Visio using relational model

Tuned queries and significantly improved performance for multiple applications.

DBA for Sybase IQ and Sybase ASE using command line, shell scripts and Sybase Central.

DBA for SQL Server using SSMS, SSIS, SSRS, perfmon and profiler. Performed index and query tuning. Performed index defragmentation and data modeling using VISIO. Performed database backups and log transfers. Performed SQL Server upgrades and migrations.

DBA for Netezza using command line, shell scripts, NZADMIN, NZSQL, NZLOAD, NZUNLOAD, NZ_MIGRATE, NZ_GROOM, NZBACKUP and NZRESTORE.

Review of Netezza data distribution, space and zone maps. Review of business relational and dimensional models in Power Designer.

Due to the omission of corporate data management I had to build and separate 2 applications with conflicting source data rules that lost 3 months of development work due to the financials being reported incorrectly when data was loaded concurrently during QA testing.

Master data management was maintained manually for my projects where the corporate data was conformed by source. Definitions, domain, volume, volatility and cross reference were maintained in excel and reports were generated for reference by the application and data groups.

Nielsen Media Research, Oldsmar, FL 2005/02-2010/01

Senior DBA/Architect and Sybase SME

Worked within database group to support Sybase,SQL Server,MySQL and Netezza RDBMS’s and help DBA’s and Developers with SQL Performance and Tuning, Design techniques and how to use database products efficiently.

Extracted and reviewed critical legacy National TV ratings data models in Power Designer.

Modified physical data models in structure and indexing to significantly improve performance by 10x to achieve SLA’s. Converted embedded client code to custom tuned stored procedure in Sybase IQ to achieve 3-100x improvement in client reporting.

Performed data and systems migrations from Solaris to Linux and WIndows. This involved custom ETL code and endian data migration to meet the production migration SLA’s. Migrations involved OLTP, OLAP and data replication components.

Worked in a team of 3 data modelers in creating the logical and physical data models for the new conformed National TV ratings suite.The models were built in Power Designer and used type 2 slowly changing dimensions for effective dating and history reporting, this was used for all dimensions in the dimensional data model.

Master data management was maintained manually where corporate data was conformed by source. Definitions, domain, volume, volatility and cross reference were maintained in the data model and reports generated for reference by the ETL teams.

Designed, coordinated and organized the application benchmarks for the 40TB Sybase IQ ADW warehouse. Largest tables had over 100 billion rows.

Extensively redesigned application reporting system using nested procedure achieving up to 100 times response time improvement.

Designed Unix/Linux/SQL benchmark tools for Sybase ASE, Sybase IQ, SQL Server and Netezza.

Provided company training on tuning and coding techniques using Sybase IQ, ASE, SQL Server and Netezza.

Defined company standards for SQL coding and database release procedures.

Migrated legacy client/server applications to new Sybase IQ warehouse. Modeled in Power Designer using dimensional model.

Team leader of 10 staff members.

DBA for Sybase IQ and Sybase ASE using command line, shell scripts and Sybase Central.

DBA for SQL Server using SSMS, SSIS, SSRS, perfmon and profiler. Performed index and query tuning. Performed index defragmentation and data modeling using VISIO. Performed database backups and log transfers. Performed SQL Server upgrades and migrations.

DBA for Netezza using command line, shell scripts, NZADMIN, NZSQL, NZLOAD, NZUNLOAD, NZ_MIGRATE, NZ_GROOM, NZBACKUP and NZRESTORE.

Review of Netezza data distribution, space, zone maps, cbt's and mv's.

ACS, Austin, TX 2003/06-2005/02

Senior DBA/Architect and Sybase SME

Worked within application group to develop new government stamp systems on Oracle 9i And tuned existing coding system running on Sybase.

Created Object Relational model to relational physical model for new government stamp system using ERWIN and Oracle 9i. Generated indexes for efficient data retrieval for Oracle 9i.

Tuned and converted reports from T-SQL to PL/SQL.

Supported and tuned legacy government stamp coding system on Sybase ASE 11.5.

Worked in a team of 5 data architects to run POC of relational, dimensional and data vault data models for the new Oracle system. The POC’s used simulated data generated using the master data management reports.

Master data management was maintained manually where corporate data was conformed by source. Definitions, domain, volume, volatility and cross reference were maintained in the data model and reports generated for reference by the development team.

EDIX, ST. Petersburg, FL 2002/03-2003/06

Senior DBA and Data Architect

Worked within application group to develop new medical systems in compliance with HIPAA using SQL Server 2000

Created Object Relational model to relational physical model for new HIPAA coding system using ERWIN and SQL Server 2000. Created stored procedures and triggers to enforce business rules and constraints. Created indexes for efficient data retrieval and scheduled daily backups. Created client reports using SSRS. DBA for SQL Server using SSMS, SSRS, perfmon and profiler. Performed index and query tuning. Performed index defragmentation,database and log backups.

Master data management was maintained manually where the project data was conformed by source. Definitions, domain, volume, volatility and cross reference were maintained in the data model and reports generated for reference by the application team.

Nielsen Media Research, Oldsmar, FL 1997/06-2002/03

Senior DBA/Data Architect

Worked within database group to support application RDBMS’s and help DBA’s and Developers with SQL Performance and Tuning, Design techniques and how to use Sybase products efficiently.

Extracted and reviewed critical legacy Local TV ratings relational data models in Power Designer.

Modified physical data models in structure and indexing to significantly improve performance by 2x to achieve SLA’s. Converted embedded client code to custom tuned stored procedure in Sybase ASE to achieve 3-10x improvement in client reporting.

Performed data and systems migrations from Solaris to Linux and WIndows. This involved custom ETL code and endian data migration to meet the production migration SLA’s. Migrations involved OLTP, OLAP and data replication components.

Worked in a team of 5 evaluating Oracle, Teradata and Sybase IQ to replace the partitioned Sybase ASE systems that were approaching capacity limits with the combined processing of ODS and Data Mart for the local TV ratings suite.

Worked in a team of 2 data modelers in creating the logical and physical data models for the new conformed Local TV ratings suite. The models were built in Power Designer and used type 2 slowly changing dimensions for effective dating and history reporting, this was used for all dimensions in the dimensional data model.

Master data management was maintained manually where corporate data was conformed by source. Definitions, domain, volume, volatility and cross reference were maintained in the data model and reports generated for reference by the ETL teams.

Converted Object Relational model to relational physical model for new local household viewing system.

Designed and coordinated benchmarks with Sybase Professional services for the new release of Sybase ASE.

Coding local station effective date generation SQL code using 13 correlated sub queries reducing 8 hour processing in C code to 20 minutes on Sybase ASE.

Produced a new algorithm for the Sybase cost based optimizer which eliminated 95% of unnecessary table scans when costing joins. Defined company standards for SQL coding and database release procedures.

DBA for SQL Server using SSMS, perfmon and profiler. Performed index and query tuning. Performed index defragmentation and data modeling using Power Designer. Performed database and log backups. Performed SQL Server upgrades and migrations.

Bankers Trust, New York, NY 1996/02-1997/06

Senior Database Administrator and Sybase architect

Worked on Global Finance risk system

Alliant Techsystems, ST. Petersburg, FL 1995/04-1996/02

Database Administrator and Sybase architect

Worked on DOD blueprint cd’s and catalogs

GTE TSI, Tampa, FL 1992/03-1995/04

Cobol coder, Database architect and team leader

Worked on cellular fraud detection.

NYNEX, Clearwater, FL 1990/12-1992/03

Cobol coder and Database architect

Worked on airport security for Newark, Legardia and JFK airports.

Forward Trust, Birmingham, England 1988/05-1990/12

Cobol and SQL coder

Worked on banking lending systems.

British Gas, Birmingham, England 1985/09-1988/05

Cobol and SQL coder

Worked on gas supply systems.

Education

Bachelor of Science in Computer Science, North Birmingham University, England

Contact this candidate