PostgreSQL
LeadershipJob 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
Shubham Vishwakarma
Full Stack Developer - Averlon
About MyDBOPS
About
Company social profiles
Similar jobs
Adobe IllustratorJob Title : Graphic Designer – Short Video Content Creator
Location : On-site – Gurgaon & Ghaziabad
Experience : 2+ Years
Working Days: Monday to Friday/Saturday
Job Summary :
We are seeking a talented and creative Graphic Designer with a strong focus on short video content creation for digital and social media platforms. The ideal candidate will have hands-on experience in both graphic design and video editing, with the ability to ideate, shoot, and edit engaging short-form video content.
Key Responsibilities :
- Design visually compelling graphics for digital, web, and social media platforms.
- Create and edit short-form videos (Reels, Stories, YouTube Shorts, Ads, etc.).
- Collaborate with marketing and content teams to conceptualize and execute campaigns.
- Develop motion graphics and basic animations as needed.
- Stay updated with design trends, social media formats, and video content best practices.
- Work on-site and coordinate with the team for shoots and editing sessions.
Required Skills :
- Proficiency in Adobe Creative Suite (Photoshop, Illustrator, After Effects, Premiere Pro).
- Knowledge of video editing tools (Final Cut Pro, DaVinci Resolve, etc. is a plus).
- Strong sense of design, typography, and color theory.
- Ability to manage multiple projects and meet tight deadlines.
- Creativity, attention to detail, and a strong portfolio of graphic and video work.
Preferred Qualifications:
- Bachelor’s degree or diploma in Graphic Design, Visual Communication, Multimedia, or a related field.
- Prior experience in a similar role with a portfolio showcasing short video content.
- Knowledge of social media platforms (Instagram, YouTube, Facebook, etc.) and their content requirements.
To Apply :
Please share your resume and portfolio/demo reel with examples of your graphic and video work.
React.js
Javascript
Redux/Flux
BootstrapRole and Responsibilities
We are looking for a great JavaScript developer who is proficient with React.js. Your primary focus will be on developing user interface components and implementing them following well-known React.js workflows (such as Flux or Redux). You will ensure that these components and the overall application are robust and easy to maintain. You will coordinate with the rest of the team working on different layers of the infrastructure. Therefore, a commitment to collaborative problem solving, sophisticated design, and quality product is important.
- • Developing new user-facing features using React.js
- • Building reusable components and front-end libraries for future use
- • Translating designs and wireframes into high quality code
- • Optimizing components for maximum performance across a vast array of web-capable devices and browsers.
- • Strong proficiency in JavaScript, including DOM manipulation and the JavaScript object model
- • Thorough understanding of React.js and its core principles
- • Experience with popular React.js workflows (such as Flux or Redux).
- • Experience in Bootstrap framework.
- • Familiarity with newer specifications of ECMAScript
- • Familiarity with RESTful APIs
- • Knowledge of modern authorization mechanisms, such as JSON Web Token
- • Familiarity with modern front-end build pipelines and tools
- • Experience with common front-end development tools such as NPM, YARN etc.
- • Ability to understand business requirements and translate them into technical requirements
- • A knack for benchmarking and optimization
- • Familiarity with code versioning tools Azure Devops.
- • Experience in IDE such as VS code \ VS.
- Experience – 10 - 14 years
- Qualification – Any graduate
The Sr. Analytics Engineer would provide technical expertise in needs identification, data modeling, data movement, and transformation mapping (source to target), automation and testing strategies, translating business needs into technical solutions with adherence to established data guidelines and approaches from a business unit or project perspective.
Understands and leverages best-fit technologies (e.g., traditional star schema structures, cloud, Hadoop, NoSQL, etc.) and approaches to address business and environmental challenges.
Provides data understanding and coordinates data-related activities with other data management groups such as master data management, data governance, and metadata management.
Actively participates with other consultants in problem-solving and approach development.
Responsibilities :
Provide a consultative approach with business users, asking questions to understand the business need and deriving the data flow, conceptual, logical, and physical data models based on those needs.
Perform data analysis to validate data models and to confirm the ability to meet business needs.
Assist with and support setting the data architecture direction, ensuring data architecture deliverables are developed, ensuring compliance to standards and guidelines, implementing the data architecture, and supporting technical developers at a project or business unit level.
Coordinate and consult with the Data Architect, project manager, client business staff, client technical staff and project developers in data architecture best practices and anything else that is data related at the project or business unit levels.
Work closely with Business Analysts and Solution Architects to design the data model satisfying the business needs and adhering to Enterprise Architecture.
Coordinate with Data Architects, Program Managers and participate in recurring meetings.
Help and mentor team members to understand the data model and subject areas.
Ensure that the team adheres to best practices and guidelines.
Requirements :
- Strong working knowledge of at least 3 years of Spark, Java/Scala/Pyspark, Kafka, Git, Unix / Linux, and ETL pipeline designing.
- Experience with Spark optimization/tuning/resource allocations
- Excellent understanding of IN memory distributed computing frameworks like Spark and its parameter tuning, writing optimized workflow sequences.
- Experience of relational databases (e.g., PostgreSQL, MySQL) and NoSQL databases (e.g., Redshift, Bigquery, Cassandra, etc).
- Familiarity with Docker, Kubernetes, Azure Data Lake/Blob storage, AWS S3, Google Cloud storage, etc.
- Have a deep understanding of the various stacks and components of the Big Data ecosystem.
- Hands-on experience with Python is a huge plus
Adobe Illustrator- Gathering and evaluating user requirements in collaboration with product managers and engineers
- Illustrating design ideas using storyboards, process flows and sitemaps
- Preparing and presenting rough drafts to internal teams and key stakeholders
- Testing UI elements such as CTAs, banners, page layouts, page designs, page flows, and target links for landing pages.
- Identifying and troubleshooting UX problems (e.g. responsiveness)
- Conducting layout adjustments based on user feedback
- Adhering to style standards on fonts, colors and images
What you need to have:
- Proven work experience as a UI/UX Designer or similar role
- Portfolio of design projects
- Up-to-date knowledge of design software like Adobe Illustrator and Photoshop
- Team spirit, strong communication skills to collaborate with various stakeholders
- Good time-management skills
React.jsJavascriptRedux/FluxJob Type: Full-time
Salary Offer: 3L PA - 5.4L PA
Job Location: Remote for 6-12 months due to the pandemic, then Mumbai, Maharashtra
Required experience:
1-2 years and above experience in developing frontend UIs using HTML5, CSS, Javascript with ReactJS. Candidate must have experience with data binding and state management (Redux/MobX)
Key Skills required :
1. Proficiency in HTML5 development
2. Proficiency in CSS Frameworks like Bootstrap ⅘
3. Strong understanding of Javascript
4. Hands on experience in building and implementing UIs in ReactJs including experience in building components, observables, state management and data binding
5. Strong expertise in building Responsive Websites
6. Experience fixing performance issues using tools like GTMetrix and Pagespeed Insights
7. Working experience in maintaining code versioning by committing to Git repositories
KRAs includes :
1. Understanding the scope of work and arriving at timelines
2. Frontend UI development using Reactjs, HTML5, Javascript and CSS
3. Implementing media queries and following Responsive Web Design principles for responsive websites
4. Implementing state management, databinding and mocking APIs
5. Unit testing prepared web applications and HTML pages
6. Coordinating with the testers to resolve any bugs
7. Reporting on daily and weekly progress
8. Optimization and performance tuning of code
strategic and business aspects of the company. You will be the first in command in the company and
responsible for giving the proper strategic direction as well as creating a vision for success. To thrive
as a CEO you must be a prudent manager, inspiring leader, has a business mindset and to be able to
see the “big picture” in a variety of settings. You will take actions to enhance the company’s cash
flow while keeping the human factor in perspective. The goal is to drive the company’s development
and guide it towards long-term success.
Responsibilities
· Develop high quality business strategies and plans ensuring their alignment with short-term and
long-term objectives
· Lead and motivate subordinates to advance employee engagement develop a high performing
managerial team
· Oversee all operations and business activities to ensure they produce the desired results and are
consistent with the overall strategy and mission
· Make high-quality investing decisions to advance the business and increase profits
· Enforce adherence to legal guidelines and in-house policies to maintain the company’s legality and
business ethics
· Review financial and non-financial reports to devise solutions or improvements
· Build trust relations with key partners and stakeholders and act as a point of contact for important
shareholders
· Analyze problematic situations and occurrences and provide solutions to ensure company survival
and growth
· Maintain a deep knowledge of the markets and industry of the company
Requirements
· Proven experience as CEO or in other managerial position
· Experience in developing profitable strategies and implementing vision
· Strong understanding of corporate finance and performance management principles
· Familiarity with diverse business functions such as marketing, PR, finance etc.
· In-depth knowledge of corporate governance and general management best practices
· An entrepreneurial mindset with outstanding organizational and leadership skills
· Analytical abilities and problem-solving skills
· Excellent communication and public speaking skills
· MBA/B.Tech from Tier-1 colleges with a knack of financial knowledge are preferred
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon