Dmitriy Ivanov

Dmitriy Ivanov Email and Phone Number

Senior developer @ Sweed POS
Dmitriy Ivanov's Location
Russia, Russian Federation
About Dmitriy Ivanov

PROFESSIONAL SUMMARYSenior Database Engineer with more than 19 years of experience in the development and administration of MS SQL Server. Strong background in T-SQL with stored procedures, triggers, functions, tables including Partitioned Tables, views, indexes, and relational database models. Proficiency in creating high availability and disaster recovery solutions using Always ON, Clustering, Replication, Mirroring and Log Shipping. Deep understanding of SQL engine and inside processes for code optimization. Good knowledge inefficiently using SSIS, SSAS, Report Service, and PowerBI tools and acquainted with C#. Possesses excellent problem-solving skills and is focused on providing quick solutions to business problems.TECHNICAL SUMMARYLanguages: T-SQL, SQL, PL/SQL, Python, C#, PowerShellDatabases: MS SQL 2000–2022 OLAP/DWH, U-SQL (Azure), MySQL, MongoDB, Amazon Redshift, Azure,AWSBI Tools: SSIS, SSAS, Report Service, PowerBIBackend: Entity Framework, NHibernate, MS FormsСloud and DevOps: Azure SQL Database, CosmosDBOther technologies: MS SQL SSIS PackagesKEY TECHNICAL SKILLSDatabases and storages: MSSQL, Azure Cloud databases, AWS• Database architecture design• Query optimization• Database troubleshooting• Database performance tuning/monitoring• High availability and disaster recovery strategies: AlwaysOn, Log Shipping, SQL Server Failover Cluster, Replications• Index and statistics maintenance strategy• Making and refactoring stored procedures, user-defined functions, triggers, CLR, and ad-hoc queries• ETL\ELT processes design, implementation, and optimization• Reports development/optimization• Triggers• SQL Server politics• SSISС#• Using backend side based on .NET to collect data for exploring business logic• Creating CLR functions for implementing business logic on SQL server• Deploying SSIS packages using C#Python• Development in Python• Using Jupiter Notebooks• Using Pandas, Numpy, Matplotlib, Sklearn, Seaborn libraries

Dmitriy Ivanov's Current Company Details
Sweed POS

Sweed Pos

View
Senior developer
Dmitriy Ivanov Work Experience Details
  • Sweed Pos
    Senior Sql Server Database Administrator
    Sweed Pos Aug 2022 - Present
    United States
    View
  • Dataart
    Senior Software Developer
    Dataart Mar 2021 - Aug 2022
    St Petersburg, St Petersburg City, Russia
    View
  • Gazprom Neft
    Head Of Big Data Department
    Gazprom Neft Nov 2019 - Feb 2021
    Saint Petersburg, St Petersburg City, Russia
    Oil and gas company MasterID – unique client identifier. The general goal is to create one identifier for clients from different external systems and show this information in consolidation format to data analytics. DL FW – custom data lake framework used for automation processing data.Responsibilities:• Managed over 5+ database servers (include 50+ databases), monitoring, working with incidents, and providing support and implementation of new custom framework• Managed team of 2 data engineers and 1 database administrator• Developed custom framework in Python for ETL/ELP business logic processes• Implemented new custom framework for migration to Hadoop• Deployed SSIS packages using C#• Developed and implemented a new architectural design based on an anchor data model• Developed integration mechanism for getting data by SOAPUsed languages and technologies: Python, T-SQL, PowerShell, SSIS, 3th nodes SQL Server 2017 Cluster with sync and not sync replicas, RestAPI/SOAP for external services.
    View
  • Arcadia
    Senior Software Development Engineer
    Arcadia Mar 2018 - Nov 2019
    Санкт-Петербург, Россия
     SQL Server Migration – migration over 10 on-premise SQL Server to Azure cloud. I did migration over 100 SSIS packages to Azure cloud. R2 – a ballot project that includes 3 different platforms for voting and consolidation results in the end reports.Responsibilities:• Managed over 20+ database servers including 300+ databases, monitoring, working with incidents, and providing support• Created high availability & disaster recovery solutions using Always ON, Clustering, Replication, Mirroring, and Log Shipping• Used Locking, Blocking & Deadlock Scenarios for resolving issues.• Provided Backup and Recovery scenarios, Backup\Restoring strategy RPO\RTO• Migrated database to Azure• Provided horizontal and vertical partitioning of tables to achieve better performance and scalability• Analyzed I/O, CPU, Memory issues and provided fix using Ignite tool and DMVs, troubleshot log file space issues, tempDb contention• Designed and implemented In-memory tables in 2016 OLTP database server• Implemented extended events to replace custom scripts for monitoring & troubleshooting issues• Provided 24x7 production support for SQL Server databases on standalone and Clustered Servers with sizes ranging > 20Tb• Installed, configured, maintained, and administrated MySQL Servers• Worked with MySQL servers and Redis like a cache server, Azure Data Factory, Azure Data Lake (Hadoop, Spark), Azure Data Analytics (U-SQL)Used languages and technologies: MS SQL 2014 - 2016, Azure, CosmosDB, SSDT, SSIS, SQL Profiler, SQL Server Failover Cluster, Jira, GitHub, CosmosDB
    View
  • Travel Republic
    Production Dba
    Travel Republic Jul 2017 - Mar 2018
    London, United Kingdom
    Online booking service Booking site (hotels, tickets, car rental) – supporting and optimization backend business logical processes, developed statistics dashboards for C-level managers.Responsibilities:• Administrated and supported MS SQL 2014, SSIS, SSRS, SSAS (Prod, Dev, Test)• Implemented and supported AlwaysOn, Mirroring, Replication and ETL• Supported big tables around 100 billion records per DB• Reviewed and refactored existing SQL code• Used TFS for versioning code store• Created CLR functions for implementing business logic on SQL server• Provided monitoring of DB including Spotlight on SQL Server Enterprise, Nagios, Extended Events, Profiler, Statistics• Optimized queries in stored procedure and adhoc• Developed and implemented technologies like DB in memory/Table in memory• Developed and supported Backup/Restore/Recovery strategy.Used languages and technologies: T-SQL, MS SQL Server 2014, SSIS, SSRS, SSAS, AlwaysOn, Tableau, MongoDB, In-Memory, Columnstore storage, SSAS, SSRS, MySQL
    View
  • Hazeltree
    Senior Database Developer
    Hazeltree Nov 2016 - Jul 2017
    New York, Usa
    Treasury management solutions Cash Manager – an application for transparent management currency and advanced analytics for hedge funds and banks.Responsibilities:• Managed SQL Server 2008/2014/2016 with over 40 servers included servers with Mirroring and AlwaysOn• Developed and refactored stored procedures, triggers, and other code in DB to provide data structures and high-performance execution• Used T-SQL, CTE’s, stored procedures, functions, triggers temp database, DMV, execution plans, and subsequent optimization of the code• Adapted and improved the architecture of the existing data store on MS SQL for analytical tasks and new functionalityUsed languages and technologies: MS SQL 2008 - 2016, Azure, .NET, TeamCity, SSDT, SSIS, SQL Profiler, AlwaysOn, MySQL, T-SQL
    View
  • Travel.Ru (Oktogo Group)
    Dba
    Travel.Ru (Oktogo Group) Nov 2013 - Oct 2016
    Санкт-Петербург, Россия
    Online booking service Booking site (hotels, tickets, car rental) – supporting and optimization backend business logical processes, developed statistics dashboards for C-level managers.Responsibilities:• Administrated and supported MS SQL 2014, SSIS, SSRS, SSAS (Prod, Dev, Test)• Implemented and supported AlwaysOn, Mirroring, Replication and ETL• Supported big tables around 100 billion records per DB• Reviewed and refactored existing SQL code• Used TFS for versioning code store• Created CLR functions for implementing business logic on SQL server• Provided monitoring of DB including Spotlight on SQL Server Enterprise, Nagios, Extended Events, Profiler, Statistics• Optimized queries in a stored procedure and adhoc• Developed and implemented technologies like DB in memory/Table in memory• Developed and supported Backup/Restore/Recovery strategy.Used languages and technologies: T-SQL, MS SQL Server 2014, SSIS, SSRS, SSAS, AlwaysOn, Tableau, MongoDB, In-Memory, Columnstore storage, SSAS, SSRS, MySQL
    View
  • The Mysale Group
    Head Devops + Dba
    The Mysale Group Sep 2014 - Feb 2015
    Australia, Brookvale
    International online retailer Supporting and optimization of MS SQL Servers DB structure for flash sales siteResponsibilities:• Coordinated release operation between programmers, system administrators and project managers• Developed and supported tools for automation of tasks release engineers• Deployed releases on test stands• Provided system development for the project• Developed and supported means for monitoring and diagnostics of operation of a product• Monitored, diagnosed and troubleshot operations of product in different environments• Supported MS SQL 2008, MS SQL 2008R2• Implemented and supported an Amazon Redshift for advanced analytics/Used languages and technologies: T-SQL, MS SQL Server 2008, 2008R2, MySQL, PowerShell
    View
  • Jsc Extra, Hypermarkets Of Glavmag
    Head Of It Department
    Jsc Extra, Hypermarkets Of Glavmag Nov 2013 - Jul 2014
    Ивановская Область, Россия
    Retail companyResponsibilities:• Managed team of 8 employees in IT department• Audited informational and technological structure of the company• Provided assessment of IT risks• Created universal informational structure included the central office and regional divisions• Organized and provided operation control and staff coordination in department• Optimized and upgraded architectural and software solutions• Optimized costs and controlled IT budget• Prepared and managed IT projects in the company
  • I-Free
    Head Of Qaulity Of Services (Ops)
    I-Free Jun 2010 - Nov 2013
    Санкт-Петербург, Россия
    Mobile development Supporting and optimization of MS SQL Servers cluster environments. An implemented monitoring system, optimized and developed business logic. Load in spike 10k tpm (transactions per min)Responsibilities:• Managed team of 4 employees in IT department that was organized for the operational solving of incidents and problems, and also for tighter integration with developers and testers within the Continuous Integration and Continuous delivery projects• Implemented methodologies Agile/Kanban using Jira• Reduced time of response for incidents by 15-20%• Reduced quantity of bugs was by 30-40%• Created knowledge database from scratchUsed languages and technologies: MS SQL Server 2008, T-SQL
    View
  • Yandex.Money
    Enterprise System Administrator
    Yandex.Money Dec 2007 - Jun 2010
    Санкт-Петербург, Россия
    Financial service Backup and reservation with Symantec Veritas Exec Backup, including reservation on remote platforms. Preparation for a case of total deploying in DataCenter. Clustering and fail safety of billing systems, included app servers and DB.Responsibilities:• Supported NLB cluster and Failover cluster for MS SQL 2000,2005,2008• Administered MS OLAP 2000-2008 and RS 2000-2008 including clusters• Managed Exchange 2003, 2007 including clusters• Supported 1C8, 1C7 with high availability 24х7, SAN, NAS, SCSI, iSCSI, Fibre Channel, RAID• Managed Citrix MetaFrame XPUsed languages and technologies: MS SQL Server 2000-2008, T-SQL, Citrix, 1C.
    View
  • Laventa
    Lead System Administrator
    Laventa Jun 2005 - Dec 2007
    Санкт-Петербург, Россия
    Retail companyResponsibilities:• Managed team of 6 people• Installed, configured, and administrated Windows 2003 including 10 remote platforms and 40 servers, SQL Server 2000• Supported ERP Axapta 3.0 (App servers, BD servers, Cache servers – AOS)• Administered Cisco Systems (871,1811,2801,2811, 2821), Cisco Wi-Fi AP• Managed EXceed WMS 4000 – warehouse management system• Supported MS Exchange Server 2003, TrendMicro, and GFI Antispam• Monitored SMS, MOM 2005• Administered 1C 7.7 (App and DB servers) and Veritas Backup 9.0Used languages and technologies: MS SQL Server 2000, Cisco, 1С, Axapta ERP, EXceed WMS.
    View
  • Rosexpertiza
    Leading It Specialist
    Rosexpertiza Sep 2004 - Jun 2005
    Санкт-Петербург, Россия
    Government servicesResponsibilities:• Installed, configured, and administrated Windows 2000/2003 Server• Supported MDaemon 6.0-7.0 mail server• Implemented MS Exchange Server 2003 from scratch• Supported ISA 2000, Kerio WinRoute Firewall• Implemented and supported AD, DNS, DHCP, WINS, ТСР/IP, POP3, SMTP, BrightStor ARCserveBackup 9.0• Was responsible for IT purchasing, repairing, and technical upgradeUsed languages and technologies: Windows 2000/2003 Server, MDaemon 6.0-7.0, MS Exchange Server 2003
    View

Dmitriy Ivanov Skills

Гибкая Методология Программирования Управление Продуктами Управление Проектами Разработка Программного Обеспечения Sql Скрам Менеджмент Microsoft Sql Server Высокая Доступность T Sql Системное Администрирование Базы Данных

Dmitriy Ivanov Education Details

Frequently Asked Questions about Dmitriy Ivanov

What company does Dmitriy Ivanov work for?

Dmitriy Ivanov works for Sweed Pos

What is Dmitriy Ivanov's role at the current company?

Dmitriy Ivanov's current role is Senior developer.

What schools did Dmitriy Ivanov attend?

Dmitriy Ivanov attended Saint Petersburg State University.

What skills is Dmitriy Ivanov known for?

Dmitriy Ivanov has skills like Гибкая Методология Программирования, Управление Продуктами, Управление Проектами, Разработка Программного Обеспечения, Sql, Скрам, Менеджмент, Microsoft Sql Server, Высокая Доступность, T Sql, Системное Администрирование, Базы Данных.

Not the Dmitriy Ivanov you were looking for?

View similar profiles

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.