Principal Architect

Experience

Salary

Expected Notice Period

Shift

Opportunity Type

Placement Type

(*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, BackendMedblocks is Looking for:

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:

• 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 haves:

• 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
  

Interview Process

• Introductory Call
• Tech Round: Previous Experience + Case Study/Problem Solving
  

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: