Description:
We are seeking a skilled and motivated Database Engineer to join our dynamic team. The ideal candidate will have expertise in PostgreSQL and Oracle PL/SQL, with additional knowledge of DynamoDB being a significant advantage.
Responsibilities
- Create and maintain database documentation, including data models, schemas, and diagrams.
- Participate in database schema design and review processes.
- Develop, implement, and optimize complex database solutions using PostgreSQL and Oracle PL/SQL
- Create and manage database objects such as tables, views, indexes, sequences, and constraints.
- Design, code, and maintain efficient and reusable database functions, triggers, procedures, packages, and indexes.
- Manage and manipulate JSON data within PostgreSQL and Oracle databases.
- Strong communication skills, with the ability to explain complex technical concepts.
- Excellent problem-solving skills and ability to work independently and as part of a team.
- Perform database tuning, query optimization, and schema refinement to ensure high performance and reliability.
- Ensure data security, integrity, and availability by implementing appropriate backup and recovery strategies.
- Familiarity with NoSQL databases, particularly DynamoDB, is a plus.
Requirements
Skills and Qualifications
- Bachelor's degree in computer science, Information Technology, or a related field
- 3 to 5 years of hands-on experience in PostgreSQL and Oracle PL/SQL database development
- Strong understanding of relational database concepts, data modeling, and normalization.
- Strong proficiency in PostgreSQL, including experience with functions, triggers, JSON capabilities, and indexing.
- Solid understanding of Oracle PL/SQL, including packages, procedures, cursors, ref cursors, collections, JSON capabilities, and indexing.
- Familiarity with cloud-based database solutions
- Collaborate with application developers to design and optimize queries and database access patterns