(04/10/2025) Principal Architect

Job Description

Experience: 5.00 + years

Salary: INR 4500000-5500000 / year (based on experience)

Expected Notice Period: 30 Days

Shift: (GMT+05:30) Asia/Kolkata (IST)

Opportunity Type: Remote

Placement Type: Full Time Permanent position(Payroll and Compliance to be managed by: Medblocks)

(*Note: This is a requirement for one of Uplers client - Medblocks)

What do you need for this opportunity

Must have skills required:

Kafka, Snowflake, CI/CD Pipeline, ETL/ELT pipelines, PostgreSQL

Medblocks is Looking for:

As a Senior Data Platform Engineer at Medblocks, you will be the primary architect of our data infrastructure, designing and implementing the foundation that powers our entire healthcare platform. This is a high-ownership role where you'll make critical decisions about data architecture, security, and performance that will scale with us for years to come.

Key responsibilities include:

- Architecting and implementing complex PostgreSQL database schemas that handle millions of healthcare records with sub-second query performance
- Writing and optimizing advanced PostgreSQL features including RLS (Row-Level Security) policies, stored procedures, triggers, and custom functions
- Building reliable, real-time data pipelines using CDC (Change Data Capture) and event-driven architectures to sync data across multiple systems
- Designing and implementing database performance monitoring, query optimization, and debugging strategies
- Creating data integration patterns that map between our core PostgreSQL database and external systems (data warehouses, analytics platforms, third-party APIs)
- Establishing database CI/CD practices including migration strategies, testing frameworks, and zero-downtime deployment patterns
- Mentoring team members on database best practices and reviewing critical database design decisions
- Documenting complex data models and creating technical specifications that other engineers can follow

Qualities We Value

- Deep technical curiosity: You read PostgreSQL release notes for fun and have opinions about indexing strategies
- Systems thinking: You understand how database decisions impact the entire application stack
- Ownership mentality: You've been the person others turn to when the database is on fire at 2 AM
- Teaching ability: You can explain why denormalization might be the right choice to both junior engineers and senior architects
- Pragmatism: You know when to use triggers vs application logic, when to normalize vs denormalize

Requirements

Must have:

- 5+ years of production database engineering experience, with at least 3 years focused on PostgreSQL
- Proven experience designing complex relational data models (50+ tables) that have scaled in production
- Deep PostgreSQL expertise including:
- Advanced SQL (CTEs, window functions, recursive queries)
- PL/pgSQL programming for procedures and triggers
- Performance tuning (query plans, indexing strategies, vacuum configuration)
- Security implementations (RLS, role-based access)
- Experience building data pipelines and ETL/ELT processes at scale
- Hands-on experience with data integration patterns (CDC, event streaming, batch processing)
- Strong DevOps skills including:
- Database migration tools and strategies
- CI/CD pipeline implementation
- Infrastructure as Code (Terraform, Ansible)
- Containerization and orchestration
- Experience with monitoring and debugging production database issues
- Track record of working in high-autonomy environments where you owned technical decisions

Nice to have:

- Experience with data warehouse technologies (Snowflake, BigQuery, Redshift, Apache Iceberg)
- Knowledge of event streaming platforms (Kafka, Debezium, Apache Pulsar)
- Familiarity with dbt, Apache Airflow, or similar data orchestration tools
- Experience with time-series data or audit log patterns
- Contributions to PostgreSQL extensions or database-related open source projects
- Experience with multi-tenant database architectures
- Background in regulated industries requiring data compliance

How to apply for this opportunity

- Step 1: Click On Apply And Register or Login on our portal.
- Step 2: Complete the Screening Form & Upload updated Resume
- Step 3: Increase your chances to get shortlisted & meet the client for the Interview

About Uplers:

Our goal is to make hiring reliable, simple, and fast. Our role will be to help all our talents find and apply for relevant contractual onsite opportunities and progress in their career. We will support any grievances or challenges you may face during the engagement.

(Note: There are many more opportunities apart from this on the portal. Depending on the assessments you clear, you can apply for them as well).

So, if you are ready for a new challenge, a great work environment, and an opportunity to take your career to the next level, don't hesitate to apply today. We are waiting for you