PLSQL Developer

Job Description

About CAMS: Computer Age Management Services (CAMS) is the leading Mutual Fund Transfer Agency to the Indian Asset Management Companies servicing ~70% of the MF Industry AUM. CAMS is also a technology enabled service solutions partner to Private Life Insurance, Private Equity Funds, Software development / maintenance and Payments. The mutual fund business constitutes ~90% of the groups revenue. Besides serving as a B2B solutions partner, CAMS brings a unique ability of B2C to serve the end customers through a variety of touch points such as pan India network of Service centers, Call center and Online Services. The company was incorporated in year 1988, has four back-office delivery centers in Chennai, Business Continuity Plan (BCP) site at Coimbatore and a Pan India network of 270+ customer service centers. CAMS is a listed company and has Warburg Pincus LLC (a leading global private equity firm) and HDFC Group among its shareholders, headquartered in Chennai, India. CAMS conducts its software solutions business through subsidiary Sterling Software Private Limited. SSPL owns, develops and maintains the technology solutions for Mutual Fund clients and as of June 30, 2020, it had a technology team of 428 personnel. Among others, Sterling Software developed Investrak.NET, a scalable Mutual Fund transfer agency platform. SSPL assists with website design and development for other businesses and consumers, providing mobility solutions, performing trend analysis, business intelligence and analytics-based services, and technical and domain consulting services. We are looking for senior dot net developers with good experience, a passion for coding and solving complex problems in the financial domain. The developer should be able to explain and code OOPS, ACID, SOLID principles. He or she should have demonstrated experience in Restful web services development and implementing various design patterns. Once in a lifetime opportunity to be part of the high performing technology team developing the platform that's leading the consented citizen's financial data movement across silos! Key Responsibilities: Develop and Maintain PL/SQL Code : Design, develop, and maintain PL/SQL stored procedures, functions, packages, and triggers to meet business requirements. SQL Queries and Reports : Write efficient SQL queries to extract and manipulate data and ensure proper indexing and optimization. Performance Tuning : Optimize SQL and PL/SQL code for performance, including query optimization and indexing strategies. Database Design : Assist with database schema design, including creating tables, views, indexes, and relationships. Data Integration : Work with cross-functional teams to integrate databases with external systems and applications. Error Handling : Implement proper error handling and exception management in PL/SQL procedures. Testing and : Maintain accurate documentation for developed procedures, functions, and other code structures. nice, functionality, and security. Documentation :Maintain accurate documentation for developed procedures, functions, and other code structures. Collaboration : Work closely with other developers, system administrators, and business analysts to ensure the overall success of database projects. Required Skills: Proficiency in PL/SQL and Oracle Database systems. Strong SQL skills and experience with performance tuning. Familiarity with database design concepts and data modeling. Understanding of data manipulation, triggers, and stored procedures. Experience with version control tools (e.g., Git, SVN). Ability to troubleshoot and resolve database-related issues. Strong problem-solving skills and ability to optimize SQL queries for performance. Qualifications: BE /B. Tech / MCA / Bachelors and master’s degree in computer application or a related field (or equivalent work experience). Knowledge and Experience with Oracle 12c or later . Python, ETL and knowledge of additional Back-end tool is value added. Kindly share the Relevant Profiles to: swetha.n@camsonline.com