Principal DBOps
Job Description:
Recent research on global cryptocurrency adoption shows that global adoption has grown by over 2300% since Q3 2019 and over 881% since the last year. Because of this, we are going under hyper-growth and we’re expanding our teams to further grow and support more cryptos and products over our digital asset platform.
Since it’s a digital asset platform, we need to make sure the relational databases are highly reliable, secure, and available. We are looking for awesome Database Architects with a very strong engineering background having extensive experience in handling relational databases like Mysql/Psql.
If you love crypto, fintech and have a craze to make an impact on actual product performance, this is a place for you. You’ll be part of the infrastructure team working closely along the Devops/SRE and Data Team.
What you will be doing
Ensure our databases are properly instrumented, resilient and proactively monitored for various issues like DB Locks, temp file accumulation.
Partner with the Data engineering, product, and data teams to ensure our databases are appropriately provisioned to meet the growing needs of a rapidly expanding company keeping cost in mind.
DR/Backups: Make sure proper DB Backups are done on regular intervals, verifying data integrity, and also be able to be part of fire drills to see system resilience and keeping low MTTR.
Making sure DB replication at large scale from multiple sources (psql, mysql) to warehouse db (psql) are properly done with services like AWS DMS, Airbyte or various other tools.
Perform Managed database installations (RDS) using Terraform , configurations, upgrades (Parameter Groups), and migrations.
Help the Analytics team to optimize their slow running queries.
Monitor and analyze DB performance using Performance insights, PGBadger or various other tools.
Document Best practices and keeping record of database access to internal employees/applications.
Drive the adoption of observability practices and a data-driven mindset - You love metrics, graphs, and gaining a deep understanding of why things happen in a system/databases, helping others gain visibility into the things they build.
Who are you:
Demonstrated experience in database architecture in both managed and self-managed, keep operational best practices in relational databases.
Demonstrated experience in designing and implementing managed databases, data replication pipeline using DMS, RDS, Airbyte etc. as infrastructure as code through Terraform.
Demonstrated Experience in automation based on events in database like killing blocked queries running for a prolonged period of time.
Secrets management of DB users at scale using Cloud-native tools like Hashicorp Vault, AWS secrets manager.
Work closely with developers and devops/sre to improve SQL queries, indexes, joins and database structure.
Have extensive knowledge of maintaining DB access privileges (DB users/Roles)
Experience with configuring, customizing, and extending monitoring & logging tools (PGBadger, Cloudwatch, Grafana etc.).
Nice to have:
Experience managing Kafka, Airflow, Apache Spark, and other data-driven tools on k8s or similar architecture/managed solutions will be added advantage
Working knowledge of Kubernetes and its internals.
A must-have:
Passionate about reliability and security and solving complex challenges across the team and organization.
Strong analytical mind and a problem-solver.
Good knowledge of English - Communicable level.
Thrive to think outside the box, innovate and differentiate
A self-starter with exceptional interpersonal skills.
Perks:
Highly competitive salary in SE Asia
Flexible working hours remote from beaches and coffee shops. : )
Health & dental insurance
A brand new MacBook Pro M1.
Required Skills:
Managing Graphs Spark Data Adoption Data Integrity Logging Support Performance Architects Kubernetes Reliability DevOps Apache Metrics Interpersonal Skills Developers Analytics Architecture Automation Infrastructure Salary Insurance Databases Security MySQL Research SQL Engineering English Management