Data Azure

Demostenes Gonzalez (Database Administrator / SQL Developer)

Elmsford, NY 10523 917-***-**** adcg01@r.postjobfree.com linkedin.com/in/demostenesgonzalez

Summary

SQL Server database administrator supporting highly available mission-critical applications for HR, payroll and financial systems. Focused on supporting AlwaysOn Availability Groups for HA/DR solutions. Working with cloud services to discover, assess and migrate database workloads to Azure SQL Database. Expertise analyzing and shaping data to develop report solutions and data visualizations. Use PowerShell scripting for tasks automation, certified administering SQL Server 2012/2014.

Skills

Strong Microsoft SQL Server 2012 – 2019 Administration, T-SQL Programming, MySQL, PostgreSQL, Oracle

Advanced Performance Tuning, Indexing to Support Workloads, Query Optimization Techniques

Strong Azure SQL Database Migration, Azure Synapse Data Warehouse, PowerShell Scripting

Proficient Designing Tableau and Power BI Reports Visualization, Developing SQL Data Models

Advanced SSIS and SSRS – ETL Processes Development & Reports Design

Proficient Failover Clustering & AlwaysOn Availability Groups, HA / DR Techniques

Advanced Data Warehouse Development on SQL Server 2012 and SQL Server 2016 platforms

Professional Experience

Main Street Pediatrics New Rochelle, NY Sep 2019-Present

SQL Server / Azure SQL Database Consultant

Providing day to day support and troubleshooting of SQL Server 2017 and Azure SQL databases in production environment for business-critical operation.

Manage the complete rehosting of an application for deployment on Azure SQL Database. Migrated VMs and databases using Azure Migrate service after assessment of applications readiness for the Azure cloud.

Performed capacity planning to determine the best deployment option, purchasing model, and service tier requirements to optimize the solution and save money on Azure services cost.

Moving data to blob storage and using Azure Data Factory to upload the data into Azure SQL databases. Setup and automation of backups, database health checks. Setup database network security, access management, and thread protection. Analyze and solve technical issues.

COPE Health Solutions New York, NY Jun 2018-Jul 2019

Lead SQL Server Database Administrator

Stage data by mapping to company structures, reconcile, and aggregate this data in support of tools and processes development to enhance population health analytics for risk contracting.

Develop efficient SSIS packages that support the growing analytics capabilities of the firm.

Data management via efficient queries optimization, use of data compression, designing better columnstore indexes and using table partitions for optimal performance of analytical tools.

Generated validation reports after the staging phase utilizing a Tableau custom toolkit and SQL stored procedures to highlight issues that would have an impact on downstream analyses.

Tableau server administration and security management, troubleshooting, proactive databases health checks and performance improvements of SQL Server 2016, and SAS instance.

Monitor system performance, reliability of the databases and implemented backup/restore strategies to ensure database recoverability in a Microsoft SQL Server 2016 environment.

IBM New York, NY Mar 2016-Dec 2017

SQL Server Database Administrator

Hands-on installation, configuration and migration of SQL Server database instances, enterprise remote monitoring, and maintaining system health and security on a hybrid environment.

Implemented, and supported AlwaysOn Availability Groups on Windows Server 2012R2 and SQL Server 2012R2 to protect against outages of HR databases on 24/7 production environments.

Project lead in establishing a disaster recovery protocol from design to implementation for all OLTP database systems based on Log Shipping/Mirroring and executing yearly recovery exercise.

Developed database automation using T-SQL scripts and SSIS packages for common database maintenance tasks such as index maintenance, and integrity checks for optimal performance.

Analyzed data from various financial systems to aid the development of in-house reports solution using SQL Server 2014, SSIS and SSRS reducing the amount of money spent on support feeds.

Setup a backup/restore strategy using Arcserve SQL backup agent from CA which was essential to protect the data on the databases for the Infor GL, HR, Sage Assets and Travel & Expenses systems.

Member of a team working in the design, coding, testing of a high-level ETL system on a data-integration project for financial reporting that consolidated information from different accounting applications hosted on different platforms with Cognos Reports as the front-end interface.

YOUNG & RUBICAM New York, NY Apr 2002-Feb 2016

SQL Server Database Administrator

Managed the Fixed Assets and Expense Reports databases from the ground up, setting up the structure and workflow of tasks and configuring components to integrate with other systems.

Virtualized all SQL Server instances to VMware VMs during the company move to cloud-based computing consolidating servers and databases resources cutting business costs.

Technical lead during the testing, implementation, and rollout of backup agents for SQL Server databases after comprehensive data protection and data management strategy study.

Created and maintained documentation for financial users and helpdesk personnel on standard operating procedures and client installation of all database applications supported by IT.

Leveraged SQL Server audit features to meet the needs of industry compliance, auditors, and security by configuring both in place system verification, and regular quality control checks.

Elevated user experience by upgrading the Infor SmartStream General Ledger system to a newer interface with improved reporting capabilities and new functionality by taking advantage of advanced features in SQL Server 2008R2 after the migration and tuning of the databases.

Researched the company’s call center and identified issues that allowed me to create better process providing database systems support as well as reducing the volume of calls for help.

Education

City University of New York, City College New York, NY

BACHELOR OF SCIENCE, COMPUTER SCIENCE

Contact this candidate