Sql Server Production Support
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 - 2019)
●Worked with Oracle 11g, DB2
●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, 2017, 2019
●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 – 40TB)
●Data Warehouse Architecture/Development
●IIS, SharePoint
●Leadership
●Change management
●Azure provisioning – SQL Database, Managed Instances
●AWS & Microsoft Azure migrations
●Azure Data Bricks, Data Lake, Azure Synapse Analytics, Azure Data Factory, data analytics(python)
TOOLS SUMMARY
●Redgate toolset, Idera Diagnostic Manager, Microsoft's TFS source control
●Service Center Operations Manager (SCOM), confluence, Jira
CAREER EXPERIENCE
Accenture Federal Services – Chantilly, Virginia
8/2023 – 7/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 in 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. 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
●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 – 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
●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 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 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:
●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