Sql Server Azure Data

Hello,

Please accept my resume for your kind consideration. My experience extends over 15 years as I have progressed from Application Development and Database Management teams to my current role as Manager Database Technologies at PanAgora Assets Management. I would like to mention a few representative contributions to illustrate the skills and abilities I offer:

TECHNOLOGY SOLUTIONS – I constantly seek to find creative ways to implement technical solutions that fit the needs of customers. That was the case when I led the SQL Server database virtualization project at EMC Corporation using VMWare technology. The results of this project implementation served as a model for EMC’s customers and partners. This project implementation served as the enabler of the Database as a service strategy that was implemented later. In my role at Amica Mutual Insurance Company I have proposed similar database as a service strategy roadmap, this time proposing a hybrid cloud solution using VMWare technology for on premise deployment and public cloud service providers. This proposal expanded the database technology stack offering from just SQL Server and MongoDB to PostgreSQL, MySQL, MariaDB, Cassandra, Hadoop, and other database technologies available in the market expanding to offer database technologies on Linux operating system (‘OS’) as my company was until then a Windows OS shop.

Adoption and active participation on Azure data lake initiative to work on data architecture project using Azure data factory, Azure Synapse and Azure SQL databases to copy/migrate data to Azure storage accounts Gen2.

TEAM MANAGEMENT – I have built global teams from ground up. I have trained, mentored.

and empowered teams across multiple departments and functions. I have managed global Application Development Teams as I did at EMC Corporation and I have built 22 personnel team located in US, and India to support a diverse stack of database technologies and data modeling that include, but it is not limited to IBM mainframe DB2, DB2 LUW, MongoDB, MySQL, SQL Server, Teradata, and Power Designer at Amica Mutual Insurance. In my tenure managing teams also includes the Data Modeling team which I led to define a new workflow to manage new projects coming to this area. In my current job at PanAgora Asset management, I built the current DBA Team to support more than 250 TB of data storage using SQL Serer on prem and, Azure SQL Databases, Azure Data Lake using Synapse and Azure Data Factory. Head of database architecture while managing the team.

Sincerely,

Franklin Lizardo Connect: 508-***-**** (C) ********@*****.***

EXECUTIVE PROFILE

IT professional with 10+ years of particularly good history delivering business value. Led design, implementation and support of mission critical application platforms and database infrastructure services. Particularly good track on operational excellence to minimize costs without sacrificing business productive. Experience in multiple technologies.

AREAS OF EXPERTISE

Database maintenance

Database backup and recovery

ITIL – Certified

Process analysis & Improvement

Lean Six Sigma – Green Belt certified

Database design

Database Performance tuning

Database architecture

Private/Hybrid Cloud

IT Database-As-a-Service practitioner

Enterprise Database Strategies

Education:

National University Pedro H. Urea (Santo Domingo, Dom. Rep.)

Bachelor of Science degree in Computer Science

Virtualized environment

Monitoring and Automation

High availability / Disaster Recovery solutions

Data Center migration and consolidation

Database migrations.

SOX and database systems internal auditing.

Azure SQL

Azure Data Factory

Azure Synapse

Azure Devops

24x7 support.

Experience

PanAgora Asset Management.

Principal Database Administrator January 2021 – Until present.

Principal DBA with extremely elevated level of experience in multiple database engines. Responsible for all database architecture across the company.

In charge of external vendors data loaders support.

Provide DBA Support to SQL Server 2014 – 2022 SQL Server instances versions.

Upgraded SQL Server 2022. Side-by-side/In-place.

SQL Server deployment using VM technology templates.

Biggest SQL Server Instance supported: 1 TB RAM, 64 CPUs

100+ TB of storage.

Provide SQL Server architecture support to new projects.

Support SQL Server running on MS Windows failover cluster.

Architecture and implementation of developer’s workstations using Azure VMs IaaS, T-SQL code, Powershell, and ASP.net VB 2022

Always-On Availability Groups configuration and support. Clustered and clusterless configuration.

Part of the team migrating data to Azure Data Lake using Azure Data Factory and Azure Synapse.

VMware maintenance and administration.

Support of AD groups and new account maintenance.

Support of ExtremeIO storage utilization for database systems.

Support Cohesity backup appliance for SQL Server.

Implementation of Cohesity database backup tool restores using powershell.

Setup SQL Server table partitioning.

Setup of Temporal tables.

SQL Server replication configuration and support. On prem and Azure SQL databases.

Design of data archiving process using table switching technique and SQL Server Azure Stretch DB.

Performance tuning using IDERA DM, SQL Sentry, and SQL Server DMVs.

Azure VMs configuration, support, SQL Server installation/configuration.

Entry level experience with Azure CosmosDB.

On premise to Azure Cloud database migration.

Enable data query and data loading using Azure Synapse and Azure Storage accounts Gen 2.

DR recovery using SQL Server Always-On and ExtremeIO storage.

SQL Server Database Cloning using EMC AppSync.

Database as a service strategy using Nutanix – DS Technology.

Public Cloud Infrastructure support using Azure.

Agile methodology using Azure Devops.

Designed database storage migration strategy from XIO to Pure Storage with minimum down time.

Senior Analyst.

November 2019 – January 2021

DBA Support for all company’s systems supporting SQL Server 2014 – 2019 SQL Server instances. Total of sixty servers

Upgraded SQL Server systems to SQL Server 2019. Side-by-side.

SQL Server deployment using VM technology templates.

Biggest SQL Server Instance supported: 1 TB RAM, 100+ TB of storage.

Provide SQL Server architecture support to new projects.

Support of SQL Server on MS Failover Cluster active/passive.

Always-On configuration and support. Clustered and clusterless.

VMware maintenance and administration.

Support of AD groups and new account maintenance.

Support of ExtremeIO storage utilization for database systems.

Support Cohesity backup appliance for SQL Server.

Implementation of Cohesity restores using powershell.

Setup SQL Server table partitioning.

Setup of Temporal tables.

SQL Server replication configuration and support.

Design of data archiving process using table switching technique.

Performance tuning using IDERA DM and SQL Server DMVs.

Azure VMs configuration, support, and SQL Server installation/configuration.

DR recovery using Always-On and ExtremeIO.

SQL Server database Cloning using EMC AppSync and Pure Storage.

Database as a service strategy using Nutanix – Era Technology.

Public Cloud Infrastructure support using Azure.

DBA Section and Data Modeling Teams Hands-on Manager at Amica Mutual Insurance. June 2016 – October 2019

In charge of a global DBA team with twenty-two members supporting the following technologies: IBM Mainframe DB2, SQL Server 2008R2-2017, DB2 LUW Warehouse, Teradata warehouse, MongoDB, PowerDesigner.

Manage the Data Modeling team.

Implement scrums meetings and Kanban boards to manage team workload using agile project management methodology.

Manage vendors and managed service relationship.

Manage and support database systems auditing process.

Defined Hybrid cloud strategy using VMware, AWS, and Azure.

ITIL implementation – incident, Change Management, Work requests.

Jira tool for project management, usage of Confluence, Tempo modules as well.

Principal Database Architect at EMC Corporation. May 2013 – May 2016

In charge of database architecture for the Data Platform Service organization.

Define database standard practices for Microsoft SQL Server, PostgreSQL and MemSQL.

Headed a major program to migrate Oracle based mission critical systems to SQL Server 2012 and SQL Server 2014. This was a multi-million program.

Mentored the DBA Team and provided support for critical issues.

Headed EMC customers briefing on how to migrate from Oracle to SQL Server.

Performed extensive scalability testing of Oracle, PostgreSQL and SQL Server using HammerDB open-source software.

Led database virtualization initiative using VMWare technology.

Active participation on the Database-as-a-Service strategy.

Contact this candidate