.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
Spring Boot
Java
Amazon 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.
JavaSpring BootJob Description:
- Experience in Core Java, Spring Boot.
- Experience in microservices.
- Extensive experience in developing enterprise-scale systems for global organization. Should possess good architectural knowledge and be aware of enterprise application design patterns.
- Should be able to analyze, design, develop and test complex, low-latency client-facing applications.
- Good development experience with RDBMS in SQL Server, Postgres, Oracle or DB2
- Good knowledge of multi-threading
- Basic working knowledge of Unix/Linux
- Excellent problem solving and coding skills in Java
- Strong interpersonal, communication and analytical skills.
- Should be able to express their design ideas and thoughts.
About Wissen Technology:
Wissen Technology is a niche global consulting and solutions company that brings unparalleled domain expertise in Banking and Finance, Telecom and Startups. Wissen Technology is a part of Wissen Group and was established in the year 2015. Wissen has offices in the US, India, UK, Australia, Mexico, and Canada, with best-in class infrastructure and development facilities. Wissen has successfully delivered projects worth $1 Billion for more than 25 of the Fortune 500 companies. The Wissen Group overall includes more than 4000 highly skilled professionals.
Wissen Technology provides exceptional value in mission critical projects for its clients, through thought leadership, ownership, and assured on-time deliveries that are always ‘first time right’.
Our team consists of 1200+ highly skilled professionals, with leadership and senior management executives who have graduated from Ivy League Universities like Wharton, MIT, IITs, IIMs, and NITs and with rich work experience in some of the biggest companies in the world.
Wissen Technology offers an array of services including Application Development, Artificial Intelligence & Machine Learning, Big Data & Analytics, Visualization & Business Intelligence, Robotic Process Automation, Cloud, Mobility, Agile & DevOps, Quality Assurance & Test Automation.
We have been certified as a Great Place to Work® for two consecutive years (2020-2022) and voted as the Top 20 AI/ML vendor by CIO Insider.
Job Description
Build and maintain bots on Azure platform. Integration with Active directory, WEB API based integration with external systems. Training and Integrate bots as per users’ requirements. Work in line with design guidelines, best practices and standards of bot deliverable. Creative approach to the conversation flow design, human aspects in the bot responses and sentiments
Qualifications
- a) 5 years of experience in software development with clear understanding of the project life cycle
b) Min 2-3 years of hands-on experience in Microsoft Azure Bot Framework, LUIS and other Cognitive services offered by Azure
c) Hands on experience with Machine Learning based chat bots
d) Experience with Azure bot services like Text Analytics etc.
e)Strong database skills and hands-on experience on databases like SQL Server/Oracle - f) Strong experience on Azure Active directory and adaptive cards integration in Chat bot.
- g) Strong experience designing and working with
with service-oriented architectures (SOA) and WebAPIs.
- h) A strong experience on Microsoft Azure, ASPNET / MVC and programming languages such as C#/VBNET
- i) Knowledge of Python and NodeJS is a plus
- j) Ability to design and optimize SQL Server 2008 stored procedures.
- k) Experience with JQuery, CSS3, HTML5 or similar technologies.
- l) Ability to adapt quickly to an existing, complex environment.
Python
DjangoAmazon Web Services (AWS)
NodeJS (Node.js)JavaWHO YOU ARE
To be successful in this role, you’ll need to have the following skills:
· Love for coding: A fanatic about writing beautiful and scalable code.
· A sense of analytics: Strong analytical and troubleshooting skills. Should be resourceful, innovative and inventive.
· Dynamic: Should be comfortable in dealing with lots of moving pieces. Have exquisite attention to detail, and are comfortable learning new technologies and systems.
· Team player: Knack for influencing without being authoritative. Pitch in wherever the team needs help, from writing blog posts to supporting customers.
· Accountability: High sense of ownership for your code and relentlessness to deliver projects with high business impact.
KEY QUALIFICATIONS
· BE/BTech in Computer Science or related field.
· 5+ years of professional production and development experience with leading-edge server and database technologies (e.g., Python, Java, Node.js, Scala, Spring Boot, MySQL, and NoSQL databases).
KEY SKILLS
· Strong computer system analysis and design skills in current methodologies and patterns Experience with professional production cloud (AWS preferred).
· Experience with RESTful Services and APIs.
.NETJava
Go Programming (Golang)
Scala- Bachelor's or Master’s degree in Computer Science or equivalent area
- 10 to 20 years of experience in software development
- Hands-on experience designing and building B2B or B2C products
- 3+ years architecting SaaS/Web based customer facing products, leading engineering teams as software/technical architect
- Experiences of engineering practices such as code refactoring, microservices, design and enterprise integration patterns, test and design-driven development, continuous integration, building highly scalable applications, application and infrastructure security
- Strong cloud infrastructure experience with AWS and/or Azure
- Experience building event driven systems and working with message queues/topics
- Broad working experience across multiple programming languages and frameworks with in-depth experience in one or more of the following: .Net, Java, Scala or Go-lang
- Hands-on experience with relational databases like SQL Server, PostgreSQL and document stores like Elasticsearch or MongoDB
- Hands-on experience with Big Data processing technologies like Hadoop/Spark is a plus
- Hands-on experience with container technologies like Docker, Kubernetes
- Knowledge of Agile software development process
Java
C#Go Programming (Golang)PythonAs an SDE, you will develop a deep understanding of our business, work closely with development teams and own the architecture and end-to-end delivery of software components.
Requirements:
- Exp: 3 - 8 years.
- 4 + years' experience building successful production software systems.
- A solid grounding in Computer Science fundamentals (based on a BS or MS in CS or related field).
- The ability to take convert raw requirements into good design while exploring technical feasibility tradeoffs.
- Expertise in System design (design patterns, LLD, HLD, Solid principle, OOAD, Distributed systems etc. ), Architecture (MVC/Micro services).
- Excellence in technical communication.
- Has experience in mentoring other software developers.
- BS/MS in Computer Science or equivalent.
- Experience developing service oriented architectures and an understanding of design for scalability, performance and reliability.
- Demonstrated ability to mentor other software developers to maintain architectural vision and software quality.
- Demonstrated ability to achieve stretch goals in a highly innovative and fast paced environment.
- Expertise in delivering high-quality, innovative application.
- Strong desire to build, sense of ownership, urgency, and drive.
- Strong organisational and problem solving skills with great attention to detail.
- Ability to triage issues, react well to changes, work with teams and ability to multi-task on multiple products and projects.
- Experience building highly scalable, high availability services.
- The ideal candidate will be a visionary leader, builder and operator.
- He/she should have experience leading or contributing to multiple simultaneous product development efforts and initiatives.
- He/she needs to balance technical leadership with strong business judgment to make the right decisions about technology choices.
- He/she needs to be constantly striving for simplicity, and at the same time demonstrate significant creativity, innovation and judgme.
- Proficiency in, at least, one modern programming language.
- Experience in SQL or Non-SQL database.
- Strong sense of ownership, urgency, and drive.
- Demonstrated leadership abilities in an engineering environment in driving operational excellence and best practices.
- Demonstrated ability to achieve stretch goals in a highly innovative and fast paced environment.
- Excellent communication, collaboration, reporting, analytical and problem solving skills.
- Good understanding of at least some of the modern programming languages (Java) and open-source technologies
JavaNodeJS (Node.js)As part of the engineering team, you would be expected to have
deep technology expertise with a passion for building highly scalable products.
This is a unique opportunity where you can impact the lives of people across 150+
countries!
Responsibilities
● Own architecture, design, development, and implementation of different modules/features of the services
● Design, develop, deploy and support web applications.
● Discover opportunities for performance improvements
● Recommend ways to improve reliability, efficiency and code quality
● Focus on continuous delivery and reducing complexity
● Carry out code reviews and manage pull requests
● Build applications based on micro-services architecture
Requirements
● Overall 1-3 years of experience in Backend development.
● B.E/B.Tech in CS or equivalent streams from institute of repute (IITs, NITs, BITs,
IIITs or equivalent)
● Strong object oriented design skills & knowledge of design patterns
● Experience designing & developing distributed systems involving multiple web services, databases (both SQL and NoSQL), caches, queues, etc. taking into consideration scalability, availability, fault tolerance, consistency, etc. of the overall system
● Well-aware of and enforces development best practices: Unit Tests, Code Reviews,
Integration Tests, CI/CD, Monitoring, Alerting, etc
JavaSENIOR SOFTWARE DEVELOPER (BACKEND DEVELOPMENT):
We are looking for a Java Developer with experience in building high-performing, scalable, enterprise-grade web applications.
You will be part of a talented software team that works on mission-critical applications. Java developer roles and responsibilities include managing Java/Java EE application development while providing expertise in the full software development lifecycle, from concept and design to testing.
Responsibilities
• Java developer responsibilities include designing and developing high-volume, low-latency applications for mission-critical systems and delivering high-availability and performance
• Contribute in all phases of the development lifecycle
• Write well designed, testable, efficient code
• Ensure designs are in compliance with specifications
• Prepare and produce releases of software components
• Support continuous improvement by investigating alternatives and technologies and presenting these for
architectural review
Requirements
• BS/MS degree in Computer Science, Engineering or a related subject from renowned (IITs, NITs, BITS etc) colleges
• Excellent aptitude, algorithmic and puzzle solving skills
• Proven hands-on Software Development experience
• Proven working experience of 2+ years in Java development
• Hands on experience in designing and developing applications using Java EE platforms
• Object Oriented analysis and design using common design patterns.
• Profound insight of Java and JEE internals (Classloading, Memory Management, Transaction management, Multi-Threading etc)
• Good knowledge of Relational Databases, SQL and ORM technologies (JPA2, Hibernate)
• Experience in the Spring Framework
• Experience in developing web applications using at least one popular web framework (JSF, Wicket, GWT,
Spring MVC)
• Experience with agile development
.NETC#.NETC#
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon