Closed

Create and Maintain Mirror SQL Server / Web Server - DBA

DBA Wanted Create and Maintain a Mirror SQL Server and Web Server - Part Time Contract Job

Project Description

We are looking for an experienced SQL Server DB Administrator (DBA) to create and maintain a mirror web site and SQL server to take over the functions in the event of failover of the principal server. We are running a web Server with ASP pages and SQL server onWindows Server 2003 Standard Edition Service Pack 2. Mirroring shall be done continuously and monitored through automated scripts.

We will take care of hosting the principal and the mirror servers. When there is failover of the principal web server or the SQL server, mirror server should preferably seamlessly take over the functions of the principal server. Alternately, we are willing to live with 10 to 15 minutes of downtime, if required. Until the principal server is restored, snapshot backup and tape backup shall be taken on Mirror server (The backup will be handled by our Mirror Server hosting service). When the principal server is restored, the data from the mirror server shall be synched with the principal server and the principal server should take back the functions. Additionally, the mirror site can also be used as a load balancer to reduce the load on the principal server, if feasible (Optional, not essential).

Mirroring can be done using SQL Server Mirror Utility or through Virtualization (MS Hyper-V or VMWare), whichever is more efficient, robust and suitable for this project. If possible, please provide your quote price for both the options.

Please quote your price to create, test and launch the mirror site. Also, please quote how much you would charge for the monthly maintenance of the mirror site. Please briefly inform how you would implement the project and how long it would take to create, test and launch the mirror site. Also, please email the list of previous projects you have executed in this field.

After the mirror server is setup and running, mirror server DBA should monitor the mirror site and hold periodic discussions at least once in a month. Of course, in case of emergency, if the mirror server has any problems, mirror server DBA should be available on call on short notice.

Person executing the project should have at least 5 year experience in SQL Server and Web Server Administration and mirroring of SQL server and web sites.

References:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view];rlz=1C1CHMA_en-GBIN337IN337&q=Mirror+sql+server+using+Microsoft+Hyper-V+Virtualization&aq=f&oq=&aqi=

Project Details

• Principal Web Server and SQL Servers are hosted on two different IP at the same server location.

• Mirror Server will be hosted on a different server at a different location.

• Principal Web Server and SQL Servers are hosted on Windows Server 2003 Standard Edition Service Pack 2.

• Failover notification of the principal server will be sent through email /phone.

• Approx. Size of Database 4000 MB, Data file – 850,000 KB, Log file – 3,200,000 KB

• Bandwidth usage: Average : 460,000 KB per day, Peak: 800,000 KB per day, Total per month: 13,000,000 KB per month

• The mirror server can be optionally used as a load balancer. If the mirror server is used as a load balancer, the data should be synched with the principal server and backed up.

• Mirror server shall be monitored continuously and periodic logs shall be sent through email to make sure that the mirror server is working properly.

• We have also installed MacAfee, Firewall, Gen 6 FTP Server for protection.

• We use SmartStats for Web log and Google Analytics for tracking some web pages.

Thanks

Vasuki

Skills: .NET, DNS, SQL, System Admin, Visual Basic

See more: www principal com, working at vmware, web site for event, web service contract, web pages scripts, web analytics service, vmware projects, vmware com, visual web, standard library c, sql server web, sql server price list, sql server dba projects, sql price, sql pdf file, sql functions pdf, sql dba wanted, sites to create web pages, site maintenance service, server scripts, server load test, quote web service, q email, project administrator job description, principal com

About the Employer:
( 3 reviews ) Irvine, United States

Project ID: #564508

16 freelancers are bidding on average $2391 for this job

krishdts

please check PMB for details.

$1500 USD in 25 days
(25 Reviews)
7.8
sandeep25101982

Hi ! We have expertise in DNS,DDOS defense and website failure alternatives. We have setup couple of DDOS mirrors for our clients. We are ready for this project ! Thanks

$1500 USD in 30 days
(42 Reviews)
6.6
itamarjp

please check PM

$3000 USD in 30 days
(51 Reviews)
5.1
templecityteck

Hello, We are Experts in SQL [url removed, login to view] have 9+ Yrs of experienced in .NET /PHP [url removed, login to view] did 200+ Web /Desktop [url removed, login to view]

$1500 USD in 30 days
(5 Reviews)
4.9
msbatechie

Please read my PM

$3000 USD in 30 days
(2 Reviews)
3.7
imszone

Hi, I will send you a private message shortly with some specs.

$1500 USD in 30 days
(2 Reviews)
1.8
SystemFramworkSG

Kindly Check Your PMB Thanks Alex Grey

$4000 USD in 22 days
(1 Review)
1.0
bitshop

Bid is to advice on this and setup, see PMB for errors in your details - I'm a previous IIS and ASP MVP.

$1500 USD in 1 day
(0 Reviews)
0.0
bobikar

Hi, I have certified web application developer, web software developer, designers, multimedia, flash and SEO professionals. I run my own freelance business in Kolkata and have 5 years of experience in web development r More

$1500 USD in 15 days
(0 Reviews)
0.0
alansepe

i'm into 12 yrs of solid software development and system analysis and window server 2003 administration and able to setup and configure mirroring sql server with in 5 days

$2000 USD in 5 days
(0 Reviews)
0.0
vyasinfosys

Dear sir, How are you doing! We have more than 10 years of experience in website designing. We are able to complete this project in the limited time period and with the superiority. Looking for a positive re More

$2000 USD in 20 days
(1 Review)
0.0
mcdbaspecialist

Hello Watch Inbox

$3000 USD in 26 days
(0 Reviews)
0.0
makahar

We 12+ years of experience doing similar projects. We have three options to do it: Option A: Using a third party solution like VMware failover or Double take failover. This will not allow load balancing. This will c More

$5000 USD in 15 days
(0 Reviews)
0.0
vocati

I have spent the last 20 years in the telcommunications and datacenter technologies and worked for Microsoft in their High Availability systems group for many years. I have set the environment that you described up fo More

$2850 USD in 3 days
(0 Reviews)
0.0
sankochk

I am a technocrat with over 3.5+ years of varied IT experience encompasses: Application support, Virtualization architect, Data Centre architect, SQL Server Admin, Web Analytics, Usability analysis, High-Volume Web Sit More

$2900 USD in 30 days
(0 Reviews)
0.0
bvodithala

Thoroughly experienced for more than 3½ years in design, development and implementation of software applications using VB.Net, ASP.Net, MTS and .Net Framework, XML, ADO, [url removed, login to view], HTML, DHTML, IIS, SQL, Oracle and SQL S More

$1500 USD in 60 days
(0 Reviews)
0.0