PL SQL - Manager
State Street15 hours ago
Bengaluru, IndiaStaff+
Responsibilities
- Analyze and develop software solutions aligned with business goals.
- Provide L3/L4 and advanced technical support for software applications.
- Install, configure, and test products; investigate problems; and perform database tracing and performance analysis.
- Debug and maintain software applications and collaborate with development teams to resolve issues.
- Perform release management and manage day-to-day deliverables.
- Handle major incidents and coordinate with other departments to resolve production issues.
- Support Investment Performance and Analytics and in-house ETL applications.
- Work with users and clients in technical or business areas in a client-facing environment.
Requirements
- Bachelor’s degree in computer science or a related field.
- Expertise in Sybase or Oracle programming and DDL/DML.
- Expertise in PL/SQL programming and Unix scripting.
- Strong knowledge of Oracle database objects, including 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.
- Strong written and verbal communication, partnership, organization, attention to detail, and problem-solving skills.
- Experience with data center migrations or Linux version upgrades is highly desirable.
- Familiarity with Perl scripting and CGI debugging or development is a plus.
- Knowledge of Git, Harness, Artifactory, and the financial domain is a plus.
- Ability to work independently and collaboratively.
Benefits
- Hybrid work environment.
- Inclusive development opportunities.
- Flexible work-life support.
- Paid volunteer days.
- Employee networks.
- Equal employment opportunity workplace.
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.