Dot Net MVC and PL/SQL Developer

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

Senior Software Engineer

Responsibilities:

• Lead by the principle of "customer first" to analyse, debug, develop, and maintain customer-centric software.

• Collaborate closely with multidisciplinary teams to analyse, debug and fix issues with high quality code, zero regressions, scalable, innovative technical solutions.

• Optimizing components for maximum performance and scalability

• Participates in R&D, Proof of Concepts, Prototyping, Code review, Root Causing, etc.

• At least 2-3 yrs of experience in taking full ownership of software development lifecycle including planning, design, architecture, development, test & deployment. And 2+ years of experience in supporting production or customer issues and escalations.

• Review and analyze support tickets that are complex in nature and require more technical knowledge to analyze. Investigate issues to identify root causes and document findings clearly.

• Influences the development practices so that they follow best practices, policies, and procedures.

• Ensure software products meet all non-functional requirements including operational and security needs.

• Excellent verbal and written communication skills, problem solving skills.

• Address complex technical challenges within software systems, ensuring robustness, compliance, and customer satisfaction.

• Contribute to knowledge base

• Support the Lead and Mentor the team of software engineers and own the technical health of the service the team is working on.

Requirements:

• Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field.

• Minimum of 5 years of professional experience in Java development with expertise in core Java, JDK, data structures, and multithreading.

• Strong analytical skills with experience in root cause analysis and fixes • Strong experience with Spring and Spring Boot frameworks.

• Strong understanding of software design principles, architecture, and best practices

• Familiarity with server technologies, including Tomcat and WebLogic.

• Proficiency in working with relational databases such as Oracle and PostgreSQL

• Experience with messaging queues, particularly JMS MQ or Artemis MQ.

• Possess exceptional debugging and troubleshooting skills to resolve complex issues across the entire, cross-functional technology stack

• Awareness / exposure to debugging Frontend applications (ReactJS / .Net) is a good to have.

• Exposure to Kubernetes, containerization and cloud (AWS) technologies in building scalable, resilient, and distributed environments.

• Excellent problem-solving skills and the ability to work in a fast-paced and in production customer sensitive environments.

• Strong communication and collaboration skills. Quick learner.

• Experience and knowledge in working in the HRP application – specifically the Claims functionality. Added experience in other areas including Enrollment, Billing, Financials is a plus. Candidate must have worked previously in HRP

• Familiarity with ticketing systems (Jira, SalesForce) and production support workflows.

Designation: Team Lead ( Dot Net Development)

Experience: 5 to 8 years

Required Skills:

• Project Management skills.
• Previous experience leading development teams is a plus.
• Application of agile development processes in a leadership capacity.
• Proven experience with Microsoft .NET technologies including, ASP.NET, MVC, Entity Framework.
• Proven Skills with C#, SQL, JavaScript/DHTML, HTML-CSS, AJAX, jQuery, Web Services, etc.
• Ability to complete all phases of software development life cycle including analysis, design, functionality, testing and support.
• Ability to manage large scale web/database application.
• Should have working knowledge of using a latest development tools and techniques.
• Must have good problem solving and analysis skills.
• Team-player with strong communication & collaboration skills.
• Previous experience with ecommerce website development is preferred.

Essential duties and responsibilities include the following.

• Design, create and maintain databases through multiple product lifecycle environments, from development to production systems
• Configure and maintain database servers and processes, monitor system health and performance, to ensure high levels of performance, availability, and security.
• Convert complex business requirements into technical specifcations to build scalable and reliable data solutions 
• Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Independently analyse, solve, and correct issues in real time on production, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes.
• Develop complex query, performance tuning, stored procedures and triggers, scheduled jobs, schema refinement.
• Flexibility to work after office hours for any production issue or production deployment.
• Perform scheduled maintenance and support release deployment activities after hours.
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

Qualifications include:

• 4+ years of database and backend development experience
• Good understanding of database systems and architectures
• Expertise in writing complex SQL queries and stored procedures
• Hands on experience with RDBMS and NoSQL data stores like  MySQL and MongoDB
• Experience working with Python scripting and application development
• Experience working with Cloud applications and data stores like AWS RDS is a plus
• In-depth understanding of data management and ETL processes

Reporting and Business Intelligence

Minimum of 8 to 10 years of experience in Report building and Business Intelligence with

Profound knowledge on Oracle BI Publisher and BI Analytics with Oracle Fusion HCM domain especially in Core HR, Payroll and Absences modules

Primary skill:

• Experience generating BI publisher reports, dashboards and drill-down reports
• BI Publisher (RTF design/ eText/ Scheduling/ Parameter Handling/Bursting/backup and migration of reports to different pods)
• Design Oracle BI Publisher Data Models, Data sets and Templates/sub-templates
• Strong PL/SQL and Advanced PL/SQL experience
• Solid understanding of performance tuning best practices and experience improving end-to-end processing times
• Knowledge on the data models related to Fusion HCM (Core HR, Absence and Payroll modules)

Nice to have skills:

• Experience generating BI publisher reports, dashboards and drill-down reports
• Strong OBI Administrator activity
• Create mobile applications with Oracle Business Intelligence Mobile App Designer
• Use BI Mobile to access BI Content
• Create and modify Interactive Dashboards
• Knowledge of additional reporting tools viz. HCM Extract / OTBI / Analysis Dashboard would be an added advantage

Behavioural and Process Skills

• Experience working in Agile teams
• Self-motivated and self-directed abilities to prioritize and execute tasks in a high-pressure environment with "time-critical" deadlines
• Proven analytical, evaluative, and problem-solving abilities
• Possesses a team and customer service provision orientation