Senior SQL Server DBA - Data Modeling & Performance Tuning

Andrew Richard Gomes

**-** **** ** **** Elmhurst, NY 11370

P: 917-***-**** E: *.*******@*****.***

Summary:

7+ years of professional experience with database development, database modeling, and systems management.

Prior knowledge of Relational Database Management Systems.

Strong expertise in SQL including stored procedures, views, indexes, triggers, and data transformations.

Knowledge of T-SQL, MS SQL (Data Definition Language, Data Manipulation Language, and Data Control Language).

Proficient in SQL Server Backup/Recovery, Disaster Recovery planning, and Security Management.

Administered SQL Server High Availability technology including Always- On, Clustering, Database Mirroring, Replication and Log shipping.

Skilled in troubleshooting database issues, performance tuning, and security.

Skilled in Batch process, SSIS, DTS, BCP, Import, Export, Backup, Database Monitoring tools and Application support.

Maintained Database authentication modes, created users, configuring permissions and assigning roles to users.

Hands on experience on SSRS/SSIS/SSAS configuration and generating reports pertaining to day-to-day transactions.

Collaborative team player with excellent communication skills and strong problem-solving mindset.

TECHNICAL SKILLS:

Operating Systems

Windows 2016/2019/2022 Server

RDBMS SQL Server 2016, 2019/2022, PL/SQL, Oracle 12c/18c Database Tools Enterprise Manager, ServiceNow, Query Analyzer, SQL Profiler, SQL Litespeed, DBAmon, IPCenter, PSS Diag, Diagmanager, SQLRegViewer, Power BI,

Dreamweaver

Programming Languages SQL, TSQL, PL/SQL, VB.NET, ASP.NET Cloud Microsoft Azure, AWS Redshift, AWS DMS, AWS EC2/RDS, Aurora Postgres, Google Cloud

Scripts VB 6.0 Script, HTML

Applications Microsoft office

Reporting Tools SSRS and Crystal Reports

Education:

William Cullen Bryant High School - HS Diploma 2011

Borough of Manhattan Community College – Associate’s in Applied Science Health Professions 2018

CUNY Medgar Evers College- Bachelor’s in Biology 2020 PROFESSIONAL EXPERIENCE:

MyTechUSA Inc Elmhurst, NY 11373 September 2024- October 2025 Database Administrator

Actively involved in writing T-SQL Programming for executing stored procedures, dynamic queries, indexing strategies, and functions for different tasks.

Developed reports using SQL Server Reporting Services.

Developed stored procedures and views used to supply data to reports and system optimization.

Designed, created, and managed multidimensional models using SSAS to support data analysis.

Developed Python scripts to automate SQL database maintenance activities such as backups, index optimization, and performance monitoring.

Integrated Python-based analytics and reporting workflows with SQL Server, enabling automated data validation scripts and trend analysis.

Implemented and maintained enterprise level High Availability and Disaster Recovery strategies for MS SQL Server using AWS Cross Regional Read Replicas (CRRR), including Microsoft Distributed Availability Groups (DAG) and Log Shipping, Replication, Mirroring, Clustering and Always-On ensuring 99.99% database uptime, seamless failover, and minimal downtime during maintenance or unexpected outages.

Automated SQL Server backup, restore, and maintenance routines using PowerShell scripts, improving operational efficiency and reducing manual interventions.

Developed Bash scripts to manage SQL Server instances running on Linux, including log rotation, permission auditing, and space monitoring.

Assigned users on witness servers responsible for Cloud disks in charge of primary replicas, secondary replicas, and solutions to failed or crashed servers.

Improved different types of Tabular Reports, Matrix Reports, chart and graphs, reports that sum up data, reports containing parameters and grouping, reports involving totals and sub totals, drill-down reports, and ad-hoc reports using SQL Server Reporting Services.

Installed, configured, and upgraded Oracle server software and related products.

Migration of the ERP product backend from Oracle 21c to SQL Server.

Proven knowledge of data loss prevention security practices. Including user roles, granted read/write/update/delete permission(s), encryption, and auditing for one database or multiple databases.

Created report models for Report Builder and managed reports via Report Manager.

Environments: OS: Windows Server 2022/2019/2016, Oracle 21c, SCOM, Linux RDBMS: MS SQL Server 2022/2019/2016

Cloud Platforms: Azure, Sharepoint

Tools: PowerShell, Power BI, Moogsoft, ServiceNow, TOAD, Aqua Data Studio Total Care Pharmacy Poughquag, NY 12570 September 2024- June 2025 Database Administrator

Performed day to day financial operations managing data extraction, generating reports, and tracking performance of pharmacy sales across prescriptions, OTC sales, and clinical services

Collaborated with database administrators for query optimization and data pipelines by means of Python profiling tools and SQL query tuning techniques.

Reconsolidate client profiles with detailed breakdown of product categories, suppliers, insurance networks, payer networks of health and data sets.

Integrated ERP/POS pharmacy systems (PioneerRx, QS/1, McKesson) with SQL pipelines, Power BI, and Excel to support automated financial workflows and analytics eliminating manual data entry.

Automated database maintenance and deployment tasks using PowerShell commands and Bash scripts (SQL Agent jobs, patching, integrity checks, and service restarts) processes in multi-node environments.

Diagnosed and resolved database connectivity, performance, security and corruption incidents, achieving zero data-loss incidents and maintaining full compliance with HIPAA, and pharmacy regulatory controls.

Delivered ad-hoc financial and operational reports to support decision- making and improve cycle management.

Ensured financial data accuracy and compliance with HIPAA, and pharmacy- specific legislative, regulatory, and organizational financial reporting policies

Environments: OS: Windows Server 2022/2019/2016

RDBMS: MS SQL Server 2022/2019

Empire Engineering LLC Richardson, TX 75080 January 2022- August 2024 Database Administrator

Supported end-to-end deployment and maintenance of 5G tower infrastructure including construction, installation, integration, and maintenance under OSHA regulation for project completion according to scope time.

Designed Python scripts for scheduled health checks, log parsing, and anomaly detection in SQL databases.

Handling project logistics using Jira smartsheets as management tools adapting the Scrum framework, monitoring tech debt, and updating refinements.

Utilized Bash and PowerShell scripting to streamline backup verification and automate data validation post-restore.

Designed and executed SQL Server maintenance plans (indexing, integrity checks, statistics updates), improving database and network reporting performance.

Worked with transcommunication applications importing and exporting company data between linked servers.

Troubleshoot and resolve blockings, deadlocks, including connectivity problems, data corruption, and performance degradation using SQL Profiler.

Developed automated data-driven scripts to streamline administration and monitoring tasks using leverage automation tools such as PowerShell for routine database management tasks and monitoring.

Developed a proactive disk capacity planning project for server environments and monitoring to prevent outages and ensure continuous system availability.

Diagnose and resolve connectivity\security issues and database corruptions in a critical production environment.

Environments: SQL Server 2019/2016/2014/2012

Tools: PowerShell, Idera, SQL Sentry

Logictink Marketing LLC Elmhurst, NY 11373 December 2018- November 2021 Database Administrator

Designed, installed, and configured SQL Server environments, including automated database maintenance plans, backup strategies, and performance monitoring with alerts.

Developed and optimized ETL workflows using SSIS and SQL scripts, including data imports/exports, transformation logic, and enhancements that improved data quality and reliability between systems and data warehouses.

Actively involved with developers to analyze incidents, resolve performance issues, and support data-driven decision making through the creation of SSRS reports, dashboards, and scheduled automated PDF outputs.

Conducted proof-of-concepts work with large-scale database migrations, version upgrades (SQL Server 2016 to 2019), and cross platform data movement to on-prem and cloud-hosted systems.

Re-designed ETL mappings to improve data quality.

Automated database administration tasks using PowerShell and Python, including SQL login synchronization, monitoring, backups, and maintenance routines.

Performed advanced performance tuning and query optimization — indexing strategies, stored procedures, views, triggers, and execution plan analysis — improving application and report performance.

Experience with SharePoint software as a data repository, organized created, maintained data reports, and gant charts showing specific information requested by management using the available data.

Participated in administrative team meetings supporting incident

/problem management, data analysis, and reporting, ensuring data quality, availability, and integrity across environments. Environments: MS SQL Server 2019/2016/2014, SCOM

Contact this candidate