Database Reliability Engineer (DBRE) - PostgreSQL

About the Company

Cover Genius is a Series E Insurtech that protects the global customers of the world’s largest digital companies including Booking Holdings, owner of Priceline, Kayak and , Intuit, Hopper, Skyscanner, Ryanair, Turkish Airlines, Descartes Ship Rush, Zip and Seat Geek. We’re also available at Amazon, Flipkart, eBay, Wayfair and SE Asia’s largest company, Shopee. Our partners integrate with XCover, our award-winning insurance distribution platform, to embed protection for millions of customers worldwide each year.

Our team and products have been recognized with dozens of awards including by the Financial Times who ranked Cover Genius as the #1 fastest growing company in APAC in 2020. Our diverse team across 20+ countries and many language groups commits itself to diverse cultural programs, in particular “CG Gives” which makes social entrepreneurs out of us all and funds development initiatives in global communities.

Our People are Bold, Authentic, Purposeful and Inspired.

Our People are not Perfect, Traditional, Complacent or Cautious.

About the Role

As a Database Reliability Engineer (DBRE) on our Technology Team, your primary purpose will be to ensure the seamless and secure functioning of the data stores which support our platform. As a DBRE you will help design solutions for large scale engineering challenges such as how to support multi-regional scaling and data sovereignty requirements.

To drive success in this role, you will have a strong background in site reliability engineering and database administration, with experience working with various data storage technologies in a public cloud environment. You should possess excellent problem-solving skills, a keen attention to detail, and a proactive approach to identifying and mitigating potential issues.

As a specialist you will primarily work alongside the Site Reliability team as well as providing expertise to application and data teams on database architecture and performance optimization. DBREs work to improve the following aspects of Cover Genius databases and data stores:

• Reliability
• Availability
• Performance
• Disaster Recovery
• Automation
• Security

Along with SREs, DBREs are responsible for writing and maintaining datastore related technical documentation such as tutorials, guides, runbooks and blameless post-mortems.

Key Responsibilities:

• Assist application teams to select and optimize datastore architectures and technologies
• Assist application teams to optimize queries, migrations and perform other datastore performance tuning
• Implement automation and reduce toil for datastore management
• Deployment, upgrade and maintenance of data stores
• Troubleshoot database related production incidents (On Call)
• Develop, test and maintain disaster recovery procedures for data stores
• Implement monitoring and alerting using key database metrics
• Develop and maintain troubleshooting documentation / runbooks
• Optimize and control costs of the company’s storage infrastructure
• Creating and refining SLOs for data stores

What you will bring:

• At least 5 years experience running major database technologies in production, especially PostgreSQL and MySQL. Experienced running these technologies in cloud environments ideally AWS RDS.
• Understanding of SRE Principles and best practices
• Experience operating other NoSQL data stores and cache technologies especially Elasticsearch, Redis, S3, DynamoDB, Bigquery and RabbitMQ.
• Excellent understanding of SQL and SQL database performance optimization
• Comfortable scripting & developing internal tooling with Bash or at least one programming language (e.g. Python, Go)
• Familiar with internals of PostgreSQL
• Experience working with infrastructure & configuration as code tools especially Terraform
• Experience working with Linux
• Solid theoretical understanding of underlying data-storage technologies and tradeoffs
• Good knowledge of AWS and/or GCP platforms and associated best practices
• Bachelor Degree in Computer Science/Engineering or equivalent practical experience

What you will have:

• Strong communication and documentation skills
• Curious and self motivated learner
• Professional approach
• Good team member
• Organizational and time management skills
• Excellent…