Database Administrator (PostgreSQL)

Ключевые навыки

Coins is looking for experienced Database Administrator across the stack to join our rapidly scaling FinTech company.

We are a product oriented company from Philippines.
Our main product is an electronic payment service and e-wallet for users from South Asian countries(for example, Philippines, Thailand, Malaysia).
Our product helps people to open access to financial tools in a complicated bank system situation.
Through our wallet users can send money anyone, pay for subscriptions, receive money transfers from 200+ countries and lands even without bank account.

WHO WE ARE LOOKING FOR
We are actively looking for the best DBA who have the following experience and skills:

• Postgres API and internal implementation understanding
• Maintaining backup solutions: backups and check backup automatization.
• Understanding how to build reliable clusters with physical or logical replication
• Query analysis and optimization
• Experience in any automation tools or approaches

GOOD TO HAVE

• Work experience with AWS RDS
• Skills to write some code to fulfil DBA team needs (bash, python, go, lua)
• Docker and related technologies (Kubernetes, docker compose, etc )
• Infrastructure as a code(AWS CloudFormation, Terraform, etc)
• Configuration as a code and automation tools(Ansible, Chef, Puppet, etc)
• Common infrastructure and platform tools: Prometheus, Grafana, others
• C programming language. Able to look issue deep though source code
• Knowledge of other RDBMS (Mysql, Oracle) and noSQL DBMS (Mongo, Couchbase)

THINGS TO DO

• Administration of PostgreSQL databases throughout the development and production lifecycles (cluster creation, maintenance, configuration)
• Design and develop logical and physical database designs from customer requirements
• Provide advice and support to development resources - close work with dev teams base on designed guidelines, code review, support
• Provide guidance in the creation and modification of standards and procedures
• Automation of standard operating procedures (configuration change, failover, failback)
• Support the current standards, policies and procedures of the customer team
• Provide mentorship to group members and help develop and support mid and junior level staff
• Training engineering team. PostgreSQL best practices, things to avoid, etc.
• Design and implement backup strategies with fixed RTO/RPO, automation for recovery, backup tests, disaster recovery plan
• Clustering of current and new DB instances, expected availability over consistency or consistency over availability (CAP trade off), partitioning, tablespaces
• Data lake and DWH integration support and optimization
• Access management implementation: security-ops strategies, audit tools
• Developing satellite tools for monitoring, alerting

WE OFFER

• To be an important part of the development of a cool asian mobile application
• Team with professionals. Our guys are the best at their work
• Career and professional growth. It means that we invest time and money in your career(IT conferences, courses, training, software - all that you need for good work)
• You can be sure that in our company a warm welcome awaits you. Our HR Team and your Team Leader can help you to be a part of Coins
• Remote work. You may work from home or the beach. No matter. The main thing is the result
• We pay for your and your family medical insurance, for coworking and your business trips to our headquarter in Manila