PostgreSQL
Amazon Web Services (AWS)Job Description for PostgreSQL Lead
Job Title: PostgreSQL Lead
Company: Mydbops
About us:
Mydbops helps fast-growing teams and unicorns run mission-critical databases with speed, scale, and reliability. Trusted by 800+ clients, including 30+ unicorns, we optimize and manage systems like MySQL, PostgreSQL, MongoDB, MariaDB, TiDB, and Cassandra, powering 10B+ transactions daily across industries such as fintech, SaaS, healthcare, logistics, and e-commerce.
With 10 years of deep expertise, we build automation tools, lead complex migrations, and solve high-impact performance and database challenges. We are ISO and PCI-DSS certified, combining engineering excellence with enterprise-grade security and compliance.
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 (10)
Python
Data AnalyticsAs an Analyst at Tap Invest, you’ll turn data into decisions. You’ll work with teams across
Product, Ops, Marketing, and Sales to uncover insights, solve real business problems, and
drive strategy.
This role is for someone who is comfortable working with data independently and can
support business teams with reliable analysis and reporting.
Key Responsibilities
● Gather, organize, and clean data from various sources including databases,
spreadsheets, and external sources to ensure accuracy and completeness.
● Write SQL queries to pull, validate, and clean data from production databases.
● Build and maintain dashboards, and generate KPI reports. Track performance
against targets and identify areas for optimization.
● Analyze user funnels and investment patterns to surface actionable insights.
● Prepare and present clear, concise reports and visualizations to communicate
findings and recommendations to stakeholders across teams.
● Document data definitions, metrics, and assumptions clearly for consistency and
reuse.
What We’re Looking For
● 1 to 2 years of experience in Data Analytics, Business Analytics, or a similar role.
● Comfortable writing in SQL and validating queries.
● Solid with Excel / Google Sheets (pivot tables, lookups, charts).
● Genuine curiosity about how businesses use data to make decisions.
● Experience with scripts for data automations.
● Prior projects involving production datasets.
Nice to Have
● Familiarity with pandas or any data manipulation library for advanced automations.
● Interest in capital markets, bonds, fixed income or FinTech.
● Exposure to AI tools
The Accounts Executive is responsible for managing day-to-day accounting activities, maintaining accurate financial records, and supporting financial reporting. The role ensures compliance with accounting standards, statutory requirements, and internal policies.
Key Responsibilities
- Maintain books of accounts including vouchers, invoices, bills, and receipts
- Handle accounts payable and accounts receivable
- Prepare journal entries, ledgers, and monthly reconciliations
- Assist in preparation of monthly, quarterly, and annual financial reports
- Process GST returns, TDS calculations, and statutory compliance
- Coordinate with auditors during internal and external audits
- Manage bank reconciliation statements and cash flow tracking
- Ensure timely payment to vendors and follow-up on receivables
- Support budgeting and expense control activities
- Maintain proper documentation and filing of financial records
NOTE : only female candidates
Candidates in and around kovilpalayam are preferred.
Bachelor’s degree in Accounting, Commerce, or Finance.
1–2years of accounting experience (internship experience can be considered for freshers).
Proficiency in MS Excel and accounting software (Tally, Zoho Books, QuickBooks, or similar).
Basic knowledge of GST, TDS, and statutory compliance. Strong numerical and analytical skills.
Excellent communication and organizational skills.
High attention to detail and ability to meet deadlines.
Ability to work in a fast-paced startup environment and adapt to evolving processes.
Job Title: Call Centre Executive – Aquaculture Shrimp Feed
Location: [Specify City/Location]
Experience Required: 1 to 1.5 Years in Voice Process
Languages Required: Hindi or Bengali (Fluency mandatory)
Industry: Aquaculture / Animal Feed / Agriculture
Job Summary:
We are seeking a proactive and customer-focused Call Centre Executive to join our aquaculture division, specializing in shrimp feed. The role involves handling inbound and outbound calls, providing product information, resolving customer queries, and supporting the sales/technical team.
Key Responsibilities:
- Handle incoming and outgoing calls from farmers, dealers, and distributors related to shrimp feed products.
- Communicate effectively in Hindi or Bengali to understand customer needs and provide accurate product or service information.
- Assist in order placement, follow-ups, and delivery coordination.
- Record and maintain customer interaction logs in the CRM system.
- Provide basic technical guidance on shrimp feed usage as trained by the technical team.
- Coordinate with the field sales and logistics teams to ensure smooth customer service.
- Escalate unresolved queries to the concerned departments.
Requirements:
- 1 to 1.5 years of experience in a call centre/voice process role (preferably B2B or agriculture-related).
- Strong communication skills in Hindi or Bengali and basic English.
- Basic understanding or interest in aquaculture, agriculture, or animal feed is a plus.
- Good computer skills – MS Office, CRM, data entry.
- Customer-centric attitude with good problem-solving skills.
Preferred Qualifications:
- Experience working with rural/agricultural customers is an advantage.
- Background in agriculture/fisheries/aquaculture is desirable but not mandatory.
Employment Type: Full-Time
Java
Spring BootJava Developer
As a senior technical member of the team, you will be expected to lead the team in the design, architecture, and implementation of high-quality, well-architected software products with a specific focus on cloud, distributed systems, scalability, elasticity and SLA rollups into each component. In this role, you are expected to interact with Senior Architects, Product Managers, Solution Architects and occasionally, with Partners and customers to discuss and collaborate on strategies for enhancing features and coming up with next-generation products. Critical thinking and strong leadership skills are a must as the candidate will be involved in leading a team and making crucial road map decisions.
The Work: What type of work will you be doing? What assignments, requirements, or skills will you be performing on a regular basis?
- 8+ years of hands-on experience with Java-based development projects using RESTful APIs, SpringBoot, horizontal scalability, microservices, high availability principles
- You master the entire life-cycle including research, design, application and deployment architecture, development, testing (dev owns quality), continuous deployment and continuous delivery up until to production.
- You will develop complex, highly available, distributed, cloud-based solutions, and maintain its high level of quality software.
- Solid background in OOP, object and data modelling using SQL and NoSQL databases
- Experience using containers, Kubernetes and developing services on AWS
- Monitor resource allocation, consumption, and performance.
- Engage in service software performance analysis and system tuning.
- Challenge yourself to walk in a different path and to deliver quickly while maintaining a high quality
- Experience with automation tools like Jenkins, GitLab CI
- Excellent communication skills essential
React.js
Javascript
Redux/Flux- 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
Javascript
Angular (2+)React.js
AngularJS (1.x)
Vue.jsKey Skills:
o Determining the structure and design of web pages.
o Ensuring user experience determines design choices.
o Developing features to enhance the user experience.
o Striking a balance between functional and aesthetic design.
o Ensuring web design is optimized for smartphones.
o Building reusable code for future use.
o Optimizing web pages for maximum speed and scalability.
o Utilizing a variety of markup languages to write web pages.
o Maintaining brand consistency throughout the design.
o Understanding of key design principles.
o Experience with Angular and React.
o Proficiency in HTML, CSS, JavaScript, and jQuery.
o Understanding of server-side CSS.
o Experience with responsive and adaptive design.
o Understanding of SEO principles.
o Good problem-solving skills.
• Good to have skills:
o Knowledge of additional framework like ViewJS and NodeJS is a big plus.
o Knowledge of PHP - object orientated concepts and frameworks such as Laravel or
CodeIgniter.
o MySQL concepts
o Understanding accessibility and security compliance
Java- A minimum of 3 years experience as a Technical Lead in Java., Strong experience in design and implementation of high performing and highly scalable websites/applications
- Strong experience in Spring MVC framework and experience in design patterns, unit testing etc..
- Strong experience in AWS services such as EC2, Lambda, S3, ECS, API Gateway and using tools such as Terraform, Ansible
- Strong experience in Endeca, ATG and BCC, Solr, any Headless CMS
- Considerable experience in databases such as SQL Server/Mongo DB is an added advantage
- Good experience in JavaScript frameworks such as Angular/React/VueJS is an added advantage
- Experience in Adobe AEM is an added advantage
- Creative problem-solving skills and ability to effectively communicate and translate feedback, needs and solutions
- Excellent verbal and written communication skills required
- Provide strategic thinking and leadership pertaining in cloud technologies and building scalable websites
- Provide technical leadership and guidance internally to the team and externally to management
- Communicate effectively across all levels of the organization
- Collaborate within and across teams with strong teamwork orientation
- Help maintain a culture of high quality
- Showcasing excellent work ethic and strong sense of ownership of end result
- Understand the structured software development methodologies including design, development and testing in an Agile environment
- Follow all security practices and identify areas and processes where performance and scalability can be improved
- Make and justify recommendations for improvement., Participate in development of solutions in cases of new technology direction and/or proof of concepts
- Should translate business needs into technical solutions with Strong analytical, conceptual and technical skills
- Support the evaluation, selection, design, development and maintenance of the platforms.
Java
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon