Viridien (www.viridiengroup.com) is an advanced technology, digital and Earth data company that pushes the boundaries of science for a more prosperous and sustainable future. With our ingenuity, drive and deep curiosity we discover new insights, innovations, and solutions that efficiently and responsibly resolve complex natural resource, digital, energy transition and infrastructure challenges.
Job Summary
Viridien Data Hub are looking for an experienced and adaptable Database Administrator to join our growing team. The ideal candidate will be a self-starter who is passionate about supporting and scaling database infrastructure in both on-prem and cloud environments.
You will be building, maintaining and configuring a range of different database-based technologies such as PostgreSQL, Neo4j, Elastic and Qdrant databases in a distributed environment to support projects for our clients. You will employ best practices in areas such as change control, security, performance tuning and disaster recovery. Experience with Azure will be beneficial, as you will be involved in the deployment and ongoing management of these databases in Azure, as well as our on-premise environments.
About the Team
Data Hub is a growing and dynamic team of scientists and developers who love solving complex problems. We provide leading edge technology solutions and services to solve our clients' data transformation and analytics challenges across a range of industries including geothermal, environmental, hydrocarbon and mineral exploration.
You will be working in an open and collaborative environment with opportunities to learn, grow, and develop. We have an informal team culture and believe work should be fun and rewarding.
You can choose to be remote or hybrid in one of our hub locations (North Wales or Crawley) and you will be working alongside our teams of data engineers, machine learning engineers and software developers.
Key Responsibilities
* Act as the primary point of contact for database related tasks and incidents
* Respond to and prioritize critical incidents; occasionally this maybe be outside of regular working hours for critical projects
* Deploy, maintain, monitor and support relational and NoSQL databases across the Data Hub estate
* Develop and maintain monitoring and alerting solutions - together with other proactive techniques - to ensure database system health and resilience
* Ensure adequate system resilience through backups and disaster recovery processes
* System capacity management and scaling
* Manage users and roles and ensure security best practices
* Support the wider team with data modelling, query optimization and data migration tasks
* Interact with wider intercompany database teams to share and align on best practices, processes and governance
Qualifications:
Required:
* Experience of database administration in PostgreSQL and at least one NoSQL database in an enterprise environment
* Experience with High Availability: WAL archiving, streaming replication, patroni and associated components and extensions
* Ability to diagnose (and separate) OS, networking & database issues and to optimise SQL queries
* Linux administration/shell scripting
* A keen eye for process improvement in the context of managing a growing database estate
* Calm and confident under pressure
Preferred:
* Systems Administration background
* Neo4J, Elastic, Qdrant, redis and/or other NoSQL databases
* Geoserver
* Understanding of concurrency control (MVCC) and transaction isolation levels
* Database/schema design
* Microsoft Azure
* Automation & IaC: Kubernetes/Docker, Airflow, Terraform/Ansible
* Knowledge of SDLC and version control
UK Benefits Package:
* Highly attractive bonus scheme
* Initial 22 days annual leave with future increases, complemented by a flexible buying and selling holiday program
* Company contributory pension plan
* Flexible Private Medical & Dental care tailored to suit individual or family needs
* Employee Assistance Program to support our staff
We Care about our Environment
* We recognise the importance of work life balance for our employees, which is supported through our flexible working and relaxed dress code policies.
* We recognise and actively support the wellbeing of our staff through many different initiatives;
* Social club events, spontaneous reward events throughout the year
* Discounts schemes, including Gym membership and a cycle purchase scheme
* Discounts on nationwide restaurants, cinema tickets and days out through our benefits platform
* Tech, Travel and Fashion discounts available through our benefits platform
* We encourage and actively support a strong sense of community, through volunteering and various company initiatives, as well as a strong company commitment to protecting our environment through sustainable solutions, energy saving and waste reduction enterprises.
We see things differently. Diversity fuels our innovation, we value the unique ways in which we differ, and we are committed to equal employment opportunities for all professionals.