Fullstack Developer

Job Title : MERN Stack Developer

Experience : 5+ Years

Shift Timings : 8:00 AM to 5:00 PM

Role Overview:

We are hiring a skilled MERN Stack Developer to build scalable web applications. You’ll work on both front-end and back-end, leveraging modern frameworks and cloud technologies to deliver high-quality solutions.

Key Responsibilities :

• Develop responsive UIs using React, GraphQL, and TypeScript.
• Build back-end APIs with Node.js, Express, and MySQL.
• Integrate AWS services like Lambda, S3, and API Gateway.
• Optimize deployments using AWS CDK and CloudFormation.
• Ensure code quality with Mocha/Chai/Sinon, ESLint, and Prettier.

Required Skills :

• Strong experience with React, Node.js, and GraphQL.
• Proficiency in AWS services and Infrastructure as Code (CDK/Terraform).
• Familiarity with MySQL, Elasticsearch, and modern testing frameworks.

We need Drupal Freelancer for maintaining our company website.

Initially there may be 50-100 Hours of work and after that per month some work

1000 - 1300 per hour

Responsibilities:

Frontend and Backend Development

Creating custom themes and modules

Troubleshooting Drupal website issues.

Experience

Strong understanding of Drupal

Experience with PHP, HTML, CSS, JavaScript & MySQL

Knowledge of DXPR Builder

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

We are looking for an experienced full-stack engineer (with a path to becoming CTO) to join our founding team! We're a B2B SaaS startup with a young vibrant culture taking this idea from inception to impact.

About the job

We want to talk to you if:

• You've built multiple, kick-ass Chrome extensions
• You've built commercial apps using chat frameworks (e.g. Chat 21/Getstream.io etc.)
• You are a React.JS, Node.JS, Javascript, & Postgres wiz
• You have experience building multi-platform apps (Web + mobile web)
• Have built or implemented integration frameworks at scale (or experience with iPaaS frameworks)
• You are obsessive about clean, optimized & scalable code with copious documentation
• You are excited about building out a team and have aspirations to become a CTO

Having B2B SaaS Startup experience is preferred and a big plus

About Us

SmartCue wants to make product demos more effective and as a result help sales teams optimize their sales cycles. Our fundamental belief is that everything we build must eliminate or reduce friction for a salesperson.

Fast Track Your Application

• Think about the Ideal Customer for SmartCue
• Download the trial for SmartCue, sign up, download, experience the product, and provide feedback on how to overhaul the current experience of the product to add immediate value to the customer

• We don't need you to fully code any feature in its entirety and are not looking for free work.

The idea is to identify folks who get what we are trying to do with SmartCue and find faster alignment with the right candidate.

Here is a video walkthrough for additional context - https://www.loom.com/share/9609cf1855e64926b71a1ff840bd7347" target="_blank">https://www.loom.com/share/9609cf1855e64926b71a1ff840bd7347

The Opportunity

• In this position, you must be ready for a fast-paced startup environment.
• Our ideal candidate is willing to be flexible and able to wear many hats.
• Must have experience engineering and scaling technologies & teams with a proven track record of success.
• Our perfect candidate is well-versed in Chrome Extensions, creating delightful front-end experiences for users, enjoys building and scaling the backend infrastructure, and has an itch to adopt the newest technologies.
• Remote forever, if you like!

Duties Include

• Develop + understand the technological roadmap
• Develop feature rollout systems and processes
• Develop strategies and solutions from customer discovery sessions
• Hire + manage outside/contracted engineering talent
• Scale while staying lean through the early stages up to fundraising
• Oversee ClickUp for project and product management, roadmap, bugs, and backlog grooming
• Collaborate with marketing to optimize user experience, onboarding and reduce churn
• Oversee security + compliance strategies
• Help field support desk inquiries
• And more...

We are an equal opportunity employer and proud to be committed to diversity and inclusiveness. We consider all qualified applicants without regard to race, nationality, gender, gender identity or expression, sexual orientation, religion, disability, or age.

• Develop software using MERN stack technologies
• Designing user interactions on web pages
• Writing clean, functional code on the front- and back-end
• Testing and fixing bugs or other coding issues
• Developing back end website applications
• Creating servers and databases for functionality
• Ensuring cross-platform optimization for mobile phones
• Ensuring the responsiveness of applications
• Working alongside graphic and UI designers for web design features
• Designing and developing APIs
• Staying abreast of developments in web applications and programming languages

• Extensive knowledge of Node.Js, React.js, HTML, CSS & Javascript
• Strong knowledge of Data structures and Algorithms
• Ability to work independently and manage the entire frontend of all platforms associated with Rejolut
• Exemplary tasks – Explore something new every day!
• Responsibility – Bring in your own ideas and get supported in executing them.
• Fun – Experience a family culture & celebrate with the founders & team.
• Team – Be a part of a high-performance & cultural diverse team

• Freshers can apply
• Students in their last semester or passed out in 2020 can also apply

• Working days: Monday to Friday
• Timings: 11:00 am to 7:00 pm
• Duration of internship: 6 months/PPO(Performance Basis)

• You are available for the above said duration.
• You prefer to work in a fast paced environment with growth & learning opportunities
• If you have not applied for an internship before with us.
•  have relevant skills and interests

•  Health Insurance
•  Work from Home
•  Fast growth and more visibility into the company
•  Experience to work on the latest technology
•  Competitive Learning Environment with supportive co-workers
•  Employee friendly HR Policies
•  Paid leaves up to certain limits
•  Liberal working atmosphere
• Get mentored by the best in the industry

equirements:

• Should have 3.6 - 5 Years work experience.
• Should have experience in Node. JS.
• Should have experience in HTML, CSS.
• Should have experience in JavaScript.