I gang

PostGre Disaster Recovery Solution Windows 2016 Server

We have a new project running on a Windows 2016 server that uses PostGre 10. We are getting ready to move into production in a few months and need a database backup/disaster recovery solution designed and implemented on the server. This is our first PostGre solution and we could use help getting a database disaster recovery solution defined and setup on the server.

The solution should at minimum do the following

- Create a full backup every night so that it can be stored offsite through an existing replication process (writes backup to local drive)

- Create a full backup at a specified time (i.e. 2:00AM)

- Keep 7 days of backups in this folder, and delete all backups older than 7 days

- Create incremental backup of at all times that can be used for local restoration of data not included it full backups on a local drive.

Must haves

- Based on free or open source tools (i.e. pg_dump, pgBackRest, pg_basebackup, etc.)

- Highly reliable

- Suitable to a mid-sized database (10-20GB) with a moderate daily transaction load during daylight hours

- Overnight backup would take less than 2 hours

- Incremental process (i.e. WAL) does not significantly impact server resources

- Restoration time is less than two hours including full and incremental

- Restoration is not overly complex

Nice to haves

- Portable and would also work on Kubernetes deployed environments with some reconfiguration/setup.

- Would allow backups to be written to cloud locations

- Would send email notifications on critical errors

- Logging of backup processes and actions

- Alignment to industry best practices - something like this?: [login to view URL]

- Ability to modify general parameters of the process (i.e. notifications, times, destinations)

Considerations

- We will not grant access to the server for setup - actual setup would be done using a Skype call / screen share with someone in English. You should be prepared to guide someone on our team with server experience through the setup process remotely.

Milestones

- First payment will be made on delivery of an approved solution design

- Second (final) payment will be made upon the solution being implemented on our server

Evner: Windows Server, Database Administration, System Administrator, PostgreSQL

Se mere: azure site recovery step by step, azure site recovery for oracle database, azure site recovery limitations, azure pricing calculator, azure site recovery sql server, azure site recovery architecture, disaster recovery in azure, windows server 2003 azure site recovery, windows custom recovery solution, windows 2016 dns server, windows 2016 server citrix, how to install cal license in windows 2016 server, radius server windows 2016, setup smtp server windows 2016, setup pxe boot server windows 2016, windows storage server 2016 download, windows storage server 2016 vs windows server 2016, windows storage server 2016 nas, windows storage server 2016 setup, windows storage server 2016 price

Om arbejdsgiveren:
( 9 bedømmelser ) Victoria, Canada

Projekt ID: #21926666

Tildelt til:

PeterLi0529

Hi there. Thank you for your posting. I read your requirements carefully. I am happy to place a bid on your project because I am familiar with HA(high availability). I have completed several projects in which I realiz Flere

$1300 CAD in 2 dage
(1 bedømmelse)
2.5

16 freelancere byder i gennemsnit $1511 på dette job

tangramua

Hello, We can easily help you with a database backup/disaster recovery solution designed and implemented on the server. Our company Tangram Canada Inc has a huge experience in PostgreSQL, System Admin, Database Admini Flere

$1300 CAD in 7 dage
(17 bedømmelser)
5.1
AwaisChaudhry

Hi,. I have gone through the brief details mentioned on the job. I have done multiple jobs with Database Administration, Linux, PostgreSQL, System Admin, Windows Server which are the skills required to get this job don Flere

$2250 CAD in 25 dage
(3 bedømmelser)
4.5
krishaweb

Hello, I hope you are doing well! We at KrishaWeb are the most preferred agency for our client due to 100% recommendation and “5 STAR” rating from our clients which we achieve through excellent client support as well Flere

$1688 CAD in 10 dage
(1 bedømmelse)
4.4
dhanuitdevendra

Hello, Hope you are doing well! We can help you with our Database Administrator as a Service (DBAaaS). Please visit [login to view URL] for details. Ple Flere

$3000 CAD in 15 dage
(4 bedømmelser)
4.3
leemilun

Hi, nice to meet you. I am Gao M. I have read your post carefully and this is very interesting for me. I have 15 years of experience in software development and have already completed 156 projects in freelancer. Especi Flere

$1500 CAD in 30 dage
(4 bedømmelser)
4.1
sodiqa32

Hello, I am pleasure with your job as detailed. Thank you for the job posting. It’s a pleasure to meet you. I’d really like to work with you on this one if possible! I do have a couple of questions, but first I’d like Flere

$750 CAD på 1 dag
(2 bedømmelser)
3.3
lexul

We are a Michigan based software dev company that also provides IT services to local government offices. We use Postgres as our primary database service for development and have a few techniques for backup and recovery Flere

$1400 CAD in 4 dage
(5 bedømmelser)
3.3
AITSoft

Hello there, How are you doing?. I have read the description, I have great experience doing similar jobs related to these skills Database Administration, Linux, PostgreSQL, System Admin, Windows Server. Right now I Flere

$1250 CAD in 6 dage
(0 bedømmelser)
0.0
Signupsole

Dear Client, I don't want to write big proposal to waste your time. just one request, please check our portfolio once before awarding the project to anyone else. Portfolio link: [login to view URL] Flere

$1500 CAD in 7 dage
(0 bedømmelser)
0.0
makelegend17

Hi,sir, I'm sure that I can be a excellent candidate for your project. Please contact me, so that we can discuss more over chat. I value my credits from clients. Thank you for your reading. I have worked for a long ti Flere

$1250 CAD in 7 dage
(0 bedømmelser)
0.0
Aperseus

Hi! I have read your description and feel confident to fulfill your requirement. I have 9 years of C, C++, C#,QT , ASP.NET, Python, Arduino ,VB,Meta Trader,Raspberry Pi,Meta Trader..... Programming Experience and those Flere

$2000 CAD in 7 dage
(0 bedømmelser)
0.0
naishodayo

How are you, sir. I have checked your post. And I just have known that you want a developer to work for your job - 'PostGre Disaster Recovery Solution Windows 2016 Server' I have much and in-depth experience and exper Flere

$1250 CAD in 7 dage
(0 bedømmelser)
0.0
Mike123082

Dear Hiring Manager, After reviewing your job description, it’s clear that you’re looking for a candidate that is extremely familiar with the responsibilities associated with the role, and can perform them confidently Flere

$1357 CAD in 7 dage
(0 bedømmelser)
0.0
SecureForYou

Dear client. Thanks for taking your valuable time for reviewing my proposal.I have read your project description and I think I can be a candidate of your project. I have been confident and sure that I can complete your Flere

$1250 CAD in 7 dage
(0 bedømmelser)
0.0
akfaqana

Hi, When we can talk please schedule a time? I will work till satisfaction of you and do work more perfectly and clearly. Please have a check Website designing and development work work below [login to view URL] Flere

$1125 CAD in 7 dage
(0 bedømmelser)
0.0