Web Backend Engineer

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

JOB DESCRIPTION

Experience: 5+ years

Location: Bangalore

Wissen Technology is now hiring for a Java Developer - Bangalore with hands-on experience in Core Java, algorithms, data structures, multithreading and SQL. We are solving complex technical problems in the industry and need talented software engineers to join our mission and be a part of a global software development team. A brilliant opportunity to become a part of a highly motivated and expert team which has made a mark as a high-end technical consulting. 

Required Skills:

• Exp. - 5+ years
• Experience in Core Java and Spring Boot.
• Extensive experience in developing enterprise-scale applications and systems. Should possess good architectural knowledge and be aware of enterprise application design patterns.
• Should have the ability to analyze, design, develop and test complex, low-latency client- facing applications.
• Good development experience with RDBMS.
• Good knowledge of multi-threading and high-performance server-side development.
• Basic working knowledge of Unix/Linux.
• Excellent problem solving and coding skills.
• Strong interpersonal, communication and analytical skills.
• Should have the ability to express their design ideas and thoughts.

Requirements:

• Energetic self-starter, with a desire to work in a startup environment.
• Proficient in advanced Java programming skills.
• Expert in Application development cloud/on premise end to end. Middle layer, DB layer.
• Nice to have understanding on MQ and DB
• Good hands on in Complex Event Processing systems.
• Solved scale and performance issues while dealing with huge sets of data. Pre compute or data aggregation frameworks to achieve good response time.
• Real world experience working with large datasets and NoSQL database technologies
• Experience of debugging applications running on Unix like systems (e.g. Ubuntu, CentOS)
• Experience developing RESTful APIs for complex data sets
• Knowledge of container based development & deployment (e.g. Dockers, rkt)
• Expertise in software security domain, a plus

We're on a mission to make it possible for every person, team, and company to be able to tailor their software to solve any problem and take on any challenge. Computers may be our most powerful tools, but most of us can't build or modify the software we use on them every day. At Notion, we want to change this with focus, design, and craft.

We've been working on this together since 2016, and have customers like Pixar, Mitsubishi, Figma, Plaid, Match Group, and thousands more on this journey with us. Today, we're growing fast and excited for new teammates to join us who are the best at what they do. We're passionate about building a company as diverse and creative as the millions of people Notion reaches worldwide.

Millions of people use Notion — and this number is increasing every day. That means a million people trust us to deliver a fast, reliable, and secure experience, and we value this more than anything. We want to keep earning trust, while also continuing to amaze our users with the tools they can build in Notion. This is where you come in — to help us forge a performant and reliable path forward to the future.

• Write clean, secure, tested, and documented code.
• Design & enhance the Notion platform with new capabilities, as and when the need arises.
• Contribute to monitoring & scaling the architecture of the platform and the infrastructure.
• Write technical documentation, and contribute to determining internal processes.
• Contribute to recruiting of new backend employees

• 6+ years of experience building scalable platforms. 
• Good understanding of database (Relational Or Nosql) internals like transactions, indexes. Experience in schema design.
• 2+ years of experience working on the AWS platform, and acquaintance with technologies like Elastic Beanstalk, AWS Lambda, Elastic Load Balancer.
• Good understanding of docker internals.
• Good communication skills, good leadership skills, attention to detail, a sound understanding of algorithms, and object-oriented programming.

• You're proficient with any part of our technology stack: React, TypeScript, Node.js, Memcached, Postgres, Docker, and Elasticsearch.
• You've heard of computing pioneers like Ada Lovelace, Douglas Engelbart, Alan Kay, and others—and understand why we're big fans of their work.
• You have interests outside of technology, such as in art, history, or social sciences.

Our customers come from all walks of life and so do we. We hire great people from a wide variety of backgrounds, not just because it's the right thing to do, but because it makes our company stronger. If you share our values and our enthusiasm for small businesses, you will find a home at Notion.

Notion is proud to be an equal opportunity employer. We do not discriminate in hiring or any employment decision based on race, color, religion, national origin, age, sex (including pregnancy, childbirth, or related medical conditions), marital status, ancestry, physical or mental disability, genetic information, veteran status, gender identity or expression, sexual orientation, or other applicable legally protected characteristic. Notion considers qualified applicants with criminal histories, consistent with applicable federal, state and local law. Notion is also committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or an accommodation made due to a disability, please let your recruiter know.

• Experience in Java and associated technologies Core Java, JSP, Spring, Struts,RESTful Services,SOAP,Tomcat, Hibernate, Maven
• Strong understanding of OOPS concepts
• Proficient understanding of RDBMS Concepts
• Strong understanding of Databases Oracle / MSQL / MySQL etc and PL/SQL Programming

• should have at least 5 years of hands-on experience in backend software development using Java.
• should have proven expertise in Spring Boot REST/Microservices.
• should have used design patterns like MVP, MVC or MVVM and should know when to use which.
• should have working experience with relational and NoSQL databases.
• should have multiple years of experience with cloud application design  and in one or more reputable cloud platform providers (e.g. AWS, GCP, Microsoft Azure … )
• should have professional experience working in an agile development environment.
• should have strong communication skills and like making decisions.
• should follow good software engineering principles such as TDD, writing modular, maintainable and clean code