Description

What you'll be doing

• Database Administration: Install, configure, and maintain relational database systems (e.g., PostgreSQL, MySQL, Oracle), ensuring data availability, performance, and security.
• Elasticsearch Administration: Set up and manage Elasticsearch clusters, optimizing performance and handling indexing and query tuning to meet the needs of high-volume data applications.
• Data Security and Integrity: Implement robust security protocols and regular backup/restore procedures to safeguard data integrity across all managed systems.
• Performance Monitoring and Optimization: Regularly monitor database and Elasticsearch environments, applying tuning techniques to ensure optimal performance.
• Data Modelling and Indexing: Collaborate with development teams to design efficient data models, implement indexing strategies, and optimize database queries.
• Incident Response and Troubleshooting: Quickly diagnose and resolve database and Elasticsearch issues, providing on-call support as necessary.
• Documentation and Compliance: Maintain comprehensive documentation on all database and Elasticsearch configurations, procedures, and policies, ensuring compliance with regulatory requirements.
• Automation and Scripting: Develop scripts to automate routine tasks, improving the efficiency of database and Elasticsearch maintenance processes.

Do you have what it takes?

• Bachelor’s degree in computer science, Information Technology, or a related field.
• 4+ years of experience in database administration, including relational database management.
• 2+ years of hands-on experience managing Elasticsearch clusters in a production environment.
• Proficiency in SQL and NoSQL database technologies, along with a solid understanding of data indexing and search optimization in Elasticsearch.
• Familiarity with monitoring tools such as Grafana, Kibana, or Prometheus for database and Elasticsearch environments.
• Experience with data backup, disaster recovery, and high-availability strategies.
• Knowledge of security best practices and data privacy regulations.
• Proficiency in scripting languages (e.g., Python, Bash) for task automation.
• Strong analytical and troubleshooting skills, with attention to detail.

• Experience with cloud-based databases (e.g., AWS RDS, Google Cloud SQL) and Elasticsearch service offerings.
• Familiarity with containerization (Docker) and orchestration tools (Kubernetes) for deployment and scaling.
• Prior experience with big data environments or data pipeline management is a plus.
• Relevant certifications in database management or Elasticsearch administration.

Why Napier?

• Group life assurance policy
• Income protections policy
• Access to our employee wellbeing programme
• An extra day off to celebrate your birthday
• Enhanced Maternity & Paternity leave
• An open and flexible culture that allows you to work in the best way for you
• Private health and dental insurance