Senior Database Engineer - Data Synchronization Specialist at M365Connect

Position Summary

• The Senior Database Engineer will be responsible for designing, implementing, and maintaining a robust PostgreSQL database that syncs with Manatal's recruitment platform. You'll work closely with our automation engineers to ensure seamless data flow and create comprehensive documentation using professional ERD tools.

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 that support 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

Required Skills & Experience

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

Preferred Qualifications

• Experience with recruitment/ATS systems (Manatal experience is a plus)
• Familiarity with multiple ERD and database design tools
• Knowledge of Redis for caching strategies
• Experience with monitoring tools (Prometheus, Grafana)
• Understanding of event-driven architectures
• Experience with data synchronization patterns and conflict resolution