Browse
···
Log in / Register
Job Summary: We are seeking a professional with solid technical expertise in data modeling, database management systems (DBMS), query languages, and database concepts, along with practical experience and analytical and communication skills. Key Highlights: 1. Solid technical knowledge in data modeling and data management 2. Practical experience in database design, implementation, and maintenance 3. Communication and collaboration skills for teamwork **Description: Essential Technical Knowledge:** A\- **Data Modeling:** Deep understanding of how to create conceptual, logical, and physical data models. This includes identifying entities, attributes, and relationships, as well as applying normalization techniques to optimize database design and avoid redundancy. A\- **Database Management Systems (DBMS):** Experience with at least one—ideally multiple—popular DBMSs, such as: o **Relational:** MySQL, PostgreSQL, Oracle, SQL Server. A\- **Query Languages:** Proficiency in SQL (Structured Query Language) for creating, modifying, and querying relational databases. For NoSQL databases, familiarity with their specific query languages (e.g., JSON for MongoDB). A\- **Database Concepts:** Solid understanding of concepts such as transactions (ACID), indexes, primary and foreign keys, views, stored procedures, triggers, security, and query optimization. A\- **ETL (Extract, Transform, Load) Tools Knowledge:** For data movement and transformation, especially in data warehousing projects. A\- **Practical Experience:** Proven experience in database design, implementation, and maintenance; experience with data migration; knowledge of Python or shell scripting; and experience handling heterogeneous file formats. **Analytical and Problem-Solving Skills:** A\- **Logical and Structural Thinking:** Ability to logically organize information and identify the most appropriate data structures for different types of information. A\- **Conflict Resolution:** Skill in identifying and resolving inconsistencies or conflicts in data requirements. **Communication and Collaboration Skills:** A\- **Effective Communication:** Ability to explain complex technical concepts to non-technical stakeholders and to document database designs clearly and concisely. A\- **Teamwork:** Collaboration with developers, business analysts, and other teams to ensure the database meets the needs of the entire application or system. A\- **Documentation:** Ability to create and maintain detailed documentation of the database schema, data dictionary, and entity-relationship diagrams (ERDs). **Additional Tools and Technologies (Preferred Qualifications):** A\- **Data Modeling Tools:** Familiarity with tools such as ER/Studio, MySQL Workbench, pgAdmin, SQL Developer. A\- **Cloud Knowledge:** Experience with cloud-based database services, such as AWS RDS, Azure SQL Database, Google Cloud SQL. A\- **Performance Tuning:** Skill in optimizing database performance, including analyzing query execution plans, optimizing indexes, and configuring the database server. **Formal Qualifications and Experience:** A\- **Academic Background:** Bachelor’s degree in Computer Science, Software Engineering, Information Systems, or related fields. Completed undergraduate education. **Years of Experience:** 4 years and 0 months. We are looking for a professional with solid technical expertise in data modeling, database management systems (DBMS), query languages, database concepts, and ETL tools. The ideal candidate must have practical experience in database design, implementation, and maintenance, as well as strong analytical and problem-solving skills. We expect you to possess strong communication and collaboration abilities—capable of explaining complex technical concepts to non-technical stakeholders and documenting database designs clearly and concisely. Additionally, you must be able to work effectively in a team, collaborating with developers, business analysts, and other teams to ensure the database fulfills the requirements of the entire application or system. As preferred qualifications, we value familiarity with data modeling tools, experience with cloud-based database services, and the ability to optimize database performance. For this position, a bachelor’s degree in Computer Science, Software Engineering, Information Systems, or related fields is required. 2511120202181802488
