.NetCore Developer

Position Responsibilities :

The Database Architect is responsible for the design, optimization, and evolution of the database layer supporting enterprise applications in cloud environments. This role focuses on ensuring efficient data access patterns, scalable query workloads, and robust database architecture capable of supporting high-volume and high-concurrency systems.

This role goes beyond traditional database administration and requires deep technical expertise in SQL query optimization, database internals, and performance diagnostics. The Database Architect analyzes how applications interact with the database and guides improvements in schema design, data access patterns, and system scalability.

As a senior technical leader, the Database Architect helps define long-term strategies for scalable and efficient data architecture while working closely with engineering teams to promote best practices for database design and SQL development.

KEY RESPONSIBILITIES

Database Architecture & Optimization

• Design and evolve database architectures for scalable enterprise systems.
• Define efficient data access patterns that support high concurrency and large datasets.
• Improve schema design, indexing strategies, and query patterns.
• Ensure database designs support both transactional and data consumption workloads.

SQL Performance Engineering

• Analyze and optimize complex SQL queries and execution plans.
• Improve database performance through indexing strategies, statistics management, and query tuning.
• Investigate workload behaviour and recommend architectural improvements.

Data Access & Systems Thinking

• Provide guidance on scalable approaches for retrieving and delivering data for data-intensive application features.
• Recommend architectural strategies such as data aggregation, caching, or pre-computed datasets where appropriate.
• Apply systems thinking to improve how data is modeled, accessed, and delivered across the application.

Advanced Diagnostics

• Diagnose database behaviour using tools such as Query Store, Extended Events, and execution plan analysis.
• Analyze query performance, wait statistics, and workload patterns to identify optimization opportunities.

Collaboration & Technical Leadership

• Partner with engineering teams to guide scalable SQL development and data access practices.
• Participate in architecture and design discussions involving database interactions.
• Document best practices and architectural recommendations.

AI-Assisted Engineering

• Use AI-assisted tools to accelerate query analysis, diagnostics, and workload investigations.
• Validate AI-generated insights through empirical testing and database telemetry.

Qualifications :

TECHNICAL SKILLS & EXPERTISE

Database & SQL Server (Required)

• Advanced SQL Server performance tuning, including query optimization, execution plan analysis, and index design
• Strong experience diagnosing and resolving deadlocks using Extended Events and deadlock graphs
• Deep understanding of locking, blocking, and transaction behaviour, including wait statistics and lock escalation
• Experience optimizing stored procedures, including mitigation of parameter sniffing and plan cache management
• Strong knowledge of indexing strategies, including covering indexes and filtered indexes
• Solid understanding of statistics, cardinality estimation, and query optimizer behaviour

Performance Analysis Tools (Required)

• Experience using SQL Server Profiler and Extended Events for workload diagnostics
• Advanced execution plan analysis using SSMS or Azure Data Studio
• Familiarity with SET STATISTICS IO/TIME for query performance evaluation
• Strong experience using Query Store to analyse query performance and plan behaviour
• Ability to diagnose issues through wait statistics and blocking chain analysis

Enterprise Application Data Architecture

• Strong understanding of database design within multi-tier enterprise applications
• Experience optimizing database workloads supporting high-concurrency systems and large datasets
• Understanding how application query patterns influence database performance
• Familiarity working with application platforms such as .NET, APIs, or modern web frameworks

Cloud & Enterprise Database Environments

• Experience working with cloud-hosted database environments
• Understanding of scalability considerations in enterprise systems
• Experience analyzing and optimizing database workloads in production environments

QUALIFICATIONS

• 8+ years of experience working with enterprise database systems
• Proven expertise in SQL performance tuning and database workload optimization
• Strong experience in analysing execution plans and database performance behaviour
• Experience collaborating with engineering teams on data architecture and query design
• Strong analytical and problem-solving skills

AI-FIRST MINDSET REQUIREMENT

We value engineers who view AI as a productivity multiplier. The ideal candidate actively leverages AI tools to accelerate diagnostics, analyze database workloads, and uncover optimization opportunities while applying strong engineering judgment to validate results

A Staff Engineer at CAW is a technical and people leader responsible for end-to-end project delivery and the growth of engineers. You own technical design (LLDs), contribute to HLD discussions, lead execution, ensure engineering best practices, and act as the primary technical point of contact for clients. You manage a set of engineers, supporting their career progression through mentorship, feedback, and performance development.

Responsibilities:

• Own Low-Level Design (LLD) and code quality; contribute to HLD discussions under guidance.
• Own end-to-end project delivery: requirements understanding, sprint planning, execution, risk management, and production readiness.
• Lead the project engineering team with clear technical direction, ownership, and execution accountability.
• Act as primary people manager for assigned engineers; own their career progression, mentorship, and growth.
• Provide regular 1:1s focused on skill development, feedback synthesis, and long-term career goals.
• Serve as primary technical point of contact for clients; build trust through clear communication and proactive problem-solving.
• Ensure best practices across architecture, implementation, testing, and production readiness.
• Establish disciplined AI usage across the team for design validation, reviews, testing, and documentation.

The core requirements for the job include the following:

Technical Expertise:

• In-depth knowledge of C#. NET languages and the DotNet Core Web API Framework.
• Strong SQL skills: complex queries, stored procedures, functions; PostgreSQL or SQL Server proficiency.
• Experience with Entity Framework or Dapper ORM.
• ReactJS/Angular frontend experience.
• Cloud, Agile, CI/CD, and DevOps environments.
• Solid grasp of SOLID Principles and OOPS Concepts.

Leadership and Ownership:

• Proven ability to own feature-level delivery end-to-end with minimal supervision.
• Strong people management skills with a track record of mentoring and developing engineers.
• Exposure to system design and architecture discussions.
• Production-first mindset with a focus on reliability, scalability, and operational excellence.

AI Systems and Engineering (Nice to Have):

• Advanced experience deploying RAG or agent-based systems with LangGraph orchestration.
• Expert-level mastery of async Python, system thinking, and building scalable backends.
• Design modular, maintainable multi-agent AI systems aligned with SOLID principles.
• Build high-concurrency, async Python backends for complex AI workloads with enterprise stability.
• Architect sophisticated agentic workflows using LangGraph with state persistence and error recovery.
• Design and optimize RAG pipelines: advanced chunking, hybrid search, and re-ranking.
• Collaborate on reusable AI components and internal frameworks to enhance team velocity.
• Authentication Providers (IdentityServer, Auth0 or equivalent).

Job description

Tech Stack: C#, .NET Core, XUnit, Entity Framework Core, MS SQL Server, PostgreSQL, Git, JIRA, Confluence

Senior (Lead) .NET Developer Responsibilities: -

Interface with product owners and software architects to review and finalize requirements

- Participate in the full SDLC including analysis, design, development, testing, deployment, and support of new features and applications

- Actively lead and participate in agile ceremonies (Standups, Refinements, Retrospectives, Planning, and Requirement’s discussions)

- Communicate effectively, clearly, and thoroughly with the Scrum Team and Stakeholders - Provide innovative solutions to complex problems

- Design, develop and modify software applications/systems according to specifications

- Develop technical documentation including services, object, and data model

- Create high quality code and perform code reviews

- Create unit and integration tests to ensure the code quality and functionality

- Proactively learn and share knowledge of technology and compare advantages and disadvantages of alternative solutions/technologies

- Identify areas needing process improvements and see them through to resolution

- Support and coach other Developers, provide technical guidance

- Help onboard new team members

Job Type: Full-time

Role- Software Development Engineer-2

As a Software Development Engineer at Amazon, you have industry-leading technical abilities and demonstrate breadth and depth of knowledge. You build software to deliver business impact, making smart technology choices. You work in a team and drive things forward.

Top Skills

• You write high quality, maintainable, and robust code, often in Java or C++ or C#
• You recognize and adopt best practices in software engineering: design, testing, version control, documentation, build, deployment, and operations.
• You have experience building scalable software systems that are high-performance, highly-available, highly transactional, low latency and massively distributed.
• Roles & Responsibilities
• You solve problems at their root, stepping back to understand the broader context.
• You develop pragmatic solutions and build flexible systems that balance engineering complexity and timely delivery, creating business impact.
• You understand a broad range of data structures and algorithms and apply them to deliver high-performing applications.
• You recognize and use design patterns to solve business problems.
• You understand how operating systems work, perform and scale.
• You continually align your work with Amazon’s business objectives and seek to deliver business value.
• You collaborate to ensure that decisions are based on the merit of the proposal, not the proposer.
• You proactively support knowledge-sharing and build good working relationships within the team and with others in Amazon.
• You communicate clearly with your team and with other groups and listen effectively.

Skills & Experience

• Bachelors or Masters in Computer Science or relevant technical field.
• Experience in software development and full product life-cycle.
• Excellent programming skills in any object-oriented programming languages - preferably Java, C/C++/C#, Perl, Python, or Ruby.
• Strong knowledge of data structures, algorithms, and designing for performance, scalability, and availability.
• Proficiency in SQL and data modeling.

About Amazon.com

“Many of the problems we face have no textbook solution, and so we-happily-invent new ones.” – Jeff Bezos

Amazon.com – a place where builders can build. We hire the world's brightest minds and offer them an environment in which they can invent and innovate to improve the experience for our customers. A Fortune 100 company based in Seattle, Washington, Amazon is the global leader in e-commerce. Amazon offers everything from books and electronics to apparel and diamond jewelry. We operate sites in Australia, Brazil, Canada, China, France, Germany, India, Italy, Japan, Mexico, Netherlands, Spain, United Kingdom and United States, and maintain dozens of fulfillment centers around the world which encompass more than 26 million square feet.

Technological innovation drives the growth of Amazon, offering our customers more selection, convenient shopping, and low prices. Amazon Web Services provides developers and small to large businesses access to the horizontally scalable state of the art cloud infrastructure like S3, EC2, AMI, CloudFront and SimpleDB, that powers Amazon.com. Developers can build any type of business on Amazon Web Services and scale their application with growing business needs.

We want you to help share and shape our mission to be Earth's most customer-centric company. Amazon's evolution from Web site to e-commerce partner to development platform is driven by the spirit of invention that is part of our DNA. We do this every day by inventing elegant and simple solutions to complex technical and business problems. We're making history and the good news is that we've only just begun.

About Amazon India

Amazon teams in India work on complex business challenges to innovate and create efficient solutions that enable various Amazon businesses, including Amazon websites across the world as well as support Payments, Transportation, and Digital products and services like the Kindle family of tablets, e-readers and the store. We are proud to have some of the finest talent and strong leaders with proven experience working to make Amazon the Earth’s most customer-centric company.

We made our foray into the Indian market with the launch of Junglee.com, enabling retailers in India to advertise their products to millions of Indian shoppers and drive targeted traffic to their stores. In June 2013, we launched http://www.amazon.in">www.amazon.in for shoppers in India. With http://www.amazon.in">www.amazon.in, we endeavor to give customers more of what they want – low prices, vast selection, fast and reliable delivery, and a trusted and convenient online shopping experience. In just over a year of launching our India operations, we have expanded our offering to over 18 million products across 36 departments and 100s of categories! Our philosophy of working backwards from the customers is what drives our growth and success.

We will continue to strive to become a trusted and meaningful sales and logistics channel for retailers of all sizes across India and a fast, reliable and convenient online shopping destination for consumers. For us, it is always “Day 1” and we are committed to aggressively invest over the long-term and relentlessly focus on raising the bar for customer experience in India.

Amazon India offers opportunities where you can dive right in, work with smart people on challenging problems and make an impact that contributes to the lives of millions. Join us so you can - Work Hard, Have Fun and Make History.

• Experience in at least one of the frameworks   YII / Codeigniter
• Experience in Laravel(Mandatory)
• Good experience in JS, JQuery, AJAX, Angular JS
• Good experience in Html, CSS, Responsive Design.
• Ability to write and consume web services and REST services.
• Knowledge on Developing APIs for Mobile Applications
• Should have excellent communication skill and technical skill
• Extensive OOD (Object-oriented design) / OOP (Object-oriented programming) experience.
• Good knowledge of relational databases (MySQL), version control tools and of developing web services
• Should have good understanding skill and ability to work independently or within a team and lead a team.
• Passion for best design and coding practices and a desire to develop new bold ideas.
• Knowledge of and experience applying design patterns andimplementing industry best practices required.

Good to Have Skills:

• Knowledge on Server Maintenance
• Knowledge on Amazon AWS

• If you fit the above criteria, send your latest resume along with following information duly filled to us immed at appleinformatics(at)yahoo.com   

  1. Total Experience:
  2. Relevant Experience:
  3. Current Job location:
  4. Notice Period:
  5. Reason for change:
  6. Current CTC:
  7. Expected CTC:

           Can join earliest by: