Peter Cwik Email & Phone Number

Gilbert, Arizona, United States

ETL Engineer\Data Engineer, writing stored procedures to transform data for the migration of State of Michigan Unemployment Insurance system to Deloitte's uFACTS system. Also performed DBA activities in Microsoft Azure Cloud SQL DBs and Managed Instances.

Chandler, Arizona, United States

Our group is responsible for setting standards for SQL Server andAzure for over 10K databases. Developing the methodologies thatwill be used to interact with those databases and being subjectmatter experts on all things database related, including NoSQLDBs. We also develop code and stored procedures to facilitatereporting via Power Query and Power BI

Chandler, Arizona, United States

Advise on data related issues regarding SQL Server, to include butnot limited to data structures, stored procedures, SQL Server jobs,security. Migrate data and structure from SharePoint to SQLServer for nationwide dealer reporting. Create new andperformance tune stored procedures and T-SQL to meet userrequirements

Chandler, Arizona, United States

Responsible for DDL and DML manipulation between allenvironments for the in-sourcing of the GM Loyalty CampaignOracle database of ~30TB from external vendor Acxiom. Maintaingovernance of objects, and permissions for all environments. Actas liaison between developers and DBAs. Work was greatlyexpedited due to excellent communication skills. Mentoreddevelopers on SQL scripting

Chandler, Az

Building and designing the SQL Server databases that run GMapplications. Duties included installation, security setup andtuning for over 100 projects in the areas of manufacturing, finance,supply chain and end user experience

Chandler, Az

I managed a team of 8 DBAs who administered over 3000 SQLServer installations. My team was responsible for the operationalhealth of all SQL Servers worldwide for General Motors. Support iscompletely in-sourced and operates on 24/7 basis. Ourknowledgebase spans versions from SQL2000 through SQL2014.We lead the market as we begin to explore not yet releasedversions of SQL Server. From a multi-terabyte SharePointinstallation to plant floor operations; when it comes to SQL Server,we keep GM running!

Phoenix, Arizona Area

I was part of a 4 member team supporting worldwide Global PlantOperations in manufacturing for all SQL Server installations. Inaddition, I had been appointed as the data steward for companywide SQL Server inventory information gathering.

-Planned, installed and maintain multi-node SQL Clusters-Currently supervise a team consisting of DBAs and Report Writers-Supervised a team of 4 DBAs both SQL Server and Oracle -Responsible for all Corporate databases both SQL Server and Oracle-Define strategy for server consolidation-Stabilize entire database environment-Document database processes and jobs-Ensure backup procedures complete in a timely manner-Ensure all scheduled jobs complete in a timely manner-Perform database performance tuning-Install and configure SQL Server 2008R2 -Install and configure SQL Reporting Services 2008R2-Develop SQL Server Integration Services packages 2008R2-Develop reports utilizing Reporting Services 2008R2 -Configure and maintain transactional replication to servers in SQL 2005 -Maintain SQL Server in clustered environments -Implement packaged software products -Configure and implement database security standards -Mentor junior DBAs

-Install and upgrade QNXT database installations-Performed database performance tuning-Troubleshoot QNXT application issues-Install and configure SQL Server 2008R2/2008/2005 -Install and configure SQL Reporting Services 2008R2/2008/2005 -Implemented packaged software products -Mentored other consultants on SQL Server

-Responsible for over 200 SQL Server installations-Install and upgrade QNXT database installations-Performed database performance tuning-Install and configure SQL Server 2008/2005 -Install and configure SQL Reporting Services 2008/2005 -Developed SQL Server Integration Services packages 2008/2005 -Developed reports utilizing Reporting Services 2008/2005 -Configured and maintained transactional replication to servers in SQL 2005 -Maintained SQL Server in clustered environments -Developed stored procedures and DTS packages to support development -Implemented packaged software products -Configured and implemented database security standards -Mentored junior DBAs

Responsible for 200+ SQL Server installations and 2000+ databases Install and configure SQL Server 2008/2005/2000Install and configure SQL Reporting Services 2008/2005Created SQL Server 2008/2005 Integration Services packagesCreated reports utilizing Reporting Services 2008/2005 Managed Transactional Replication on 100GB+ databasesCreated stored procedures and DTS packages to support development Created and implemented security standards Implemented packaged software products Configured and implemented database security Mentored junior DBAs

Responsible for SQL Server security procedures related to Department of Defense Authority to Operate Created stored procedures to support the development environment Created Data Transformation Services (DTS) packages Conducted peer code review Installed and configured SQL Server 2000 on a cluster server Implemented packaged software products Configured and implemented database security Mentored junior DBAs

Contractor on location at Triwest Healthcare Alliance Created and maintained entity relationship diagrams and schematics Constructed Data Transformation Service packages Configured and implemented database security Stored procedure creation to support application development Trained in HIPAA regulations Contractor on location at Intel Designed and implemented star schema architectures for OLAP cubes and data warehouseCoded and provided troubleshooting MDX for calculated measures Managed performance and tuning of OLAP cubes and calculated measures Customized data transformation services for extraction, transformation and loading of data to data warehouseCreated and altered stored procedures for extraction, transformation and loading of data to data ware house

College instructor for four courses, including: Administration of a Microsoft SQL Server 2000 Database Design and Implementation of a Microsoft SQL Server 2000 Database Administration of a Microsoft SQL Server 7.0 Database Design and Implementation of a Microsoft SQL Server 7.0 Database Created all lesson plans and tests.

-Contract locations included Intel and Ugly Duckling Car Sales -SQL Server DBA -Performed cradle to grave design and implementations of OLAP databases and cubes -Designed and implemented star schema architectures -Code and troubleshoot MDX for calculated measures -Performance and tuning of OLAP databases and cubes/calculated measures. -Presales assistance -Customized Data Transformation Services for Extraction, Transformation and Loading for Data Warehouse-Mentored users on OLAP installation and maintenance -Assessed and provided troubleshooting for SQL Server, Windows NT, Windows95, Windows98 installations -Upgraded SQL Server installations to version 2000 and version 7.0 -Configured and installed replication in multi-site environments

-Designed and implemented Data Warehouse utilizing data from a DB2 source into SQLServer 7.0. -Constructed Data Transformation Service packages -SQL Server DBA. Responsibilities included daily maintenance and performance and tuning, object design and implementation of 4 MS SQL Server 7.0 servers. -Upgraded database and OS -Ensured replication between SQLServers -Ensured backup and recovery procedures -Configured and implemented database security -Developed and maintained entity relationship diagrams and schematics -Distributed data for internet provider directory system -Stored procedure and trigger creation to support application development -Provided administration of Oracle data warehouse -Maintained and modified existing PowerBuilder applications -Developed state-wide provider directory system utilizing PowerBuilder -Report creation for HEDIS, NCQA

-Team member on a project to transfer reporting capabilities of a major U.S. bank to an Oracle7 database -Team lead in charge of technical documentation of installation of Oracle Financial and Manufacturing applications -Transferred to Advance Technologies Solutions dealing with Internet Solutions and Electronic Commerce -U.S. point of reference for emerging technology of Oracle Digital Library Solution Framework -U.S. point of reference for emerging technology of Oracle InterOffice -Instructed and installed Oracle WorkFlow