Behavioural Scientist

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

About Us:

Stuvio is a dynamic creative hub dedicated to crafting impactful digital experiences. With a team-driven approach and a commitment to innovation, we spark conversations, drive positive change, and forge genuine connections, delivering tangible results. Our collaborative journey unites diverse perspectives, guiding brands toward meaningful and lasting impacts that transcend the conventional.

The Role:

As a Senior Frontend Developer at Stuvio, you will play a leading role in shaping the future of our web presence by driving innovation, mentoring junior developers, and delivering exceptional user experiences. You will leverage your deep technical expertise and leadership skills to guide the development process, ensuring the creation of high-quality, performant, and scalable web applications.

Responsibilities:

• Lead the development of complex web applications, ensuring technical feasibility, code quality, and adherence to best practices.
• Mentor and coach junior developers, providing guidance, feedback, and opportunities for growth.
• Oversee and drive projects forward, setting clear goals, managing timelines, and resolving technical challenges.
• Collaborate effectively with designers, back-end developers, and other stakeholders to ensure seamless integration and alignment.
• Stay up-to-date with the latest frontend technologies and trends, identifying opportunities for improvement and innovation.
• Contribute to the development and implementation of best practices and coding standards within the team.

Qualifications required for the Role:

• 3+ years of experience as a frontend developer with a proven track record of success.
• In-depth knowledge of HTML, CSS, JavaScript, and modern frontend frameworks (e.g., React, Vue.js, Angular).
• Solid understanding of web development principles, architecture, and best practices.
• Experience with testing, debugging, and performance optimization techniques.
• Strong leadership, communication, and collaboration skills.
• Passion for mentoring and coaching others, fostering a positive and growth-oriented team environment.
• 
  

Why Join Stuvio:

• Make a real impact: Lead complex projects, mentor junior developers, and contribute to the overall success of our web development initiatives.
• Foster a culture of excellence: Share your knowledge and expertise, inspiring and guiding others to achieve their full potential.
• Stay at the forefront of technology: Explore and implement cutting-edge technologies to enhance our web applications and user experience.
• Embrace a dynamic culture: Thrive in a collaborative and supportive environment that values continuous learning and innovation.
• Competitive compensation & benefits: Includes flexible hours, unlimited leaves, and professional development opportunities.

• 0-2 years exp in Product Support Role.
• Need to Understand the product and features, to demonstrate them to the end users.
• Sound knowledge of Java and SQL
• Need to Analyze and Resolve the Product specific queries, MySQL.
• Consistently Deliver customer requirements.
• Engage with the Development team and manage the progress of cases.
• Should be able to cope with a high-pressure work environment.
• The working model will be 24X7.

Must require

• Good Communication both verbal and written
• Analytical skills
• Team player

Are you good at visualizing things? Do you like telling stories via visuals? We are building out our product marketing team, and you are the kind of help we need. No matter how engaging and strong our content is, it won’t work with just a giant block of text. We need help to tell these stories in a visually engaging way with a relevant tone. We are looking for a strong individual contributor who is excited about making sense of complex concepts, thrives on ambiguity, and loves coming up with ideas and bringing them alive through design.

• You’ll be expected to understand our brand identity and create a visual identity guideline for different touchpoints.
• You’ll be involved throughout the design process from the concept stage to delivery.
• You’ll develop visual assets for various campaigns across channels to increase the effectiveness of marketing campaigns.
• You’ll design digital content assets that are pivotal to communicate with our prospects and customers in the international markets.
• You'll be responsible to create and own imagery style on customer-facing assets such as Website, emails & collaterals, etc.

• You understand the global technology consumer and the relevant design sensibilities.
• You start all design work with a problem statement, goal, and context.
• Your work is conceptually clear and visually stunning.
• You are well versed with contemporary imagery style and have the skill set to create them.
• You have a high level of competency in most of the applications of Adobe CC.
• You have worked on contemporary design tools like Figma that enable team collaboration.
• Have spent the last 3-6 years of your career on digital design projects at agencies, design focused startups with exposure to international markets.
• You have a portfolio to showcase.

You will be working closely with the product marketing team and report to the marketing head. You will be interacting with all the customer-facing teams such as the marketing, sales & customer success teams. Your initiatives will help them improve their success metrics as well.

A wholesome opportunity in a fast-paced environment that will enable you to juggle between concepts, yet maintain the quality of content, interact and share your ideas and have loads of learning while at work. Work with a team of highly talented young professionals and enjoy the benefits of being at Xoxoday.

A fast-growing SaaS commerce company based in Bangalore with offices in Delhi, Mumbai, SF, Dubai, Singapore, and Dublin. We have three products in our portfolio: Plum, Empuls, and Compass. Xoxoday works with over 1000 global clients. We help our clients in engaging and motivating their employees, sales teams, channel partners or consumers for better business results.

• Good interpersonal skills: ability to communicate complex concepts. requiring a GCSE in English or equivalent
• Liaise with team members to identify and implement new features and technologies that will provide significant product enhancements and cutting-edge features.
• Must be self-motivated, enthusiastic, hardworking, and possess a willingness to learn.
• Confidence, enthusiasm, and the energy to make a significant contribution to an organization.
• Must be self-reliant and able to work independently or as part of a development team.
• Possess excellent innovative problem-solving skills.
• Evidence of organizational and analytical skills with an ability to research/investigate issues, analyze and consider wider implications, and then compile reports and/or present recommendations

Technical Knowledge

• Executing full lifecycle software development
• Programming well-designed, testable, efficient code
• 4+ years of work experience with React and function components.
• Advanced understanding of; React, Redux, JavaScript, ES6+, Jest.
• Computer Science fundamentals in object-oriented design, data structures, algorithm design, problem-solving, and complexity analysis. Good experience with HTML5, CSS3, responsive design, material UI
• Expert in Browser Compatibility, Responsive Web Design, Accessibility
• Basic understanding of Node.js, Express
• Experience using common design patterns. High standards for code quality, maintainability, and performance
• High understanding of web development UI/UX design principles and best practices
• Working knowledge of RESTful API Paradigms
• Feel comfortable with: Jira and Git (Bitbucket)
• A natural curiosity for new scripting languages, frameworks, and technologies
• Knowledgeable with Agile – Scrum way of working
• Solid working experience with TDD
• Azure experience
• Knowledge of web security principles, Data Protection Act and GDPR.
• Knowledge of working in an ISO27001 and Cyber Essentials compliant environment.

• As a Senior Software Engineer you will work closely with the Tech Lead, and the rest of the engineering team to build and scale a data-driven platform. This role will act as a great springboard to accelerate career growth & transition into a Tech Lead level role.
• Your primary focus will be the development of server-side logic, building new services and APIs, developing core business logic, supporting the maintenance of current APIs, reviewing work, and improving the performance and reliability of our systems as we rapidly scale our product and organization.
• An effective Senior Software Engineer will be a self-motivated learner; a highly creative engineer having obsessive attention towards detail and thoroughness.

Must Haves

• You’ve been building web applications professionally for 5+ years
• You’re proficient in PHP 7, Laravel, and PostgreSQL
• You possess strong OOP and design pattern knowledge
• Familiar with modern engineering practices: Code Reviews, Continuous Deployment, Automated Testing, etc
• You write understandable, testable code with an eye towards maintainability and experienced with TDD (Test Driven Development)
• You’ve the ability to build RESTful APIs
• Explaining complex technical concepts to designers, support team, and fellow engineers is not a problem for you
• Well versed with the fundamentals of computer science and distributed systems

Nice-to-haves

• FrontEnd experience; have built applications in either: React, Vue, Angular, or Svelte
• Startup experience, preferably a tech startup
• Open Source contributor
• You have experience with other programming languages -- e.g. NodeJS, Python, Ruby, Go, C, etc.
• Passionate about/experienced with open source and developer tools
• You have a bachelor's degree in Computer Science, Engineering or related field, or equivalent training, fellowship, or work experience

Bonus

• Experience deploying applications; AWS, DigitalOcean, etc.
• Experience with leading a team of 3+ developers

Apply if

• You want to be a team member rather than an employee - cultural fit is the most important thing. Start-up life is a roller coaster and we want to make sure no matter how the day has gone we can still go out (virtually) for a pint at the end of it
• You take ownership
• You’ve an eye for detail
• You’re a problem solver, and a perpetual learner
• You possess a positive and solution-oriented mindset