
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
Job Title : Lead – Endpoint Security & Tooling
Experience : 7+ Years
Location : Sector 32, Gurgaon
Work Mode : 5 Days Working (On-site/Hybrid)
Notice Period : Immediate to 15–20 Days
Role Overview :
We are looking for a skilled professional to Lead endpoint security operations, tooling, and architecture.
The role involves managing tools like Intune and Zscaler, developing secure endpoint policies, performing risk assessments, and driving continuous improvements in endpoint protection.
Mandatory Skills :
Microsoft Intune, Zscaler (ZIA/ZPA), EDR tools, Application Control, risk assessment, endpoint policy design, and strong knowledge of endpoint security architecture.
Key Responsibilities :
- Manage and optimize endpoint security tools (Zscaler, Intune, EDR, Application Control).
- Configure, maintain, and troubleshoot endpoint security infrastructure.
- Lead policy development, risk assessment, and architecture design for secure endpoints.
- Collaborate with IT and security teams to align tools and practices with compliance.
- Stay updated with evolving security threats, tools, and standards.
Preferred Certifications :
CISSP, CEH, CESP (optional)
Core Responsibilities:
· Lesson Planning & Delivery: Plan, prepare, and deliver engaging lessons that align with the required curriculum, covering reading, writing, speaking, and listening skills.
· Language Fundamentals: Instruct students on grammar rules, composition, sentence structure, vocabulary, and pronunciation.
· Literature & Critical Thinking: Expose students to various forms of literature and guide them in analyzing texts, identifying themes, and developing critical thinking skills.
· Assessment & Feedback: Create, administer, and grade assignments, homework, and exams to assess student progress. Provide timely and constructive feedback to support learning and improvement.
· Classroom Management: Foster a positive, safe, and inclusive learning environment with clear behavioral expectations to ensure an effective learning atmosphere.
· Communication & Collaboration: Maintain open communication with parents, guardians, and colleagues to discuss student performance and needs. Participate in staff meetings and professional development.
· Individualized Support: Adapt teaching methods and materials to meet diverse student needs, including those with special educational needs or English as a second language (ESL/EAL).
English Expo" Responsibilities
A teacher involved in an "English Expo" or similar extracurricular event would likely have the following additional duties:
· Event Planning: Coordinate and plan the logistics of the expo, which might involve themes, schedules, and required materials.
· Student Supervision & Guidance: Supervise students in their preparation for the event, such as projects, presentations, or performances.
· Promotion & Displays: Promote the event and help organize displays of student work to celebrate achievements publicly.
· Collaboration: Work with other teachers, administrators, and potentially community members to ensure the event's success.
· Activity Design: Design specific activities or competitions for the expo that enhance English skills in a practical, engaging manner (e.g., spelling bees, debate contests, creative writing showcases).
Key Skills and Qualifications
· A bachelor's degree in English or Education (a master's degree is a plus).
· Relevant teaching certification or license.
· Strong command of the English language and literature expertise.
· Excellent communication, organizational, and time management skills.
· Patience, empathy, and adaptability to work with diverse student populations.
· Proficiency in using technology and various teaching methodologies.
The Inside Sales Specialist is a key player in our organization, responsible for nurturing existing client relationships and creating new ones. This role involves converting pre-qualified leads, upselling, and ensuring an exceptional customer experience.
Responsibilities:
- Source Opportunities: Identify new sales prospects through inbound lead follow-up, outbound cold calls, and emails.
- Understand Customer Needs: Listen to customer requirements and understand their needs and preferences.
- Route Qualified Opportunities: Pass qualified leads to the appropriate sales executives for further development and closure.
- Achieve Quotas: Close sales deals and meet quarterly targets.
- Research and Identify Key Players: Understand the client landscape, identify decision-makers, and generate interest.
- Maintain Prospect Database: Keep your database of prospects up-to-date within your assigned territory.
- Collaborate with Channel Partners: Work closely with channel partners to build a strong sales pipeline and close deals.
- Conduct Effective Online Demos: Showcase our products/services to potential clients.
Requirements:
- Proven Inside Sales Experience: Demonstrated success in inside sales.
- Strong Phone Presence: Comfortable making numerous calls daily.
- Proficiency with CRM Tools: Familiarity with Salesforce.com or similar CRM systems.
- Excellent Communication Skills: Both verbal and written.
- Effective Listening and Presentation Skills: Ability to understand client needs and present solutions.
- Time Management and Multitasking: Prioritize tasks effectively.
- Bachelor’s Degree or Equivalent: Educational background in business or related field.
Why Join Us?
- Be part of a dynamic team in the engineering industry.
- Opportunity to make a significant impact on our growth.
- Collaborate with channel partners and contribute to our success.
If you’re passionate about sales, building relationships, and contributing to an engineering company’s success, we’d love to hear from you! Apply now and let’s create something great together!
Roles and Responsibilities;-
- Include managing Java/Java EE application development while providing expertise in the full software development lifecycle, from concept and design to testing.
- Designing, developing and delivering high-volume, low-latency applications for mission-critical systems
Framework required – spring boot, Hibernate
Skills - Should have knowledge of JPA, js, Ajax
Position Summary:
As a QA Engineer at LimeChat, you will play a crucial role in ensuring the quality and performance of our messaging and communication applications. You will primarily focus on manual testing to identify issues, validate product functionality, and provide feedback to our development teams. Additionally, you will be involved in automation testing to enhance efficiency and test coverage.
Key Responsibilities:
- Execute test cases, identify defects, and report issues accurately.
- Collaborate with cross-functional teams to ensure product requirements and user expectations are met.
- Conduct manual testing of LimeChat's messaging applications to verify product functionality and user experience.
- Develop and maintain test plans and test cases for both new features and regression testing.
- Participate in design and implementation reviews to provide input on potential issues.
- Perform exploratory testing to uncover hidden defects and ensure a robust product.
- Automate test cases using testing frameworks and tools.
- Maintain and update automated test scripts as necessary.
- Execute automated test suites to improve test efficiency and coverage.
- Continuously monitor the quality of our applications and participate in the release process.
- Collaborate with developers to isolate and reproduce defects for faster resolution.
- Maintain and document testing processes and procedures for reference.
- Contribute to a culture of continuous improvement in quality assurance.
Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
- Proven experience as a QA Engineer, with a strong emphasis on manual testing.
- Familiarity with automation testing tools such as Selenium, Appium, or similar.
- Proficiency in writing and executing test cases.
- Strong analytical and problem-solving skills.
- Knowledge of software testing methodologies and best practices.
- Experience with mobile and web application testing.
- Ability to work independently and as part of a team.
- Excellent communication and documentation skills.
- Detail-oriented with a commitment to quality.
- Experience with testing APIs is a plus.
Full-stack developer - Remote position
Are you...
- Interested in working at a successful, well-funded start-up where every team member can make a huge contribution?
- Keen to make software that people will use every single day to make their lives easier?
- Excited to work on greenfield projects with responsibility and independence?
- Ready to develop and use your skills across our frontend, backend and mobile offerings?
- Meticulous about quality, and gifted with a strong desire to write beautiful code?
About the company
KeyNest solves the key exchange problem for Airbnb users. Our worldwide network of over 4,000 shops store keys so that Airbnb guests / cleaners / contractors can pick them up whenever is convenient for them. As a global partner of Airbnb we’ve checked-in over 2 million guests.
Why we need you
As the entire Airbnb ecosystem increasingly relies on KeyNest, our customers expect us to integrate additional features without reducing the ease of use that our customers love. This is why we continue to invest in beautiful, intuitive user interfaces that integrate with every tool and are used by our customers, their guests and staff, as well as our own staff.
Our product team is lead by one of the founders and complete with a director of engineering, product manager, UX designer, one mobile developer and one senior full-stack developer who will be mentoring you. We want to work with a developer who cares about the way their code impacts the people who use it.
With a genuine passion for high quality work, attention to detail and readiness to own your own projects, you will be looking for a new and exciting challenge which allows you to use your experience to drive change and maintain the high standards of our organisation.
Our Tech Stack
- C# MVC modern tech stack
- Front end web in TypeScript & Angular or Node & React
- Test Driven Development (TDD) and follow SOLID design principles.
- EF 6.0
- SQL Server 2017
- Agile experience (Scrum, Kanban)
- TFS
- Cloud hosted in Azure with micro-services architecture
Your qualities
- 2-4 years experience in C#
- Front-end web experience in Angular
- Track record of building great products
- Excited about understanding the real problems working people come up against and fixing them with technology
- You’ll love the idea of being a big part of a small team: if you come up with a great idea, you can take it all the way to production
- Motivation and ambition to succeed in a fast-paced environment
- Not afraid to take on responsibilities
What we offer
- Crucial role in a funded, dynamic & fast-growing start-up shaking up the sharing economy
- Competitive salary based on relevant experience
- Flexible working for our most committed staff
- Unparalleled opportunities to develop your career as the company develops rapidly
If you want to join the KeyNest team, please get in touch – we look forward to meeting you.
We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, colour, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.
- 3-4 years of experience in IT with 3 +minimum years of experience in React Development
- Previous experience working as a react.js developer.
- In-depth knowledge of JavaScript, CSS, HTML, and front-end languages.
- Knowledge of REACT tools including React.js, Enzyme, Redux, and Flux.
- Experience with user interface design.
- Knowledge of performance testing frameworks including Mocha and Jest.
- Experience with browser-based debugging and performance testing software.
- Excellent troubleshooting skills.
- Solid analytical and problem-solving skills.
- Strong interpersonal, written and verbal communication skills.
- Experience with gathering user requirements and understanding and interpreting requirements specifications
- Experience with full System Development Life Cycle is a plus
- Maintain time reporting on projects and provide timely updates to project milestones.
Required Candidate profile
Primary Skills:
Strong working knowledge of Typescript, MongoDB, Express.
Strong proficiency in TypeScript, Javascript including DOM manipulation and the JavaScript object model, ES6.
Strong understanding of NodeJS fundamentals.
Knowledge and experience working with PostgreSQL is a major plus.
Experience with ORM libraries.
Familiarity with RESTful APIs.
Experience in troubleshooting and RCA of Production issues Analyze logs in Kibana Elastic Search.
Knowledge of tools like Git, Github, JIRA, Cucumber, Jasmine, and others that make coding more efficient and easier to share.
Familiarity of working in either the AWS Cloud or Azure including Docker + Kubernetes based microservice deployment.
Secondary Skills:
Good communication and design skills Experience in handling teams.
Solid back-end software development experience.
Ability to understand business requirements and translate them into technical requirements.
Experience working in an Agile environment.
Qualification:
Good experience as Software Developer.
Prior experience in a technical leadership or developer position.
Back End Developers/ API Web Services Experience Mandatory.
NodeJS is mandatory.
One RDBMS and one document database mandatory.
Location Mumbai or Ahmedabad.
Candidates from ecommerce and consumer facing app development experience will be given preference.











