Roman D.

Ready-made solutions I can roll out in a matter of hours: - BI portal using Power BI Embedded in the Azure cloud - SQL Server monitoring - Subscription plans for database administration at a fraction of the cost of a full-time DBA - Database Audit As an SQL Server DBA, developer and architect, I specialize in mission-critical data systems and business intelligence solutions using Microsoft SQL Server. Over the course of my career, I have served as an architect, developer, team leader, project manager, and consultant, always ensuring I was on top of industry best practices. I’m honored to say SMEs bring me on to consult on their toughest projects because of my vast experience across industries, combined with an innate ability to cut costs and create corporate change. For companies without the internal resources to handle their most sensitive DBA needs, I’m proud to act as a true partner. Specialties: - Azure Data Platform (Synapse, SQL Azure, SQL Server Virtual machines and managed instances, Data Factory, Data Lake, CI/CD, Azure DevOps), Power BI, Power BI embedded portal solutions - Database Administration: monitoring, maintenance, installation, configuration, upgrades, migrations, security - Database development and architecture: T-SQL, database design, CLR, XML - Performance Tuning and indexing - Disaster Recovery, backups and restores, VLDB - High Availability: Replication, Clustering, Mirroring, Log shipping, AlwaysOn - BI Architecture & Implementation, Data Warehousing, OLAP, ETL, Reporting & Analysis (SSRS, SSIS, SSAS) - Systems integration - Distributed teams management (SCRUM), project management - Storage Technologies: - MS SQL Server 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, 2019 - Power BI Embedded portals - SQL Azure, Synapse, IaaC, IaaS, PaaS - MS SQL Server Reporting Services (SSRS) - MS SQL Server Integration Services (SSIS), DTS, BCP - MS SQL Server Analysis Services (SSAS) - ASP.NET, ASP.NET(MVC) - .NET Framework - Hyper-V, VMWare - Dell, HP Servers - SAN, RAID, DAS, NAS