DBA Database Administrator

This job has now expired please search on the home page to find live IT Jobs.

Database administrator - DBA - Postgres database administrator - Postgres DBA - PostgreSQL DBA - SQL DBA

Skills: DBA - Postgres - PostgreSQL - MySQL - MS SQL - SQL - SQL Server

Role

A database administrator position has been created for an individual who is looking for great job satisfaction. In addition the role is ideal for a database administrator who enjoys working with database, running queries, and optimising the queries.

Working alongside the development team, you will enhance with the delivery of crucial information that is held within an innovative technical product that benefits a great cause. As a result great job satisfaction will be gained from this role as your work will make a positive impact and difference to people's lives.

Your work will focus involve handling and processing raw data. 24 hours a day, large amounts of data are loaded onto the server. Therefore you will be working with databases, specifically PostgreSQL and SQL Server.

The role will involve and therefore require the below skills and experiences:

* PostgreSQL (ideally enterprise level). Alternatively MySQL or SQL Server

* Query Optimisation, understanding query planner

* Common Table Expressions

* Window Functions (LAG, LEAD etc)

* Views

* Functions and Stored Procedures

* Writing queries, dissecting queries making improvements to the speed

* Look for trends and patterns

* Sequential scans

* SQL processing

* Work with Linux servers - load balancing (except ubuntu)