MERN full stack developer

Key Responsibilities

Reporting & Analytics Development

• Design, develop, and maintain complex reporting solutions serving mission-critical emergency

response operations

• Build interactive dashboards and data visualizations that transform large datasets into

actionable insights

• Develop advanced analytics features including trend analysis, predictive metrics, and

operational intelligence

• Create self-service reporting capabilities enabling stakeholders to access critical data

independently

• Implement real-time and scheduled reporting systems with appropriate caching and

optimization strategies

SQL & Database Architecture

• Write and optimize complex SQL queries involving multiple joins, subqueries, CTEs, window

functions, and aggregations

• Review existing database architectures and identify performance bottlenecks and optimization

opportunities

• Design and implement database schema enhancements to support evolving reporting

requirements

• Develop and maintain stored procedures, functions, and views optimized for reporting

workloads

• Perform comprehensive query performance analysis and implement tuning strategies across

PostgreSQL and AWS Aurora environments

• Create efficient indexing strategies and data access patterns for large-scale datasets

• Establish data modeling best practices for dimensional and transactional reporting needs

Performance Optimization

• Conduct systematic performance analysis of reporting queries processing millions of records

• Implement query optimization techniques including execution plan analysis, index tuning, and

query refactoring

• Design and implement data aggregation strategies, materialized views, and summary tables for

improved performance

• Monitor and optimize database performance metrics including query response times, resource

utilization, and concurrency

• Develop ETL processes and data pipelines optimized for reporting and analytics workloads

• Implement caching strategies and data archival policies to maintain optimal system

performance

Technical Collaboration

• Partner with Product and stakeholder teams to translate business reporting requirements into

technical solutions

• Conduct code reviews focused on SQL quality, performance, and best practices

• Provide technical guidance to development teams on reporting architecture and database

optimization

• Document database schemas, reporting architectures, and optimization strategies

• Collaborate with DevOps on database infrastructure, monitoring, and scaling initiatives

Required Qualifications

Experience & Background

• 8+ years of software engineering experience with significant focus on reporting, analytics, or

business intelligence

• 5+ years of hands-on experience writing complex SQL in production environments

• 3+ years working with large-scale databases (millions+ records) and optimizing query

performance

• Proven track record developing enterprise reporting solutions and analytics platforms

• Experience conducting database architecture reviews and implementing performance

improvements

Technical Expertise - SQL & Databases

• Expert-level SQL proficiency including complex joins, subqueries, CTEs, window functions, and

advanced aggregations

• Deep PostgreSQL expertise with production experience in query optimization and performance

tuning

• Strong understanding of database internals including execution plans, indexing strategies, and

query optimization

• Experience with AWS Aurora or other cloud-based PostgreSQL solutions

• Proficiency in stored procedures, triggers, functions, and database programming

• Advanced knowledge of database design principles, normalization, and dimensional modeling

• Experience with database performance monitoring and profiling tools

• Strong programming skills in PHP (Yii framework or similar MVC frameworks preferred)

• Solid experience with Vue.js or similar modern JavaScript frameworks for building reporting

interfaces

What You'll Work With

• Databases: PostgreSQL, AWS Aurora, multi-tenant architectures

• Backend: PHP (Yii framework), RESTful APIs

• Frontend: Vue.js (Vue 2/3), modern JavaScript, data visualization libraries

• Infrastructure: AWS (RDS, Aurora, S3, Lambda), Postgres

• Tools: Git/GitHub, JIRA, Agile development workflows

Work Location

Hyderabad, India - On-site position with flexible working arrangements to accommodate both India

and onsite teams

Responsibilities:

• Engage directly with customers to design, develop, and deploy AI enterprise applications on the 
• Become an expert in application design and development on the ; lead design and code reviews of end-to-end customer applications
• Perform enhancement, testing, and troubleshooting, of applications with and on behalf of customers
• Continuously identify technical risks and gaps; devise mitigation strategies in anticipation of customer needs
• Write specifications, documentation, and user guides for customer applications

 Required Qualifications:

• Bachelor’s degree in a Science, Technology, Engineering or Math (STEM) field
• 3+ years professional experience in a customer-facing role building enterprise cloud software applications
• Solid understanding of cloud computing concepts
• Solid understanding of databases types and trade-offs
• Demonstrated proficiency in Java and/or similar programming languages
• Working knowledge of Agile software development methodology
• Strong analytical ability and problem-solving techniques
• Strong organizational skills with high attention to detail
• Excellent interpersonal skills with the ability to work effectively in a cross-functional team

 Preferred Qualifications:

• Bachelor’s degree in Computer Science or equivalent field; graduate degree in complimentary STEM or Business field
• Experience building and deploying AI-based enterprise applications
• Solid understanding of common machine learning techniques, applications, and trade-offs
• Demonstrated proficiency in javascript and/or similar programming language
• Domain expertise in one or more of the following industries: Aerospace, Financial Services, Healthcare, Industrial Manufacturing, Oil & Gas, Public Sector, Power & Utilities, Supply Chain, Telecommunications
• Proficiency in time series analysis, data cleansing, and data normalization

Looking for someone who can take care of all the server-related works, their security, can handle code versions through GitHub, handle the server logs, loads with automated tools.

Hassle-free deploying the code on servers with automated scripts. Should have provision to manage the server downtime efficiently during deployment time on production environment.  Only privileged candidates can access the code and servers with a restricted IP address.

1. Responsibilities

• Serve as a point of cross-functional contact and expertise, providing support to development and QA teams for the build and release process in all environments.
• Provide emergency support for critical issues, research possible cause, and provide solutions.
• Aid DevOps team in the maintenance of existing automated deployment operations as well as the advancement of desired state automated CI-CD Pipelines
• Documents build and deployment process for assigned product and/or tools
• Aid Infrastructure team in the implementation of new resources used by the development, test, and production environments.
• Maintain awareness of best-in-class tools, languages, and practices related to development operations.
• Provides instructions to Infrastructure, Development and Test teams to aid in product development life cycle.

• Participate in discussions regarding new product development and product enhancements.
• 2. Requirements

• Experience working on Linux based infrastructure
• Configuration and managing databases such as MySQL, MongoDB
• Excellent troubleshooting
• Working knowledge of various tools, open-source technologies, and cloud services
• Awareness of critical concepts in DevOps and Agile principles
• Great Experience with public cloud platforms such as AWS, Google Cloud Platform (GCP), or Microsoft Azure.
• Must have implementation experience with TLS/SSL, public private key cryptography, how certificates work, and mutual authentication
• Should have deal with IP addressing, firewalls, open ports, DNS & DHCP

Product management

• Work closely with the product team to translate abstract business & product requirements into crisp technical specifications along with a delivery roadmap

Product Development

• Define code architecture decisions to support a high-performance and scalable product with a minimal footprint
• Developing the frontend/backend and APIs, primarily using the MERN stack for Troopod.
• Delivering a robust backend platform for the product by incorporating important considerations regarding minimal downtime, high availability, data redundancy, tight security, etc. into the design
• Preparing test cases, creating automated build and test processes, setting up systems for CI/CD, and monitoring for the product
• Deploying on AWS using the right services for optimal performance
• Support the Troopod mobile application in its entirety, including working on bug fixes and improving application performance, reliability, and stability
• Continuously discover, evaluate, and implement new technologies to maximize development efficiency
• Managing development and deployment of the product following Modular programming, proper documentation, and code versioning

Customer Success

• Ensuring seamless use of Troopod Web-app and Mobile App by clients or internal teams and successful integration of client systems with Troopod backend and APIs wherever applicable
• Assisting clients with necessary remote support needed for the smooth understanding of and integration with Troopod product

Team Growth

• Contributing to the growth of the engineering team through proactive effort on knowledge growth, process improvements, and performance enhancements on existing solutions

Prior experience in the following things is MUST:

• Minimum 2 years of hands-on technical development experience as a MERN stack developer
• In-depth knowledge of NodeJS, Express or Restify
• Experience implementing applications using ReactJS and React Native
• Experience in creating frontend applications using HTML5, Angular, React, LESS/SASS
• Hands-on experience with JavaScript Development on both client and server-side
• Experience with modern frameworks and design patterns, minimum 3-year experience with MERN Full-stack paradigm
• Should have worked on AWS(EC2), DNS, and other server features
• Familiarity with code versioning tools (Such as Git, SVN, or Mercurial)

• Development experience for high-traffic, consumer-facing web or mobile application
• Experience in building a chat or social media app
• Creating secure RESTful-based web services in XML and JSON, Javascript, JQuery
• Experience in hiring and leading a team of developers
• Open-source contributions
• Experience with next.js, serverless, and tailwind CSS
• Eat, sleep, code, and repeat is a typical mantra of your life

• Work in a well-funded startup with a team of 2nd-time founders from top tier colleges like BITS and NIT
• Chance to get decent equity and become part of the founding and core team
• Build a highly scalable product that would one day impact the lives of billions across the globe
• Get guidance from the best product and tech folks out there at leadership positions in Dunzo, Razorpay, Haptik, etc

• Strong development experience in Java, JavaScript on Node.js
• Proficiency in full-stack web application development (MEAN stack)
• Strong programming skills with experience in design, coding, and testing
• Proficiency with relational databases such as MySQL
• Good understanding of server-side CSS preprocessors (such as Sass, based on project requirements)
• Good experience with AJAX, REST, and JSON
• Experience with AWS cloud services will be an added advantage
• Understanding of Source Control tools for version control: GIT/SVN

Requirements

• Bachelor's degree in Computer Science, Engineering or a related subject
• 2 - 6 years of hands-on experience developing, implementing, and delivering web applications
• Excellent written and verbal communication skills 

Job Description :

- Should have handson experience of more than 1+ years

- Good knowledge of NodeJS, ExpressJS or Restify

- Should have good knowledge of JavaScript.

- Experience implementing frontend using Angular 2+.

- Any database knowledge (SQL.Mongo or NoSQL)

- Basic understanding of version control using GIT

- TypeScript knowledge would be a plus

- Should have good logical skills.

Job Details:

 Core java – Concepts like oops, Collection,Expection handling, Java 7 well versed, Webservice, SQL

1. Spring – Concepts like spring boot, spring core, Spring MVC
2. ORM Tool like -Hibernate or Spring JPA
3. Front End Areas like angular 4 and above version should be strong.
4. Microservice is mandate at least a knowledge or Experience
5. Kafka or Rabbit MQ experience or knowledge is must
6. RDBMS or Nosql Or oracle or SQL experience is must

Please revert back with below details.
Total Experience:
Relevant Experience:
Current CTC:
Expected CTC:
Any offers: Y/N
Notice Period:
Qualification:
Present Company Name:
Designation:
Domain
Reason for job change:
Current Location:

Thank & Regards

Khadri SH

Sr Executive – TAG

IsquareSoft|Bangalore