AI Architect

Role Overview:

We are looking for a detail-oriented and experienced Full Stack Developer to join our growing team in India. This is a remote, full-time opportunity to work on high-impact

projects using modern web technologies. While specific project discovery is underway, we’re looking to onboard developers with a solid foundation across front-end and back-end technologies who are comfortable working in agile environments. You will be collaborating directly with a US-based client and must be available to work the UK shift.

Key Responsibilities:

·        Develop and maintain scalable and performant full-stack web applications

·        Collaborate with UI/UX designers and backend teams to implement responsive, user- friendly interfaces

·        Write unit tests using Jest and ensure code quality and reliability

·        Develop RESTful APIs using Node.js and NestJS framework

·        Utilize Docker Compose for local development and deployment

·        Manage and optimize MySQL databases, including views, stored procedures, and performance tuning

·        Implement access control mechanisms using identity providers like Okta or Auth0

·        Document APIs using tools like SwaggerUI and Postman

·        Participate in sprint planning, code reviews, and team stand-ups via JIRA and Confluence

·        Use Git for version control and manage merge requests and branches effectively

·        Integrate application loggers for monitoring and diagnostics

Must-Have Skills:

·        Proficiency in HTML, CSS, SASS/SCSS

·        Strong hands-on experience with Angular 18 or higher

·        Familiarity with Angular Material or similar UI component libraries

·        Experience with Node.js and NestJS 10+

·        Working knowledge of Docker Compose

·        Strong SQL skills and experience with MySQL

·        Understanding of authentication and authorization best practices with Okta, Auth0, etc.

·        Comfort using Postman, SwaggerUI, Git, and logging tools

·        Familiarity with agile development processes and using JIRA and Confluence

Nice to Have:

·        Experience with form builders like Formsite or FormSort

·        Knowledge of data encryption best practices

·        Prior experience in the public health or POSIT (Public Health Informatics) domain

Qualifications:

·        Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field

·        3–6 years of experience in full-stack development

·        Strong communication skills and the ability to work independently in a remote team environment

Availability to work UK shift hours to ensure overlap with the US-based client

Equal Opportunity Statement:

BigRio is an equal-opportunity employer. We prohibit discrimination and harassment of any kind based on race, religion, national origin, sex, sexual orientation, gender identity, age, pregnancy, status as a qualified individual with disability, protected veteran status, or other protected characteristic as outlined by federal, state, or local laws. BigRio makes hiring decisions based solely on qualifications, merit, and business needs at the time. All qualified applicants will receive equal consideration for employment.

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

About Us:

At Clickretina, we are looking for a SEO Executive to join our team. We’re a growing company focused on digital marketing, and we need someone who can help us manage and improve our online marketing strategies. If you have experience with SEO and enjoy working with data to make smart decisions, we want to hear from you!

Role Overview

As an SEO Executive, you will be responsible for optimizing website content to improve search engine rankings and drive organic traffic. They conduct keyword research, implement on-page and off-page strategies, and analyze performance using tools like Google Analytics. Their goal is to increase visibility and enhance user engagement on digital platforms.

Job description

• Research and implement search engine optimization recommendations.
• Research and analyze competitor on-site and off-site SEO strategies for better insights.
• Develop and implement a link-building strategy.
• Work with the development team to ensure SEO best practices are properly implemented on newly developed code.
• Work with editorial and marketing teams to drive SEO in content creation and content programming.
• Recommend changes to website architecture, content, linking, and other factors to improve SEO positions for target keywords.
• We are looking for an experienced SEO expert to lead and manage all search engine optimization strategies and delegate work to other SEO experts.
• You will be responsible for managing all SEO activities such as content strategy, link building, and keyword strategy to increase rankings on all major search networks.

Skills Required:

• Minimum 1 year proven experience working in SEO
• Must have a local SEO strategy and plan based on experience.
• Solid understanding of performance marketing, conversion, and online customer acquisition.
• In-depth experience with website analytics tools (e.g., Google Analytics, WebTrends).
• Knowledge of ranking factors and search engine algorithms.
• Up-to-date with the latest trends and best practices in SEO.

Interested candidates can fill out the form -https://clickretina.com/job-application-form/

Academic Qualification

 B.Tech/B.Sc/MSc in Electronics only

Job Description / Responsibilities

 1.    Thorough knowledge in MS office tools

2.      Knowledge in technical content writing

3.      Domain knowledge in Electronics and Communications Systems is an added advantage

Requirement :-

- 3-5 Yrs Exp. Ecommerce / D2C exp preferred
- Ideally from the future ecosystem, who will be able to manage imports, TP purchases
- Also lead Traded Products + Packaging Procurement.

Job Requirements :

- Should have experience in supporting the application and infrastructure 24x7.

- Should have good working knowledge on troubleshooting skills of Operating Systems (Linux/Windows)

- Good experience on Java/j2EE application supporting and AWS infra supporting.

- Ability to work with 3rd parties/FOPS and provide required instruction to troubleshoot and restore faults.

- Respond quickly and effectively to production issues, troubleshooting solutions, and
taking responsibility for seeing those solutions through resolution.

- Identify root cause and corrective actions for highly complex availability, capacity, security, performance, and quality issues affecting the database.

- Strong knowledge of Linux/Unix operating system.

- Good knowledge of scripting languages like Shell, Python.

- Good Knowledge of Databases like Mongo, Mysql, SQL Server.

- Respond to alerts and take corrective action to ensure the high availability of our
production environments and participate in an after-hours on-call rotation.

- Experience/Knowledge of other cloud platforms (Azure, Google Cloud) is a plus

- Strong verbal and written communications skills are a must

- Must have production support experience as the requirement is 24X7X365 production support.

• Has experience of working in a graphics environment, to a brief and delivering to deadlines with some evidence of design management capability
• Familiarity with best practices for graphics and video content on social media platforms (YouTube, LinkedIn, Facebook, Twitter, Instagram)
• Should optimize existing graphics and video content
• Use of Microsoft Office, Dropbox, and G Suite.
• Has advanced knowledge of Adobe Creative Suite (mainly InDesign, Illustrator, Premiere, and Photoshop)

Candidate Specification

• A strong portfolio of illustrations or other graphics.
• A keen eye for aesthetics and details.
• Communication skills.
• A degree in Design, Fine Arts, or a related field is a plus.
• Is self-starting, highly motivated, and hands-on
• Creativity and awareness of current design trends
• Can manage time efficiently, able to prioritize, works fast and accurately to meet tight deadlines