Data Engineer (Consultant Role)

Job Description for PostgreSQL Lead

Job Title: PostgreSQL Lead

Company: Mydbops

About us:

As a seasoned industry leader for 8 years in open-source database management, we specialise in providing unparalleled solutions and services for MySQL, MariaDB, MongoDB, PostgreSQL, TiDB, Cassandra, and more. At Mydbops, we are committed to providing exceptional service and building lasting relationships with our customers. Our Customer Account Management team is vital in ensuring client satisfaction and loyalty.

Role Overview

As the PostgreSQL Lead, you will own the design, implementation, and operational excellence of PostgreSQL environments. You’ll lead technical decision-making, mentor the team, interface with customers, and drive key initiatives covering performance tuning, HA architectures, migrations, and cloud deployments.

Key Responsibilities

• Lead PostgreSQL production environments: architecture, stability, performance, and scalability
• 
  
• Oversee complex troubleshooting, query optimization, and performance analysis
• 
  
• Architect and maintain HA/DR systems (e.g., Streaming Replication, Patroni, repmgr)
• 
  
• Define backup, recovery, replication, and failover protocols
• 
  
• Guide DB migrations, patches, and upgrades across environments
• 
  
• Collaborate with DevOps and cloud teams for infrastructure automation
• 
  
• Use monitoring (pg_stat_statements, PMM, Nagios or any monitoring stack) to proactively resolve issues
• 
  
• Provide technical mentorship—conduct peer reviews, upskill, and onboard junior DBAs
• 
  
• Lead customer interactions: understand requirements, design solutions, and present proposals
• 
  
• Drive process improvements and establish database best practices

Requirements

• Experience: 4-5 years in PostgreSQL administration, with at least 2+ years in a leadership role
• 
  
• Performance Optimization: Expert in query tuning, indexing strategies, partitioning, and execution plan analysis.
• 
  
• Extension Management: Proficient with critical PostgreSQL extensions including:
• 
  
• pg_stat_statements – query performance tracking
• 
  
• pg_partman – partition maintenance
• 
  
• pg_repack – online table reorganization
• 
  
• uuid-ossp – UUID generation
• 
  
• pg_cron – native job scheduling
• 
  
• auto_explain – capturing costly queries
• 
  
• Backup & Recovery: Deep experience with pgBackRest, Barman, and implementing Point-in-Time Recovery (PITR).
• 
  
• High Availability & Clustering: Proven expertise in configuring and managing HA environments using Patroni, repmgr, and streaming replication.
• 
  
• Cloud Platforms: Strong operational knowledge of AWS RDS and Aurora PostgreSQL, including parameter tuning, snapshot management, and performance insights.
• 
  
• Scripting & Automation: Skilled in Linux system administration, with advanced scripting capabilities in Bash and Python.
• 
  
• Monitoring & Observability: Familiar with pg_stat_statements, PMM, Nagios, and building custom dashboards using Grafana and Prometheus.
• 
  
• Leadership & Collaboration: Strong problem-solving skills, effective communication with stakeholders, and experience leading database reliability and automation initiatives.
• 
  
• 
  

Preferred Qualifications

• Bachelor’s/Master’s degree in CS, Engineering, or equivalent
• 
  
• PostgreSQL certifications (e.g., EDB, AWS)
• 
  
• Consulting/service delivery experience in managed services or support roles
• 
  
• Experience in large-scale migrations and modernization projects
• 
  
• Exposure to multi-cloud environments and DBaaS platforms

What We Offer:

• Competitive salary and benefits package.
• Opportunity to work with a dynamic and innovative team.
• Professional growth and development opportunities.
• Collaborative and inclusive work environment.
• 
  

Job Details:

• Work time: General shift
• Working days: 5 Days
• Mode of Employment - Work From Home
• Experience - 4-5 years

We are seeking a qualified HR Associate in regard to selling cars and bike service products that our customers have grown to rely on. We are a growing platform and are required to target customers by hiring more sales executives on daily basis.

Vah Vah! is an ed-tech company that offers online makeup courses in micro-batches to students across India to learn from the leading teachers in top cities. We provide holistic education with lots of practical training that makes our students job-ready with not just the base skills but also the soft skills for great customer service. Our teachers have more than 15+ years of experience in training makeup and have certified more than 1000+ students. Vah Vah! is founded by executives with extensive experience running consumer business and mobile games at scale (over 100 million players) at Zynga. Vah Vah! is backed by a leading investment firm.

Website Link: https://vahvah.com/

The Mission

Vah Vah teaches professional makeup to budding makeup artists and influencers through live online classes. We have students from Srinagar, all the way to the Andamans. And experienced teachers who have worked in Bridal Makeup, Ramp Shoots, Film and more. We empower our students to join the workforce as fully trained makeup artists. This is the future of vocational education, and you can help build it.

Our Culture

• Amazing workplace and colleagues to work with
• We have the right mixture of creativity, analytics and hustle to move fast in the right direction.
• You will work with colleagues who don’t take themselves too seriously but move mountains.
• See yourself evolving every month with new problems to solve and new skill to master.
• Work with the smartest engineers so you can learn from them.
• Competitive salary at par with the best in the industry
• Great stock options so you can benefit from the company's growth.
• Immense exposure to new technologies

Responsibilities:

• Complete ownership of building and maintaining Web APP
• Deliver across the entire app life cycle design, build, deploy, test, release to production and support
• Should be comfortable in building a great consumer user interface and responsive web apps.

Requirements:

• Overall experience of 2-4 years
• React Web Developer with 2+ years of experience
• Should have worked on NodeJS with express framework
• Understanding of Backend services, API implementation, and database systems. - Familiarity with MySQL and Mongo databases
• We encourage all our devs to have a base level of DevOps skills & w.r.t
• Source Control, CI/CD systems, Cloud Services such as AWS, Firebase, GCP Minimum 1 year of experience in responsive app development
• Ability to implement designs and functionality provided by UI/UX teams
• Strong knowledge of JavaScript ES6
• knowledge of Java/J2EE, Spring, Spring Boot, Spring Cloud is a plus

Key Skills:

• React/JS, NodeJS, Typescript
• Familiarity with Analytics integrations
• Conversant with Github, CI/CD pipeline

What you get:

• Amazing workplace and colleagues to work with
• Competitive salary at par with the best in the industry
• Immense exposure to new technologies

Responsibilities:

• Plan and execute all performance marketing campaigns, including but not limited to SEM, Google Display and Discovery ads, remarketing & email campaigns
• Manage budgets and campaigns across all digital channels to drive strong return on investment by optimisimng cost per qualified lead
• Plan, execute, and measure experiments and conversion tests
• Manage landing pages and optimize user experience
• Ensure successful planning, execution, optimization for key traffic KPIs via paid, organic & other media channels
• Identify trends and insights, and optimize spends and performance based on the insights

Requirements:

• Any Bachelor’s/ Master’s degree
• Certifications in Google and Facebook ad management strongly preferred
• 1-3 years of experience in setting up and optimizing Google AdWords & Facebook Ad campaigns.
• Experience in identifying target audiences and devising digital campaigns that engage, inform, and motivate
• Demonstrable experience managing SEM, marketing database, email, social media and/or display advertising campaigns
• Experience in optimizing landing pages and user funnels
• Experience with A/B and multivariate experiments

• Write high quality code in ReactJS using TypeScript or JSX that is easy to maintain and test.
• Participate in an Agile environment using Scrum software development practices, Automated unit testing, Continuous integration, Code reviews, Version control systems, Automated build processes. Raise issues proactively that might impact delivery commitments.
• Fix production issues and maintain the code as needed .

• BS degree in CS or equivalent work experience 5+ years professional experience building single page applications in ReactJS using TypeScript or JSX with extensive experience working with HTML5 and CSS3.
• Experience working with cross-browser behaviors and quirks.

• Passion for new technologies. Product development experience building large scale web applications.
• Experience designing and developing highly scalable consumer facing web application. Care deeply about writing high-performance, reusable code for components that will be used across our product.
• GraphQL experience is preferred.