Position: Database Engineer
Company: Svitla Systems, Inc.
Category: SQL
Experience required: 3y
English level: upper
Published: 2023-04-01T00:00:00+03:00

As a Database Engineer on this project, you will ensure that our databases are performant, reliable, scalable, and automated. You will be overseeing more than 100 databases, almost all of which are Postgres, but also having a hand in the success of the project's expanded use of AWS managed services (such as DynamoDB, Elasticsearch, and Redshift, etc.). Partnering with product team engineers across a great variety of use cases, you will analyze the performance of databases and systems to provide optimizations and partner with product engineers on query tuning to help us keep scaling safely. 

Requirements:
● 3+ years of experience working with PostgreSQL 9.6+
● Experience building and maintaining mission-critical production PostgreSQL databases
● Solid understanding of PostgreSQL database architecture (locking, consistency, transaction logging, etc)
● AWS managed services experience (Aurora, etc.)
● Experience with high-availability, backup and recovery solutions and strategies
● Advanced knowledge of query tuning and optimization techniques
● Experience provisioning PostgreSQL databases in AWS with tools like Terraform, CloudFormation, Ansible
● Experience with monitoring and logging tools like Datadog, New Relic, Sumo Logic
● Experience with other databases like DynamoDB, Redshift, Elasticsearch, Snowflake is a plus

Responsibilities:
● Design and implement high availability database architecture in AWS
● Partner with developers and SREs to build and automate the provisioning of new infrastructure
● Continuously monitor and improve database performance via query and index tuning, schema updates, partitioning, etc.
● Collaborate with developers to tune and optimize database queries
● Work with our Data and ML teams on Kafka and Snowflake integrations and data flows from our main DBs
● Plan and execute disaster recovery scenarios
● Build dashboards for database health and alerting
● Perform Terraform deployments of database instances, users, groups, and permissions
● Manage database upgrades and migrations with minimal to zero-downtime
● Take on-call duty to respond to production incidents