Company Description
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 developing, 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 our software-based technology solution that is deployed and maintained in clients’ and our own environments. You will employ best practices in areas such as change control, security, performance tuning, health monitoring 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. You will also be involved in software development activities, ensuring that our database infrastructure fits seamlessly into our overall software solution.
Team Summary
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
· Develop our databases and the systems around them to fit within our wider data transformation software solution; working closely with other developers and teams
· 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 Digital estate (data transformation software solutions)
· 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 and Experience
Required
· Experience of database administration in PostgreSQL and at least one NoSQL database in an production 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
Additional Information
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 Staff and 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.