
About Clag Tech Pvt. Ltd.
About
Connect with the team
Company social profiles
Similar jobs (10)
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 talented UI/UX Designer to create amazing user experiences.
- The ideal candidate should have an eye for clean and artful design, possess superior UI skills and be able to translate high-level requirements into interaction flows and artifacts, and transform them into beautiful, intuitive, and functional user interfaces.
- Experience in Mobile UI Design , responsive website
- Participating in a team-oriented environment to develop complex web front-end.
- Experience in creating mockups and converting PSD into HTML(Responsive) , HTML/CSS into PNG/JPEG.
- Experience in Adobe Photoshop, Firework, illustrator, Dreamweaver.
- Well versed in HTML, HTML5, CSS, CSS3, Bootstrap and Java Script.
- Worked on wordpress project i.e Theme customization , wordpress installation & convert HTML/CSS to wordpress
- Ability to understand the requirement and do work individually.
- Test websites compatibility on different resolutions and browsers such as IE, Firefox, Safari.
- Excellent communication skills (English)
Location: Mumbai (On-site)
Experience: 2+ Years
Joining: Immediate Joiner Preferred
Employment Type: Full-time
🔍 Key Responsibilities:
- Develop and maintain web applications using PHP and CodeIgniter framework.
- Build and manage dynamic frontends using Angular.
- Integrate RESTful APIs and ensure seamless communication between backend and frontend.
- Optimize application for maximum speed, performance, and scalability.
- Collaborate with cross-functional teams for end-to-end product development.
- Debug and resolve application issues and bugs.
✅ Must-Have Skills:
- Strong experience with PHP and CodeIgniter.
- Proficient in Angular (any version).
- Solid understanding of HTML5, CSS3, JavaScript, and TypeScript.
- Knowledge of MySQL or other relational databases.
- Familiar with Git version control and RESTful API integration.
Job Objectives:
- Integration of user- facing elements developed by front- end developers with server- side logic
- Optimize web applications to maximize speed and scale. Support diverse clients from high- powered desktop computers to small mobile devices
- Optimization of the application for maximum speed and scalability - Implementation of security and data protection
- Collaborate with senior management, operations & business team
- Building Rest APIs and maintain Database optimizations
Looking For:
- Great understanding of PHP, Node, react, Express, Socket.io, MVVM framework
- Worked on e- commerce website, server handling and deployments scripts
- The one who has worked on customer facing product for 2 years
- Strong knowledge of MERN stack
- Experience designing scalable, fault tolerant systems and databases.
Must know MySQL & PostgreSQL
- Good Knowledge of HTML, PHP Frameworks (like CI, Laravel, YII), Core PHP, JavaScript and CSS coding.
- Knowledge of Bitbucket/GitHub.
- Strong hands-on Bootstrap.
- Knowledge of databases and database concepts.
- Strong knowledge of Laravel/ CodeIgniter and its extensive feature set.
- Working Knowledge of e-commerce frameworks like OpenCart, WordPress, cs-cart, and Magento.
- Working knowledge of API for Mobile Applications
- Experience in Cache, and search plugins in terms of optimization
- Developing plug-ins/add-ons in PHP for various CMS solutions.
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
Skill Set Required:
|
· Good understanding with hands-on experience on PHP-Code-igniter / Laravel framework. · Writing web services on PHP. · Thorough understanding of OOP Concepts. · Working experience on HTML5/CSS3/jQuery · Knowledge of REST Service integration (JSON) · Must be a self-motivated, smart working person with a good attitude to work in teams and individually. |
We are seeking a WordPress Developer responsible for both back-end and front-end development, including creating WordPress themes and plugins. This position requires a combination of programming skills (namely PHP, HTML5, CSS3, and JavaScript) and aesthetics (understanding element arrangements on the screen, the color and font choices, and so on). The candidate should have a strong understanding of industry trends and content management systems. Experience with the responsive and adaptive design is strongly preferred. Also, an understanding of the entire web development process, including design, development, and deployment is preferred.
Responsibilities
- Designing and implementing new features and functionality
- Establishing and guiding the website’s architecture
- Ensuring high-performance and availability, and managing all technical aspects of the CMS
- Helping formulate an effective, responsive design and turning it into a working theme and plugin.
Skills and Qualifications
- Good understanding of front-end technologies, including HTML5, CSS3, JavaScript, jQuery
- Experience building user interfaces for websites and/or web applications
- Experience designing and developing responsive design websites
- Comfortable working with debugging tools like Firebug, Chrome inspector, etc.
- Ability to understand CSS changes and their ramifications to ensure consistent style across platforms and browsers
- Ability to convert comprehensive layout and wireframes into working HTML pages
- Knowledge of how to interact with RESTful APIs and formats (JSON, XML)
- Strong understanding of PHP back-end development
- Basic onpage SEO skills










