Job Description

Designation - Associtae Tech Lead

Location - Pune (Hybrid)

Job Description

- Take end-to-end ownership of maintenance, enhancement, and support activities for a large-scale ASP.NET Web Forms application.
- Analyze, debug, and optimize complex PostgreSQL stored procedures, functions, and triggers within a database of ~11,000 stored procedures.
- Triage and resolve production incidents, performance issues, and data integrity problems within agreed SLAs.
- Lead impact analysis for change requests across a tightly coupled legacy codebase and database layer.
- Review code and stored procedure changes submitted by team members; enforce coding, security, and performance standards.
- Break down client requirements/tickets into tasks, estimate effort, and distribute work across the team.
- Mentor junior and mid-level engineers on Web Forms, C#, and PostgreSQL/SQL best practices.
- Act as the primary technical point of contact with the client/stakeholders for status updates, root-cause analysis reports, and technical decisions.
- Identify and drive modernization or optimization opportunities within the constraints of a legacy platform.
- Maintain and improve documentation for application modules, database objects, and support runbooks.
- Support release planning, deployment coordination, and post-release validation.
- Evaluate, pilot, and drive adoption of AI-assisted development tools (e.g., GitHub Copilot, Claude Code, or similar) to accelerate bug triage, root-cause analysis, and quick-fix turnaround on the legacy codebase and stored procedures.
- Design and build lightweight AI-based automation for recurring maintenance tasks — e.g., auto-summarizing incident logs, generating impact-analysis drafts for change requests, flagging risky stored procedures before deployment, or auto-drafting RCA reports.
- Define guardrails and review practices for AI-generated code/SQL changes (validation, testing,



sign-off standards) to ensure production safety in a high-stakes legacy environment.
- Champion a human-in-the-loop, AI-co-assisted maintenance model within the team — coaching engineers on effective prompting, verification, and safe use of AI tools against an 11K-stored-procedure codebase.

Additional Details:

- 6–7 years of hands-on software development experience, with significant time spent on ASP.NET Web Forms and C# / .NET Framework.
- Strong expertise in PostgreSQL, including writing, debugging, and optimizing complex stored procedures, functions, triggers, and views.
- Proven experience working with and navigating large, complex database schemas (high stored-procedure-count systems is a strong plus).
- Solid understanding of application performance tuning (application-side and query-side).
- Experience with production support/maintenance projects — incident triage, RCA, defect resolution.
- Familiarity with version control systems (Git, TFS, or SVN) and change management processes.
- Working knowledge of IIS deployment and application hosting/troubleshooting in a Windows setting.
- Prior experience mentoring engineers or leading a small technical team (2–6 members).
- Excellent communication skills — able to explain technical issues clearly to technical and non-technical stakeholders.
- Hands-on experience using AI coding assistants (GitHub Copilot, Claude Code, Cursor, or similar) in a real development/maintenance workflow.
- Experience building small automation scripts or agents (using LLM APIs) for tasks like log analysis, ticket triage, code/SQL review assistance, or documentation generation.
- Awareness of risks/limitations of AI-generated code in legacy, high-complexity systems and how to mitigate them.

Job Snapshot

Updated Date

03-09-2026

Job ID

Harb727

Department

Delivery Unit 2

Location

Kothrud, Pune, Maharashtra, India

Experience

6 - 8 Years

Employee Type

Permanent

📌 Associate Tech Lead (India)
🏢 Harbinger Group
📍 India