Senior Database Engineer - Data Synchronization Specialist

Role Overview: You will be responsible for designing, implementing, and maintaining a robust PostgreSQL database that syncs with Manatal's recruitment platform. Collaborating with automation engineers, you will define data flow requirements and sync strategies to ensure seamless data flow. Additionally, you will configure and manage Docker containers for PostgreSQL, pgAdmin, and other database tools while monitoring database performance and troubleshooting data inconsistencies. Key Responsibilities: - Design and implement PostgreSQL database schemas optimized for recruitment data synchronization - Collaborate with automation engineers to define data flow requirements and sync strategies - Configure and manage Docker containers for PostgreSQL, pgAdmin, and other database tools - Create and maintain comprehensive ERD documentation using professional tools (Lucidchart, dbdiagram.io, etc.) - Monitor database performance and troubleshoot data inconsistencies - Implement security best practices for database access - Optimize database performance through indexing, query optimization, and maintenance procedures - Design data models supporting efficient synchronization patterns - Maintain detailed technical documentation and data dictionaries - Provide training and support to team members on database usage - Evaluate and recommend database tools and technologies Qualification Required: - Database Expertise: - 5+ years of PostgreSQL administration and development - Expert knowledge of SQL, including complex queries, stored procedures, and triggers - Experience with JSONB data types and polymorphic relationships - Database performance tuning and optimization skills - Experience with database replication and high availability setups - Modern Database Platforms: - Experience with Supabase or similar PostgreSQL-based platforms - Understanding of real-time subscriptions and row-level security - Knowledge of database-as-a-service platforms - Experience with database migrations and schema versioning - Data Architecture & Design: - Strong understanding of data modeling and normalization - Experience designing schemas for high-volume synchronization - Knowledge of data warehousing concepts - Understanding of API data structures and transformation requirements - DevOps & Infrastructure: - Strong Docker and Docker Compose experience - Linux server administration (Ubuntu preferred) - Experience with database backup and recovery strategies - Version control with Git/GitHub - Documentation & Visualization: - Proficiency with professional ERD tools (Lucidchart, dbdiagram.io, ERwin, etc.) - Experience creating technical documentation and data dictionaries - Ability to communicate complex database designs to non-technical stakeholders Role Overview: You will be responsible for designing, implementing, and maintaining a robust PostgreSQL database that syncs with Manatal's recruitment platform. Collaborating with automation engineers, you will define data flow requirements and sync strategies to ensure seamless data flow. Additionally, you will configure and manage Docker containers for PostgreSQL, pgAdmin, and other database tools while monitoring database performance and troubleshooting data inconsistencies. Key Responsibilities: - Design and implement PostgreSQL database schemas optimized for recruitment data synchronization - Collaborate with automation engineers to define data flow requirements and sync strategies - Configure and manage Docker containers for PostgreSQL, pgAdmin, and other database tools - Create and maintain comprehensive ERD documentation using professional tools (Lucidchart, dbdiagram.io, etc.) - Monitor database performance and troubleshoot data inconsistencies - Implement security best practices for database access - Optimize database performance through indexing, query optimization, and maintenance procedures - Design data models supporting efficient synchronization patterns - Maintain detailed technical documentation and data dictionaries - Provide training and support to team members on database usage - Evaluate and recommend database tools and technologies Qualification Required: - Database Expertise: - 5+ years of PostgreSQL administration and development - Expert knowledge of SQL, including complex queries, stored procedures, and triggers - Experience with JSONB data types and polymorphic relationships - Database performance tuning and optimization skills - Experience with database replication and high availability setups - Modern Database Platforms: - Experience with Supabase or similar PostgreSQL-based platforms - Understanding of real-time subscriptions and row-level security - Knowledge of database-as-a-service platforms - Experience with database migrations and schema versioning - Data Architecture & Design: - Strong understanding of data modeling and normalization - Experience designing schemas for high-volume synchronization - Kno