.Net Core - Principal Software 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

Key Responsibilities:

Team Leadership and Management:

• Lead, mentor, and manage a team of backend developers, fostering a culture of collaboration, innovation, and technical excellence.
• Promote a shared vision for the team, ensuring alignment with business goals and organizational objectives.
• Conduct performance reviews, provide constructive feedback, and create opportunities for team members’ professional growth.
• Drive cross-functional collaboration between development teams, designers, and product managers to deliver seamless and high-quality software.

Technical Strategy and Execution:

• Define and drive architectural decisions for both backend and frontend systems,ensuring scalability, reliability, and performance.
• Advocate and implement best practices in software development, including coding standards, test-driven development (TDD), and peer code reviews.
• Encourage the adoption of Large Language Models (LLMs) and AI-driven tools to optimize development and testing workflows.
• Provide technical direction on backend development using modern frameworks and languages, as well as frontend development using React, Angular, or Svelte.

Process and Quality Management:

• Ensure robust integration between backend APIs and frontend systems for seamless user experiences.
• Establish and enforce coding, testing, and deployment standards for both backend and frontend teams.
• Implement and optimize automated testing frameworks for backend and UI layers to ensure comprehensive coverage.
• Monitor system performance and application stability, proactively identifying and mitigating risks.
• Establish CI/CD pipelines and DevOps best practices for efficient and reliable delivery cycles.

Stakeholder Collaboration:

• Act as a bridge between engineering teams, business stakeholders, and leadership, ensuring effective communication and alignment.
• Translate complex business requirements into actionable technical solutions and guide teams through their implementation.
• Provide regular updates on progress, challenges, and innovations to stakeholders.

Innovation and Exploration:

• Stay updated on advancements in Large Language Models (LLMs) and integrate them into development and quality assurance workflows where applicable.
• Encourage the exploration of cutting-edge technologies, tools, and frameworks for both backend and frontend development.
• Champion the use of AI and machine learning tools for performance optimization, automated testing, and enhanced developer productivity.

Skills & Qualifications:

Must-Have Skills:

• Proven experience as an Engineering Manager or similar leadership role.
• Strong technical background in backend technologies (e.g., Java, Spring Framework).
• Deep understanding of RESTful API design, microservices architecture.
• Hands-on experience with containerization and orchestration tools like Docker.
• Solid knowledge of Agile methodologies, TDD, and CI/CD pipelines.
• Excellent leadership, communication, and problem-solving skills.
• Expertise in integrating Large Language Models (LLMs) and AI-powered tools into development workflows.

Nice-to-Have Skills:

• Experience with cloud platforms like AWS, GCP, or Azure.
• Knowledge of automated testing frameworks for both backend (e.g., JUnit, Postman) and frontend (e.g., Playwright).
• Understanding of DevOps practices and infrastructure-as-code tools like Terraform.
• Exposure to AI/ML frameworks and libraries for enhancing application features and team efficiency.

Job Description – Blueprism Developer

• Design technical specifications for RPA (Blue Prism) that meets the requirements and handled all the non functional requirements of concurrency, scalability, security requirements, restart and recovery.
• Develops and configures automation processes as per the technical design document to meet the defined requirements. Works on the coding the more complicated automations or reusable components, and delegates and mentors junior developers for the less complex components.
• Develops new processes/tasks/objects using core workflow principles that are efficient, well structured, maintainable and easy to understand.
• Complies with and helps to enforce design and coding standards, policies and procedures.
• Ensures documentation is well maintained.
• Ensures quality of coded components by performing thorough unit testing.
• Works collaboratively with test teams during the Product test and UAT phases to fix assigned bugs with quality.
• Reports status, issues and risks to tech leads on a regular basis
• Improves skills in automation products by completing automation certification.
• Mentors junior developers and performs code reviews for quality control.

Qualifications

Bachelor degree in Engineering / Computer Science

Additional Information

•  5- 8 years of IT experience and having good understanding of programming concepts.  Should be from a programming background on any coding language (.Net, Java).
• Working experience in RPA for a minimum of 2 years and having project experience of a minimum 3 RPA implementations.
• Understands development methodology and lifecycle
• Should be trained on RPA tools (Blue Prism).
• Self-motivated, team player, action and results oriented.
• Well organized, good communication and reporting skills.

🚀 We’re Hiring: Senior Python Backend Developer 🚀

📍 Location: Baner, Pune (Work from Office)

💰 Compensation: ₹6 LPA

🕑 Experience Required: Minimum 2 years as a Python Backend Developer

About Us

Foto Owl AI is a fast-growing product-based company headquartered in Baner, Pune.

We specialize in:

⚡ Hyper-personalized fan engagement

🤖 AI-powered real-time photo sharing

📸 Advanced media asset management

What You’ll Do

As a Senior Python Backend Developer, you’ll play a key role in designing, building, and deploying scalable backend systems that power our cutting-edge platforms.

Architect and develop complex, secure, and scalable backend services

Build and maintain APIs & data pipelines for web, mobile, and AI-driven platforms

Optimize SQL & NoSQL databases for high performance

Manage AWS infrastructure (EC2, S3, RDS, Lambda, CloudWatch, etc.)

Implement observability, monitoring, and security best practices

Collaborate cross-functionally with product & AI teams

Mentor junior developers and conduct code reviews

Troubleshoot and resolve production issues with efficiency

What We’re Looking For

✅ Strong expertise in Python backend development

✅ Solid knowledge of Data Structures & Algorithms

✅ Hands-on experience with SQL (PostgreSQL/MySQL) and NoSQL (MongoDB, Redis, etc.)

✅ Proficiency in RESTful APIs & Microservice design

✅ Knowledge of Docker, Kubernetes, and cloud-native systems

✅ Experience managing AWS-based deployments

Why Join Us?

At Foto Owl AI, you’ll be part of a passionate team building world-class media tech products used in sports, events, and fan engagement platforms. If you love scalable backend systems, real-time challenges, and AI-driven products, this is the place for you.

At Upswing, we are a passionate and self-driven team of thinkers who aspire to build the rails to connect the legacy financial sector with financial innovators through a simple and powerful banking-as-a-service (BaaS) platform.

We’re building our platform putting the focus on pragmatism, reliability, and maintainability. We believe that keeping the engineering complexity under control is key to preserving the development productivity and long-term evolution of a platform.

To bring this vision to life, we are building the infrastructure using Microservices architecture using the latest set of technologies that are also fun to work with such as Java, Scala, Postgres, Akka, Kafka with a completely automated DevOps pipeline from the get-go using tools like Chef, Jenkins, Grafana, Graylog.

We are looking for motivated engineers who will be working in a highly creative and cutting edge technology environment to build a world-class financial services suite.

Why you should join us:

• You will redefine the financial services landscape for India in the coming years.
• Be part of a core Engineering team that will create innovative and scalable Fintech solutions.
• Work with passionate and experienced engineering, product & business workforce that believes in teamwork, and that helps fast-track your learning on solving complex technical challenges.
• We are funded by the leading fintech VC `QED Investors` and other established Founders and Executives of awesome Indian companies.

What you will do if you join us:

• Propose solutions to solve complex system architecture challenges and actively lead the end-to-end development of the system.
• Create robust, flexible, consistent, and easy-to-use APIs
• Continuously strive for performance improvements, code reusability, and readability

You should have:

• Tech or a higher degree in computer science or a related field.
• 1+ years of experience working on the back-end development for complex distributed systems who are willing to adopt any Programming language as per the requirement.
• Familiarity with any of the following – Java, C++, Scala, Kotlin, and frameworks like Spring, Play, Hibernate, Django, etc.
• Good understanding of Algorithms, Data Structure, OOP, Design patterns, Parallel programming, Multithreading concepts & Event-Driven Systems.
• Experience with Relational databases such as MySQL, PostgreSQL, Oracle, or any NoSQL database.

It’s a plus if you have:

• Familiarity with cloud platforms like AWS, Azure, or Google Cloud
• Worked on Micro-services architecture

• Python knowledge: object-oriented programming: inheritance, abstract classes, dataclass, dependency injection, design patterns: comand-query, repository, adapter, hexagonal architecture, swagger/Open API, flask, connexion
• Experience on AWS services: lambda, ecs, sqs, s3, dynamodb, auroradb
• Experience with following libraries boto3, behave, pytest, moto, localstack, docker
• Basic knowledge about terraform, gitlab ci
• Experience with SQL DB