Senior Database Engineer - Data Synchronization Specialist at M365Connect in Delhi, India

M365Connect is seeking a highly skilled Senior Database Engineer specializing in Data Synchronization to join our team in Delhi, India. This critical role involves architecting and maintaining our Manatal recruitment database synchronization infrastructure. The primary goals are to ensure data authority, overcome API throttling limitations, and provide flexible data access across the organization.

Position Overview

As a Senior Database Engineer, you will design, implement, and maintain a robust PostgreSQL database for synchronizing with Manatal's recruitment platform. You will collaborate closely with automation engineers to ensure seamless data flow and create comprehensive technical documentation using professional Entity-Relationship Diagram (ERD) tools. This is an opportunity to significantly impact our data strategy and infrastructure.

Key Responsibilities

• Design and implement PostgreSQL database schemas optimized for recruitment data synchronization.
• Collaborate with automation engineers to define data flow requirements and synchronization strategies.
• Configure and manage Docker containers for PostgreSQL, pgAdmin, and related database tools.
• Create and maintain comprehensive ERD documentation using professional tools such as Lucidchart or dbdiagram.io.
• Monitor database performance and troubleshoot data inconsistencies.
• Implement and enforce security best practices for database access.
• Optimize database performance through indexing, query optimization, and regular 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 and best practices.
• Evaluate and recommend new database tools and technologies to enhance our infrastructure.

Required Skills & Experience

Database Expertise

• Minimum of 5 years of experience in PostgreSQL administration and development.
• Expert-level knowledge of SQL, including complex queries, stored procedures, and triggers.
• Proven experience with JSONB data types and polymorphic relationships.
• Strong skills in database performance tuning and optimization.
• Experience with database replication and high availability setups.

Modern Database Platforms

• Experience with Supabase or similar PostgreSQL-based platforms is required.
• Understanding of real-time subscriptions and row-level security implementation.
• Familiarity with database-as-a-service (DBaaS) platforms.
• Experience with database migrations and schema versioning techniques.

Data Architecture & Design

• Solid understanding of data modeling principles and database normalization.
• Experience designing database schemas for high-volume data synchronization.
• Knowledge of data warehousing concepts and best practices.
• Understanding of API data structures and transformation requirements.

DevOps & Infrastructure

• Strong proficiency in Docker and Docker Compose.
• Experience with Linux server administration, preferably Ubuntu.
• Knowledge of robust database backup and recovery strategies.
• Proficiency in version control using Git/GitHub.

Documentation & Visualization

• Proficiency in using professional ERD tools like Lucidchart, dbdiagram.io, or ERwin.
• Experience in creating detailed technical documentation and data dictionaries.
• Ability to clearly communicate complex database designs to both technical and non-technical stakeholders.

Preferred Qualifications

• Experience with recruitment or Applicant Tracking Systems (ATS), with Manatal experience being a significant advantage.
• Familiarity with a variety of ERD and database design tools.
• Knowledge of Redis for implementing effective caching strategies.
• Experience with monitoring tools such as Prometheus and Grafana.
• Understanding of event-driven architectures.
• Experience with various data synchronization patterns and conflict resolution techniques.

What We Offer

• A competitive salary, commensurate with experience.
• Flexibility of remote work.
• A unique opportunity to architect and build critical infrastructure.
• Access to professional development and learning opportunities.
• The chance to make a direct and significant impact on the company's data strategy.