Encerrado

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

Habilidades: .NET, DNS, SQL, Administrador do Sistema, Visual Basic

Ver mais: working vmware, web site event, web service contract, web pages scripts, vmware projects, visual web, sql server web, sql server price list, sql server dba projects, sql price, sql functions pdf, sql dba wanted, sites create web pages, site maintenance service, server scripts, server load test, quote web service, q email, project administrator job description, peak 10, notification utility, monthly service contract, microsoft sql server price, long web pages, location service google

Acerca do Empregador:
( 3 comentários ) Irvine, United States

ID do Projeto: #564508

16 freelancers estão ofertando em média $2391 para este trabalho

krishdts

please check PMB for details.

$1500 USD in 25 dias
(25 Comentários)
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 dias
(42 Comentários)
6.6
itamarjp

please check PM

$3000 USD in 30 dias
(51 Comentários)
5.1
templecityteck

Hello, We are Experts in SQL Server.We have 9+ Yrs of experienced in .NET /PHP Applications.We did 200+ Web /Desktop applications.Thanks

$1500 USD in 30 dias
(5 Comentários)
4.9
msbatechie

Please read my PM

$3000 USD in 30 dias
(2 Comentários)
3.7
imszone

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

$1500 USD in 30 dias
(2 Comentários)
1.8
SystemFramworkSG

Kindly Check Your PMB Thanks Alex Grey

$4000 USD in 22 dias
(1 Comentário)
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 em 1 dia
(0 Comentários)
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 Mais

$1500 USD in 15 dias
(0 Comentários)
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 dias
(0 Comentários)
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 Mais

$2000 USD in 20 dias
(1 Comentário)
0.0
mcdbaspecialist

Hello Watch Inbox

$3000 USD in 26 dias
(0 Comentários)
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 Mais

$5000 USD in 15 dias
(0 Comentários)
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 Mais

$2850 USD in 3 dias
(0 Comentários)
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 Mais

$2900 USD in 30 dias
(0 Comentários)
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, ADO.Net, HTML, DHTML, IIS, SQL, Oracle and SQL S Mais

$1500 USD in 60 dias
(0 Comentários)
0.0