Associate Database Engineer

About the role

As an Associate Database Engineer (DBE), you will support the maintenance, monitoring, and optimization of the organization's relational database systems. Working alongside experienced engineers, you will help ensure the integrity, availability, security, and performance of critical data that supports business operations. You will collaborate with IT teams and developers to troubleshoot database issues, perform routine maintenance, and contribute to database improvements. This role offers an opportunity to develop practical skills in PostgreSQL and SQL Server database management systems hosted in AWS, particularly Amazon RDS. The ideal candidate will have a basic understanding of relational databases, good problem-solving skills, and a willingness to learn and grow in a collaborative engineering environment.

This is an Associate level role. The salary is up to 11K PLN gross per month

What will you be doing?

• Assist in developing and maintaining database schemas, tables, and indexes while following established standards and best practices.
• Support database security measures, including user access management, permissions, and data protection.
• Monitor database health and performance using existing monitoring tools. Identify potential issues, analyze basic performance metrics, and escalate complex problems to experienced engineers.
• Assist in troubleshooting database issues such as slow queries, database locks, and resource contention under the guidance of senior team members.
• Support database performance optimization through basic query tuning, index maintenance, and analysis of query execution plans.
• Write, maintain, and troubleshoot SQL queries and stored procedures to efficiently retrieve and manipulate data.
• Assist in configuring and maintaining database replication, high availability, and failover mechanisms to ensure data availability and reliability.
• Participate in code reviews to learn and apply database best practices, performance guidelines, and data access patterns.
• Collaborate with software developers to understand application requirements and support database schema design and development activities.
• Work with application developers to identify and resolve database-related issues, including inefficient queries and data access patterns.
• Perform routine database maintenance tasks, including monitoring database health, reviewing logs, and supporting scheduled maintenance activities.
• Assist in performing regular database backups, restore testing, and disaster recovery procedures to ensure data availability and integrity.
• Support incident investigation and resolution by following established operational procedures and working closely with experienced engineers.
• Maintain database documentation, follow established processes, and contribute to improving operational procedures and technical runbooks.
• Stay up to date with database technologies, trends, and best practices through self-study, training

What are we looking for?

• Basic knowledge of SQL, with familiarity with PL/pgSQL or T-SQL and a willingness to develop practical skills in database programming.
• Basic understanding of database design principles, including normalization, indexing, and data modeling.
• Familiarity with database security concepts, including user authentication, access controls, encryption, and auditing.
• Basic understanding of relational database management systems, particularly PostgreSQL or Microsoft SQL Server.
• Basic knowledge of AWS cloud services, with familiarity with Amazon RDS considered an advantage.
• Understanding of database backup, recovery, and high availability concepts.
• Basic troubleshooting and problem-solving skills, with the ability to investigate technical issues and seek guidance when needed.
• Willingness to learn new technologies, follow established best practices, and develop database administration and optimization skills.
• Good communication and collaboration skills, with the ability to work effectively as part of an engineering team.
• Communicative level of English.

Tech stack

• PostgreSQL
• MS SQL
• Amazon Web Services
• C# .Net

What do we offer?