| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name , MCPStreet Address Haverston Rd.Lyndhurst, Ohio Street Address
EMAIL AVAILABLEPHONE NUMBER AVAILABLEKNOWLEDGEABLE, RESULTS-ORIENTED, ENTHUSIASTIC SERVICES DELIVERED WITH PROFESSIONAL RESULTSCAREER PROFILESenior-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 principlesSKILLS 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, JiraCAREER EXPERIENCEAccenture Federal Services Chantilly, Virginia8/2023 4/30/2024Sr. 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 databaseParker Hannifin Beachwood, Ohio7/2022 4/30/2023Lead 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 synapseAmerican Society of Composers, Authors & Publishers (ASCAP) New York, New York1/2021 12/2021SQL Server DBA/Data ArchitectEngaged 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 serversKSI Auto Parts South Plainfield, New JerseySQL Server DBA (consultant)10/24/2019 April 2020Engaged 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 platformPaychex Beachwood, Ohio4/2/2019 6/30/2019SQL 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 statusFederated Investors - Pittsburgh, PA5/21/2018 2/14/2019Azure 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 replicationUniversity of Akron Akron, Ohio4/5/2018 4/30/2018SQL Server DBA/Data ArchitectEngaged 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 cleansingCoSo Cloud Oakland, CA11/2017 1/2018Cloud 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 clientsFormFire LLC, Cleveland, Ohio
October 2017 November 2017SQL 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 2017SQL 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 implementationNations Lending Corporation, Independence, Ohio
March 2016 May 2016SQL 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 2014EQUITY TRUST COMPANY, Westlake, Ohio
April 2015 Nov 2015SQL Server DBA, Production SupportI served as a Production Support DBA in a very fast-paced, forward thinking environment that was in the process ofMigrating 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, OhioJuly 2014 March 2015Sr. 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 tasksTIMKEN, Canton, OhioApril 2014 June 2014Sr. SQL Server DBA (Consultant)Engaged to mentor/teach a System Administrator who has taken on the role of SQL Server DBA. Responsibilitiesincludes 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 planningPRECISION DIALOGUE, Westlake, OhioJanuary 2014 April 2014Sr. 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 countersCLEVELAND HEIGHTS/UNIVERSITY HEIGHTS SCHOOL SYSTEM, University Heights, OhioJuly 2013 September 2013Sr. 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, OhioFebruary 2013 April 2013Sr. 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 tuningFIRST PLACE BANK, Youngstown, OhioJune 2012 December 2012Sr. 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, OhioNovember 2011 April 2012Sr. 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 workshopPREEMPTIVE SOLUTIONS, Mayfield Village, OhioApril 2011 September 2011Sr. 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 operationsPNC FINANCIAL SERVICES (Formerly National City Bank), Cleveland, OhioOctober 2006 March 2011Sr. SQL Server DBAServed 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 instancesCGI CONSULTING, Cleveland, OhioApril 2006 September 2006Sr. 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 ETLTUCKER ELLIS & WEST LLP, Cleveland, OhioSeptember 2004 April 2006Application 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, OhioSeptember 2003 September 2004DBA, OperationsThe 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) ticketsRT-TECHNOLOGIES, Cleveland Heights, OhioJuly 2002 September 2003ConsultantAccelerated Computer Technologies, Inc, Winston Salem, NCDatabase 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 environmentEDUCATIONCleveland State University Bachelor of Business AdministrationMicrosoft Certified Professional & certificates (C#, visual basic, HTML, Python) |
