We are looking for an experienced Database Engineer to join our team. The Database Engineer will be responsible for designing, managing, and maintaining Rezi's databases. The ideal candidate will have a strong knowledge of database design and development, including database administration and performance tuning. The Database Engineer must have experience with large-scale enterprise systems, distributed databases, and big data technologies. The Database Engineer must also have experience with NoSQL and SQL databases and be proficient in at least one scripting language such as Python or Bash. The Database Engineer will work closely with the engineering team to ensure the databases remain secure and reliable. Responsibilities include optimizing query performance, conducting backups and disaster recovery, and writing database stored procedures. The ideal candidate must have excellent problem-solving skills and the ability to communicate effectively with the engineering team.
• As a Database Engineer at Rezi, responsible for designing, building and maintaining the company’s data storage and access systems
• Develop and maintain database structures for data warehouse and data lake, ensure high availability and performance, and leverage best practices in data governance
• Design and implement data models using relational and non-relational databases, such as Oracle, MySQL, PostgreSQL, MongoDB, etc.
• Optimize queries and stored procedures to ensure optimal performance of the databases, troubleshoot performance bottlenecks and other technical issues
• Automate and streamline database processes and procedures, monitor data integrity and security
• Work closely with data scientists to design databases and data access patterns to support advanced analytics
• Develop and maintain documentation of database layout, usage, and security protocols
• 5+ years of experience in designing, developing, and administering databases.
• Proficient in developing, configuring, maintaining, and administrating databases such as SQL Server, Oracle, MySQL, MongoDB, and Postgres.
• Experience in designing and developing complex queries and stored procedures using SQL.
• Knowledge of data modeling and optimization techniques.
• Hands-on experience with database performance tuning and optimization.
• Experienced in troubleshooting, diagnosing and resolving database issues.
• Familiarity with data security and protection standards.
• Knowledge of cloud-based database technologies such as AWS, Azure, and GCP.
• Ability to work in a distributed, collaborative environment.
• Excellent problem-solving and communication skills.