Teradata

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

∙

Good experience in 5+ SQL and NoSQL database development and optimization. 

∙Strong hands-on experience with Amazon Redshift, MySQL, MongoDB, and Flyway. 

∙In-depth understanding of data warehousing principles and performance tuning techniques. 

∙Strong hands-on experience in building complex aggregation pipelines in NoSQL databases such as MongoDB. 

∙Proficient in Python or Scala for data processing and automation. 

∙3+ years of experience working with AWS-managed database services. 

∙3+ years of experience with Power BI or similar BI/reporting platforms. 

Software Engineer (Web/UI Engineer)

Please apply only if you satisfy work experience requirements Our Vision , we are building a first-of-its-kind, lifestyle health product for Women in India. We believe that the future of health and fitness is digital, and women will drive the digital fitness revolution in India. Existing digital health and fitness products are highly transactional and we see a huge opportunity to build a truly aspirational product that will inspire and empower millions of women to lead healthier lives. If you are passionate about building a product that blends together, technology, content, and community, we would love to talk to you. looking for results-oriented Engineers. An ideal candidate for us would be a passionate builder of great products/frameworks and someone who would thrive in a fast-paced environment and enjoy the challenge of complex business contexts that are typically being defined in real-time. In this role, you will be responsible for building world-class technology products and platforms that are at the forefront of the technology revolution in the Indian healthcare ecosystem. You are someone who insists on the highest standards for quality, maintainability, and performance. You will be working in a fast-paced and agile work environment delivering quality solutions that have an immediate business impact. Responsibilities ● Own the end-to-end development and launch of features on the web ● Participate in scoping, planning discussions with the designers, PMs, and Leads ● Conceptualize and develop prototypes quickly ● Develop and own launch plans ● Identify opportunities and implement solutions to improve the performance and the architecture of our web stack ● We will depend on this person to set-up/improve the fundamental architecture of our web apps and so it is highly desirable to have someone who has worked extensively on React codebases. Required Skills ● Solid understanding of HTML and CSS ● Strong proficiency in JavaScript ● Responsive Web pages ● React preferably with Typescript ● Has worked with the react ecosystem for eg, redux, react-query, react-router etc. ● At least 2 years of experience working in a consumer tech set-up (ecommerce, D2C) ● Work with Rest APIs Good-to-have Skills ● Next.js ● Knowledge of deployment and hosting react apps

Job Title: Senior Lead – Application Engineering

Remote | Chennai | Hyderabad | Bangalore

Tiger Analytics is a global AI and analytics consulting firm. With data and technology at the core of our solutions, our 2800+ tribe is solving problems that eventually impact the lives of millions globally. Our culture is modeled around expertise and respect with a team-first mindset. Headquartered in Silicon Valley, you’ll find our delivery centers across the globe and offices in multiple cities across India, the US, the UK, Canada, and Singapore, including a substantial remote global workforce. 

We’re Great Place to Work-Certified™. Working at Tiger Analytics, you’ll be at the heart of an AI revolution. You’ll work with teams that push the boundaries of what is possible and build solutions that energize and inspire.

Curious about the role? What your typical day would look like?

As an Application Engineer, you will be responsible for Application Engineering capability, designing and developing web applications, and managing small teams of App engineers In doing so, you will closely collaborate with program leads and technology architects across global locations.

More specifically, you might:

• Collaborate with business analysts and technical managers to understand functional, and non-functional requirements, and scope.
• Design and develop multi-tier, cloud-native, high-performance, and scalable solutions
• Indulge in applying benchmarking software engineering principles and design patterns to build robust world-class solutions.
• Direct cross-functional agile teams as a leader across the software development lifecycle
• Analyse design alternatives using proofs-of-concept, and engage with architects to choose the best optimal solutions
• Obsess about writing high-quality code and performing reviews of the design and code.
• Interact and collaborate with project/program managers to estimate, plan, and reduce technical concerns at the module or project level.
• Ideate with your peers, support their work, and provide constructive feedback on their solutions.
• Try to get to the heart of the problem by closely liaising with customers and getting to the heart of what's working and what's not.

What do we expect? 

• 8+ years of experience
• A passion to write clean yet simple programs using JavaScript, HTML5, CSS3
• A drive to create basic, uncluttered programs using Java / .Net core / Python with Django or Flask.

• Keen interest in creating web frameworks like Angular / React JS 
• A comprehensive foundation using object-oriented and functional programming languages. 
• Wide-ranging knowledge in web server technologies - Node.js / Nginx
• Exposure to Cloud environments - AWS / Azure / GCP
• Good understanding of working with API design and development

You are important to us, let’s stay connected!

Every individual comes with a different set of skills and qualities so even if you don’t tick all the boxes for the role today, we urge you to apply as there might be a suitable/unique role for you tomorrow. 

We are an equal-opportunity employer. Our diverse and inclusive culture and values guide us to listen, trust, respect, and encourage people to grow the way they desire. 

Automation Testing

• Lead end to end Testing Automation Process
• Design and implement efficient Testing practices
• Conduct Test case and Code reviews to ensure the quality of Test Cases, Test coverage and Automation Code
• Participate in Planning meetings and ensure quality at all levels of SDLC
• Provide estimations for Manual and Automation
• Provide Testing and Automation Strategy for newly developed Features
• Identify the right tool and set up the automation framework for UI, API, and unit level
• Increase Automation confidence by reducing random test failures
• Work closely with the Development team and ensures code is delivered with high code coverage
• Responsible for QA metrics and Automation ROI and report them to management
• Identify Performance Application Performance bottlenecks and suggest the right tool and test strategy for Non-Functional Testing
• Guide and Mentor QA Team on the Testing and Automation Tools, Frameworks and Process
• Measure and Investigate Defect Leakage and provide preventive measures
• Identify CI / CD tools, define branching strategies, setup CI / CD pipeline

• Generate new business opportunities by introducing the company’s wide suite of solutions within assigned territories and accounts via cold-calling, email, and social media prospecting.
• Identify the key decision-makers within these prospects to understand their requirements in detail and how the can company help in delivering those requirements.
• Follow-up on leads generated through websites, events, emails campaigns, and qualify it further to be passed on to the sales reps for closure.
• Keep the data within the CRM updated with all the relevant information, communications on regular basis.
• Maintain and expand your database of prospects within your assigned territory
• Work closely with the assigned sales rep to grow the sales pipeline to meet monthly, quarterly targets.

Key Requirements.

• 2-5 years of experience in inside sales in India and other Southeast Asian countries.
• Excellent verbal and communication skills.
• Strong listening skills.
• Ability to multi-task, prioritize and manage time effectively.
• Experience working with HubSpot CRM or equivalent.
• Familiar with basic email and phone etiquettes while communicating with clients or prospects.

Skill Sets

• Communication.
• Cold calling.
• Listening
• Business Email Writing.
• Organizing and Planning.
• Problem-solving and analytical.
• Market research and information gathering.

• Company is developing cutting-edge technology and you will be working on a patented technology in a challenging environment with industry veterans and highly talented engineers
• Company is in an explosive growth path and now is the right time to ride-along and experience the growth from a startup to an iconic large company