Full time system administrator, PL-SQL Programming

Assignment Help:

Need Windows and Linux system Administrator

We are seeking a part time system administrator to take care of our servers.

Your things to do would add, but not limited to:

- Monitor server uptime (whatever or pingdom you want)

- Take action when a server is down

- Maintaining our Linux haproxy load balancer

- Maintain our Windows 2012 webserver, this adds:

 Setting up new websites (IIS) with FTP

 Preparing login credentials for partners we work with (per site)

 Backup websites

Ensure our databases keep running

 Backup databases (MySQL, SQL Server Express)

 Install SSL certificates

- Maintain installed on our servers

- Prepare and configure new VM

 VM's are configured to connect to off-location VPN's. You will want to setup firewall rules to allow permanent remote desktop connections even when the VM is dialed to a VPN

Setup remote desktop on different ports so partners can dial in directly.

The infrastructure is pretty much set and running, installing and maintaining new VM's, websites and setting up backups would be the first tasks to do. While bidding, please put in the description which version of powershell is added in windows 2012 r2.

You need to be managed, and work from a shared directory (if possible our office365 SharePoint) to save credentials and data.

Skills required are Apache, MySQL, IIS, SQL, Windows Server


Related Discussions:- Full time system administrator

%rowtype - cursors, %ROWTYPE: This attribute gives a record type which ...

%ROWTYPE: This attribute gives a record type which represents a row in the database table or a row fetched from a formerly declared cursor. The Fields in the record and corresp

Rowid - sql pseudocolumns, ROWID The ROWID returns the rowid (binary a...

ROWID The ROWID returns the rowid (binary address) of a row in the database table. You can use the variables of the type UROWID to store rowids in a readable format. In the il

%notfound - explicit cursor attributes, %NOTFOUND The %NOTFOUND is log...

%NOTFOUND The %NOTFOUND is logical, opposite of the %FOUND. The %NOTFOUND yields FALSE if the last fetch returned a row, or TRUE when the final fetch failed to return a row. I

Comparison operators- pl/sql, Comparison Operators The Comparison operat...

Comparison Operators The Comparison operators can compare one expression to another. The outcome is always true, false, or null. Usually, you use a comparison operators in condi

Example of delete - sql, Example of DELETE - SQL As with UPDATE, a FOR...

Example of DELETE - SQL As with UPDATE, a FOR PORTION OF clause can be specified if the target table has a defined period name, as illustrated in Example. Example: Deleting

EXCEPTION handling, set serveroutput on declare a number(5); b numb...

set serveroutput on declare a number(5); b number(5); c number(5); begin a:=&a; b:=&b; c:=a/b; dbms_output.put_line(c); exception when zero_divide then d

Using %rowtype-declarations in sql, Using %ROWTYPE The %ROWTYPE attribut...

Using %ROWTYPE The %ROWTYPE attribute gives a record type which represents a row in a table (or view). The record can store the whole row of data selected from the table or fetc

Write sql queries, Write SQL queries to solve the following specifications....

Write SQL queries to solve the following specifications. Include the query AND THE OUTPUT.  A screen dump of the output is acceptable. Show as many rows as you can. A screen dump i

Example of alternative formulation as a table constraint, Example of Altern...

Example of Alternative formulation as a table constraint Example: Alternative formulation as a table constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Must_be_enrolled_to_

Product-specific packages, Product-specific Packages The Oracle and dif...

Product-specific Packages The Oracle and different Oracle tools are supplied with the product-specific packages which help you to build the PL/SQL-based applications. For illus

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd