Database Reliability Engineer (DBRE) - PostgreSQL
About The Position
As a Database Reliability Engineer (DBRE) on our Technology Team, your primary purpose will be to ensure the seamless and secure functioning of the datastores 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 datastores: 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.
Requirements
- 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 datastores 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
Nice To Haves
- Strong communication and documentation skills
- Curious and self motivated learner
- Professional approach
- Good team member
- Organizational and time management skills
- Excellent attention to detail
- Positive approach to change
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 datastores
- Troubleshoot database related production incidents (On Call)
- Develop, test and maintain disaster recovery procedures for datastores
- 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 datastores
Benefits
- Flexible Work Environment - our teams are hybrid. We work from home on Wednesdays and Thursday and attend the office on Monday, Tuesday and Friday with flexibility around start/finish times.
- Wellness day a month.
- Employee Stock Options
- CG Gives programs enables us to all become philanthropists through our peer recognition and rewards system.
- Social Initiatives
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
