Customer Support executive

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

A B.Tech/M.Tech in Computer Sc, an UI specialist should have 5-7 years of experience in UI development. We are specifically looking for a specialist who has:

• in depth understanding of Single Page Application Development.
• high expertise in ReactJS concepts, including the modification and creation of ReactDOM /Virtual DOM elements and testing of ReactJS components (Jest, Enzyme)
• proficiency in JavaScript Functional Programming techniques (JavaScript, Strong Understanding of JS Array functions, Ability to build Pure JS functions, Modular JS Development, Proficient in using Webpack bundling)
• strong understanding of JSX Layout dynamics and Styling (JSX, JSS)
• strong understanding of global state management libraries e.g. Redux
• proficiency in agile development environment under open source gitlab including testing, change management
• exposure to full life cycle of enterprise product development
• [Desirable] high level of skill with UI Frameworks such as Material-UI (React) and Prime React

QA Engineer - Automation:

We are looking for a candidate who will be an agent of change and who will drive and execute based on our Quality and Reliability Transformation Roadmap. He/She will be responsible for testing Education Service domains across platforms, automation of functional/regression and RFB (sanity) service test suites, Continuous Integration/Continuous Delivery pipeline and Shift Left methodologies. We will also expect the candidate to take ownership of a functional domain and play a hands-on role in the execution of testing for projects in this area.

The candidate should have extensive experience in testing, testing automation, testing leadership and software development. The candidate should be proficient in-service automation testing tools like Eclipse, IDNE, Jenkins, GIT hub. The candidate should have at least 4-8 years of service testing or software development experience.

The candidate should be flexible, highly adaptable and an excellent team player. The candidate is expected to work with Agile teams that consist of test analysts, developers, automation engineers and other stake holders. The candidate should expect to work in a global virtual team, sometimes across multiple time zones. The candidate may be assigned to more than one role or project at a time.  

QA Engineer - Automation Responsibilities:

• Create automation plan and delivery roadmaps
• Develop test automation solutions for applications across different platforms
• Adhere to existing standards; provide suggestion to improve and set new standards
• Participate in technical discussions with engineering teams to understand application architecture and API model
• Collaborate with QA Engineers and Software Developers to identify test automation scope and priorities
• Configure, maintain, and operate service test automation tools and frameworks
• Capture requirements and test cases, understand application features, analyse requirements and develop test automation solution with a view of the end to end application flow
• Design and create robust automated test scripts to address business and technical use cases
• Integrate test automation scripts with Continuous Integration and Delivery pipeline
• Communicate progress to the senior leadership on a regular basis
• Should have Education Service domain and application knowledge

QA Engineer - Automation Requirements: 

• A Bachelor's degree in Computer Science or related field
• 4-8 years’ experience working as a Service Test Automation Engineer
• Experience in collaborating effectively across a variety of IT and business groups, across regions, roles, and able to interact effectively with all levels
• Proven record of execution of QA strategy and unification of QA processes across organization
• Must have hands-on experience with Selenium automation using Java
• Working knowledge of any Relational Database and DB Queries.
• Working knowledge of tool and technologies like Jenkins, GIT, JIRA and ALM
• Well versed with approaches like BDD, Keyword Driven, Data Driven and hybrid Driven test automation.
• Good to have understanding of model-based testing.
• Understanding of Agile/Waterfall development process and is comfortable diving into the technical architecture of complex and highly scalable solutions
• Excellent leadership, communication (written and oral) and interpersonal skills. Experience in presenting to diverse audiences and conducting education and training.
• Have deep experience in defining and developing the service test automation framework.
• Development background is a major plus.
• knowledge of Rest, SOAP, MQ and microservices. (Nice to Have)

The Role

• Create fast and functional and intuitive interfaces.
• Create mobile responsive web pages that work on desktop, tablets and smart phones.
• Create well-written JavaScript, as well as expanding current JavaScript code.
• Create and maintain web forms that integrate with our CRM.
• Assist with API integration for dynamic email/web prospect and customer communications.
• Translate designs and style guides provided by the UI/UX team into functional user interfaces, ensure cross-browser compatibility and performance.
• Create functional pages and banners from design mock-ups.
• Test code across platforms and browsers.
• Document work and communicate issues when they arise.
• Assist troubleshooting production issues.

Requirement:

• Associate degree in a technology-related field required (bachelor’s degree preferred).
• 3+ years of experience in front-end development in a start-up or similar work environment.
• 1+ experience with Front End frameworks such as Angular 2.0/React JS/React Native.
• Knowledge of web standards and accessibility (W3C and s508).
• Ability to create production-quality CSS, SASS, and HTML for web applications with support for mobile and tablet devices.
• Good understanding of web-based application architecture.
• Designing/coding to overcome browser/platform constraints.
• Excellent problem-solving skills and JavaScript Knowledge.
• Ability to learn new tasks outside immediate range of skills.
• Able to collaborate effectively with both technical and non-technical colleagues
• Deadline oriented and able to multi-task in a fast pace environment.
• Knowledge of unit test frameworks like karma, Jasmine, Mocha, Chai etc.

• Manage sales operations in assigned district to achieve revenue goals.
• Supervise sales team members; the BSMs, on daily basis and provide guidance whenever needed.
• Identify skill gaps and conduct trainings to sales team.
• Work with team to implement new sales techniques to obtain profits.
• Assist in employee recruitment, promotion, retention and termination activities.
• Conduct employee performance evaluation and provide feedback for improvements.
• Contact potential customers and identify new business opportunities.
• Stay abreast with customer needs, market trends and competitors.
• Maintain clear and complete sales reports for management review.
• Build strong relationships with customers for business growth.
• Analyze sales performances and recommend improvements.
• Ensure that sales team follows company policies and procedures at all times.
• Develop promotional programs to increase sales and revenue.
• Plan and coordinate sales activities for assigned projects.
• Provide outstanding services and ensure customer satisfaction.