
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
Strong Full Stack Engineer profiles
Mandatory (Experience 1) – Must have 1+ years of hands-on full stack engineering experience (avoid frontend-heavy only profiles, backend heavy will work)
Mandatory (Experience 2) – Must have strong backend engineering experience using Python, including designing and owning APIs, services, and data models in production environments
Mandatory (Experience 3) – Must have strong frontend development experience using React (or equivalent), including component architecture, state management, and building production-grade user interfaces
Mandatory (Experience 4) – Must have end-to-end ownership experience, building and shipping features across the full stack (UI + API + database) without clear handoff boundaries
Mandatory (Experience 5) – Must have strong web fundamentals, including understanding of browser rendering, performance optimization, and accessibility best practices
Mandatory (Experience 6) – Must be able to demonstrate solving complex problems on both frontend and backend, clearly articulating trade-offs, decisions, and outcomes
Mandatory (Experience 7) – Must have solid experience with databases (SQL/NoSQL), including schema design, query optimization, and handling performance bottlenecks
Mandatory (Company) - Top Product Companies, (preferred early-stage startups with Seed to Series C/D with fast-paced shipping culture)
Mandatory (Education) - Tier-1 institutes (IITs, BITS, IIITs), Can be skipped if from Top notch product companies
- Sound knowledge of Mongo as a primary skill
- . Should have hands on experience of MySQL as a secondary skill will be enough
- . Experience with replication , sharding and scaling.
- . Design, install, maintain highly available systems (includes monitoring, security, backup, and performance tuning)
- . Implement secure database and server installations (privilege access methodology / role based access)
- . Help application team in query writing, performance tuning & other D2D issues
- • Deploy automation techniques for d2d operations
- . Must possess good analytical and problem solving skills
- . Must be willing to work flexible hours as needed
- . Scripting experience a plus
- . Ability to work independently and as a member of a team
- . good verbal and written communication skills
Company Description
At Magma, we create content that delivers tangible outcomes. Some of the world’s best companies come to us when they need content that ranks high on search engines and drives real engagement.
Our clients include Airbnb, Upwork, Digital.com, Nice Job, Unmudl, and many more.
Job Description
We are seeking a dynamic and detail-oriented Brand Manager with experience in a marketing agency environment to join our team. The ideal candidate will have a proven track record of managing clients and executing successful brand strategies. This role requires a strong understanding of social media management, content planning, and team leadership, with a keen eye for detail and excellent communication skills.
Key Responsibilities:
1) Develop and implement comprehensive brand strategies for clients to enhance brand awareness and market presence.
2) Manage client relationships, ensuring exceptional service and clear communication to understand their needs and objectives.
3) Oversee social media management, including content planning, creation, and scheduling to drive engagement and brand loyalty.
4) Collaborate with cross-functional teams to produce high-quality content that aligns with brand guidelines and marketing goals.
5) Monitor and analyse market trends, competitor activities, and campaign performance to inform strategy and optimize results.
6) Lead and mentor team members, fostering a collaborative environment to achieve project goals.
7)Coordinate with international teams or clients, leveraging global insights to enhance brand
strategies.
8)Utilize SEO best practices to improve online visibility and drive traffic to brand platforms.
Qualifications:
1) Bachelor’s degree in Marketing, Business, or a related field.
2) 3-5 years of experience in brand management, preferably within a marketing agency.
3) Proven experience in client servicing and relationship management.
4) Strong knowledge of social media platforms, content planning, and digital marketing strategies.
5)Familiarity with SEO principles and practices is a plus.
6) Exceptional communication skills, both written and verbal.
7) Ability to multitask and manage multiple projects simultaneously while maintaining attention to detail.
Benefits:
1) Opportunities for professional development and growth.
2) A dynamic work environment that encourages creativity and innovation.
As a IT Sales Executive, you will play a crucial role in expanding our client base, building strategic relationships, and identifying new business opportunities. This role is ideal for someone who is ambitious, results-driven, and eager to grow in the field of sales and business development.
Key Responsibilities:
✅ Lead and manage the sales process to attract new clients.
✅ Collaborate with senior team members to identify and mitigate risks.
✅ Build and maintain strong client relationships to ensure satisfaction and retention.
✅ Conduct thorough market research to identify potential business opportunities.
✅ Prepare and deliver impactful sales pitches to prospective clients.
✅ Foster a collaborative and growth-oriented environment within the organization.
Key Skills Required:
✔ Target-driven mindset – Ability to achieve and exceed sales goals.
✔ Time management & organizational skills – Effectively prioritize tasks and meet deadlines.
✔ Strong communication & presentation skills – Ability to confidently present ideas.
✔ Enthusiastic, ambitious & confident approach – A go-getter attitude towards sales.
✔ Adaptability & problem-solving – Ability to handle challenges proactively.
✔ Professionalism & flexibility – Strong interpersonal and negotiation skills.
● 3- 5 years of experience with copy. Experience working with an agency or
withan in-house team are strong bonuses.
● The ideal candidate also has some experience writing for a finance brand. It’s
NOT a must, but good to have.
● Flexibility to work independently while also being able to collaborate
effectively within a team, change course as needed, or brainstorm on the
spot.
● Ability to own and back up their work, along with a positive attitude and
openness toward input and revisions from stakeholders.
Day to day responsibilities:
● Work with our existing team to produce high-quality communications, from
concept to execution, for emails, landing pages, social media, microsite,
marketing collateral and more.
● Write clear effective copy, using the creative brief as your primary source of
guidance.
● Participate in project kickoffs, internal team meetings as needed.
● Ensure adherence to delivery timelines for all output.
● Walk through your their work internally and have a clear point of view that they
can clearly explain
● Act as an audience advocate and a steward of the brand. Ensure that all
output is on-brand, consistent and of high quality.
provide right information and advice on study opportunities and visa
application for International Institutions.
• Submit applications to the educational institutions, obtain offers and facilitate
enrolments
• Follow- up with potential students and maximise conversion by submitting
applications and finalising enrolments.
• Maintain proper and comprehensive records and documentations including the
ability to learn on own initiatives and research best study options for students.
• Assist in organizing exhibitions and other promotional activities
• Proactively connect with existing and potential students via various
communications channels such as email, phone and in person
• Maintain professional relationship with students, internal offices staff and
educational institutional representatives.
• Undertake work as decided by the senior heads or the Director of of the
company and meet the assigned targets.
• An ability to communicate effectively with colleagues, students and other
members of the public of all age groups and social backgrounds.
Their services are available across the globe, with over 65% of their client base being from US, UK, and Canada. The company's primary focus is on Ayurveda and taking the ancient knowledge to anyone who wishes to bring back balance to their health and apply the tools in their everyday life.
- Tracking, managing and replenishing inventory at all the warehouses and all products of all brands of the company.
- Keeping an eye on the sales targets and making sure that inventory projections are made on a biweekly basis and tallied with the inventory in pipeline to ensure products are never out of stock.
- Managing and optimizing logistics cost constantly by optimizing daily processes and analyzing to find all inefficiencies in the processes currently in use.
- Establishing and enforcing departmental policies in sync with the other teams and their policies to ensure smooth synergy within the organization.
- Overseeing expenses related to packaging and other secondary expenses made by all warehouses and optimizing for any inefficiencies
- Reviewing team performance of all warehouses and solve for any gaps.
What you need to have:
- 1 to 4 years of experience in operations/ logistics.
- Preferably in Ecomm , retail, FMCG Companies
- Bachelor's degree
- Excellent understanding and background working in supply chain and warehouse management
- Research industry-related topics (combining online sources, interviews and studies)
- Write clear marketing copy to promote our products/services
- Prepare well-structured drafts using Content Management Systems
- Proofread and edit blog posts before publication
- Coordinate with marketing and design teams to illustrate articles
- Conduct simple keyword research and use SEO guidelines to increase web traffic Promote content on social media
- Identify customers’ needs and gaps in our content and recommend new topics Ensure all-around consistency (style, fonts, images and tone)
- Update website content as needed








