We are looking for an experienced Software Engineer with strong expertise in Advent APX , .NET (C#) , and MS SQL Server to support enterprise Wealth & Asset Management platforms. The ideal candidate should possess hands-on experience in application support, backend development, platform optimization, database administration, automation, and modern engineering practices. This role offers the opportunity to work on business-critical investment management platforms while driving automation, process optimization, and the adoption of modern technologies including AI and microservices. Requirements Key Responsibilities Platform & Database Management Manage, maintain, and optimize the Advent APX platform. Ensure the stability, availability, and performance of the Advent APX application environment. Design, develop, optimize, and troubleshoot complex MS SQL Server databases. Write and optimize T-SQL queries, stored procedures, functions, and triggers. Monitor database performance and implement tuning strategies. Ensure database integrity, backup, recovery, and high availability. Application Development Design, develop, and maintain backend applications using .NET (C#). Build scalable, secure, and maintainable backend services. Develop APIs and integration services to support business applications. Work closely with business users and technical teams to deliver platform enhancements. Troubleshoot production issues and provide Tier-2/Tier-3 application support. Participate in code reviews and follow software engineering best practices. Test Automation & DevOps Design and implement automated testing frameworks. Develop automation scripts using tools such as Playwright or equivalent. Improve software quality through automated regression and validation testing. Build and maintain CI/CD pipelines. Support release management and deployment automation. Process Improvement & Innovation Review existing business processes and identify opportunities for automation. Modernize legacy workflows through engineering improvements. Integrate modern APIs and microservices using .NET and Node.js. Evaluate and implement AI and Large Language Model (LLM) technologies to automate business processes and improve operational efficiency. Contribute to continuous improvement initiatives across engineering teams. Required Technical Skills Advent APX Minimum 5 years of hands-on experience administering and supporting Advent APX. Strong understanding of Wealth & Asset Management platforms. Experience in APX configuration, customization, troubleshooting, and performance optimization. Microsoft SQL Server Expert-level proficiency with MS SQL Server. Advanced T-SQL programming. Experience developing: Stored Procedures Functions Views Triggers Database design and optimization. Query performance tuning and indexing. Database administration fundamentals. .NET Development Strong hands-on experience with .NET Framework and C#. Backend application development. API development and integration. Object-Oriented Programming (OOP). Software architecture and design principles. Node.js Working knowledge of Node.js. Experience building or integrating REST APIs. Understanding of microservices architecture. Automation & DevOps Hands-on experience with Playwright or similar automation testing frameworks. Experience building automated testing solutions. Familiarity with CI/CD pipelines. Experience with Git and version control systems. AI & Modern Engineering Exposure to AI-powered development tools. Understanding of Large Language Models (LLMs). Experience leveraging AI to automate engineering or operational workflows is highly desirable. Required Competencies Strong analytical and troubleshooting skills. Excellent problem-solving ability. Strong ownership and accountability. Ability to challenge existing processes and drive improvements. Excellent communication and stakeholder management skills. Ability to work independently as well as within cross-functional teams. Strong attention to detail and commitment to engineering excellence. Preferred Domain Experience Wealth Management Asset Management Investment Platforms Banking Financial Services Capital Markets Nice to Have Experience with RESTful APIs and microservices architecture. Exposure to cloud platforms and modern engineering practices. Knowledge of DevOps methodologies. Experience supporting enterprise financial applications. Exposure to AI-assisted software development tools such as GitHub Copilot, Cursor, Claude Code, or similar.