Database Administrator

Database Administrator

Location:

The DBA will have overall responsibility for the uptime of our platform databases. You will work closely with Engineers and QAs and DevOps to help design, build and maintain a highly performant database architecture. You will be responsible for defining, producing and maintaining key database metrics.

Roles and Responsibilities:

• Responsible for the uptime and performance of the database infrastructure
• Capacity planning - ensuring storage is sufficient for future needs
• Performance tuning - providing advice to Engineers to ensure schemas and

queries are designed to support low latency

• Monitoring - ensure databases are monitored 24x7 and preventative action is taken to remedy any detected issues
• Contribute to output from slow running performance tests to suggest improvements
• Installing and applying upgrades and patches, ensuring databases are up to date and adhere our upgrade policies
• Ensuring replication is in sync
• Providing appropriate documentation for key business databases, including details of the underlying infrastructure and configuration settings
• Planning and implementing backup, recovery and high availability of PostgreSQL databases
• Configure and maintain resources on AWS
• Contribute to the data retention and archiving policy
• Maintain infrastructure using Terraform, Ansible, Kubernetes (helm) and Jenkins
• Implement monitoring and automation where needed to proactively prevent issues and improve uptime
• Ensure infrastructure adheres to the companys security requirements
• Participate in on-call rotation to provide 24/7 support of hosting infrastructure
• Use ticket management system such as Jira to manage work priorities

This may be the right role for you if you have.

• 10 years+ of RDBMS, with good working knowledge of PostgreSQL
• In-depth knowledge of query optimizing techniques to assist with performance and scalability
• Technical diagnostic expertise including database failure investigation, reproduction, and resolution skills
• Experience with database administration in cloud environments (AWS)
• Deep understanding of the Linux operating system, with Ubuntu experience is a plus
• Understanding of Java and Hibernate
• Strong understanding of hosting and resource management (CPU, memory, storage, security, networking, I/O etc.)
• Hands-on experience with configuring and maintaining resources on AWS
• Knowledge of networking fundamentals
• Experience with and a strong understanding of security best practices
• Strong familiarity with Java/Spring Boot and PostgreSQL database stack
• Experience with Atlassian tooling including Jira and Confluence
• Strong written and verbal communication skills
• A degree in Computer Science, or a related subject is beneficial