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

Defining autonomous transactions, Defining Autonomous Transactions To ...

Defining Autonomous Transactions To define an autonomous transaction, you use the pragma (compiler directive) AUTONOMOUS_TRANSACTION. The pragma instructs the PL/SQL compiler

Updating variables, Updating Variables For assignment, SQL uses the ke...

Updating Variables For assignment, SQL uses the key word SET, as in SET X = X + 1 (read as "set X equal to X+1") rather than X: = X + 1 as found in many computer languages.

Advantages of invoker rights, Advantages of Invoker Rights The Invoker-...

Advantages of Invoker Rights The Invoker-rights routines centralize the data retrieval. They are particularly helpful in applications which store data in various schemas. In su

Write a program, to write a heap sort program usin pl-sql

to write a heap sort program usin pl-sql

Execute immediate statement - syntax, EXECUTE IMMEDIATE Statement   Th...

EXECUTE IMMEDIATE Statement   The EXECUTE IMMEDIATE statement prepare (parses) and instantly executes a dynamic SQL statement or an anonymous PL/SQL block. Syntax:

Use the pls_integer datatype - performance of application, Use the PLS_INTE...

Use the PLS_INTEGER Datatype When you require to declare an integer variable, use the datatype PLS_INTEGER that is the most efficient numeric type. That is as the PLS_INTEGER

Substitution and instantiation - sql, Substitution and Instantiation - SQL ...

Substitution and Instantiation - SQL It shows how NULL might appear in substitution for a parameter of a predicate and how it might thus participate in instantiation of that p

%isopen - implicit cursor attributes, %ISOPEN The Oracle closes the SQ...

%ISOPEN The Oracle closes the SQL cursor automatically after executing its related SQL statement. As a result, the %ISOPEN forever yields FALSE.

Differentiate between snowflake schema and star schema, Problem: (a) De...

Problem: (a) Define the following terms: (i) data mining. (ii) OLAP. (b) Differentiate between snowflake schema and star schema. Support your answer with appropriate

Oracle, Literature review

Literature review

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