Database Administrator - NoSQL / Oracle / DBA
Location: South Wales
My client is a digital media technology giant based in South Wales and they are currently seeking a Database Administrator - DBA, to provide support for the traditional Oracle Relational databases and their NoSQL database platforms. As DBA you will be responsible for all phases of database administration on their production and development environments, with emphasis on performance troubleshooting, database tuning, analytical problem solving and business customer support.
The successful DBA will:
*Install, configure and administer databases, including Oracle and Open source technologies like MongoDB, Hadoop, Cassandra and Neo4J
*Set-up and maintain databases in the development, test and production environments
*Work with development teams to ensure each application is fully covered in terms of backup and restore requirements as well as create and maintain software modules to support these processes
*Perform ongoing performance tuning, technology upgrades and system resource optimization.
*Develop prototypes and proof of concept solutions as required by the business to support future technology selection and to aid solution definition for future product lines
*Support developers in development oriented activities including scripting and analysis of implementation to ensure performance considerations are taken into account
*Support the Continuous Delivery process through required maintenance and updates of associated tooling (e,g Jenkins)
*Develop and maintain documentation for assigned projects including install guide, troubleshooting guide, etc.
As a DBA you will have:
*Proven, established and expert hands on DBA skills in at least one of the core database platforms used by the company
*Strong Experience in database disaster recovery planning and failover
*Ability to solve complex database administration problems
*Ability to work with database developers and engineers to analyse and resolve database performance issues Nexus, Puppet etc.)
*Experience and competency in Continuous Delivery and Deployment pipelines and associated tooling (Jenkins, Nexus, Puppet etc.)
*Knowledge of Relational Database Management Systems (RDBMS) concepts such as SQL, stored procedures, JDBC/ODBC drivers, tables, foreign keys, joins, normalization, etc.
*Knowledge of core NoSQL concepts and types (Key/Value, Document, Graph, Column).
*Strong Linux System Administration skills including experience in writing shell scripts and creating scheduled jobs.
*Experience and competency in at least one of the following scripting languages (Shell, Perl, Python).
It would be beneficial as the DBA to have experience with any of the following, although not essential:
*Knowledge of NoSQL Scaling and an understanding of HA strategies, including replica sets and sharding.
*Experience installing and configuring Real Application Clusters / Maximum Availability Architecture (MAA) solutions or clustering technologies to address high availability requirement.
*Knowledge of Cloud and Container based deployment architectures and technologies (OpenStack, AWS, Docker etc).
*Some knowledge and exposure to Java would be beneficial.
If you are a DBA with experience with Open Source technologies then get in touch with Simon Allen at IC Resources.
Keywords: MongoDB, Hadoop, Cassandra, Neo4J, NoSql, RDBMS, shell, perl python, Jenkins, nexus puppet, Wales, dba, database