PLSQL Developer - Assistant Manager
State Street3 days ago
Bengaluru, IndiaStaff+
Responsibilities
- Analyze and develop high-quality software solutions aligned with business goals.
- Provide L3/L4 and SME support for investment performance, analytics, and ETL applications.
- Install, configure, and test products; investigate problems; and perform database configuration, tracing, and performance analysis.
- Debug and maintain software applications and collaborate with development teams to resolve issues.
- Perform release management, day-to-day deliverables, and ownership of deliverables as an individual contributor.
- Handle major incidents and coordinate with other departments to resolve production issues.
- Interact with technical and business users in a client-facing environment.
Requirements
- Bachelor’s degree in computer science or a related field.
- Expertise in Sybase and Oracle programming, including DDL and DML.
- Expertise in PL/SQL programming and Unix scripting.
- Proficiency in Unix shell scripting; experience with data center migrations or Linux version upgrades is highly desirable.
- Strong knowledge of Oracle database objects, especially indexes, partitioning, and views, as well as database architecture and components.
- Strong knowledge of data warehouses, schema types, and dimensional modeling.
- Understanding of core and advanced Java, Hibernate, Persistence API, JSP, and JPA concepts.
- Working knowledge of Autosys or another job scheduling tool.
- Familiarity with Perl scripting and CGI debugging and development is a plus.
- Knowledge of Git, Harness, and Artifactory is a plus.
- Knowledge of the financial domain is preferred.
- Strong written and verbal communication, relationship-building, organizational, attention-to-detail, and problem-solving skills.
Benefits
- Hybrid work environment.
- Inclusive development opportunities, flexible work-life support, paid volunteer days, and employee networks.
About State Street
State Street is a global custodian bank and asset manager serving institutional investors with investment servicing, fund accounting, trading/FX, data, and index/active strategies. Its products include State Street Global Advisors’ funds and ETFs, the Charles River Investment Management Solution, and the front-to-back State Street Alpha platform. Founded in 1792 and headquartered in Boston, the company is publicly traded on the NYSE (ticker: STT) and operates across major markets worldwide.