Senior Database Engineer - Data Synchronization Specialist

Lagos, Lagos State
Permanent
Full-time

22 days ago
Apply easily

Manatal Database Sync ProjectSenior Database Engineer - Data Synchronization SpecialistCompany OverviewWe 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 SummaryThe 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

M365Connect