You will get an SQL Server audit with recommendations and action plan
Project details
We’ve been working with IT and software development departments over the last 12 years to audit and optimize their SQL Servers, and would love to discuss the administration and tuning of your databases to boost the performance, scalability, and reliability of the applications relying on them.
So, how does it work?
Step 1: make a quick discovery call or text chat to figure out the current state of your database environment
Step 2: performance data collection and technical data collection
Step 3: data analysis
Step 4: delivery of the report and a call to discuss the results and advise on the next steps
You can either implement the report's recommendations yourself or hire us to do that.
After the assessment and implementation of the recommendations, we can continue to serve as your DBA as a service. Real-time database monitoring solution included. It usually takes a fraction of a full-time DBA budget.
So, how does it work?
Step 1: make a quick discovery call or text chat to figure out the current state of your database environment
Step 2: performance data collection and technical data collection
Step 3: data analysis
Step 4: delivery of the report and a call to discuss the results and advise on the next steps
You can either implement the report's recommendations yourself or hire us to do that.
After the assessment and implementation of the recommendations, we can continue to serve as your DBA as a service. Real-time database monitoring solution included. It usually takes a fraction of a full-time DBA budget.
Database Type
MS SQLWhat's included $970
These options are included with the project scope.
$970
- Delivery Time 14 days
- Number of Revisions 2
Optional add-ons
You can add these on the next page.
Extra consulting hour
+$60
9 reviews
(9)
(0)
(0)
(0)
(0)
This project doesn't have any reviews.
WK
Wolfgang K.
Sep 3, 2021
Software architect: Virtual Power Systems Operator local optimization of (renewable) energy systems
Excellent work - to be continued. Thank you
GC
Graham C.
Feb 28, 2017
Database and BI development and administration
JR
Jesse R.
Feb 20, 2017
I need an SQL DB expert to fix some database issues with a SaaS
Great work as always.
RT
Ricky T.
Nov 29, 2016
Data Analysts with expert SQL
GC
Graham C.
Nov 12, 2016
Database administrator
Great job. Thanks Roman!
About Roman
SQL Server DBA | Power BI | SSIS | SSRS | DWH | Azure | DevOps | .NET
100%
Job Success
Dubai, United Arab Emirates - 11:12 pm local time
- 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
Steps for completing your project
After purchasing the project, send requirements so Roman can start the project.
Delivery time starts when Roman receives requirements from you.
Roman works on your project following the steps below.
Revisions may occur after the delivery date.
Discovery call
Access setup