Software Engineer Sql Server

Sergey Veys

Houston, TX ***** +1-954-***-**** ******.****@*****.***

LinkedIn: linkedin.com/in/ssveys

Professional Summary

Lead Senior Software Engineer with 24+ years of experience in Production (24x7), Development, Testing Enterprise-level environments. Specialized in Optimization, T-SQL, ETL, REST API development, and cloud delivery using AWS & Azure.

● Experienced in installing, designing, developing, maintaining & tuning SQL Server 2017/2019/2022, Oracle 12c/19c/21c, T-SQL, PL/SQL, BCP, Stored Procedures, Triggers, UDF, SSIS packages

● Proficient in developing Data Flow Diagrams, Data Modeling (logical and physical), Entity relationship diagrams (ERD), Ad-hoc reports, data mapping, unit testing, migration, conversions and process documentation

● Extensive experience in Extracting, Transforming and Loading (ETL tools) using SSIS packages, Import/Export Data, Bulk Insert, BCP and ODI (Oracle Data Integrator)

● Highly proficient in the use of T-SQL for developing complex creating Database, Tables, Indexes, Views, Triggers, Stored Procedure, User Defined Function, relational database models and data integrity, SQL joins and query writing.

● Experienced with data partitioning, online indexing, Data Definition Language (DDL) triggers, Dynamic Management views (DMV), Dynamic Management Functions (DMF), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).

● Experience in Data Modeling (logical modeling and physical modeling), Entity relationship diagram (ERD) development/normalization and physical database schema design.

● Excellent skills in High Availability Technologies (Clustering, Log Shipping, Transactional\ Snapshot\Merge Replication, Mirroring), Database Backup, Linked Servers

● Collaborative team player with excellent communication skills Technical Skills

Databases & BI: SQL Server 2017/2019/2022, Oracle 12c/19c/21c, DB2, ElasticSearch, SSIS, SSRS, SSAS, Tableau, NHibernate, T-SQL, PL/SQL, ERWin

Programming Languages & Frameworks: C#, VB.NET, ASP.NET (2.0–5), ASP.NET Core, Java 8/11, Spring Boot, WCF, ADO.NET, .NET Framework, .NET Generics, Web Services, REST APIs, Angular 2+, ReactJS, JavaScript, TypeScript, HTML, CSS, Bootstrap 3, VBScript, XML, XSL, XSLT, EscmScript 6, Visual Basic 5/ 6.0

Cloud & DevOps: AWS (CloudFormation, CDK, SQS, SNS, SES, Lambda, CloudWatch), Azure, Git, Octopus, Team Foundation Server, CI/CD pipelines

Monitoring & Tools: AppDynamics, SolarWinds, SonarQube, ServiceNow, MS Teams, Visual Studio

(2003–2010), InstallShield, Visio, AccuRev, OnTime 2012, PDFTron, Gizmox, Ext.NET Development Practices: SQL Performance Tuning, ETL Design & Development, Data Modeling & Architecture, Backend & API Development, Object-Oriented Programming (OOP), Agile & DevOps Methodologies

Professional Experience

Software Engineer III /SQL Developer / Tokio Marine North America Services Jul 2024 – Apr 2025

● Troubleshooted problems with existing reports, validated reports data integrity to ensure accuracy and reliability of data

● Conducted data migration processes in the SQL Server environments using Integration Services, developed executed & scheduled SSIS packages using the execution package

● Investigated, troubleshooted and resolve database problems, implemented monitoring alerts/notifications to proactively identify and addressed potential issues

● Monitored server critical issues including Response Delay, Locking/Blocking and Server Downtime, database backups, reviewed/optimized poor-performing T-SQL queries

● Provided queries performance tuning & optimization, provided ongoing production support, managed support tickets

● Involved in Backing up and restoring of databases primary in Development environment

● Delivered scalable upgrades and collaborated with Business Analysts, QA and Architecture Teams for insurance applications to deliver scalable and reliable solutions

● Gathered business requirements, translated them into technical specifications Lead Software Engineer/Sr. SQL Developer / AutoNation – Fort Lauderdale, FL Aug 2014 – Jan 2024

● Built and maintained SQL Server environments, developed high-volume REST APIs

● Migrated .NET systems to Java Spring Boot microservices on AWS

● Developed a WebSocket server for real-time notifications using C#

● Integrated ElasticSearch and AWS services with backend SQL platforms

● Provided Performance tuning & optimization by Identifying & resolving performance bottlenecks using monitoring tools & techniques (AppDynamics, SolarWind, AppInsights), developed stored procedures, tables, triggers, views, analyzed query execution & optimized T-SQL queries, indexes, etc., for enhanced performance, data archiving, and purging as per mutually agreed data retention policy for the applications, proved to identify issues and improved existing processes to make processes more reliable,

● Resolved database/API/web-related problems, such as performance degradation, deadlock analysis, etc.

● Reduced data latency by 60% through stored procedure optimization

● Integrated middle-tier services with SQL Server, ElasticSearch, and SQS

● Worked closely with the entire team to identify issues and improve existing processes to make them more reliable, resolving database-related problems on all stages of the development life cycle and Production support (24/7 SWAT issues)

● Performed SQL Server DBA tasks, Monitored databases, file growth & disk space usage, and Implemented monitoring alerts and notifications to proactively identify and address potential issues, performed BI ETL development

● Collaborated with other IT teams to troubleshoot cross-functional issues & provide technical support and guidance to data engineers

● Supported Security Management, High Availability & Disaster Recovery Architecture, Technical Documentation and Knowledge Sharing across an organization Senior Software Engineer / DBA / BI / Epic Loan Systems – Miami, FL Nov 2012 – Aug 2014

● Designed ACH gateway and marketing engine; built SQL schemas and SSRS reports

● Maintained production SQL Servers and delivered ETL pipelines and Tableau dashboards

● Work closely with project team members to re-design, develop, enhance, and maintain the core web front-end user interfaces.

● Designed and implemented an intelligent schedule process for core company software.

● Created stored procedures, views, tables, triggers, table-valued, scalar functions etc. on various databases for critical data involving profit /loss/net revenue/forecasting and for reporting purposes

● Designed and implemented a new approach to achieve outstanding performance and schedule modification to the core Marketing Module which allows sending as many unique emails and text messages to customers, in as many intervals as needed.

● Overview and support of all support tickets.

● Performed Day-to-day Database Administration 24x7 for company SQL Servers, backup and maintenance implementation, performance tuning, reporting with SQL Server Reporting Services

& Tableau Dashboards, Disaster Recovery tests &, etc.

● Worked on BI SSRS, SSIS, and SSAS development, tuning SQL query, ETL & batch jobs Software/SQL Developer / Octagon Research Solutions – Philadelphia, PA Mar 2011 – Nov 2012

● Supported OLAP cubes, SSIS packages, and backend services for document systems

● Led coordination with offshore teams, managed code review pipelines, planned initial and new versions of the Document Publisher Business Application based on incoming development requests, developed and maintained project plans, managed project delivery/deliverables

● Hands-on project management of Document Publisher software, from analysis through testing.

● Managed a development team offshore resource (LiquidHub in India) which includes more than 20 team members.

● Identify and coordinate requirements through offshore project coordinators.

● Regularly report cross-project/program status to the Director of Product Development.

● Provide estimates for upcoming core product and custom development efforts to be used for internal planning or customer proposals.

● Follow standard operating procedures to ensure efficient, effective project execution and high standards of quality.

● Work closely with Product Support to plan resolutions for escalated customer-reported issues. Application Engineer / BI Developer / Access Group Inc. – Philadelphia, PA May 2009 – Mar 2011

● Developed WCF services and core SQL batch engine for student loan systems

● Supported RSA-based user verification, PayPal integration, and ETL processes

● Architect and construct a core batch engine to be used by the company batch jobs. Rewrote old batch jobs for the new batch engine.

● Implementation of 2 new loan products (PEAKS Loan Program and Affiliated Student Loan) in the existing website including modifications and new development.

● Integrated PayPal IPN solution to an existing website for collecting conference fees using online services

● Developed File Inspector application to validate a file based on the signature (not extension) of the file for Excel files, TIFF files, JPEG, and MS Word Document files.

● Developed an application to read the header information of a file and based on its signature and the application algorithm, assigned a percentage of possible file types.

● The application was used on more than 3,000,000+ files.

● Day-to-day activities and support of current production releases and testing Software Engineer / Sr. SQL Developer / Arris Systems Inc. – Philadelphia, PA Nov 2005 – Apr 2009

● Designed backend systems and data layers for the EASITRAX vending management platform

● Developed scheduling algorithms, recursive business objects, and transactional frameworks

● Built BI components using SQL Server (SPs, triggers, functions) for Coca-Cola and Pepsi clients

● Led database migration from SQL Server 2005 to 2008 and optimized SSIS workflows

● Managed performance tuning, source control, and application deployment (MS Installers)

● Delivered custom imaging and survey applications used in healthcare and vending industries Senior Software Engineer / SQL Developer / SHPS Inc. – Philadelphia, PA 1999 – Nov 2005

● Architected and led development of ChoiceOne Link, a benefits administration platform

● Designed SQL databases, object models, scheduling tools, and data transfer systems

● Built custom reporting engine and GMAT (generic mapping tool) for file transfers

● Developed Census application for loading benefit data via custom-mapped files

● Spearheaded enterprise security, data auditing, and integration into Benenroll Services

● Managed SourceSafe repository and release processes across internal teams Education & Certifications

Belarusian University, Minsk, Belarus, Bachelor’s Degree in Physics, 1992 CSC Institute, Philadelphia, PA, Certified Software Developer (840 hours), 1999 Additional Training:

● Microsoft Summit – Visual Studio & SQL Server

● XML-Based Web Applications Microsoft Course 1905BC

● BizTalk Server Deployment Microsoft Course 2379A

● Microsoft Summit – Extending Possibilities with Microsoft.NET Professional References available upon request

Contact this candidate