SUMMARY:

• 15+ years of recent and relevant SQL Database Administration.
• Migrations of SQL Server 2005/2008/2012/2014
• SSIS and SSRS conversions, developments and deployments.
• On - premises to Azure Cloud migrations
• Microsoft Azure installation and administration
• Backup and Restoration via Native SQL and Netbackup
• Active Public Trust Security Clearance

PROFESSIONAL EXPERIENCE:

SQL Server DBA

Confidential, Arlington, Virginia

Responsibilities:

• Migrations of legacy Sql2005 databases to SQL2016 and to Azure Cloud
• Restores/Refreshes of data between Production, Staging, and Test environments
• Installing & Configuring Azure VM’s using Dashboard and Powershell. On-premise to Cloud migrations of SQL Databases via bacpac and bcp
• Excel to SQL modifications
• Clustering and AlwaysOn configurations and support
• Creation of technical documents for end users. Development of Best Practices for clients and vendors.

SQL Server DBA

Confidential, St Louis, Missouri

Responsibilities:

• Backup/Restore of Sql2012 databases. Migrations from SQL
• Support of Development during acquisition/merger to TD Ameritrade brokerage system (Broadridge)
• Azure backups, restores, configuring Azure VM
• Always On configurations, restorations, and backups
• ServiceNow Ticketing system, Idera and SolarWinds for monitoring
• Excel Vlookups into SQL database via SSIS ETL
• Managed and created ServiceNow How-To documents. Created Sharepoint documents to assist customers and vendors.

SQL Server DBA

Confidential, Chicago, Illinois

Responsibilities:

• SQL Server 2008R2 to SQL Server 2012 Migrations
• Always On configurations, restorations, and backups
• Modifying SSAS deployments to run with greater efficiency.
• Backup and restores of multi-terabyte databases from production into staging and development environments
• Creating and maintaining Reporting Services dashboards.
• Hadoop installations and MapReduce configurations.
• Performance monitoring of virtual and physical servers using Idera SQL Diagnostic Manager
• Query plan monitoring to see the causes of blocks and deadlocks

SQL Server DBA

Confidential, Chicago, Illinois

Responsibilities:

• SQL Server - 24x7 Production Support Operations
• Working with developers to design and implement scripting for Microsoft ETL implementations.
• Altering and monitoring Tivoli, Onbase, Confidential, E-flow and TMS
• Troubleshooting SQL Server database issues to meet government deadlines to get immigration papers processed effectively.
• Executing Profiler traces to discover applications problems, performance tuning, and identifying slow running queries
• SQL Server performance monitor using SolarWinds - primarily to discover and resolve locking and blocking

SQL Server DBA

Confidential, Naperville, Illinois

Responsibilities:

• Deploying Analysis Services and SSIS development projects.
• Optimizing and redesigning Analysis Services aggregations using sampling frequencies and queries.
• Data scrubbing and transformations using SSIS to prepare data for migration from staging into data warehouse.
• Designing Finance Measure groups and dimensions in Analysis Services.

SQL Server DBA

Confidential, Chicago, Illinois

Responsibilities:

• Interfaced extensively with business analysts and developers to install software, approve and execute scripts, and deploy SSIS packages into staging and production.
• Profiler traces to discover performance issues.

SQL Server DBA

Confidential, Madison, Wisconsin

Responsibilities:

• Migrations from SQL2005 to SQL2008. Installation and Configurations of SSIS, and Reporting Services (SSRS).
• Resolving Active Directory, Kerberos, and IIS 6.0 issues related to recent Reporting Services deployments.
• Lead for SSIS ETL project to convert databases from DB2 and VSAM into SQL Server 2008.

SQL Server DBA

Confidential, Hoffman Estates, Illinois

Responsibilities:

• Production SQL DBA projects. Backups, restores, disaster recovery projects. Migrating SQL2005 to SQL2008
• Working with developers to implement Microsoft ETL implementations.
• Converting DTS packages to SSIS. Developing, configuring and deploying SSAS.

SQL Server DBA

Confidential, Chicago, Illinois

Responsibilities:

• Migrating SQL2000 server to SQL2005. Installing LightSpeed for backups and restores. Creating instances.
• Converting legacy DTS packages to SSIS. Deploying SSIS to servers.
• Creating package configuration for SSIS solutions. Resolving issues related to SSIS solution deployment.

SQL Server DBA

Confidential, Miami, Florida

Responsibilities:

• Converted and migrated SQL 2000 DTS to SQL2005 SSIS.
• Implemented checkpoints, created precedence constraints, some debugging and handling of errors.
• Added SSIS package security, created SQL Server Agent Jobs to execute SSIS packages, performed end-of-project development of SSIS packages.

Confidential, Carson City, Nevada

SQL Server Administrator

Responsibilities:

• Moved log files to separate disk subsystem from other databases and server activity to reduce disk contention and outstanding I/O bottlenecks. Moved Tempdb to separate disk allowing the faster creation of indexing on some of the larger tables.
• Removed unused indexes and identified overly large indexes robbing Insert and Update performance. Created covering indexes to reduce Bookmark Lookups. Created two hash indices and packaged them inside of a stored procedure which eliminated some very wide indexes on large tables which were degrading performance.
• Performed RAID calculations to identify system disk bottlenecks and recommended adding physical disks to provide for future growth. Used Performance Monitor to identify instances of excessive paging and drafted Change Management to add an additional drive to the array and to use a different version of RAID

SQL Server DBA

Confidential, Deerfield, FL

Responsibilities:

• Troubleshooting stored procedures, reverse engineering for cleaning up and fixing code that was previously written in SQL versions 2000 to comply with SQL Server 2005.
• A great part of the production support was maintaining the existing replication servers.
• Creating and editing DTS packages and conversions from DTS to SQL Server 2005 SSIS packages.
• Moving files from Oracle database to SQL database, through DTS.