You will get Always-On availability Group (AAG) setup for SQL Server
Project details
You will get faster SQL Server instances that are configured with Microsoft Best Practices for setting up Always On. You will also get detailed documentation covering my analysis and recommendations as well.
I will provide the below in this package:
- Build Always-on availability groups for your databases
- Build Failover Cluster Instance
- Build any Replication type or mirroring
- Health check and Performance Tuning
- Setup and configure VMs or physical needed for the environment
- Create a backup and maintenance plan for your databases include (Full backup, Transactional backup, rebuild indexes, etc.)
I will provide the below in this package:
- Build Always-on availability groups for your databases
- Build Failover Cluster Instance
- Build any Replication type or mirroring
- Health check and Performance Tuning
- Setup and configure VMs or physical needed for the environment
- Create a backup and maintenance plan for your databases include (Full backup, Transactional backup, rebuild indexes, etc.)
Database Type
MS SQLWhat's included
| Service Tiers |
Starter
$300
|
Standard
$450
|
Advanced
$550
|
|---|---|---|---|
| Delivery Time | 2 days | 2 days | 2 days |
Number of Revisions | 1 | 1 | 2 |
Schema Diagram | - | - | - |
Permissions Setup | - | - | - |
Import/Export Data | |||
Admin Panel Setup | - | - | - |
5 reviews
(5)
(0)
(0)
(0)
(0)
This project doesn't have any reviews.
MT
Manash T.
Jul 10, 2021
SQL DB Creation
Good Work
SP
Sanjeev P.
Dec 30, 2020
SQL database restore
Ajay completed the contract very fast and within time.
I am satisfied with his work and I would highly recommend him to anyone looking for SQL DBA.
I am satisfied with his work and I would highly recommend him to anyone looking for SQL DBA.
MJ
Martin J.
Nov 22, 2020
Techie needed for market research and product research
PT
Prince T.
Nov 12, 2020
SQL Server Always-On database not in Sync
Ajay is Knowledgeable and skillful SQL DBA.
SP
Sivyansh P.
Nov 8, 2020
SQL server installation and Patch
_"Brilliant work!! Ajay delivered the project fast and as agreed."_
About Ajay
SQL Database Administrator & Azure Professional (SQL DBA)
Delhi, India - 10:07 am local time
• Hands-on Experience in implementing and troubleshooting High Availability solutions like
Always-On SQL Server 2014, 2016, and 2017 environment
• Backup, Restore activities, Login creation, Job setup
• Identifying and Resolving Blocking and Deadlock issues by using System Stored Procedures, DBCC, Activity Monitor, and Profiler.
• Experience in the usage of DBCC commands and DMVs for troubleshooting.
• Experience with upgrades from SQL Server 2014 to 2016 and from 2014 to 2017.
• Maintain database consistency check using DBCC commands.
• Linked server creation.
• Implemented Database mirroring feature in SQL 2014 and 2016 servers.• Having experience in Weekend Maintenance Activities like Rebuilding/Reorganizing Indexes, Update Statistics, and Consistency Checks in Databases.
• Experience in Troubleshooting performance issues.
Certifications: 1. Microsoft Azure Fundamentals(AZ-900)
2. Administering Relational Databases on Microsoft Azure (DP-300)
Steps for completing your project
After purchasing the project, send requirements so Ajay can start the project.
Delivery time starts when Ajay receives requirements from you.
Ajay works on your project following the steps below.
Revisions may occur after the delivery date.
Introduction Call
Quick introduction call to discuss your main pain points and setup my access to your environment. This call will also be used to ensure that I can help with your issues. If not, we can simply cancel the project within the first 24 hours.
SQL Server Analysis
I will review your SQL Server instance and document all my findings. You get back to work while I identify your pain points and develop a plan to attack them. This will include my findings with actionable recommendations on how to resolve them.