SQL DBA - Trainee analyst/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

Must Have Skills:

1.      Experience with the .NET framework and .NET Core technologies: C#

2.      Writing and consuming REST API/Web API in .Net framework, .Net Core

3.      Must have excellent knowledge in Azure hosting services

4.      Good knowledge of Trouble shooting, Azure Hosting, maintaining and performance tuning

5.      Knowledge of Frontend framework (React), If not then Angular, or Vuejs etc

6.      Excellent Aptitude, Attitude and Communication Skills

7.      Strong understanding of OOPS Concepts

8.      Strong knowledge of Unit Testing

9.      Excellent knowledge and working experience in Microservice Architecture

10.  RDBMS Concepts, MS-SQL Server

11.  Writing & Optimizing SQL Queries for best performance

12.  Able to manage release by mean of CI/CD pipeline to deploy applications in Azure

13.  Well versed of code review and code scanning tools

Good to have Skills:

1.      Knowledge of HTML, Bootstrap, CSS, Responsive Design

2.      Entity Framework/LINQ, MVC

3.      Strong understanding of current design patterns & best practices

4.      Knowledge of Agile methodology and JIRA

5.      Knowledge of Electron is a plus

Key Responsibilities:

1.      Work with Scrum Team to prioritize tasks and ensure deadlines are met

2.      Communicate and actively participate in client call and understand requirements

3.      Convert design and architecture to code using best practices

4.      Provide expert level knowledge and guidance on modern software engineering techniques and methodologies for code reviews

5.      Demonstrate expertise in a variety of software concepts (object-oriented design), practices (design patterns), and procedures (troubleshooting defects)

6.   Able to troubleshoot and debug the code, write code with best coding practice and perform unit & Integration testing

7.      Collaborate with the technical team to build and migrate applications in Azure

8.      Test and update application so that it can be used for cross web browsers

9.      Use and set-up CI/CD pipeline

We're Hiring: Senior Developer (AI & Machine Learning)** 🚀

🔧 **Tech Stack**: Python, Neo4j, FAISS, LangChain, React.js, AWS/GCP/Azure

🧠 **Role**: AI/ML development, backend architecture, cloud deployment

🌍 **Location**: Remote (India)

💼 **Experience**: 5-10 years

If you're passionate about making an impact in EdTech and want to help shape the future of learning with AI, we want to hear from you!

• Proven experience in any high-level programming languages like Java (Preferably)
• Strong knowledge of data structure, algorithms and coding
• Experience with any Messaging technologies like Kafka or Rab-bitMQ, etc.
• Proven experience in database technologies like NoSQL
• Hands-on experience with Spring, Spring Security, Spring boot, and Hibernate framework.
• Working knowledge of developing Restful Micro services.
• Strong analytical, problem-solving skills.
• Attend team meetings to discuss projects, brainstorm ideas, and put forward solutions to any issues.
• Ability to understand the Platform/domain of the business in detail & Ability to multi-task.
• Good communication and organizational skill

Key Responsibilities:

• SDLC development of product features, enhancements, UAT/production issues.
• Work with development team members for development of product features.
• Client-side and server-side development.
• Develop and manage well-functioning databases and application.
• Write/ design product APIs and write unit test cases.
• Follow standard agile scrum practices for software development.
• Peer review, pull requests, code refactoring and managing source code per standards and ensure quality. 

Required Experience & Skills:

• 5+ years of software development experience using Microsoft .Net technology stack.
• Strong experience in .Net, .Net Core, C#, Entity Framework, SQL server, JavaScript, jQuery, etc.
• Experience in using unit test framework e.g., xUnit, Moq.
• Experience in Web API development.
• Experience in Agile / SCRUM development process.
• Good to have experience in Domain driven design development and Microservice architecture.
• Excellent communication and teamwork skills
• Good to have knowledge and experience in ABP.IO framework, Angular 8+, PostgreSQL and AWS cloud service and CI/CD process.

Roles & Responsibilities:

• Work as a Web Developer to create front end & backend of websites
• Play a key role in the design lifecycle, from brief through to design and release/implementation
• Should have good knowledge of HTML, CSS, REACT JS, NODE JS, POSTGRES, GIT, REST API.
• A good understanding of servers, hosting, domains, DNS
• Ensure all designs work across all browsers and on all devices
• Help to design elements of mobile apps
• Ensure all designs are produced to deliver a great user experience

Key Skills/Experience:

• A minimum of one year of experience in designing and developing websites and web apps
• Good working experience in React JS, Redux, JavaScript ES6, NodeJS, AJAX, HTML, CSS, etc
• Knowledge about REST API
• Who has worked on libraries such as Bootstrap, Material is.
• Experience with Unit testing, Git, GitHub, and other DevOps and CI/CD tool
• A strong portfolio that demonstrates a range of work and techniques
• A passion for strong web design that delivers a great user experience
• A good understanding of the latest web design trends

Mandatory Skills:

1. Good Coding Skills
2. Hands on Experience on C#
3. Indexer
4. Object Oriented concepts using C#
5. Linq
6. Generics
7. Delegates
8. File IO
9. GAC concepts
10. MVC
11. Entity framework
12. .Net Core Concepts
13. Web-API
14. Sql Queries

Secondary Skills:

• Knowledge of Angular/React/Vue/Java Script/ Type Script
• Knowledge of HTML and CSS
• SQL Server and PL/SQL
• Understanding of Design Patterns

Interpersonal Skills:

1. Good in communications (Verbal and Written)
2. Should have worked individually or in team

Job Description:

• Build large scale enterprise applications.
• Responsible for providing deep technical expertise in designing and delivering end to end high performance, scalable & flexible solutions using Java and Open Stack technologies including Mobility/Responsive Web apps, APIs, application & data Integration, scalable databases, DevOps, Cloud Computing.
• He/ She would be also responsible to experiment, explore and demonstrate application of new technologies by means of conducting quick prototypes to solve business problems. Work with the direction from Solution Architect/ Enterprise Architect and co-create solutions with rest of the IT delivery teams