VP-Lead Engineer

Key Responsibilities:

• Design, develop, and maintain full-stack applications using Python and React.
• Collaborate with designers, product managers, and other developers to build user-friendly interfaces and seamless APIs.
• Optimize applications for maximum speed and scalability.
• Write clean, maintainable, and well-documented code.
• Debug and resolve technical issues promptly.
• Implement unit and integration tests to ensure high-quality deliverables.
• Stay updated with the latest industry trends, tools, and technologies.
• Participate in code reviews and contribute to team best practices.

Required Skills and Qualifications:

• 3–5 years of hands-on experience with Python and React.
• Strong understanding of JavaScript, ES6+, and TypeScript (preferred).
• Proficient in building RESTful APIs and integrating with frontend frameworks.
• Experience with state management libraries (e.g., Redux, Context API).
• Familiarity with databases such as MongoDB, PostgreSQL, or MySQL.
• Experience with modern build tools and package managers like Webpack, Babel, NPM, or Yarn.
• Hands-on experience with version control tools, particularly Git.
• Knowledge of containerization and CI/CD pipelines is a plus.

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

Required Skill Set-

Project experience in any of the following - Data Management,

Database Development, Data Migration or Data Warehousing.

• Expertise in SQL, PL/SQL.

Role and Responsibilities -

• Work on a complex data management program for multi-billion dollar

customer

• Work on customer projects related to data migration, data

integration

•No Troubleshooting

• Execution of data pipelines, perform QA, project documentation for

project deliverables

• Perform data profiling, data cleansing, data analysis for migration

data

• Participate and contribute in project meeting

• Experience in data manipulation using Python preferred

• Proficient in using Excel, PowerPoint

 -Perform other tasks as per project requirements.

process of managing a business for millions of Indian MSMEs.

The software allows users to create business transactions, share them with their

customers, manage their inventory, keep track of their receivable/payable and manage

end-to-end taxation.

• Study design briefs and determine requirements
• Schedule projects and define budget constraints
• Conceptualize visuals based on requirements
• Prepare rough drafts and present ideas
• Develop illustrations, logos, and other designs using software or by hand
• Use the appropriate colors and layouts for each graphic
• Work with copywriters and creative director to produce a final design
• Test graphics across various media
• Amend designs after feedback
• Ensure final graphics and layouts are visually appealing and on-brand

• Proven graphic designing experience
• A strong portfolio of illustrations or other graphics
• Familiarity with design software and technologies (such as Sketch, Figma, Adobe XD, InDesign, Illustrator, Dreamweaver, Photoshop)
• A keen eye for aesthetics and details
• Excellent communication skills
• Ability to work methodically and meet deadlines
• Degree in Design, Fine Arts or related field is a plus

Java
J2ee
working experience with one or more clouds

Understanding of design architecture

Experience with Traditional databases and nosql databases

Sound in Algorithms,data structures and problem solving 

Good at coding and design

We are looking for a person that is a skilled full-stack iOS mobile app developer, is fun and inspiring to work with, and is passionate about our mission. There are a lot of opportunities to further develop your own skills through future enhancements. Experience in the respective profile is required but the willingness to learn in a fast-paced environment is a must.