
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 MyDBOPS
About
Similar jobs
The Impact you will create on the Job
Understand and handle deploying, troubleshooting issues with Compute, Networking, Storage, Database services on AWS & Azure.
IT experience in a team handling the cloud, infrastructure and Linux, Windows operating systems.
Working on different services in AWS & Azure Cloud Platform
In depth knowledge of a wide range of AWS & Azure services in Compute, Storage, Networking, Infrastructure as a code, Serverless computing, IAM, CI/CD pipelines
Possess a thorough understanding of Internet based technologies (DNS, Security, IP Routing, SSH, FTP, HTTP/HTTPS etc.)
Job Role: Placement Co-Ordinator
Roles & Responsibilities:
- Proactively identify, contact, and build relationships with HRs, hiring managers, and recruiters across IT and digital industries.
- Search and monitor job sites, industry platforms, and portals for relevant openings
- Share relevant job openings with eligible candidates and ensure timely application submissions.
- Coordinate and execute successful placement drives to connect students
- Reach out to recruiters and hiring managers to understand their workforce requirements
- Maintain and update placement data for transparency and accountability.
Key Skills Required:
- Must have strong english communication skills
- Extroverted and outgoing personality.
- Any experience is fine.
- Strong ability to identify and build relationships
- Excellent communication, research, and networking skills.
- Effective organizational and reporting abilities
- Ability to work as part of a team.
Candidates from Western line will be preferred.
Job Types: Full-time, Permanent
Pay: ₹18,000.00 - ₹30,000.00 per month
Office Timing: 9.00 am - 6 pm | Mon - Sat | 6 Days Working

JOB DESCRIPTION:
1) Understand client requirements and functionalities.
2) Write well-designed, testable, efficient code.
3) Responsible for solving complex technical issues.
4) Ensure quality projects are delivered within defined timelines.
5) Active involvement in client communication to understand functional requirements.
6) Maintain high standards of quality for code, documentation and other deliverables.
Required Skills
1) Good experience in Angular's Latest Versions
2) Hand on Node.JS./Express JS
3) Database: MYSQL/MongoDB
4) Experience in JavaScript, TypeScript.
5)Good experience in HTML5, CSS3, JavaScript, Jquery
6) Experience working in an Agile environment.
7) Good communication skills.
About Company:
The company is a global leader in secure payments and trusted transactions. They are at the forefront of the digital revolution that is shaping new ways of paying, living, doing business and building relationships that pass on trust along the entire payments value chain, enabling sustainable economic growth. Their innovative solutions, rooted in a rock-solid technological base, are environmentally friendly, widely accessible and support social transformation.
Requirements:
1. Java 8+, J2EE,
2. Core Java- More hands on collections framework
3. JPA- Spring, Hibernate
4. Webservices (SOAP / Rest)
5. Knowldege on SQL & PLQL (Oracle/MySQL)
6. Expericne in Agile tools & processes
7. Good analytical & Communication skills



Job Purpose
We work in the latest technology, and our foundations are data structures, algorithms, solid logical reasoning, and mathematics. We are looking for very strong engineers who love coding, optimizing, and ensuring their code is the most efficient.
You will be involved with hardcore development. If you are an assembler of code or packages from different places to build something, you may not find our team to be the right fit.
You must be someone who can build anything from the ground up. Programming language should not be any barrier for you, as you should be able to pick up any programming language or underlying technology within a week.
Key Areas of Responsibility
Core development. Ready to participate in the designing, brainstorming, and development process. You must give sleepless nights to meet deadlines whenever required.
Desired Candidate Profile
Essential Skills
- Reliable, Accountable, and Trustworthy
- Ability to understand software requirements based on a wireframe/program specification
- Familiarity with GoLang / PHP / Python / Java / C / C++ / Linux Shell and Scripting / HTML / CSS / JS / Node.js is a plus
- Effective communication skills to ensure smooth coordination of tasks with the Team Leader.
- Knowledge of MongoDB, MySQL, and PL/SQL is a plus
- Familiarity with ML, TensorFlow, and Keras is a plus
- Knowledge of web servers such as Apache, NGNIX, and the HTTP protocol is a plus.
- Knowledge of multi-process, threads, memory, and filesystem on Linux is desirable.
- Must Solve The Following
To consider you for the current opening, please make sure to understand the following question and solve it. A simple program in any programing language would do. If you cannot solve this, please do not apply.
Write a function foo(x) where foo(foo(x)) = -x (assume x to be an integer, and foo(x) has to be always real), any programming language would do. Before submitting the answers, please verify that the output of foo(foo(10)) should be -10 and foo(foo(-10)) should be 10.
Wolken Software provides a suite of AI-enabled, SaaS 2.0 cloud-native applications for Customer Service and Enterprise Solutions namely Wolken Service Desk, Wolken's IT Service Management, and Wolken's HR Case Management. We have replaced incumbents like Salesforce, ServiceNow Zendesk, etc. at various Fortune 500 and Fortune 1000 companies.
Duties and Responsibilities
- Design and Review wireframes, and UI designs for the company website. Create social media posts including static posts, motion graphics & self-shot videos, explainer and product demo videos, and marketing collaterals viz. Brochures, emailers, standees, presentations, and any other collateral required.
- Have a keen eye on more delicate details in design principles, concepts, layout, alignment, visualization, etc.
- Work on Adobe XD, Photoshop, Illustrator, Canva, and other design tools to deliver prototypes, flows & ideas.
- Keep coming up with new ideas, modern designs, styles, and concepts for the creatives.
- Be responsible for meeting deliverables on time and in high quality.
- Have an in-depth understanding of what we do as a company and put that neatly into designs
- Have an eye for usability, minimalism, and simplicity.
- Think, argue, analyze, strategize, and iterate.
ABOUT US
White.Inc is a house of digitally native brands (DNBs) that is creating Instagram-first DTC brands across verticals like Cookware, Houseplants, Drinkware, Apple Gear and Luggage. We believe that to lead a better life in today's ever-changing world, we need products that are constantly evolving and contribute to our busy lives. To bring to life such category-disrupting brands, we have partnered with the world’s leading product design company to create products that are crave-worthy and address the needs of a new generation of Indian consumers.
Started by people with a decade+ experience in the e-commerce and D2C sectors, the founders have developed 2000+ products across multiple categories and scaled global brands in India such as RhinoShield & PopSockets. Leveraging on their expertise in driving growth, product development, supply chain, technology and access to global markets, White Inc is poised to deliver products that inspire and excite our consumer base.
We are rapidly growing and looking for someone as excited as us to be a part of this growth journey. If you love start ups, a fast-paced environment with lots of action and the opportunity to create India's new-gen disruptive brands, then click away and get set to propel your career to greater heights.
We are looking for a junior copywriter with working experience creating content across a range of channels to join our in-house marketing team.
THE ROLE
We are looking for a Junior Copywriter with excellent writing and research skills to develop memorable and stand-alone copy. As part of this role, you will create content across several channels including social media, websites, landing pages and performance content as well as be a part of brainstorming sessions to develop brand campaign ideas. We are looking for a candidate who is a team player, can think innovatively and has a flair for creative copywriting and ideation.
RESPONSIBILITIES
• Write compelling content across various platforms including engaging social media posts, click-worthy email campaigns, website copy, etc.
• Collaborate with internal stakeholders to interpret project briefs and develop relevant concepts into content.
• Ideate for and contribute towards a content strategy for marketing and tactical campaigns.
• Conduct in-depth research to write copy specific to our target audience.
• Emulate and hone brand persona in all the content and creatives.
• Proofread all content before it is sent across to the senior copywriter for further review.
• Respond to and consolidate multiple edits and points of feedback into your work.
QUALIFICATIONS
• Minimum 1-year experience as a copywriter.
• Candidates from agency backgrounds are a must.
• A passion for writing and the willingness to learn from other creative professionals.
• Strong research skills that ensure all copy is correct and accurate.
The role is about 70% support (aka reactive > keeping the customer happy) and 30% success (aka pro-active > helping the customer get success with LimeCall to stick and love us).
On the SUPPORT side, you’ll be doing things like… (80% of your day)
- Helping customers and potential customers on LIVE Chat (we use Intercom)
- Figuring out the “problem” the customer is having with our software. ("My text didn’t get sent, what happened?")
- Manage customer success pipeline (we use Hubspot)
- Relaying bugs to our development team to get taken care of (we use Jira)
- Creating user stories around customers wants, needs, issues (Asana)
- Using Stripe to process payments, refunds, and all things billing
- Create systems for tracking bugs, feature requests, and better ways to improve our support process and channel
- Create, edit, and continuously update our knowledge-base so our customers don’t have to bother you on how to do the simple things.
- Create videos and animated gif's that show people how to DO things (people love walk-throughs)
On the SUCCESS side, here are some things that you’ll be doing… (30% of your day)
- Host group & 1-on-1 demo’s, webinars, and training with leads and customers weekly and monthly
- Create surveys and google forms to gain feedback from current customers
- Reach out to “likely to churn” customers to help them get value from Salesmsg
- Engage with canceling customers and design a system for tracking for later followup.
- Speak with customers on the phone, text message, live chat, email, and other channels to help them with whatever questions they have.
- Onboard new customers
Job description:
Title – Technical Manager
Department – Technology
Reports To – CTO
Location – Andheri E, Mumbai
Compensation – Market Competitive
Role Specifications –
Solutioning the E-Retail team’s organizational technical initiatives
Responsible for System Architecture & Design
Designing, integrating and managing complex infrastructure solutions
Managing escalations, negotiate issues and schedule with stakeholders
Work closely with the Operations Head and Process owners for technical interventions/initiatives
Support pre-sales and creating pilots to showcase capability
Monitored network designs and employed technological advancements in business network
architecture.
Trained network professionals and assisted in resolving operational issues.
Recommend Alternative Technologies and Improvements.
Project management experience
Experience with web technologies and building enterprise architecture roadmaps
Experience designing, integrating and managing complex infrastructure solutions
Experience planning and developing support processes and adhering to best practices
Strong written and oral communication skills, and the ability to effectively communicate with technical
and non-technical audiences
Technical Specifications –
IT Delivery Management, Architecture Consulting, Production Support
Release & Configuration management.
Core Java & Java Enterprise Technologies – Jmeter, Spring, JsF, Structs 1.x, Hibernate 3. Ejb 2.0,
Primefaces, Apache Poi, Itext.
Build / Automation - Apache Ant, Apache Maven 3.0, Nexus.
Databases - Mysql, Mariadb, Nosql (Cassandra, Mongodb)
Scrummaster, Pmp, Agile And Standard Sdlc Models.Tomcat, Jboss 4.X, Weblogic 10.3
Configuration - Oracle Fusion Middleware 11, Identify & Access Management, Jahia 5.0.6
Domain Experience –
Knowledge of Retail/CPG domain ecommerce terms/concepts (SKUs, ASINs, catalogs, etc…)
preferred
Experience in building automation processes/products for back-office retail operation teams
will be beneficial
Knowledge of web scraping, product matching, attribution etc will be an added advantag

