.NETPosition 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
Shubham Vishwakarma
Full Stack Developer - Averlon
About Deltek
About
Project-based businesses transform the world we live in. Deltek innovates and delivers software and solutions that power them to achieve their purpose. Our industry-specific software and information solutions maximize our customers' performance at every stage of the project lifecycle by enabling superior levels of project intelligence, management and collaboration.
Deltek is the recognized global standard for project-based businesses across government contracting and professional services industries, helping more than 30,000 organizations of all sizes deliver on their mission.
With over 4,200 employees worldwide, our team of industry experts is passionately committed to creating exceptional customer experiences.
Company social profiles
Similar jobs
.NET
Amazon Web Services (AWS)
PostgreSQLJob Title : Backend Developer (.NET Core)
Experience : 2 to 5 Years
Work Environment :
- Hybrid model : Minimum 3 days/week from office
- Office Location : Hauz Khas, Delhi
- Flexible working hours based on project needs
Job Summary :
We are looking for a skilled and motivated Backend Developer with 2–5 years of experience, proficient in .NET Core and experienced with cloud platforms (AWS preferred or Azure).
You will be responsible for building scalable backend services and RESTful APIs, integrating with cloud components, and ensuring robust data handling.
Key Responsibilities :
- Design, develop, and maintain robust backend systems using .NET Core 6 or above.
- Develop and manage Web APIs for frontend and third-party integrations.
- Work with cloud infrastructure (preferably AWS: Lambda, EventBridge, SQS, CloudWatch, S3; or Azure: AppService, Functions, AzureSQL, EventHub, Blob Storage).
- Work with databases such as SQL Server, PostgreSQL, and tools like PGAdmin.
- Utilize Entity Framework Core, Dapper, or equivalent ORM tools.
- Collaborate using Git or TFS for version control.
- Develop, debug, and maintain code in Visual Studio.
- Write optimized and scalable SQL queries and stored procedures.
- Participate in code reviews and maintain high code quality.
Required Skills :
- Proficient in .NET Core 6+.
- Experience with RESTful API development.
- Strong command of SQL and relational databases.
- Familiarity with cloud platforms (AWS preferred, Azure acceptable).
- Good understanding of Git/TFS.
- Hands-on experience with tools like Visual Studio, SQL Server, PGAdmin.
- ORM experience with Entity Framework Core, Dapper, or similar.
Nice to Have :
- Exposure to asynchronous processing or event-driven architecture.
- Experience working with Cursor-based data fetching or streaming.
Spring Boot
JavaAmazon Web Services (AWS)What we Require
We are recruiting technical experts with the following core skills and hands-on experience on
Mandatory skills : Core java, Microservices, AWS/Azure/GCP, Spring, Spring Boot
Hands on experience on : Kafka , Redis ,SQL, Docker, Kubernetes
Expert proficiency in designing both producer and consumer types of Rest services.
Expert proficiency in Unit testing and Code Quality tools.
Expert proficiency in ensuring code coverage.
Expert proficiency in understanding High-Level Design and translating that to Low-Level design
Hands-on experience working with no-SQL databases.
Experience working in an Agile development process - Scrum.
Experience working closely with engineers and software cultures.
Ability to think at a high level about product strategy and customer journeys.
Ability to produce low level design considering the paradigm that journeys will be extensible in the future and translate that into components that can be easily extended and reused.
Excellent communication skills to clearly articulate design decisions.
- Position: Appian Tech Lead
- Job Description:
- Extensive experience in Appian BPM application development
- Knowledge of Appian architecture and its objects best practices
- Participate in analysis, design, and new development of Appian based applications
- Mandatory Team leadership and provide technical leadership to Scrum teams Certification Mandatory- L1, L2 or L3
- Must be able to multi-task, work in a fast-paced environment and ability to resolve problems faced by team
- Build applications: interfaces, process flows, expressions, data types, sites, integrations,
- Proficient with SQL queries and with accessing data present in DB tables and views
- Experience in Analysis, Designing process models, Records, Reports, SAIL, forms, gateways, smart services, integration services and web services
- Experience working with different Appian Object types, query rules, constant rules and expression rules
Qualifications:
- At least 6 years of experience in Implementing BPM solutions using Appian 19.x or higher
- Over 8 years in Implementing IT solutions using BPM or integration technologies
- Experience in Scrum/Agile methodologies with Enterprise level application development projects
- Good understanding of database concepts and strong working knowledge any one of the major databases e g Oracle SQL Server MySQL
Additional Information Skills Required
- Appian BPM application development on version 19.x or higher
- Experience of integrations using web services e g XML REST WSDL SOAP API JDBC JMS
- Good leadership skills and the ability to lead a team of software engineers technically
- Experience working in Agile Scrum teams
- Good Communication skills
RedisJob Summary:
We are looking for a skilled and motivated Backend Engineer with 2 to 4 years of professional experience to join our dynamic engineering team. You will play a key role in designing, building, and maintaining the backend systems that power our products. You’ll work closely with cross-functional teams to deliver scalable, secure, and high-performance solutions that align with business and user needs.
This role is ideal for engineers ready to take ownership of systems, contribute to architectural decisions, and solve complex backend challenges.
Website: https://www.thealteroffice.com/about
Key Responsibilities:
- Design, build, and maintain robust backend systems and APIs that are scalable and maintainable.
- Collaborate with product, frontend, and DevOps teams to deliver seamless, end-to-end solutions.
- Model and manage data using SQL (e.g., MySQL, PostgreSQL) and NoSQL databases (e.g., MongoDB, Redis), incorporating caching where needed.
- Implement and manage authentication, authorization, and data security practices.
- Write clean, well-documented, and well-tested code following best practices.
- Work with cloud platforms (AWS, GCP, or Azure) to deploy, monitor, and scale services effectively.
- Use tools like Docker (and optionally Kubernetes) for containerization and orchestration of backend services.
- Maintain and improve CI/CD pipelines for faster and safer deployments.
- Monitor and debug production issues, using observability tools (e.g., Prometheus, Grafana, ELK) for root cause analysis.
- Participate in code reviews, contribute to improving development standards, and provide support to less experienced engineers.
- Work with event-driven or microservices-based architecture, and optionally use technologies like GraphQL, WebSockets, or message brokers such as Kafka or RabbitMQ when suitable for the solution.
Requirements:
- 2 to 4 years of professional experience as a Backend Engineer or similar role.
- Proficiency in at least one backend programming language (e.g., Python, Java, Go, Ruby, etc.).
- Strong understanding of RESTful API design, asynchronous programming, and scalable architecture patterns.
- Solid experience with both relational and NoSQL databases, including designing and optimizing data models.
- Familiarity with Docker, Git, and modern CI/CD workflows.
- Hands-on experience with cloud infrastructure and deployment processes (AWS, GCP, or Azure).
- Exposure to monitoring, logging, and performance profiling practices in production environments.
- A good understanding of security best practices in backend systems.
- Strong problem-solving, debugging, and communication skills.
- Comfortable working in a fast-paced, agile environment with evolving priorities.
Ruby on Rails (ROR)
Ruby● Collaborate with engineering, design and product teams to design and ship new
features. Identify and solve bottlenecks and fix bugs.
Desirable Qualifications:
● Deep knowledge of Ruby on Rails (RoR) practices and commonly used modules; deep
understanding of RoR internals like databases, API, caching, proxies, web services,
performance and scalability.
● Experience creating self-contained, reusable, and testable modules and components.
● Experience in SQL and NoSql databases in production environments. Experience
working with Git, AWS/GCP.
● Good communication skills
● 4+ years of relevant experience as a software engineer
.NETSkills Required:
- 7+ years of experience as software engineer.
- Experience in Dot.Net technologies - Asp.Net MVC, WebAPI, .NetCore
- Experience in ORM like Entity Framework /Dapper
- Experience with Object-Oriented Design and SOLID principles
- Experience with Unit Testing, Mocking and Dependency Injection frameworks
- Experience with SQL Server, NoSQL or other database technology
- Experience with software quality, testing procedures and build automation tools
- Knowledge of the Principles & Patterns of Agile Software
- Ability to understand and troubleshoot existing code and maintain existing systems.
- Ability to identity performance bottlenecks.
- Experience working with version control tools such as GIT and CI/CD tools.
.NET
C#
.NETC#Main Responsibilities:
- Should be accountable for the deliverables of assigned MS Dynamics CRM functionality
- Should be able to work with Business groups, Architects to understand the functional expectations, produce technical solutions and documentation
- Should be able to conceptualize and design solution, independently customize, develop/code using MS Dynamics 365 and technologies such as C#, .Net, Integration technologies including SQL Server & Kingsway Soft
- Should be able to own technical impediments, liaise with various groups and troubleshoot /resolve
- Participate in the Scrum process activities including Sprint Planning and Estimating sessions, Daily Stand-ups, Sprint Demos and Sprint retrospectives.
Basic Qualifications:
- 4+ years’ strong experience in MS dynamics 365 implementations & support and extensive experience with C#, .NET, JavaScript, Power apps
- Strong experience in Web API development and plug in’s
- Strong experience in integration technologies including SQL Server & KingswaySoft to connect internal & third-party systems
- Experience with Power BI, SQL Server Integration Services, ASP.net, client-side JavaScript frameworks, Xamarin.
Preferred Qualifications:
- Strong experience using Microsoft Azure Dev Ops, MS Visual Studio and MS SQL server
.NETC#- Strong experience require in C# coding & Concepts & Threads
- Strong Experience require in SqlServer & MySql & Sqllite
- Experience required in ASP.NET MVC & ASP.NET
- Expericend required in Restful services using WCF & WEB API
- Strong experience using Entity Framework (Edmx,code first)
. Experience require in ADO.NET
- Familiarity with the client side framework jQuery & Javacsript & Reactjs
. Familiarity with HTML & CSS
- Familiarity with Git Repositories
. Familiarity with Microsoft Azure
. Having knowledge in Xamarin.Forms will be added advantage
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon