Senior Database Engineer & Architect (SQL)
Senior Database Engineer & Architect (SQL)
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Job description
As a Senior Database Engineer & Architect (SQL) you will play a key role in designing optimizing and scaling our database infrastructure. You will collaborate closely with engineers data analysts and product teams to improve the current database architecture and build new high-performance scalable and secure databases tailored to our business needs.
Design develop and optimize highly scalable database architectures with a focus on PostgreSQL.
Lead the migration optimization and restructuring of existing databases to ensure efficiency and scalability.
Implement and enforce database best practices including indexing partitioning query optimization and normalization.
Define and execute high-availability and disaster recovery strategies.
Develop and maintain ETL pipelines and data processing workflows.
Work closely with engineering teams to ensure efficient database schema design and support the development of new features.
Monitor and troubleshoot database performance identifying and resolving bottlenecks.
Ensure data security and compliance with industry standards implementing encryption access control and auditing policies.
Optimize stored procedures triggers and functions for maximum efficiency.
Technology Stack:
Database: PostgreSQL (Primary) AWS RDS SQL.
Big Data & ETL: Apache Kafka Airflow dbt Snowflake (nice to have).
Performance Optimization: Indexing Partitioning Query Optimization Caching.
Security: Data Encryption Role-Based Access Control (RBAC) Auditing.
Tools & DevOps: Liquibase Flyway Terraform Kubernetes (for DB management).
Scripting & Programming: SQL PL/pgSQL Python Bash.
Methodologies: Agile Scrum.
What Twisto can offer:
A place to grow and do meaningful work - We support you in developing your skills taking ownership of your projects and sharing ideas that improve the way we work.
Friendly and open culture - No dress codes no bureaucracy. Were a close-knit collaborative team that values transparency and agility.
Work where it suits you - Whether you prefer the office remote work or something in between were flexible.
Time for work time for life - Our 37.5-hour workweek helps you keep a healthy balance and energy for what matters outside of work.
Benefits youll actually use - MultiSport card fresh fruit in the office regular team events and at least 5 weeks of vacation per year etc.
Be part of something exciting - Twisto is growing in Europe and your work will directly contribute to that journey .
Job requirements
5 years of experience as a Database Developer or Database Architect focusing on PostgreSQL.
Proven expertise in designing optimizing and managing large-scale high-performance databases.
Strong knowledge of AWS database services (RDS Aurora EC2-based PostgreSQL instances) and on-premise PostgreSQL deployments.
Experience implementing HA (High Availability) & replication strategies (e.g. Patroni PgBouncer Streaming Replication).
Deep understanding of query optimization partitioning indexing caching and concurrency control.
Proficiency in backup/recovery strategies and disaster recovery planning.
Hands-on experience with CI/CD pipelines and Infrastructure as Code tools like Terraform Ansible or AWS CloudFormation.
Experience in database security ETL pipelines and data warehousing.
Proficiency in SQL PL/pgSQL and scripting languages like Python or Bash for automation.
Familiarity with monitoring and alerting tools (AWS CloudWatch Prometheus Grafana Datadog).
Excellent English communication skills with the ability to collaborate effectively with both technical and non-technical teams.
- Prague Praha Hlavn msto Czechia
- Warsaw Mazowieckie Poland
All done!
Your application has been successfully submitted!
Required Experience:
Senior IC
Employment Type
Full-Time
