Insurance SME / Senior Manager - Product

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

Ideal Candidate

Experience: 5- 6 years of proven experience as a UI/UX Designer with a focus on mobile app design (iOS & Android). Proven experience in building high-quality consumer-facing apps

Design Portfolio: A strong portfolio that showcases your design process, wireframes, mockups, prototypes, and micro-animation work.

Figma Expertise: Proficient in Figma, with hands-on experience designing user interfaces, prototypes, and micro-animations.

Animation Skills: Solid understanding of motion design principles and experience creating micro-interactions and transitions within mobile apps.

Technical Knowledge: Familiarity with mobile app design guidelines for both iOS and Android.

Communication: Strong written and verbal communication skills. Ability to present and articulate design ideas clearly to stakeholders and team members.

Team Player: Comfortable collaborating within a cross-functional team environment, and able to take constructive feedback to iterate on design solutions.

Passion for Design: A keen eye for detail, aesthetics, and a passion for creating delightful user experiences.

Key Responsibilities:

1. Video Editing:

• Edit raw footage into a cohesive and visually appealing final product, including cutting and trimming scenes, rearranging sequences, and adding transitions.
• Incorporate music, dialogues, graphics, and special effects to enhance the video’s narrative and visual appeal.
• Review shooting script and raw material to create a shot decision list based on scenes’ value and contribution to continuity.

2.Special Effects and Graphics:

• Add special effects, motion graphics, and animations to enhance video storytelling and visual appeal.
• Create or incorporate pre-existing graphics, such as lower thirds, titles, and credits, into the video.

3.Collaboration and Communication:

• Work closely with the director, producers, and other team members to understand the vision and requirements for each project.
• Provide creative input during brainstorming sessions and offer suggestions for improving the video’s narrative and visual style.
• Communicate regularly with the production team to ensure alignment on project goals, timelines, and deliverables.

1. Color Correction and Grading:

• Perform color correction to ensure consistency and accuracy across all scenes.
• Apply color grading techniques to create the desired mood and atmosphere in the video.

4.File Management and Archiving:

• Organize and manage digital video files, ensuring proper naming conventions and storage for easy retrieval.
• Archive completed projects in an organized manner for future reference or reuse.

5.Quality Control:

• Review final videos to ensure they meet technical standards for broadcasting, including resolution, aspect ratio, and audio quality.
• Make necessary revisions based on feedback from clients or stakeholders.

6.Continuous Learning and Improvement:

• Stay updated with the latest video editing software, tools, and techniques.
• Attend workshops, webinars, and training sessions to enhance video editing skills and keep up with industry trends.

Qualifications:

• Bachelor’s degree in Film, Media, Communications, or a related field.
• Proven experience as a Video Editor or similar role.
• Proficiency with video editing software (e.g., Adobe Premiere Pro, Final Cut Pro, After Effects).
• Strong understanding of video formats, codecs, and editing workflows.
• Creative mindset with a strong eye for visual composition and storytelling.
• Ability to work independently and collaboratively, with strong time management and organizational skills.
• Knowledge of color correction and audio editing is a plus.

YoHo Designs Pvt Ltd is a startup company located in Bengaluru, specializing in interior design solutions. Our mission is to provide our clients with affordable and durable interior designs that suit their preferences. Our goal is to grow to 100 employees and have 3 experience centers in Bengaluru within a year, with plans for further expansion in multiple cities. We are founded by young entrepreneurs with experience in running successful businesses.

Role Description

We are looking for a full-time Interior Sale's Associate role in Bengaluru who will be responsible for interacting with customers, helping them choose designs, and matching their preferences. They should have excellent communication skills, a flair for design, and the ability to work within a team. As it is an on-site role, the candidate should be based in Bengaluru.

Qualifications

Bachelor's degree or relevant experience in interior design or a related field.

Experience in sales or customer service is preferred.

Excellent communication and interpersonal skills to interact with customers.

Ability to provide expert advice based on customer preferences while also being able to work within a team and with designers.

Passion for design and keeping up with industry trends and developments.

Proficient in relevant software and tools such as AutoCAD, SketchUp, and Adobe Creative Suite.

About the Company:

Alyke, recognized as India's first friendship app, is revolutionizing the way people find friends online through its innovative matching algorithm. Alyke has quickly gained traction, surpassing 1 million users. This platform uniquely connects individuals based on shared interests and proximity, and stands out for its commitment to creating a secure environment that encourages users to express themselves freely. Joining Alyke offers the chance to be part of an innovative team dedicated to reshaping the landscape of social connections

Role Overview:

As a Senior Backend Developer, you will play a crucial role in the design, development, and optimization of our backend systems. You will be instrumental in building scalable, high-performance applications that support our business's needs. This role demands a deep understanding of backend technologies, database design, cloud infrastructure, and the ability to integrate a wide range of services and APIs.

Key Responsibilities

• Design and implement scalable, secure, and robust backend services and APIs.
• Lead the development of microservices architecture, ensuring optimal performance and scalability.
• Oversee the integration of third-party services and external APIs, including notification services like FCM.
• Develop and manage database schemas, optimizing for performance and scalability using MongoDB and Redis.
• Implement real-time data processing mechanisms for live updates and push notifications, utilizing technologies like Firebase.
• Manage cloud infrastructure and serverless functions on platforms such as AWS and GCP, ensuring efficient operations and cost management.
• Ensure the security of backend systems through robust authentication, authorization, data encryption, and adherence to best practices in data security and compliance.
• Work closely with the frontend team to integrate backend services and ensure a seamless user experience.
• Continuously evaluate and adopt new technologies and frameworks to improve the backend infrastructure.
• Mentor junior developers, fostering a culture of learning and growth within the team.

Qualifications

• Bachelor’s degree in Computer Science, Engineering, or a related field.
• 5+ years of experience in backend development, with a strong portfolio of projects demonstrating expertise in NodeJS, ExpressJS, and asynchronous programming.
• Extensive experience with database design, optimization, and management using MongoDB and Redis.
• Proven track record in developing and managing REST APIs.
• Deep understanding of microservices architecture and real-time data processing.
• Solid experience with caching mechanisms and SQS management.
• Comprehensive knowledge of security principles, including authentication, authorization, and data encryption.
• Familiarity with compliance and data protection standards.
• Should have worked on scalable microservices architecture
• Experience with Lambda functions.
• Experience working with firebase
• Should have proven experience in mobile application development
• Should have working experience in sqs
• Have knowledge of elastic cache 
• Experience with cloud-native development and managing cloud infrastructure on AWS or GCP.
• Excellent problem-solving skills, with the ability to lead projects and collaborate effectively with cross-functional teams.
• Strong communication and leadership skills, with a passion for mentoring and driving technical excellence.
• Attach the link of mobile application worked on till date

Why Join Us?

• Opportunity to lead a cutting-edge project impacting users globally.
• Work in an environment that fosters innovation, collaboration, and professional growth.
• Competitive compensation, comprehensive benefits.

• Working on our security suite, to build and maintain security software which runs on 1000's of client websites
• Building scalable applications in Symfony and fine tuning our CMS (WordPress/ Magento etc.) plugins
• Working in an agile environment of engineers to architect, design, develop and build our server-side infrastructure for our web security product
• Researching, designing and coding, troubleshooting and supporting. What you create is also what you own
• Writing secure, high quality, modular, testable & well documented code for features outlined in every sprint
• Designing and implementing APIs in support of front-end services with a highly scalable, flexible, and secure backend using the LAMP stack
• Identifying and correcting bottlenecks and fix bugs
• Driving strict code review standards among the team
• Ensuring timely delivery of the features/products
• Working with product managers to ensure product delivery status is transparent & the product always looks like how it was imagined
• Working closely with Security & Malware teams in writing APIs, modules
• Being responsible for technical hiring, training, reviewing

What you need to have:

• To appoint Block Sales Manager in their respective Districts.
• To manage sales operations in assigned district to achieve revenue goals.
• To supervise sales team members on daily basis and provide guidance whenever needed.
• To identify skill gaps and conduct trainings to sales team.
• To work with team to implement new sales techniques to obtain profits.
• To assist in employee recruitment, promotion, retention and termination activities.
• To conduct employee performance evaluation and provide feedback for improvements.