- Assess database schemas and DDL for gaps and improvements
- Analyze and optimize long-running queries and workloads
- Partner with DBAs to assess Greenplum cluster and tune performance
- Establish governance for SQL code reviews and best practices
- Lead database capacity planning and scalability strategy
- Participate in Data Modeling of a modern centralized Data Models and architecture for datastreaming, ingestion and API scalability
- Support and evaluate the state of ETL/ELT optimization and integration with MPP platforms
- Ensure database design aligns with security, governance, and compliance
- Drive Greenplum to Redshift migration POCs, including performance benchmarking
- Strong expertise in Greenplum performance tuning and MPP optimization
- Hands-on experience with AWS Redshift design and migration
- Proven track record in query optimization and remediation
- Strong SQL, indexing, and schema design skills
- Experience with ETL/ELT pipelines and cloud-native integrations (e.g., Kafka, S3)
- Knowledge of database monitoring, governance, and compliance best practices
- Knowledge of PostgreSQL and integration patterns with Data Warehouses
Nice-to-Have experience with Snowflake, familiarity with Informatica, Glue, modern ETL tools and Batch orchestration, scripting skills (Python/Scala/Java) for automation
Vention is a global engineering partner to tech leaders and fast-growing startups, combining 20+ years of product development expertise with an AI-first approach and a reputation for reliable delivery.
With 150+ data engineers and over 20 years of experience, we help startups and enterprises turn data into smart decisions and better user experiences. Our teams work with Python, Java, Scala, and R to build scalable data pipelines and infrastructure that power real results.
Our culture is rooted in the belief that ongoing growth benefits employees and the company alike. Because of that, we offer:
- An individualized approach to career development, tailoring growth plans to every role
- Access to our technology mentorship program as a mentor or mentee
- The opportunity to contribute to up to 300 original projects in 30 different fields
And that's not all! We also offer:
- Expanded medical support for employees in Almaty
- 19 working days of vacation per year, 21 after two years with the company
- Access to 700+ gyms via 1 Fit membership
- Сonferences & meetups, organized by our company
- Support for the significant events in your life
- Access to discounts across a variety of stores, restaurants & cafes through a corporate discount program
- And referral bonuses
Engineer your success!