Database Administrator Data Engineer
Resume:
Demostenes Gonzalez
Elmsford, NY *****, USA
**********.********@*****.***, linkedin.com/in/demostenesgonzalez/
DATA ENGINEER AZURE SQL DATABASE ADMINISTRATOR DEVELOPER
Skilled data engineer/database administrator with extensive experience in Azure SQL, designing and implementing solutions ensuring data quality, security, cloud integration, performance and robust data modeling for meaningful analytics. Designing and managing ETL processes to orchestrate data flow from source systems into mission-critical data warehouses, utilizing Azure services for scalable and efficient data storage solutions. Implementing security measures to protect sensitive data and creating robust data models to ensure data consistency and integrity enabling a wide range of use cases for end-to-end analytics utilizing Microsoft Fabric.
SKILLS & PROFICIENCIES
Microsoft Fabric, Azure Synapse Analytics, Azure SQL, Azure Data Factory, SQL Server, ETL Processes, Snowflake, Terraform, Upgrades & Migration, T-SQL Programming, Performance Tuning, Query Optimization, PowerShell Scripting, Power BI, Semantic Models, Advanced SSRS, Power Automate, Logic Apps, Python, Spark, DevOps, Git/GitHub, Problem Solving.
PROFESSIONAL EXPERIENCE
NBC Universal, Stamford, CT Database Administrator (Apr 2024 – Nov 2024)
Maintained the highest standard of data integrity and availability, especially during high-profile events like the Olympics. This role involves managing SQL Server Managed Instances and on-premises servers, where I've honed skills in mirroring, log shipping, and disaster recovery strategies, ensuring seamless database access across regions.
Executed reliable data backup procedures to ensure the preservation and integrity of critical information for DR, implemented strategies for indexing and statistics on all databases for improved performance and data retrieval at high volume usage during the games. Used DPA and Query Store to resolve performance issues efficiently by troubleshooting problems and providing effective solutions for the SCORE databases.
Supported numerous Power Automate flows running on schedules, which managed content in Power Apps to ensure that Peacock services remained up to date with necessary changes. I rebuilt critical automation flows that relied on outdated, legacy connectors that were no longer supported by Microsoft. In addition, I enhanced the notification system, enabling more efficient management of flow performance and alerts.
Enhanced several SSRS reports to reflect the most recent Olympic Games data, ensuring accurate and timely information was available to managers. Created many SharePoint lists and pages to facilitate team collaboration.
North Mill Equipment Finance, Norwalk, CT Azure SQL Database Administrator and Developer (Nov 2020 – Jan 2024)
I developed pipelines using Azure Data Factory (ADF) to ingest data into a production data warehouse on Azure SQL Database. As the lead engineer, I drove the integration of data from various sources, including Aspire, Great Plains, Salesforce, and other accounting/financial applications of acquired companies. Additionally, I accessed APIs from services like Google Analytics and RingCentral to gather data points from company websites, enabling deeper insights into business performance.
Data collection managing the ETL design of mapping and wrangling dataflows to ingest accurate, clean, and timely data into the data warehouse. Created data lakes via Microsoft fabric for discovery and exploration.
Database migration by moving many databases to the Azure cloud using DMA, Azure migrate service and ADS migration extension to ease the integration and data extraction into the Azure SQL databases.
Designed and implemented stored procedures, functions and views to fulfill user’s requests into business reports with tools like Power BI and SQL Server Reporting Services (SSRS) providing insights to support decision-making.
Administered the whole database operation of the accounting software solving issues and writing T-SQL code to provide and enable new features, also built Logic Apps to automate processes like feeding data daily to an online payment portal.
Proposed and helped lead an initiative to gather insights on customer behavior through the payment portal via a pilot project aimed at discovering potential insights using a lakehouse and Microsoft Fabric tools to manage the solution.
Built ADF environments and its resources to allow the team to perform tests of microservices integrating with web sites.
Main Street Pediatrics, New Rochelle, NY Azure Database Consultant / Developer (Sep 2019 – Oct 2020)
Implemented security and access management to the databases, automated backups to cloud storage, and improved database performance via query tuning. Delivered technical support and performed troubleshooting of SQL Server 2017 and Azure SQL databases for business-critical operations in production environment. Performed a re-hosting of application for migration to Azure SQL Database.
Led successful migration of VMs and databases by implementing Azure Migrate service after assessment of applications readiness for the Azure cloud.
Conducted capacity planning on Azure services cost to ascertain best purchasing model, service tier and deployment option requirements for solution optimization and cost saving.
Using Azure Data Factory built pipelines to process data files in many formats, transforming and cleaning its data for ingesting it into Azure SQL database tables and blob storage accounts.
Improved several highly used reports by combining and filtering data using T-SQL, creating views and later building visualizations in Power BI to upload to the online service for sharing.
COPE Health Solutions, New York City, NY Lead SQL Server Database Administrator (Jun 2018– Jul 2019)
Introduced stage data to reshape company structures, reconcile, and aggregate data in assisting tools and process development to improve population health analytics for risk contracting. Held accountability for Tableau server administration, security management, troubleshooting, proactive databases health checks, and performance improvements of SQL Server 2016 and SAS instance.
Managed system performance and databases consistency and executed backup/restore strategies to certify database recoverability in a Microsoft SQL Server 2016 environment.
Established efficient SSIS packages that improved analytical proficiencies.
Performed data management via efficient queries optimization, use of data compression, designing better column store indexes, and using table partitions for optimal performance of analytical tools.
Produced validation reports after staging phase by applying Tableau custom toolkit and SQL stored procedures to highlight issues that create great impact on downstream analyses.
Implemented SQL Server security to secure confidential data of clients and reduce problems.
IBM, New York City, NY SQL Server Database Administrator (Mar 2016 – Dec 2017)
Installed, managed, and migrated SQL Server database instances as well as initiated remote monitoring and preserved system health and security in a hybrid environment. Initiated and launched AlwaysOn Availability groups on Windows Server 2012R2 and SQL Server 2012R2 to secure against outages of HR databases in continuous production environments. Drove database automation using T-SQL scripts and SSIS packages for common database maintenance tasks, such as index maintenance and integrity analysis for optimal performance.
Successfully lead the completion of a project in developing a disaster recovery protocol from design to execution for all OLTP database systems based on log shipping/mirroring and implementation of yearly recovery exercise.
Evaluated and examined data from several financial systems to build and deliver in-house reports solutions using SQL Server 2014, SSIS, and SSRS while reducing cost spent on support feeds.
Launched backup/restore strategy using Arcserve SQL backup agent from CA, essential to protect data on databases for Infor SmartStream GL, PeopleSoft HR, Sage Fixed Assets, Concur Travel and Expenses systems.
Conducted design, coding, and testing of a high-level ETL system on data-integration project for financial reporting that amalgamated information from different accounting applications hosted on different platforms with Cognos Reports as front-end interface.
Worked in projects using Oracle, MySQL, and PostgreSQL databases to make data in these systems available for reporting.
EDUCATION & CERTIFICATIONS
Bachelor of Science, Computer Science, September 1999 City University of New York, City College
Administering Microsoft SQL Server Database (MCDBA), February 2018
Contact this candidate