Lead Senior Software Engineer

Location: Mumbai or Remote

Duration: 3 to 6 months

About the Role

Websites.co.in is looking for a Full Stack Developer Intern to support our engineering team across backend and frontend development. You will work on real product features and fixes across our website builder platform used by small businesses globally. This role is designed for learners who want practical full stack exposure.

You will mainly assist, build small modules, fix bugs, and improve existing features under guidance.

What You Will Do

• Assist in building and updating features using basic PHP and Laravel
• Work on simple database queries and data handling
• Help create and modify REST API endpoints
• Build and improve basic responsive UI using HTML, CSS, and JavaScript
• Connect frontend pages with backend APIs using AJAX and JSON
• Fix minor bugs across frontend and backend code
• Support simple third party API integrations
• Use Git for basic version control tasks
• Learn and work with existing codebase and modules

Required Skills

• Basic knowledge of PHP and any MVC framework preferred
• Basic understanding of Laravel concepts is a plus
• Basic knowledge of HTML, CSS, and JavaScript
• Basic understanding of databases like MySQL
• Familiar with REST API basics
• Exposure to Git
• Has done at least one academic or personal web project
• Willingness to learn and take feedback

Perks

• Real product development exposure
• Mentored learning environment
• Fast skill growth
• PPO opportunity based on performance

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

Key Responsibilities would include: 

1. Design, develop, and maintain enterprise-level Java applications. 

2. Collaborate with cross-functional teams to gather and analyze requirements, and implement solutions. 

3. Develop & customize the application using HTML5, CSS, and jQuery to create dynamic and responsive user interfaces. 

4. Integrate with relational databases (RDBMS) to manage and retrieve data efficiently. 

5. Write clean, maintainable, and efficient code following best practices and coding standards. 

6. Participate in code reviews, debugging, and testing to ensure high-quality deliverables. 

7. Troubleshoot and resolve issues in existing applications and systems. 

Qualification requirement - 

1. 4 years of hands-on experience in Java / J2ee development, preferably with enterprise-level projects.

2. Spring Framework including - SOA, AoP and Spring security 

3. Proficiency in web technologies including HTML5, CSS, jQuery, and JavaScript.

4. Experience with RESTful APIs and web services.

5. Knowledge of build tools like Maven or Gradle

6. Strong knowledge of relational databases (e.g., MySQL, PostgreSQL, Oracle) and experience with SQL.

7. Experience with version control systems like Git.

8. Understanding of software development lifecycle (SDLC) 

9. Strong problem-solving skills and attention to details.

About ProjectDiscovery

ProjectDiscovery is an open-source powered cyber security company with a mission to democratize security. With one of the largest open-source security communities in the world, we host contributions from security researchers and engineers to our 20+ open-source projects, including tools like Nuclei and httpx, which have earned us over 100k GitHub stars and millions of downloads.

We’re a passionate, globally distributed team of ~35, driven by the shared mission of revolutionizing the application security landscape. Backed by $25M in funding, we’re looking for talented individuals to join us in Jaipur office.

Learn more at:

🌐 ProjectDiscovery.io

📂 ProjectDiscovery GitHub

About the Role

We are looking for a software engineer to join our core platform team. The Platform team is a small group of experienced engineers managing ProjectDiscovery infrastructure, improving developer velocity, and ensuring the security, reliability, and scalability of our software. We are highly engaged in shaping the engineering culture at ProjectDiscovery, and operate as “the execution arm” working closely with founders and our CTO.

• Own codebase health, iteration velocity, and developer experience for all of ProjectDiscovery engineering.
• Build and maintain scalable, high-performance web applications.
• Work across the stack, from crafting intuitive front-end interfaces to building robust backend systems.
• Design and implement secure, maintainable APIs for seamless integration of tools and platforms.

What We’re Looking For:

• Expert with JavaScript (Next.js, React) and backend technologies like Node.js and Go.
• Experience with cloud services (Vercel, AWS, GCP) and modern DevOps practices.
• Knowledge of RESTful APIs and database systems like PostgreSQL, Elastic or MongoDB.
• Self-motivated and passionate about solving complex problems at scale.
• Operating and optimizing CI/CD systems to improve developer velocity

Why Join Us?

• Competitive compensation package and stock options.
• Inclusive Healthcare Package.
• Learn and grow - we provide mentorship and send you to events that help you build your network and technical skills.
• Learn with intense innovation and software shipping cycles. We ship multiple times a week and push major releases a couple of times a month.

Our Interview Process

We value efficiency and technical excellence in our hiring process:

1. Application Review: Your application is reviewed by a technical team member.
2. Initial Screening: A short call to understand your background, goals, and fit.

• Technical Rounds:Coding Assessment: Solve challenges using our tech stack.
• Create PR: Develop or enhance a feature related to one of our open-source tools.

1. Final Round: Showcase your work, share your vision, and discuss how you can contribute to ProjectDiscovery at our office in Jaipur.

Requirements:

·       Bachelor's degree in Computer Science, Software Engineering, or related field (or equivalent experience).

·       Minimum of 4 years of professional Python development experience.

·       Strong expertise in Django framework and its ecosystem.

·       Proficiency in web development technologies such as HTML, CSS, JavaScript, and front-end frameworks.

·       Experience with database systems like PostgreSQL, MySQL, or MongoDB.

·       Knowledge of RESTful API design and integration.

·       Familiarity with version control systems, especially Git.

·       Excellent problem-solving and debugging skills.

·       Strong communication and collaboration skills.

·       Self-motivated and able to work independently or in a team.

·       Experience with React.js and Docker is a plus.

Role description:

We are looking for Senior Software Engineer with expertise and experience in designing and developing

applications including new developments, enhancements, maintenance and support. The role involves continuous collaboration with team, partners.

Candidate description:

Should have:

 Passion for technology and financial domain with demonstrated ability to learn quickly

 Delivery focus with ability to take full ownership

 Strong commitment to quality and delivery

 Strong communication skills

Skills/Knowledge and experience:

 Object oriented design and development skill

 Webservices - Node JS/Express JS, Rest API

 Frontend – Angular (Javascript and Typescript), React

 Unix and Shell scripting

 SQL Proficiency, good to know MongoDB

• Java / Java Script code development using frameworks like Spring, Hibernate , Rest web services,  AWS services.
• · Dev-Ops activities using Maven, Eclipse and other tools
• · Contribute to providing estimates for implementation of new requirements and work diligently towards delivering within the estimates
• · Ensure Quality of the releases by adhering to SDLC best-practices such as, unit tests,continuous integration, system testing
• · Re-use code. Ensure delivered code is modular and extensible
• · Ensure adequate coverage of functional and non-functional requirements in test plans Position Requirements
• · 3-5+ years of hands on experience in Java/J2EE development. Experience with the implementation of a distributed, enterprise JAVA/J2EE solution is strongly preferred
• · Experience in JAVA/J2EE Frameworks such as Spring, hibernate is strongly preferred
• · Experience in SOA and SOA related technologies, solutions and products as well as experience with implementation of REST full web services is preferred
• · Experience with data modelling and experience with relational databases like MySQL, SQL Server or Oracle is desirable
• · Mobile application development experience on Android or iOS is desirable