
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
We’re Hiring! Business Development Executive (BDE) – IT Staffing & Recruitment 🚀
📍 Location: Remote
📅 Experience: 6+Years
🏢 Industry: IT (B2B) | Permanent & C2H Staffing
Are you a go-getter with a passion for sales and client engagement in the IT staffing industry? We’re looking for a driven Business Development Executive (BDE) to join our growing team!
🔍 What We’re Looking For:
Must-have: Proven experience in B2B sales with a strong background in IT recruitment – Permanent & C2H
Key Responsibilities:
Lead generation & full sales lifecycle management
Building strong client relationships
Conducting market research & achieving revenue targets
Collaborating with internal recruitment teams
🌟 Why Join Us?
✅ 5-day workweek (Monday–Friday)
✅ Supportive, growth-focused culture
✅ Exposure to diverse IT clients across industries
📧 If this sounds like you—or someone you know—let’s connect!
We are seeking a new graphic designer to join our team. You will be designing a wide variety of things across digital and offline media. To be successful in this position, youll be a self-starter, capable of delivering brilliant creative ideas, and show amazing attention to detail.
Here are the details
Experience : 0-2 yrs
Mode : C2H
Skillset : Graphic designer
Location : Remote (Anywhere in India)
Interested candidates Please share your updated profiles to us along with portfolio's.
Responsibilities:
- Design website banners, retouch images, company creatives and collaterals
- Create Infographics, brochures, flyers, etc. using Adobe tools
- Convert content in compelling images for Amzurs social channels
- Adhere to brand guidelines and complete projects according to deadline
Requirements:
- Excellent communication skills to present the design ideas
- Basic knowledge of layouts, typography, line composition, color, lighting
- Should understand design aesthetics and functionality fundamentals
- Sound understanding of InDesign, Adobe Photoshop, and Illustrator
- Strong creative and analytical skills
- Understanding of Google Slides, Docs, and Sheets
- Understanding of After effects is a plus but optional
- Basic video editing capabilities are a plus but optional
- Compelling portfolio of graphic design work
- Should adhere to SDLC processes and Oracle standard documentation /Operating Procedures
- Develop Reports, Charts and Forms using built-in UI components
- Add HTML5 and CSS3 scripting to improve the User Interface thereby providing a better user experience
- Include custom scripting (JavaScript/JQuery/AJAX) as per the business requirement
- Prepare Test cases/reports. Perform Unit , Peer and System Testing on the same
- Inspect / Debug the code logic using the browser developer tools
- Deploy Authentication and Authorization for the modules as per requirement
- Build features and applications with a mobile responsive design (Not mandatory)
- Migrate application and DB objects from DEV to TEST/PROD environments.
- Mandatory to work from Bosch Bangalore office from the start
Mandatory and Optional Skills
Sr. No.
Technical Skills
Mandatory /Good to have
Min Years of hands on Exp in this skill
1
Oracle Apex
Mandatory
3 Yrs
2
Oracle SQL, PL/SQL, Oracle DB Models/Objects
Mandatory
3-5 Yrs
3
Extensive project experience in developing Interactive Reports/Grids, Charts/Graphs, Forms (version > 20.x)
Mandatory
3
4
JavaScript, JQuery, AJAX, CSS and HTML5
Knowledge
1-2 Yrs
5
Data and UI integration with external (Oracle & Non-Oracle) systems
Knowledge
3 Yrs
- Should adhere to SDLC processes and Oracle standard documentation /Operating Procedures
- Develop Reports, Charts and Forms using built-in UI components
- Add HTML5 and CSS3 scripting to improve the User Interface thereby providing a better user experience
- Include custom scripting (JavaScript/JQuery/AJAX) as per the business requirement
- Prepare Test cases/reports. Perform Unit , Peer and System Testing on the same
- Inspect / Debug the code logic using the browser developer tools
- Deploy Authentication and Authorization for the modules as per requirement
- Build features and applications with a mobile responsive design (Not mandatory)
- Migrate application and DB objects from DEV to TEST/PROD environments.
- Mandatory to work from Bosch Bangalore office from the start
Mandatory and Optional Skills
Sr. No.
Technical Skills
Mandatory /Good to have
Min Years of hands on Exp in this skill
1
Oracle Apex
Mandatory
3 Yrs
2
Oracle SQL, PL/SQL, Oracle DB Models/Objects
Mandatory
3-5 Yrs
3
Extensive project experience in developing Interactive Reports/Grids, Charts/Graphs, Forms (version > 20.x)
Mandatory
3
4
JavaScript, JQuery, AJAX, CSS and HTML5
Knowledge
1-2 Yrs
5
Data and UI integration with external (Oracle & Non-Oracle) systems
Knowledge
3 Yrs
About us:
HappyFox is a software-as-a-service (SaaS) support platform. We offer an enterprise-grade help desk ticketing system and intuitively designed live chat software.
We serve over 12,000 companies in 70+ countries. HappyFox is used by companies that span across education, media, e-commerce, retail, information technology, manufacturing, non-profit, government and many other verticals that have an internal or external support function.
To know more, Visit! - https://www.happyfox.com/
We’re looking for a Lead Backend Engineer with 5+ years of experience in building web services to join our engineering team to help architect, build and run our growing list of products. You should have prior experience being responsible for building sufficiently complex products/services and mentoring software engineers.
Responsibilities:
- Lead a team of engineers working on our product roadmap. You are expected to contribute to feature development with hands-on development tasks
- Oversee software architecture, source control workflows, and CI/CD processes and perform code reviews to ensure exceptional code quality
- Improve the development experience and the quality of the codebase. You will define and uphold best practices and coding standards for the team
- Responsible for architecture and design decisions
- Own stability and performance of the service that you work on
- Work with the Engineering Manager to ship stable software on time
- Contribute to the vision and long-term strategy in your area of expertise
Requirements:
- 2+ years of experience in a technical lead role designing and building complex backend systems
- 5+ years of professional software development experience
- Excellent knowledge of best practices and coding patterns
- Deep knowledge of backend programming languages like Python and web application frameworks like Django
- Solid experience in building web services using relational databases like PostgreSQL or NoSQL databases like MongoDB
- Proficiency with Amazon Web Services (AWS) or Google Cloud Platform or Azure
- Extensive experience with Linux/UNIX production environments
- Strong sense of quality in terms of both program architecture and code style
- Passion to dig into technically complex problems to troubleshoot and figure out a solution
- Desire to continuously improve and ship the best quality product
- Pragmatic approach to make sure technical decisions align with actual business needs.
- Good understanding of the trade-offs when building for product value, reliability, or performance
- Excellent communication skills with the ability to discuss and explain your point of view clearly and effectively
- An engineering degree is a must(B.E. CS preferred)
Organization Name: Agami Realty
Company Website:agamirealty.com
Position Name: Sales Executive
Job Location: Boisar
Nature of Job: Permanent
Monthly Salary: In the range of Rs10,000/- to Rs 20,000/-
Sales Executive job responsibilities include, but are not limited to:
- Conduct market research to identify selling opportunities and evaluate customer needs
- Generate sales through cold calling and explain project amenities and pricing
- Set up meetings with potential clients to ensure maximum site visits
- Participate on behalf of the company in exhibitions or conferences
- Explaining the customer about the EMI and loan eligibility
- Help the customer in getting ready the documentation required for loan processing
Requirements
- Excellent knowledge of MS Office
- Thorough understanding of selling and negotiating techniques
- Fast learner and passion for sales
- Self-motivated with a results-driven approach
(Field Work)
• Doing cold calling
• Identifying sales opportunities
• Closing business deals
• Negotiating
• Following up with customers
• Meeting sales targets
• Managing customer relationships, ensuring sales growth
• Explaining the products to the customers
About the company
unHR is the brand name for Talent Loans Technologies Pvt. Ltd.
We provide HR-shared services to startups and small businesses who are either looking to hire their first HR or are struggling to manage their HR Processes.
Roles and Responsibilities
- Write high-engagement social media content that reflects our brand’s voice
- Edit and proof work to ensure high editorial standards are met across all content outputs
- Conducting research to formulate ideas or support writing.
- Create compelling ad copy, landing pages, and marketing campaigns
- Write high-quality product descriptions and provide supporting content
- Work on creating graphics and social media content designs for the brand
- All designs are to be made on canva.
Requirements
- Strong editorial, proofreading, and writing skills
- Familiarity with keyword research
- Experience with social media and content marketing
- Excellent interpersonal, verbal, and written communication skills
- Ability to manage multiple projects and meet deadlines under pressure
- Must have worked on Canva
❖ Designing and maintenance of fully functional large relational and non-relational databases
❖ Server management and cloud-based infrastructure
❖ Identification of application issues when deploying the apps
❖ App deployment on the cloud along with solving debugging issues
❖ Coding architecture for frontend and backend
❖ Collaboration with IT team, researchers, designers for designing robust apps and encouraging business goals
❖ Creating features in apps that have a mobile responsive design
❖ Testing applications and fixing bugs, along with security and data protection features
❖ Establish code architecture decisions for supporting scalability and good performance
❖ Makes use of popular front-end frameworks like Bootstrap, LESS, etc and design UI components
❖ Participation with developers for the creation of scalable RESTful APIs.
❖ Conducting code reviews of peer developers.
• Build pixel-perfect, UIs for all mobile platforms.
• Native API's for deep integrations with both platforms.
• Identify and fix bugs and performance hold-up for showing that feels native.
• Write highest quality code
• Write automated tests to ensure the product is of the highest quality.
Skills
• Knowledge of object-oriented programming
• Experience in React-Native and Redux,
• Familiar with native build tools, like XCode, Android studio
• Solid at working with third-party component and debugging dependency conflicts
• Experience in native development for iOS and Android.
• Understanding of REST APIs, the document request model, and offline storage.
we are looking for a Sr. Software UI Engineer to join us! You will design, develop, troubleshoot and debug software programs for software enhancements and new products. Develops software including operating systems, compilers, routers, networks, utilities, databases and Internet-related tools. Determines hardware compatibility and/or influences hardware design. If you have a track record in and a passion for software engineering, want to be part of a business that is growing—with great opportunities, and are ready for your next role, then please apply today.










