Software Lead programmer job description1. Software development Software Architecture and Design: Design and develop scalable, robust, and secure software applications using the Microsoft technology stack. Create high-level and detailed software design documents, including architecture diagrams and technical specifications. Implement best practices for software design, including SOLID principles, design patterns, and domain-driven design. Software Development: Develop web applications, APIs, and backend services using C#, .NET Core/Framework, and related technologies. Build front-end interfaces using ASP.NET MVC, Blazor, or React/Angular (with TypeScript). Leverage Azure services such as Azure Functions, Azure Logic Apps, Azure App Services, and Azure DevOps for scalable and cloud-native solutions. Database Design and Development: Design and implement relational database schemas for performance and scalability using Microsoft SQL Server or Azure SQL Database. Develop and optimize complex stored procedures, functions, triggers, and views using T-SQL. Build and maintain data models (relational and dimensional) that support software applications and reporting requirements. Implement data integrity, indexing strategies, and partitioning for large-scale databases. Develop and manage ETL/ELT workflows using SQL Server Integration Services (SSIS) or Azure Data Factory (ADF). Collaboration and Requirements Gathering: Work closely with product owners, business analysts, and stakeholders to gather and analyze requirements. Translate business requirements into technical solutions, ensuring alignment with business objectives. Facilitate design workshops, brainstorming sessions, and code reviews to enhance solution quality. System Integration and Testing: Integrate with third-party systems and services, ensuring compatibility and performance. Implement automated testing frameworks, including unit testing, integration testing, and performance testing. Performance Optimization and Troubleshooting: Monitor, troubleshoot, and optimize software performance and reliability. Implement logging, monitoring, and alerting using tools like Application Insights or Azure Monitor. Leadership and Mentorship: Mentor junior developers and provide guidance on best practices and technology adoption. Contribute to knowledge sharing within the team through documentation and training.Technical Skills: Programming and Frameworks: Proficient in C#, .NET Core, .NET Framework, ASP.NET MVC, Blazor, and RESTful API development. Database Design and Development: Expert in Microsoft SQL Server, Azure SQL Database Proficient in T-SQL for writing complex queries, stored procedures, and triggers. Strong understanding of database normalization, indexing, and partitioning strategies. Familiarity with dimensional modeling, star schema design, and data warehouse concepts. Experience with ETL tools like SSIS Cloud Technologies: Familiarity in Microsoft Azure services, including Azure Functions, Azure App Services, Azure Cosmos DB, and Azure Storage. Familiarity with Azure tools for database management and optimization, such as Azure Monitor, Azure Data Studio, and Azure Purview.Tools and Practices: Version control with Git and CI/CD pipelines using Azure DevOps. Experience with automated testing frameworks for software and database testing. Knowledge of ORM tools like Entity Framework Core.Soft Skills: Strong problem-solving and analytical abilities. Excellent communication skills for working with technical and non-technical stakeholders. Ability to manage multiple projects and meet tight deadlines. Team-oriented, with the ability to mentor and lead by example.2. Software delivery management Work closely with stakeholders (e.g., business users, product owners, and technical teams) to understand detailed software requirements. Conduct interviews, workshops, and brainstorming sessions to identify and prioritize functional and non-functional requirements. Analyse and understand process flow documents, Requirement Specification document, Functional solution document, milestones document, resource allocation and schedule document to ensure software delivery according to agreed quality standards and within the agreed timescale. Oversee end-to-end implementation activities, including configuration, integration, testing, and go-live support. Ensure software solutions are deployed within agreed timelines, budgets, and quality standards. Manage and resolve implementation-related issues. Act as the primary point of contact for clients or internal stakeholders during the implementation process. Facilitate regular meetings to update stakeholders on project status, gather feedback, and address concerns. Collaborate with users to drive engagement, adoption, and satisfaction with the implemented software.Key Competencies:1. Strategic Mindset: Align software delivery and operational improvements with long-term business goals.2. Execution Focus: Demonstrated ability to manage priorities, deliver on commitments, and optimize resource use.3. Operational Expertise: Strong grasp of operational KPIs, including uptime, deployment frequency, and system reliability.4. Collaboration: Proven ability to work with cross-functional teams and manage diverse stakeholders.3. Root Cause Management Root Cause Analysis (RCA):Lead detailed root cause investigations for critical software incidents and recurring problems.Facilitate post-incident reviews (PIRs) to identify contributing factors, root causes, and improvement opportunities.Analyse logs, data, and system behaviour to uncover underlying issues causing software failures.Document RCA findings and ensure they are shared across relevant teams and stakeholders. Corrective and Preventive Actions:Collaborate with development, QA, and operations teams to document corrective actions implemented to resolve root causes.Document preventive measures, such as automation, process enhancements, or system redesigns, to avoid recurrence.Track the implementation of action plans and validate their effectiveness. Incident and Problem Management:Maintain a problem management database, ensuring all recurring issues are logged, tracked, and resolved. Collaboration and Communication:Serve as the primary point of contact for RCA activities, providing regular updates to stakeholders on progress and outcomes.Foster collaboration between engineering, IT operations, and business teams to ensure seamless problem resolution.Present RCA findings, trends, and recommendations to senior leadership and governance boards. Continuous Improvement:Analyse incident and problem trends to identify systemic weaknesses and recommend improvements.Contribute to the refinement of RCA and problem management processes to enhance efficiency and effectiveness.Train and mentor team members on RCA techniques and tools.Key Competencies:1. Analytical Thinking: Ability to break down complex problems and identify root causes systematically.2. Leadership: Takes ownership of RCA processes and drives accountability across teams.3. Collaboration: Works effectively with cross-functional teams to resolve issues and implement solutions.4. Attention to Detail: Ensures accuracy and thoroughness in RCA documentation and action planning.5. Process Orientation: Demonstrates a structured approach to problem-solving and continuous improvement.