SUMMARY

• Performance - driven IT professional with 24 years of combined experience in SQL Server Database Administration, Database and System Architecture and Production Support.
• Expertise in engineering medium and large-scale OLTP and Data warehouse solutions using wide array of technologies. Adept in database design, development, testing, debugging, and quality assurance strategies to align with database and software development methodology.
• Skilled in development of ETL and real-time data movement systems.
• Self-directed, resourceful team player with refined communication, leadership, and problem-solving abilities.

TECHNICAL SKILLS

Databases: SQL Server 2019, 2017, 2016, 2014, 2012, 2008R2, 2008, 2005, 2000, 7.0, 6.5 (64- and 32-bit). Azure Databases, CouchBase, SSAS (DDS and Tabular), Oracle,Sybase.

Systems: Windows Server 2016, 2012 /R2, 2008. Azure and AWS platforms. VMWare

Languages: T-SQL, PowerShell, SSIS, VBScript

High Availability: AlwaysOn AAG’s, Windows Clustering, Pure base replication, Zerto, Veeam

Data Migration: Attunity Data replication (Now Qlik Replicate), SQL Server Integration Services (SSIS), Data Transformation Services (DTS)

Database Tools: SQLSentry/SentryOne, Idera and Redgate Monitoring, Toad, SolarWinds, sp Blitz, Profiler, extended events, Actifio, Rubrik, Attunity (Now Qlik Replicate), Veeam, Rubrik backup, Catalogic

Reporting tools: WebFocus, PowerBI, Tableau, SSRS - Reporting services

Enterprise Applications: SAP, Salesforce, Great Plains, Yardi, Various CRM’s, In House custom built

PROFESSIONAL EXPERIENCE

Confidential

Sr. Database Administrator

Responsibilities:

• Actively managing 6 SQL Servers that host 91 databases and multiple Web and SSRS servers that supports the Association’s billing, donations and web applications and blogs.
• Manage all aspects of supporting the SQL Server environments. Backups, Performance monitoring and tuning, Security, Maintenance.
• Working with multiple consulting partners with web support upgrades of IPV2 to IPV3 to be able to support a future upgrade to the website’s security modules.
• Created a central repository using PowerShell and T-SQL to collect nightly statistics of all servers and database metrics and kpi’s. This included for an example, Windows and system hardware spec’s, SQL Server spec’s including sizes, index information, SQL Server system information, Security and many more metrics.

Confidential

Sr. Database Administrator /Data Architect/SQL System Architect

Responsibilities:

• Currently managing 35 servers and 345 databases that support the company’s applications, data warehouses, analytics layer, and reporting systems. I also support and develop data movement ETL jobs that are currently built in SSIS.
• Responsible for on-call 24/7 support of the databases as well as application support.
• Upgraded SQL Servers, analysis services and reporting servers from 2008R2/2012/2014 to Windows 2016 and SQL Server 2017.
• Rearchitected the SQL Servers to be highly available and reduce the footprint on the environment.
• Architected a highly available solution using AlwaysOn to ensure that the RPO/RTO was met to satisfy the SLA’s defined by management.
• Managed all aspects of support for the SQL Server environments, Backups, Performance, Security, Maintenance, Patching, code deployments and database build outs.
• Managed a third-party Partners who created one of Heiman’s data warehouses. This included working with code review, change controls and data management and enhancements.
• Worked with Infrastructure teams to ensure a stable hardware/virtual environment to support the SQL Servers. Ensured the SQL servers are on the optimal configuration in the sub layer.
• Currently working with a partner to transition Heiman’s property management application to an outsourcing company to provide services for property management.
• Continuous tuning of Systems, Software, and database level to increase performance.
• In process of building a multi-dimensional warehouse to support Heiman’s PowerBI analytical layer and business systems.
• Created a central repository using PowerShell and T-SQL to collect nightly statistics of all servers and database metrics and kpi’s. This included for an example, Windows and system hardware spec’s, SQL Server spec’s including sizes, index information, SQL Server system information, Security and many more metrics.

Confidential, Chicago

Database Administrator, Database/SQL System Architect

Responsibilities:

• Responsible for on-call 24/7 support of the databases as well as application support.
• Provide Database installation, configuration, High Availability and Disaster recovery solutions.
• Work closely with Directors, Managers, and development teams to accomplish project goals and support of Confidential ’s systems.
• Performed database deployments for project teams and as well as third party software.
• Create and document and implement database security policies.
• Build, support and deploy SSAS (DDS and Tabular) databases.
• Install, configure and Support third party vendor software (SAP, MAXIMO, Microsoft software…)
• Implement, Manage, and audit Database security for application and end user access to databases.
• Create Confidential standards and policies as it applies to databases and related integrated technologies.
• Work closely with development and performance tune databases, indexes, code and ETL’s. Performed T-SQL scripts reviews with developers for deployment to QA and production.
• Support and configure CouchBase NoSQL Servers.
• Continuous communication and development of future state of Confidential ’s database systems and related technologies.
• Worked closely with the Infrastructure team to create the architecture to support the SQL servers local and at the remote site (DR) to support geo clustering of the AlwaysOn servers. This also included architecting the DR solutions to ensure Confidential ’s RPO and RTO SLA’s.
• Continuous tuning of Systems, Software, and database level to increase performance.
• Experience was either Proof of Concept or side projects as part of BizSpark sponsorship by Microsoft. BizSpark sponsorship was for 3 years. During this period used Azure DB's, ADW, Data Factory, Stream analytics, Azure VM's, Azure Storage, IOT Related services and Azure Backups and geo-clustering.
• Used storage forActifio and Rubrik backups.
• Did Azure POC for Confidential up and through setting up environments.
• Used AWS for POC's of MS AlwaysOn and geo-clustering of the secondary nodes.
• At Confidential, used AWS storage for a tertiary site for Actifio and Rubrik backups of all database servers and as well as DB's.
• Upgraded Confidential ’s databases servers from SQL Server 2005 through 2008,2012,2014,2016 and currently upgrades of 2017.
• Built Confidential ’s database High Availability solutions for key systems using AlwaysOn AAG’s geo clustering to Confidential ’s disaster recovery site.
• Redefied and rearchitected thousands of nightly data movement batch jobs to near real-time replication of data using Attunity (Now Qlik Replicate).
• Rearchitected the refresh process of 495 databases from production to lower environments DEV, Test and QA reducing the refresh period from 5 days per environment to less than 4 hours by implementing Catalogic software to perform Pure based snapshots.
• Reduced the overall footprint of the data warehouse and Confidential ’s largest application systems by using database compression in turn saving the company over 100 TB.