Lead Data Scientist

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

AccioJob is conducting a Walk-In Hiring Drive with Adobe for the position of Tech Apprentice.

To apply, register and select your slot here: https://go.acciojob.com/fBcgVa

Required Skills: JavaScript, Java, SQL, HTML, CSS, Python

Eligibility:

Degree: MCA

Branch: All

Graduation Year: 2023, 2024, 2025

Work Details:

Work Location: Bangalore (Onsite)

CTC: 6 LPA to 7 LPA

Evaluation Process:

Round 1: Offline Assessment at AccioJob Bangalore & Chennai Centre

Important Note: Bring your laptop & earphones for the test.

Further Rounds (for shortlisted candidates only):

Programming Test, Aptitude + Programming Test, Technical Interview 1

Register here: https://go.acciojob.com/fBcgVa

SA Role Summary:

The Solutions Architect is responsible for designing and leading the implementation of technology solutions that align with the organization's business goals and technology standards. This role involves working closely with both technical teams and business stakeholders to translate business requirements into robust, scalable, and secure technology solutions.

Key Responsibilities:

Solution Design and Architecture:

●      Develop and maintain a comprehensive understanding of the business processes and technology landscape.

●      Design holistic technology solutions that address business challenges and opportunities, integrating with existing systems and technologies where necessary.

●      Define and document architectural designs, including system components, functionalities, interfaces, and data flows.

●      Taking into account all pillars of the Well-Architected Framework (WAF) on AWS - including Scalability, Resiliency

●      Identifying reusable components in a project and working with the Backend team to generalize those components.

●      Amazon Web Services (AWS) Certification (Preferred)

Technical Leadership and Guidance:

●      Provide technical leadership and guidance to development teams throughout the implementation phase, ensuring adherence to architectural principles and best practices.

●      Evaluate and recommend technologies and tools for the effective development and management of solutions.

●      Ensure the implemented solution is in compliance with the designed architecture. Deviation from the architecture must be evaluated and agreed upon.

Stakeholder Engagement and Communication:

●      Collaborate with business stakeholders to understand their requirements and translate them into technical specifications.

●      Communicate complex technical concepts to non-technical stakeholders in a clear and concise manner.

●      Act as a liaison between technical teams and business units, facilitating understanding and alignment on project objectives and deliverables.

Project and Risk Management:

●      Participate in project planning activities, including resource allocation, timeline estimation, and risk assessment.

●      Identify potential technical and project risks and develop mitigation strategies.

Quality Assurance and Best Practices:

●      Ensure solutions are designed and implemented to high-quality standards, including performance, security, and scalability considerations.

●      Advocate for and ensure adherence to software development best practices, including code reviews, continuous integration, and automated testing.

Continuous Learning and Improvement:

●      Stay abreast of emerging technologies and industry trends, evaluating their applicability to organizational needs.

●      Promote a culture of continuous improvement, encouraging innovation and efficiency improvements in technology practices.

About TensorIoT

TensorIoT is an AWS Advanced Consulting Partner. We help companies realize the value and efficiency of the AWS ecosystem. From building PoCs and MVPs to production-ready applications, we are tackling complex business problems every day and developing solutions to drive customer success.

TensorIoT's founders helped build world-class IoT and AI platforms at AWS and Google and are now creating solutions to simplify the way enterprises incorporate edge devices and their data into their day-to-day operations. Our mission is to help connect devices and make them intelligent. Our founders firmly believe in the transformative potential of smarter devices to enhance our quality of life, and we're just getting started!

TensorIoT is proud to be an equal opportunity employer. This means that we are committed to diversity and inclusion and encourage people from all backgrounds to apply. We do not tolerate discrimination or harassment of any kind and make our hiring decisions based solely on qualifications, merit, and business needs at the time.

• Hands on Work experience as a Python Developer
• Hands on Work experience in SQL/PLSQL 
• Expertise in at least one popular Python framework (like Django, Flask or Pyramid)
• Knowledge of object-relational mapping (ORM)
• Familiarity with front-end technologies (like JavaScript and HTML5)
• Willingness to learn & upgrade to Big data and cloud technologies like Pyspark Azure etc.
• Team spirit
• Good problem-solving skills
• Write effective, scalable code

Job Responsibilities:

• Collaboratively work with UX team, product managers, back-end engineers and other technical teams to create new, delightful and scalable UI
• Mentor junior members through training and individual support
• Responsible for all front end development on a project
• Ensure the technical feasibility of UI/UX designs
• Optimize application for maximum speed and scalability
• Identify and troubleshoot UX problems (e.g. responsiveness)
• Conduct layout adjustments based on user feedback
• Adhere to style standards on fonts, colors and images
• Optimize existing user interface designs
• Proactively learn and accordingly apply new technologies, best design practices and usability patterns

The ideal candidate must - 

• 5+ years of experience working with React or React-based frameworks
• Proficiency with browser-based debugging and performance testing
• Proficiency in Git and version control
• Considerable experience with a testing framework (Jest/Mocha)
• Familiarity with RESTful APIs and GraphQL
• Knowledge of modern authorization mechanisms, such as JWT Tokens
• Good understanding of common front-end development tools such as Babel, Webpack, NPM, Yarn etc
• Hands-on experience with CSS-in-JS libraries
• Proficient understanding of cross-browser compatibility issues and ways to work around them
• Keen to learn, mentor and willingness to take ownership of work items
• Possess strong communication and self-accountability

ASP.net core , MVC , *ASP.net core, MySql
MS SQL
*Angular 4 above
* oops concepts

* java script, case, and HTML exp in agile like scrum.

LOCATION- PUNE
Currently work from home.

Job Type: Full-time

• 2+ years of experience participating in the delivery of technology services.
• A proven ability to learn new applications & innovate in technology
• Strong Experience in technologies like Node, Webservices and Microservices
• Experience with cloud components and services and containerization technologies is desirable
• Exposure to ReactJS desirable
• Experience working with multiple types of datastores: Mongo DB, SQL
• Experience in integrating, designing and developing solutions is desirable
• Experience with CI/CD and TDD is desirable
• Frameworks - Express , Hapi , feathers
• Strong knowledge in Javascript

Roles & Responsibilities

• Capability to develop highly responsive applications and websites.
• Capability to find and fix bugs.
• Enhance the performance of an application close to a native one by removing the constriction.
• Capability to maintain code that is easy to understand.
• Write tests for automation so that the app can be tested easily.
• Capability to take advantage of native APIs for deep integration of all platforms.
• Capability to completely transcend a React Web App into a React Native one.

Skills

• Knowledge of Object-Oriented Programming.
• Complete familiarity with Javascript and capability to write script that is optimised and works perfectly.
• Capability to write Well-documented code with Javascript that is easily readable.
• Having the knowledge of third-party dependencies and debugging dependency conflicts that might occur.
• Understanding of native build tools like Xcode, Gradle etc.
• Experience in testing with tools like Jest, Detox, Cypress etc.
• Knowledge about Offline Storage, REST APIs, and document request model.

You are a motivated and energetic rockstar full stack developer. Go-getter, think out of box to create awesome front-end (jQuery or ReactJS) and back-end (APIs) of an application platform.

Skills:

- Develop web apps using jQuery or ReactJS, HTML5, CSS3, Bootstrap, PHP Advanced, any MVC framework and Ajax.

- Hands on knowledge of Adobe Photoshop

- Experience of setting up a production workflow with git and cloud deployment will be plus.

- Knowledge of web technologies such as NodeJS, ReactJS, VueJS etc will be plus


// must have a strong understanding of UI, cross-browser compatibility, general web functions and standards.

// willingness to learn and improvise skills

// "NEVER SAY NO" attitude towards new and challenging projects

// good verbal and communication skills

// excel in a fast-paced startup-like environment. Should be goal-orientated and be able to work without any supervision or mentorship.