**About our customer**
In most of the cases, we work with contractor dynamic, USD payment, and remote positions. And in all of the cases, your contract will be through a Software Factory.
This is a general job description, we will consider your experience and contact you in case to move forward and talk about the best match for you, considering your background, expectations and the caracteristics of our clients.
Can't wait to get to know you!
**Job Summary**
We are seeking an experienced Database Developer to join our team. As a Database Developer, you will be responsible for supporting and developing queries, creating tables, constraints, indexes, and optimizing query performance. If you have a strong background in database development, experience with complex queries, query optimization techniques, and knowledge of PL/pgSQL and AWS technologies, we would love to hear from you.
**Responsibilities**:
- Creating tables, constraints, indexes, and other database objects.
- Developing complex queries using advanced SQL techniques such as outer joins, common table expressions (CTEs), window functions, and subqueries.(like Outer joins ,Common Table Expressions, Window functions, Subqueries)
- Optimizing query performance through techniques like explain plan analysis, indexing strategies, test harnesses for benchmarking queries, and identifying wait events. (Explain plan, Indexing, Test harnesses, Wait events)
- Implementing partitioning strategies for large datasets to improve query performance.
- Utilizing materialized views for pre-aggregated or frequently accessed data.
- Assisting with data migrations between different database systems or versions.
**Basic Qualifications**
- Strong expertise in PL/pgSQL programming language for PostgreSQL databases.
- Experience working with AWS cloud services related to databases (e.g., Aurora RDS).
**Nice to Have Skills**
- Familiarity with the Aurora RDS console for managing PostgreSQL databases on AWS.