SUMMARY:

• Senior - level SQL Server DBA Offering the following database management skills:
• Database Admin & Database Architecture, Strong T-SQL (SQL Server )
• Worked with Oracle 11g, 12c & DB2, and MySQL
• Administered SAP Business Objects
• Mentored/Trained/Coached less experienced DBAs and Other IT professionals
• Good understanding of networking principles
• Administered VLDBs over 10TB in size
• Windows 8.1, 10 & Windows Server 2008 R2, 2012 R2
• Data/Database migrations including data conversion using T-SQL scripts & SSIS
• Production support 24/7/365
• Establishment of SOPs
• Powershell, Linux shell scripting
• 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 - 12TB)
• Data Warehouse Architecture/Development
• IIS, SharePoint
• Leadership

TECHNICAL SKILLS:

TOOLS: Redgate toolset, Idera Diagnostic Manager, Microsoft's TFS source control Service Center Operations Manager (SCOM)

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA (consultant)

Responsibilities:

• 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
• SQL Server patching
• Performance tuning & optimization (PTO)
• SQL Server instance migrations & version upgrades

Confidential

SQL Server DBA

Responsibilities:

• Designed, Built and modified SSIS packages to load approximately 150 tables
• Reviewed and modified stored procedures
• Performed data cleansin

Confidential

DevOps DBA (consultant)

Responsibilities:

• 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)

Confidential, Cleveland, Ohio

SQL Server DBA (consultant)

Responsibilities:

• 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, modification and maintenance. Worked with developers to resolved .net issues.

Confidential, Perrysburg, Ohio

SQL Server DBA (consultant)

Responsibilities:

• Migration entails rebuilding windows/SQL Server clusters
• Sizing virtual machines - allocating CPUs, RAM, and storage capacity
• Implemented database mirroring, AlwaysOn availability groups, replication
• Created & Deployed SSIS (ETL) packages
• Migrated SSIS, SSAS & SSRS
• Mentored Jr DBAs

Confidential, Independence, Ohio

SQL Server DBA/Data Architect (consultant)

Responsibilities:

• Held meetings with stakeholders and modeled the data structures
• 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

Confidential, Westlake, Ohio

SQL Server DBA, Production Support

Responsibilities:

• 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

Confidential, Cleveland, Ohio

Sr. SQL Server DBA, Operations

Responsibilities:

• 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

Confidential, Canton, Ohio

Sr. SQL Server DBA (Consultant)

Responsibilities:

• 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

Confidential, Westlake, Ohio

Sr. SQL Server DBA (Independent Consultant)

Responsibilities:

• 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

Confidential, University Heights, Ohio

Sr. SQL Server DBA (Consultant)

Responsibilities:

• 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

Confidential, Independence, Ohio

Sr. SQL Server DBA (Consultant)

Responsibilities:

• 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

Confidential, Youngstown, Ohio

Sr. SQL Server DBA (Consultant)

Responsibilities:

• 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

Confidential, Richfield, Ohio

Sr. Production Support DBA (consultant)

Responsibilities:

• 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 R2
• Learned how to use Team Foundation Server in a in-house workshop

Confidential, Mayfield Village, Ohio

Sr. SQL Server DBA (Consultant)

Responsibilities:

• 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

Confidential, Cleveland, Ohio

Sr. SQL Server DBA

Responsibilities:

• 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)
• 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

Confidential, Cleveland, Ohio

Sr. SQL Server DBA (Consultant)

Responsibilities:

• 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

Confidential, Cleveland, Ohio

Application DBA

Responsibilities:

• 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).

Confidential, Richmond Heights, Ohio

DBA, Operations

Responsibilities:

• 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

Confidential, Cleveland Heights, Ohio

Consultant

Responsibilities:

• 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