Senior SQL Server Database Engineer

OSVALDO MELARE

Senior MS SQL Server Database Engineer, Administrator & Developer AZ-900 DP-900 MCDBA MCITP Land O' Lakes, FL Green Card Holder English, Portuguese, Spanish 321-***-**** *******.******@*****.*** linkedin.com/in/osvaldomelare

PROFESSIONAL SUMMARY

Senior MS SQL Server Database Engineer with 20+ years improving performance, reliability, and operational efficiency across mission-critical environments. Expert in execution plan analysis, query optimization, partitioning, HA/DR, and VLDB engineering, applying DBRE principles for observability, automation, capacity planning, and long-term data lifecycle management. Former software developer and consultant with strong analytical foundation, mentoring engineers on T-SQL best practices and stored procedure optimization. Expanding expertise in Snowflake and PostgreSQL administration, leveraging deep SQL Server experience for cloud architecture, performance tuning, cost governance, and workload management. Experienced across regulated and high- volume industries including banking, insurance, healthcare, e-commerce, telecommunications, datacenter operations, and enterprise platforms. Familiar with security and compliance standards such as HIPAA, PCI-DSS, SOC 2, and GDPR, and with enterprise ERPs including Microsoft Dynamics, SAP, and custom internal applications. CORE TECHNOLOGIES

• Database Platforms: SQL Server 2000–2025 • Azure SQL Managed Instance (GP and BC) • Azure SQL Database • VLDB

• Performance Engineering: Execution Plan Analysis • Query Store • Extended Events • Wait Statistics • Deadlock Resolution • Index Optimization • Query Rewriting • Load Testing • DMV Analysis

• Advanced Architecture: Database Partitioning • Data Archiving Pipelines • Filegroup Management • Compression Strategies

• High Availability & DR: Always On Availability Groups • Windows Failover Clustering • Log Shipping • Replication • Backup

& Recovery

• Development & Automation: T-SQL • Complex Stored Procedures • PowerShell • SSIS • SSRS • Monitoring & Alerting

• Collaboration Tools: GitHub • GitHub Copilot Enterprise • Jira • Bitbucket BUSINESS DOMAINS & ENTERPRISE SYSTEMS

• Enterprise Systems: Microsoft Dynamics • SAP • Custom Internal ERPs

• Industries Served: Banking & Financial Services • Insurance & Health Insurance • Online Auctions • E-commerce • Retail Chains

• Healthcare (Hospitals & Clinical Laboratories) • Telecommunications • Datacenter Operations • Construction & Real Estate • Universities & Educational Institutions • Hospitality • Last-Mile Delivery • Law Firms • Manufacturing & Industrial Operations PROFESSIONAL EXPERIENCE

Senior MS SQL Server Database Engineer, Administrator & Developer — Escher Group Jun 2025 – Present

• Serve as primary escalation point for performance incidents involving blocking, deadlocks, timeouts, excessive I/O, CPU contention, and memory pressure across mission-critical transactional systems.

• Perform advanced execution plan analysis, workload profiling, statistics management, indexing strategy design, and query optimization using Query Store, Extended Events, DMVs, wait statistics, and load-testing analysis.

• Design partitioning strategies for VLDB environments and architect enterprise archival and retention pipelines using staging frameworks, dependency-aware archival processing, automated validation, and batch-based data movement.

• Design and maintain Always On Availability Groups, Windows Failover Clustering, and HA/DR architectures while supporting migrations, capacity planning, and cloud modernization initiatives.

• Achieved 20x faster optimization delivery using GitHub Copilot Enterprise and AI-assisted development tools while validating 34-table dependency scenarios.

• Delivered 26x faster archiving procedures, eliminating millions of logical reads while processing 200M+ records.

• Reduced production blocking by 99% through transaction redesign.

• Applied advanced query hints optimization based on execution plan analysis to eliminate deadlocks and support concurrent archival execution while ensuring data consistency. Senior Azure SQL Database Administrator — Actabl

Oct 2024 – Jun 2025

• Managed 15 Azure SQL Managed Instances and 500+ databases containing billions of rows and 30TB+ of data supporting millions of daily transactions.

• Led performance tuning initiatives optimizing high-volume transactional workloads through columnstore indexing and execution plan analysis, significantly reducing query response times and improving system throughput.

• Developed proactive monitoring and health-check frameworks that substantially reduced unplanned downtime and accelerated incident resolution.

• Implemented a CDC (Change Data Capture) modernization initiative replacing legacy triggers, improving data replication efficiency and reducing transaction log growth.

Founder & Senior SQL Server Consultant — DBVAX Consulting Jan 2012 – Sep 2024

• Founded a specialized SQL Server consulting practice serving Fortune 500 clients including UnitedHealth Group, Capgemini, TCS, and Gafisa.

• Delivered dramatic query performance improvements through advanced execution plan analysis, index optimization, and T-SQL rewriting for high-volume OLTP workloads.

• Architected Always On Availability Groups, Windows Failover Clustering, and HA/DR solutions ensuring maximum uptime for mission-critical environments.

• Designed enterprise archiving frameworks for VLDB environments and led database migrations across SQL Server versions

(2000 through 2022) with zero data loss and minimal downtime. Senior SQL Server Database Administrator — UOL Diveo & TCS Jan 2002 – Dec 2011

• Managed enterprise SQL Server environments for telecommunications and technology services organizations supporting millions of customers with stringent uptime requirements.

• Maintained high availability for customer-facing transactional systems through proactive monitoring, performance tuning, and rapid incident response.

• Resolved critical deadlock and blocking scenarios, substantially reducing production incidents through execution plan analysis and index optimization.

EDUCATION

• Associate Degree in Data Science / Information Technology CERTIFICATIONS

• Microsoft Certified IT Professional (MCITP)

• Microsoft Certified Database Administrator (MCDBA) – Since SQL Server 2000

• Azure Fundamentals (AZ-900)

• Azure Data Fundamentals (DP-900)

Contact this candidate