Senior Database Engineer - Data Synchronization Specialist

M365Connect; Venezuela; A distancia; VES 8.094.000 - 12.952.000; Jornada completa

Descripción de la vacante

A technology solutions provider is looking for a Senior Database Engineer to architect and maintain their PostgreSQL database synchronization for recruitment data. Responsibilities include designing database schemas, collaborating on data flow, and optimizing performance. The ideal candidate has over 5 years of experience in PostgreSQL and strong SQL skills. The role offers competitive salary and remote work flexibility.

Servicios

Competitive salary based on experience

Remote work flexibility

Professional development opportunities

Formación

• 5+ years of experience with PostgreSQL development.
• Expert SQL knowledge including complex queries and optimization.
• Strong understanding of data modeling and normalization.

Responsabilidades

• Design PostgreSQL schemas for data synchronization.
• Collaborate with engineers for data flow definitions.
• Monitor and troubleshoot database performance issues.

Conocimientos

PostgreSQL administration

SQL expertise

Database performance tuning

Docker management

Data modeling

Herramientas

PostgreSQL

Docker

Lucidchart

Git

Descripción del empleo

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