Sql Server Production Support
Resume:
Russell Tye, MCP
Cleveland, Ohio *****
*********@*****.***
KNOWLEDGEABLE, RESULTS-ORIENTED, ENTHUSIASTIC…SERVICES DELIVERED WITH PROFESSIONAL RESULTS
CAREER PROFILE
Senior-level SQL Server DBA Offering services in data management, analysis, networking skills and cloud-based knowledge.
SKILLS SUMMARY
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 – 40TB)
Data Warehouse Architecture/Development
Visual Studio 22
Leadership
Change management
Azure provisioning – SQL Database, Managed Instances, VMs
Azure Key Vault
TOOLS SUMMARY
Redgate toolset, Idera Diagnostic Manager, Microsoft's TFS source control
Service Center Operations Manager (SCOM), confluence, Jira
CAREER EXPERIENCE
Fleet Response, Hudson, Ohio
1/14/2025 - current
Production Support
Backups/recovery operations
SQL Server maintenance
Database security
Query & hardware optimizations
Accenture Federal Services – Chantilly, Virginia
8/2023 – 11/30/2024
Sr. Data Architect/ Database Administrator
Lead team of six production support DBAs
Perform SQL Server backups/restores
Performance tuning & optimizations
Develop ETL packages via SSIS and Azure Data Factory
Monitor SQL Agent alerts
Production support ticket resolution
Built new database schema for migration to Azure SQL database
Parker Hannifin – Beachwood, Ohio
7/2022 – 4/30/2023
Lead Azure Database Administrator
Engaged to perform an application migration to Azure. This is a multi-million dollar project involving several components and a 30GB database.
Assigned tasks to other DBAs
Building SQL scripts and SSIS packages to facilitate migration to Azure SQL database (SaaS). Also used Azure Data Factory in Azure to execute SSIS packages.
Analyzed data using python data frames
Data cleansing & Data analysis which involved provisioning Azure Synapse, data lake storage, and databricks and Azure synapse
American Society of Composers, Authors & Publishers (ASCAP) – New York, New York
1/2021 – 12/2021
SQL Server DBA/Data Architect
Engaged to provide production support and work on a variety of projects. Charged with the following activities:
Migrate several database applications to AWS cloud data lake storage
Production support
Change management
Performance tuning & optimization and Index analysis
Backup/restore databases
Administer security
Advise developers
Support help desk tickets
Performed data modelling, database design including stored procs, views, tables, functions and SSIS packages
Remediated and sunset old database servers
Environment included AlwaysOn Availability Group configuration and management.
KSI Auto Parts – South Plainfield, New Jersey
SQL Server DBA (consultant)
10/24/2019 – April 2020
Engaged to do performance tuning & Optimization of the SQL Server instance:
Led a team of four DBAs assigning tasks to each DBA on a daily basis
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 – Beachwood, Ohio
4/2/2019 – 6/30/2019
SQL Server DBA/Data Architect (Consultant)
Engaged to install and configure SQL Server instances (standalone & cluster)
Administered security
AlwaysOn availability groups configuration and management
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 - Pittsburgh, PA
5/21/2018 – 2/14/2019
Azure Database Administrator(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 cloud (PaaS) services including Azure data lake storage
SQL Server patching
Change management
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 – Akron, Ohio
4/5/2018 – 4/30/2018
SQL Server DBA/Data Architect
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 – Oakland, CA
11/2017 – 1/2018
Cloud 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 for database administration and data lake storage for backups
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
HA/DR implementation
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 in Azure using SQL pool and data lake storage
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
Exercising disaster recovery tasks
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
Mentored developers on disaster recovery principles.
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
Mentored developers on disaster recovery principles.
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 databases compliant with (Sarbanes-Oxley (SOX)
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 on disaster recovery principles.
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:
Worked on complex databases dealing with Sarbanes-Oxley (SOX)
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