Senior Database Developer
Resume:
Victor Ivantsov
Jacksonville, FL 32258
******.********@*****.***
Senior Database Architect / Developer with 29 years of hands on experience (27 in the U.S.) designing, building, and supporting high availability data platforms. Deep expertise in Microsoft SQL Server (6.5 2022) with exposure by work on Oracle, Teradata, MySQL and PostgreSQL environments. Combines rigorous data modeling discipline with strong .NET/C# development skills to deliver scalable, well documented solutions. Comfortable leading or slotting into cross functional teams, troubleshooting gnarly production issues, and squeezing milliseconds out of slow queries through evidence driven performance tuning and root cause analysis.
SQL Server Architecture & Engineering
29 yrs on versions 6.5 2022— Configuration, Always On, DR Strategy, Replication, Query Store, CLR, Azure
Query Performance & Production Rescue
Execution – query plan analysis, indexing strategy, waitstats review, rootcause hunting
Data Integration & Reporting
SSIS pipelines, SSRS dashboards, dimensional modeling with enterprise reporting
TSQL / Deployments
Advanced TSQL, C# & PowerShell to script deployments (re-runnable with rollbacks), CI/CD, and re-runnable data fixes
Technical Leadership & Training
Regular speaker/participant at SQL Saturday conferences—mentoring junior DevOps and learning from the MVPs
Education:
M.S. Industrial Engineering, Tula State University, Russia 1995
Certifications & Professional Development
Microsoft Certified IT Professional (MCITP): Database Developer, SQL Server 2008
SQL Saturday Speaker / SQL Clinic Volunteer — Orlando, Jacksonville, South Florida
PROFESSIONAL EXPERIENCE:
Senior Database Developer
Sept 2024 – May 2025 Streamline Work Comp, Inc., Jacksonville, FL
Client claims eligibility—ongoing support and improvements into existing SSIS/SQLCLR ETL framework that normalizes 15 + customer file layouts into a single standard structure, improving data hygiene and eliminating unnecessary data updates
Propay EDI implementation Following strict guidelines of custom EDI format implemented data interchange with Streamline client to facilitate electronic payments using T-SQL and SSIS
Production support and performance review ongoing slow query triage and the art of index tuning
Senior Database Developer/DBA
May 2014 – June 2024 BenefitWerks, Inc., Jacksonville, FL
Designed and implemented a reusable SSIS/C# ETL framework that consolidates 50+ inbound file formats (demographics, payroll, benefits, audit) into a unified schema, reducing newfeed development efforts and maximum code reuse, simplified maintenance, safety checks
Established an enterprise reporting environment by building a starschema data warehouse and standardized SSRS architecture with rolebased security, reducing OLTP load and improving report runtimes from minutes to seconds.
Implemented a rolling archival strategy that migrated 1.2 TB of historical data to a separate filegroup while maintaining query access through indexed views, increasing OLTP read performance and deferring storage expansion costs.
Production maintenance and query performance tuning DR implementation using ongoing backup/consistency checks/fragmentation maintenance, monitoring server activity, query tuning, sharing and documenting technical knowledge
Developed a comprehensive TSQL dataintegrity suite that validates gaps, overlaps, other configuration issues, data rules errors, reducing production dataquality incidents
Rigorous regressiontesting process that enumerates all parameter and data combinations prior to major release, consistently identifying breaking changes before deployment.
Senior Database Developer/DBA
March 2010 – April 2014 Provider Power, Jacksonville, FL
Designed SSIS/T-SQLbased EDI framework that exports outbound enrollment and billing data to utility partners
Optimized datawarehouse nightly load jobs - limiting historical data loads, adding new measures and improving SSRS reports using Microsoft Visual Studio.
Ongoing database development – for various areas of power distribution company: stored procedures, triggers, views, functions
Expanded reporting and analytics: created new SSRS reports, enhanced SSAS cubes with additional measures, better data visualization
Database Developer/DBA
Oct 2006 – Jan 2010 MPS Group, Beeline, Jacksonville, FL
Engineered SSIS/C# ETL platform that imported 20+ types of files from various Beeline clients making it faster and more user friendly
Rewrote cursorbased import procedures into setbased TSQL, significantly cutting nightly maintenance load window.
Automated database deployments - efficient collaboration with offshore team required concept of scripted database objects changes and data build triggered by PowerShell, strict source control, and environmentaware configuration
Automated data archiving—generated T-SQL scripts to move historical data away from the OLTP database (in transactional matter) based on company retention policy
Ongoing production support lending my expertise to DBA operations when challenging issues arise.
Contact this candidate