Project Leader - Website Applications Development - PHP/OOPS

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 a Laravel Developer to join our team! You will be responsible for building and maintaining web applications using Laravel.

Full Stack Developer (Python, Javascript, HTML, API)

Job Overview

The SkillTurk Team is seeking a skilled Full Stack Developer with expertise in Python, JavaScript, HTML, and API functions to join our dynamic team. As a Full Stack Developer, you will be responsible for designing, developing, and maintaining web applications that seamlessly integrate front-end and back-end components. Your role will involve working on server-side development, utilizing your knowledge of Python, JavaScript, HTML, and API integration to deliver robust and scalable solutions.

Responsibilities:

·      Full Stack Development: Design, develop, and deploy feature-rich web applications using Python, JavaScript, HTML, and CSS technologies.

·      Front-end Development: Create responsive and intuitive user interfaces using HTML, CSS, and JavaScript frameworks, ensuring optimal user experience across different devices and browsers.

·      Back-end Development: Develop server-side logic and APIs using Python frameworks such as Django or Flask to enable smooth data flow and interaction between the front-end and the database.

·      API Integration: Understand and integrate third-party APIs and services to enhance the functionality and capabilities of web applications.

·      Database Management: Design and implement efficient database schemas, write optimized SQL queries, and ensure data integrity and security.

·      Testing and Debugging: Conduct rigorous testing and debugging to identify and fix issues, ensuring high-quality and bug-free code.

·      Collaborate with Teams: Work closely with the data engineer and stakeholders to gather requirements, provide technical insights, and ensure seamless integration of front-end and back-end components.

·      Continuous Learning: Stay up to date with industry trends, emerging technologies, and best practices in full stack development, and apply them to enhance the development process and deliver innovative solutions.

·      Troubleshooting and Issue Resolution: Identify and resolve technical issues, performance bottlenecks, and system failures, both during development and in production environments.

·      Code Maintenance and Version Control: Manage code repositories, version control systems (e.g., Git), and documentation to ensure efficient collaboration and codebase integrity.

Requirements:

·      Strong proficiency in Python programming language.

·      Proficiency in client-side web technologies including JavaScript, HTML, and CSS.

·      Experience with server-side frameworks such as Django or Flask.

·      Understanding of API design principles and experience with API integration.

·      Knowledge of database systems, SQL and the ability to write optimized queries.

·      Familiarity with version control systems like Git.

·      Solid understanding of web development principles, including responsive design, cross-browser compatibility, and accessibility.

·      Strong problem-solving and debugging skills.

·      Excellent teamwork and communication abilities.

Preferred Skills (not mandatory but beneficial):

·      Experience with cloud platforms such as AWS or Azure.

·      Understanding of Github deployments.

·      Understanding of security principles and best practices in web development.

If you are a highly motivated individual with a passion for full stack development and possess the required skills, we encourage you to apply for this position. Join our team and contribute to the creation of cutting-edge web applications that deliver seamless user experiences and drive innovation.

Job Title- PHP Developer

Location : Mumbai, Navimumbai

Job Description-

We are looking for a PHP Developer responsible for managing back-end services and the interchange

of data between the server and the users

Responsibilities

- Integration of user-facing elements developed by front-end developers

- Build efficient, testable, and reusable PHP modules

- Solve complex performance problems and architectural challenges

Skills And Qualifications

- Strong knowledge of PHP web frameworks {such as Laravel, Codeigniter, depending on your technology stack}

-Any JS Framework experience like NodeJS, Angular JS, React JS will be an advantage.

- Understanding the fully synchronous behavior of PHP

- Understanding of MVC design patterns

- Basic understanding of front-end technologies, such as JavaScript, HTML5, and CSS3

- Knowledge of object oriented PHP programming

- Understanding accessibility and security compliance

- Strong knowledge of the common PHP or web server exploits and their solutions

- Understanding fundamental design principles behind a scalable application

- User authentication and authorization between multiple systems, servers, and environments

- Integration of multiple data sources and databases into one system

- Familiarity with limitations of PHP as a platform and its workarounds

- Creating database schemas that represent and support business processes

- Familiarity with SQL/NoSQL databases and their declarative query languages

- Proficient understanding of code versioning tools, such as Git

Hurry Upp!!! We are Hiring Full Stack Developer

We are looking for a highly skilled computer programmer who is comfortable with both front and back-end programming. Full Stack Developers are responsible for developing and designing front-end web architecture, ensuring the responsiveness of applications, and working alongside graphic designers for web design features, among other duties.

Full Stack Developers will be required to see out a project from conception to final product, requiring good organizational skills and attention to detail.

Full Stack Developer Responsibilities:

• Developing front-end website architecture.

• Designing user interactions on web pages.

• Developing back-end website applications.

• Creating servers and databases for functionality.

• Ensuring cross-platform optimization for mobile phones.

• Ensuring responsiveness of applications

• Working alongside graphic designers for web design features.

Role and Responsibilities

•  Working with front-end developers and providing server-side algorithms of user-facing web application elements.
• Coding and creating functional web applications, optimizing code for increasing response time and efficiency.
• Analyzing the goals and requirements, efficiently handling bugs and errors, and finding effective solutions for the same.
•  Interacting with the database for storing data and ensuring that every user has access to what they search.
•  Accomplishing the projects and goals within deadline.
• Managing APIs that are executed across the devices.
•  Involving in defining the architecture of the system.

Required skills

• In-depth knowledge of PHP and related frameworks like Laravel, Codeigniter, Yii. Competent in Ruby, Python, nodeJs, and Java will be an added advantage.
• Good Communication, Analytical, Logical, and Leadership skills.
• Knowledge of front-end technologies, such as Angular, React, HTML, CSS, and JavaScript will be preferred.
• Capable of managing a hosting environment along with database administration such as MySQL, Oracle.
• Excellent knowledge of APIs (REST, SOAP) and Web services.
• Ability to scale applications to handle the load changes.
• Knowledge of accessibility and security compliance.
• Good to have experience in version control, such as GIT.

• Collaborate with multiple stakeholders to understand the business context
• Take responsibility for developing product features
• Implement development best practices

• Rich experience in Javascript and front end frameworks like React, Angular or Vue
• Build a backend APIs using Java, Node, Python or GoLang
• Proficiency in leveraging Cloud Native components in AWS, Azure or GCP
• Experience in building scalable applications using Microservices principles is a plus
• Experience in designing for performance is a big plus
• Ability to write high quality code
• Experience in polygot persistence using databases like relational (MySQL, Postgres) and NoSQL (MongoDB, Cassandra, DynamoDB, Redis etc)
• Familiarity with DevOps tools and technologies is a plus
• Passion for continuous learning of new technologies

Senior Software Engineers are responsible for the design and development of the suite of cloud-based software products utilizing cutting-edge tools and technologies.

What You Will Be Doing:

Work on Internet scale applications, where performance, reliability, and scalability, are critical design goals – not after-thoughts.
Learn the nuts and bolts of Microservices Architecture and build robust RESTful APIs.
Create beautiful, interactive, and easy-to-use web applications using modern client-side frameworks and libraries.
Gain experience with different database technologies, ranging from traditional relational to the latest NoSQL products such as Couchbase and Elastic Search.
AWS for infrastructure, deploying services with ECS and Lambda

What You Will Need for this Position

The prerequisites for joining our development team are simple. We care more about your attitude and aptitude than the specific tools and technologies you have used in the past. You need to have a strong passion for software development and must take pride in your coding. You should also have great analytical skills and ability to handle complex, modular software development in a collaborative team-based environment.

5+ years of overall development experience, which ideally includes working with an object-oriented language (Java)
Experience with using and implementing RESTful APIs.
Experience with one or more of the following databases: traditional relational database as well as document/NoSQL storage.
Experience with JavaScript, React/Angular/Vue and Node.js. We will also welcome proven engineering leaders who are eager to immerse themselves in mastering Typescript/JavaScript and our tech stack
BS, MS or PhD in Computer Science OR related technical discipline.
Big plus if prior experience with video processing, streaming and video-related cloud services such as AWS Elemental & Amazon IVS

Salary :- No bar for deserving candidates

Apptroit is a leading Mobile App & Web Solution Development Company in the USA, UK, UAE and India and serving its clients across the globe. Also having proficient and dedicated Android app developers, iOS App developers, designers and digital marketing experts with a reputation for getting things done. We are well-versed in a variety of operating systems, networks, and databases. We work with just about any technology that a small business would encounter. We use this expertise to help customers with small to mid-sized projects.