Senior Database Engineer

Job Description Manatal Database Sync Project Senior Database Engineer - Data Synchronization Specialist Company Overview We are seeking an experienced Database Engineer to architect and maintain our Manatal recruitment database synchronization infrastructure. This role is critical for maintaining data authority, overcoming API throttling limitations, and providing flexible data access across our organization. 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 What We Offer - Competitive salary based on experience - Remote work flexibility - Opportunity to architect critical infrastructure - Professional development opportunities - Direct impact on company data strategy