Database Reliability Engineer

Database Reliability Engineer (DBRE)

SRE is responsible for the reliability of our SaaS offerings. This team works with product development to define our Service Level Objectives and performs the work required to ensure we meet those SLOs. These teams employ agile and lean principles in a culture of constant learning and improving.

This role is to join a newly created site reliability team, working within the existing corporate systems reliability team, specifically to support the Software Monetization business unit. The business is about to make the transition from a hosted environment to AWS.

As a Database Reliability Engineer, you will be tasked with automating every aspect of datastore management. You will own the existing database systems including MS SQL, PostgreSQL, and cloud services such as Amazon RDS. You will automate the mundane, and design, implement, and optimize the future.

Some of the technologies we use include:

- SQL Server

- PostgreSQL

- Amazon Aurora

- AWS Knowledge

Exploring things, technically competent

Good communication skills, Sri Lanka, Europe, UK, USA

Shouldn't be speaking too fast.

India time zone (Chances to work for maintenance-related work during weekends, Stretch to time late evenings at times)

AWS, Terraform, Postgres, SQL Server**

Responsibilities:

- Strong experience and expertise in core concepts of DBMS and administration of both PostgreSQL (on-premises and AWS) and MS SQL Server.

- Proficiency in PostgreSQL administration, including knowledge of RDS PostgreSQL, database internals, backups, and replications.

- Hands-on experience in PostgreSQL performance tuning.

- Proficient in PostgreSQL programming language.

- Solid understanding of MS SQL Server administration, including Performance Tuning and Optimization.

- Extensive knowledge of SQL Server backups, restore operations, recovery models, and indexing.

- Strong familiarity with High Availability (HA) and Disaster Recovery (DR) options for SQL Server, such as Always On, Replication, and log-shipping.

- Self-motivated and proactive, demonstrating initiative in problem-solving and troubleshooting.

- Excellent communication skills to effectively collaborate with team members and stakeholders.

- Highly organized with the ability to manage multiple tasks and prioritize effectively.

Minimum Qualifications:

- Computer Science degree or related qualification

- 8+ years of experience

Critical Skills / Competencies:

- Extensive experience in a DBA or Database Engineer position supporting mission-critical databases.

- MS SQL Server experience

- Experience with automation tools (Terraform, Packer & Docker)

- Experience with AWS

- Strong conflict resolution competence

- Excellent written and verbal communication skills

- Experience implementing fault detection

- Experience designing scalable services

- Experience designing distributed, fault-tolerant systems

- Experience with database migration tools (Liquibase, FlywayDB, SQLAlchemy, Active Record Migrations)

Bonus Skills:

- PostgreSQL, Informix, Elasticsearch

- Powershell

- Linux system administration experience