Server Dba Auto Parts
Resume:
Russell Tye, MCP
Lyndhurst, Ohio 44124
*********@*****.***
KNOWLEDGEABLE, RESULTS-ORIENTED, ENTHUSIASTIC…SERVICES DELIVERED WITH PROFESSIONAL RESULTS
CAREER PROFILE
Senior-level SQL Server DBA Offering the following database management skills:
Database Admin & Database Architecture, Strong T-SQL (SQL Server 2000 - 2017)
Worked with Oracle 11g, PostgreSQL
Mentored/Trained/Coached less experienced DBAs and Developers
Data Modelling
Database server remediation
Good understanding of networking principles (Active directory)
Windows Desktop & Windows Server 2008 R2, 2012 R2, 2016
Data/Database migrations including data conversion using T-SQL scripts & SSIS (Azure, AWS)
Production support 24/7/365
Establishment of SOPs
Disaster recovery principles
SKILLS SUMMARY
Active/Passive Clusters & Always on availability groups
Performance tuning & optimization
Database Mirroring, log shipping, replication
Database migrations/Conversions & SSIS, SSAS, SSRS Administration
SQL Server security, Backup/restore & disaster recovery
SQL Server patching/upgrades
Worked with several VLDBs large-scale (10TB – 20TB)
Data Warehouse Architecture/Development
IIS, SharePoint
Leadership
Azure provisioning – SQL Database, Managed Instances
AWS & Microsoft Azure migrations
Azure Data Factory
TOOLS SUMMARY
Redgate toolset, Idera Diagnostic Manager, Microsoft's TFS source control
Service Center Operations Manager (SCOM)
CAREER EXPERIENCE
Parker Hannifin
7/2022 - current
Engaged to perform an application migration to Azure. This is a multi-million dollar project involving several components and a 30GB database.
Building SQL scripts and SSIS packages to facilitate migration to Azure SQL database.
Data cleansing
American Society of Composers, Authors & Publishers (ASCAP)
1/2021 – 12/2021
SQL Server DBA
Engaged to provide production support and work on a variety of projects. Charged with the following activities:
Migrate several database applications to AWS cloud
Production support
Performance tuning & optimization and Index analysis
Backup/restore databases
Administer security
Advise developers
Involved in quarterly planning
Involved in bi-weekly software releases
Support help desk tickets
Performed data modelling, database design including stored procs, views, tables, functions and SSIS packages
Remediated and sunset old database servers
KSI Auto Parts
SQL Server DBA (consultant)
10/24/2019 – April 2020
Engaged to do performance tuning & Optimization of the SQL Server instance:
Modify system configuration including memory allocation, MAXDOP, cost of threshold of parallelism, disk I/O, processor, etc.
Perform deadlock analysis
Perform index analysis
Query tuning
Analysis of all jobs
Execution plan analysis
Provisioned, designed and migrated databases to the Azure cloud platform
Paychex
4/2/2019 – 6/30/2019
SQL Server DBA (Consultant)
Engaged to install and configure SQL Server instances (standalone & cluster)
Administered security
Perform backups/restores
Wrote SQL scripts to provide custom SSRS reports
Built SSIS projects
Performed code reviews and approval
Interact with developers in an advisory capacity
Performance tuning & optimization
Capacity planning
Built a complete dev environment consisting of a three-node cluster.
Developed a PowerShell script to poll over 30 SQL Server instances to verify that each SQL Agent job executed and its status
Federated Investors
5/21/2018 – 2/14/2019
SQL Server DBA (consultant)
Engaged to perform production support and various projects
Administer security
Database backups and restores
Automate routine procedures such as maintenance tasks
Participate in on-call rotation
Recommend software upgrades
Provide support for help desk tickets including writing stored procedures, ad-hoc scripts and SSIS packages
Performed database migration of over 300 database applications (some were on-prem while others migrated to Microsoft Azure
SQL Server patching
Performance tuning & optimization (PTO)
SQL Server instance migrations & version upgrades some of which were to Microsoft cloud using Azure data factory v1 (SQL Server to SQL Server; Oracle to SQL Server; Sybase to SQL Server)
Developed a PowerShell script to determine whether or not Reporting Services was causing a certain error
Remediated many of the outdated database servers
Worked with Oracle DBA group to manage Oracle database along with Golden Gate replication
University of Akron
4/5/2018 – 4/30/2018
SQL Server DBA
Engaged to perform Extract, Transform, Load data into SQL Server 2014 database.
Designed, Built and modified SSIS packages to load approximately 150 tables
Wrote, Reviewed and modified stored procedures and ad-hoc SQL scripts
Performed data cleansing
CoSo Cloud
11/2017 – 1/2018
DevOps DBA (consultant)
Engaged as a DevOps Database Administrator in a Windows/Linux/Cloud environment.
Performed backup and recovery operations, database maintenance, and app support
Developed new databases and database objects
Modified various data structures to improve performance
Worked with both azure and AWS cloud platforms
Worked with SQL Server 2008R2, 2012, and 2016
Administered integration services, analysis services, reporting services (SSIS, SSAS & SSRS)
Wrote custom scripts for specified clients
FormFire LLC, Cleveland, Ohio
October 2017 – November 2017
SQL Server DBA (consultant)
Engaged as DBA consultant to resolve database performance issues.
Diagnosed performance using DMVs, performance monitor, task manager and other native SQL Server tools.
Performed index analysis, modifications and maintenance. Worked with developers to resolved .net issues.
First Solar, Perrysburg, Ohio
January 2017 – June 2017
SQL Server DBA (consultant)
Engaged as a Sr SQL Server database consultant to perform over 70 SQL Server instance migrations. The team is moving these instances from physical servers to virtual servers. The instances are SQL Server 2012, 2014 and 2016. Also engaged to troubleshoot performance issues some of the instances
Migration entails rebuilding windows/SQL Server clusters
Sizing virtual machines – allocating CPUs, RAM, and storage capacity in Azure SQL database
Implemented database mirroring, AlwaysOn availability groups, replication
Created & Deployed SSIS (ETL) packages
Migrated SSIS, SSAS & SSRS to Azure cloud
Mentored Jr DBAs
Nations Lending Corporation, Independence, Ohio
March 2016 – May 2016
SQL Server DBA/Data Architect (consultant)
Engaged as a SQL Server database architect/consultant to design and build a data warehouse in the MS could environment (Azure). In order to accomplish the goals and objectives of the project, the following tasks were performed:
Held meetings with stakeholders and modeled data structures with Erwin data modeler
Documented all terms and definitions such as how to handle slowly changing dimensions.
Created a data dictionary & proof of concept
Educated management on the development of data warehouses
Developed the schema, fact and dimension tables of the DWH
Developed all ETL processes and data visualization w/PowerBI
Installed Microsoft Analysis Services and Reporting Services using SQL Server 2014
EQUITY TRUST COMPANY, Westlake, Ohio
April 2015 – Nov 2015
SQL Server DBA, Production Support
I served as a Production Support DBA in a very fast-paced, forward thinking environment that was in the process of
Migrating to the cloud. As a result, my responsibilities include the following:
Performed database modifications, performance tuning, stored procedure tuning, and server optimization
Created indexed views, updated statistics and analyzing storage and data types
Created and deployed SSIS (Integration Services) packages
Administered Microsoft Reporting Services
Wrote standardization policies regarding backup & recovery, system file layout, and security
Administered SQL Server security
Installed & configured transactional replication
Always on availability groups
Also involved in a huge data conversion/migration project to the cloud (enterprise-wide migration)
Developed PowerShell scripts to report on jobs status, database status and disk drive free space
Administered Team Foundation Server (TFS
DEALER TIRE, LLC, Cleveland, Ohio
July 2014 – March 2015
Sr. SQL Server DBA, Operations
Serve as Production Support DBA in a dynamic, fast-paced environment. Primary responsibilities including the following:
Support all SQL Server instances in the development, QA, and production environments.
Performance tuning and optimization
Monitored all SQL Server instances using Idera Diagnostic Manager
Administered SQL Server security
Developed index management strategy
Performed and coordinated promotions to staging and production of both database and web
Monitored all SAP DI (Data Integration) jobs
Perform backups and refreshes to all environments
SQL Server migrations & SSIS package enhancements
Supported M-Files & VB.Net applications
TIMKEN, Canton, Ohio
April 2014 – June 2014
Sr. SQL Server DBA (Consultant)
Engaged to mentor/teach a System Administrator who has taken on the role of SQL Server DBA. Responsibilities
includes the following:
Developed T-SQL &PowerShell scripts, and other methods to automate routine tasks
Developed migration scripts using T-SQL
Developed documentation (including screen shots) of new server builds
Provided demonstrations & presentations
Developed backup & recovery policies & procedures
Established drive layout for data, log and tempdb files
Used DMVs for monitoring & troubleshooting
Taught system administrator how to install & configure SQL Server 2012
Capacity planning
PRECISION DIALOGUE, Westlake, Ohio
January 2014 – April 2014
Sr. SQL Server DBA (Independent Consultant)
Engaged to troubleshoot/performance tune & optimize database systems in SQL 2012:
Analyzed server configuration including storage/disk subsystem, memory, and other system configurations
Reconfigured memory to proper setting according to Microsoft recommendations
Reconfigured Tempdb (resized & added/dropped data files as appropriate) and transaction log files
Analyzed query execution plans & indexes of long-running queries and tuned the same
Conducted tests using DMVs to analyze workloads and corroborated results using perfmon counters
CLEVELAND HEIGHTS/UNIVERSITY HEIGHTS SCHOOL SYSTEM, University Heights, Ohio
July 2013 – September 2013
Sr. SQL Server DBA (Consultant)
Engaged to perform the following tasks as an SQL Server DBA:
Conducted a complete inventory of SQL Server instances
Completed an assessment of database maintenance plans
Documented the current state and future state of database operations
Assessed database performance issues and tune any databases that were not performing optimally
Assessed SQL Server security and proposed any modifications necessary to protect the data
Train staff on basic SQL Server operations
DENTAL ONE PARTNERS, Independence, Ohio
February 2013 – April 2013
Sr. SQL Server DBA (Consultant)
As a consultant, served as a Senior SQL Server DBA. Primary responsibilities included the following:
Reviewed entire database operations and recommended improvements
Monitored all database systems including enterprise reporting via sharepoint
Preformed upgrade of the shared SAN environment involving a 4-node SQL cluster
Performance tuning and optimization of production SQL Servers, including replication tuning
FIRST PLACE BANK, Youngstown, Ohio
June 2012 – December 2012
Sr. SQL Server DBA (Consultant)
Responded to production issues (trouble tickets)
Installed and configured SQL Server 2008R2
Reviewed security model and enhanced where necessary
Performance tuning & Optimization (PTO)
Provided documentation for all database operations
CHARLES SCHWAB, Richfield, Ohio
November 2011 – April 2012
Sr. Production Support DBA (consultant)
As a consultant, served as a Production Support DBA. Primary responsibilities included the following:
Managed access to dev, QA, and production SQL Servers (all databases were > 10TB in size)
Monitored production servers for performance, disk space and other issues
Managed all SQL Agent and other jobs
Performing SQL Server version upgrades and patches
Participated in the design and implementation of a reporting solution
Upgraded SQL Server cluster from SQL Server 2005 to 2008 R2
Learned how to use Team Foundation Server in a in-house workshop
PREEMPTIVE SOLUTIONS, Mayfield Village, Ohio
April 2011 – September 2011
Sr. SQL Server DBA (Consultant)
As a Consultant, my primary responsibilities included 24/7 support of all database (terabyte size). In addition, worked on moving their production databases from the cloud (Amazon) to dedicated in-house hardware
Documented current state database operations and proposed a new architecture Performance tuning and optimization of current production terabyte-size databases
Worked with developers on issues regarding query optimization
Performed point-in-time database restore
Built numerous SSIS packages to perform ETL operations
PNC FINANCIAL SERVICES (Formerly National City Bank), Cleveland, Ohio
October 2006 – March 2011
Sr. SQL Server DBA
Served as Subject Matter Expert on all projects involving SQL Server instances. Responsibilities included:
Capacity planning
SQL Server installation & configuration including applying service packs, cumulative updates & hot fixes
Designed & configured security
Built multi-node SQL Server clusters (SQL 2005 & SQL 2008R2)
Installed, configured and monitored Oracle database
Designed & built table partitions for VLDBs (terabyte size)
Worked with shared SAN and mount points
Worked with LiteSpeed & Legato backup/restore software & configure DB Mail
Wrote SQL scripts: stored procedures, triggers, user-defined functions, views
Linked SQL Server to Oracle and DB2 and wrote stored procedures & views to access Oracle databases
Expert SQL Server performance tuning and optimization
Performed backups/restores and other aspects of database maintenance
Handle multiple projects simultaneously (as much as 15 projects at a time)
Modeled data and built conceptual, logical & physical diagrams
ETL via DTS and SSIS Packages
Mentored less experienced DBAs and Developers
Worked on massive consolidation project involving over 1000 physical servers and countless database instances
CGI CONSULTING, Cleveland, Ohio
April 2006 – September 2006
Sr. SQL Server DBA (Consultant)
Primarily Production Support DBA in two major environments. Responsibilities were as follows:
Designed and Built data marts, table partitions in SQL 2005
Converted databases from SQL 2000 to SQL 2005 & Processed analysis services cubes
Configured security & Built DTS/SSIS packages for ETL
TUCKER ELLIS & WEST LLP, Cleveland, Ohio
September 2004 – April 2006
Application DBA
Responsible for all SQL Server servers (39 SQL Server instances) including maintenance, data migration projects and application support in three environments (development, staging and production).
AXENTIS, LLC, Richmond Heights, Ohio
September 2003 – September 2004
DBA, Operations
The responsibilities of the DBA, Operations include the following tasks:
Installed and configured SQL Server 2000 in the various environments that comprise the organization.
Managed security, backup/recovery & other database maintenance
Developed T-SQL scripts including stored procedures, functions, views & tables.
Resolved service/help desk (trouble) tickets
RT-TECHNOLOGIES, Cleveland Heights, Ohio
July 2002 – September 2003
Consultant
Accelerated Computer Technologies, Inc, Winston Salem, NC
Database conversion project involving SQL Server 6.5 and SQL Server 2000.
Scripted all tables, views, stored procedures, and other database objects
Imported data into SQL Server 2000 using data transformation services (DTS) and other methodologies
Tested all scripts in the SQL Server 2000 environment
EDUCATION
Cleveland State University – Bachelor of Business Administration
Microsoft Certified Professional & certificates (C#, visual basic, HTML, Python)
Contact this candidate