As a Database Engineer, your main activities will consist of:

• Administration and troubleshooting of Database systems, from development to mission-critical production systems running on Oracle, MySQL, PostgreSQL and InfluxDB database engine.
• Database administration of other database technologies of interest for the High Energy Physics community.
• Configuration and support of database platforms: architecture and design, evolution, scaling, migration, upgrade and patching.
• Proactively monitoring database environments to ensure optimum performance, improve throughput, stability and security of the database platform.
• Providing technical expertise to application development teams. Encouraging accepted best practice and work towards resolving issues and performance concerns.
• Development of database related software automation following group guidelines and project needs.
• Sharing domain and technical expertise, providing technical mentorship and training to peers.

Experience

The successful candidate should have demonstrated experience in following fields:

• Operation of large scale production database environments.
• Technical and troubleshooting skills with relational databases running on Oracle, PostgreSQL and/or MySQL.
• Performance tuning, query optimisation, replication techniques, clustering, partitioning and security issues.
• Database backup, restore and recovery.
• SQL knowledge with ability to write and troubleshoot SQL code (stored procedures, functions, tables, indexes, constraints).

Additional experience in following fields would be an asset:

• Knowledge of High Availability and Disaster Recovery solutions for Oracle, PostgreSQL and/or MySQL.
• Database operations experience in an Agile development environment - Exposure to puppet configuration management.
• Administration of Linux based Operating systems
• Experience with containerisation technology, e.g. Kubernetes

Technical competencies

• Administration of databases: familiarity with large-scale and high-availability database environments.
• Knowledge of operating systems: such as Linux, knowledge of enterprise storage management (SAN or NAS) would be an asset.
• Knowledge of programming techniques and languages: SQL knowledge is required. UNIX shell script or Python programming would be an advantage.
• Capturing and analysis of requirements for ICT systems: ability to collect the needs of users and to manage the different phases of a project.
• Architecture and design of ICT systems: ability to design systems that fulfil the requirements and can be maintained efficiently.

Please contact Miroslav Potocky for more information.