Senior Oracle Database Engineer – Assistant Manager

Senior Oracle Database Engineer – Assistant Manager Who we are looking for We are looking for a highly skilled and experienced Senior Oracle Database Developer / Oracle Performance Tuning Specialist with 10+ years of hand-on experience in Oracle database technologies. The ideal candidate will possess deep expertise in Oracle SQL Performance tuning, SQL, PLSQL development, oracle Golden Gate, and Exadata environments and provide SME support in State Street for various in-house ETL Applications. The job entails resolving developer problems and maintaining application resiliency in State Street. Why this role is important to us The Team you will be joining is part of our technology function, Global Technology Services (GTS), which is vital to State Street and is the key enabler for our business to deliver data and insights to our clients. We’re driving the company’s digital transformation and expanding business capabilities using industry’s best practices and advanced technologies such as cloud, artificial intelligence and robotics process automation. We offer a collaborative environment where technology skills and innovation are valued in a global organization. We’re looking for top technical talent to join our team and deliver creative technology solutions that help us become an end-to-end, next-generation financial services company. Join us if you want to grow your technical skills, solve real problems and make your mark on our industry. What you will be responsible for As a Oracle Database Engineer and Performance Tuning Specialist you will Analyze, troubleshoot, and optimize complex SQL queries to improve database performance. Perform advanced SQL and PL/SQL code reviews and tuning activities Identify and resolve database bottlenecks, locking issues, deadlocks and performance degradation. Monitor database performance using Oracle tools such as AWR, ASH, ADDM and execution plans. Design, Develop, test and maintain complex SQL queries, stored procedures, packages, functions, triggers and views Develop scalable and efficient PL/SQL solutions adhering to coding standards and best practices Support database design, data modelling and schema optimization initiatives. Design, configure, implement, and support oracle GolenGate replication solutions. Monitor and troubleshoot replication processes, latency issues and data synchronization challenges. Ensure data integrity and consistency across source and target Provide production support for database-related incidents Conduct root cause analysis and implement preventive measures. Participate in on-call support and critical issue resolution when required. Collaborate with application teams and infrastructure teams.

These skills will help you succeed in this role Strong written and verbal communication skills. Strong partnership and relationship building skills. Exceptional organizational skills and attention to detail. Strong problem-solving ability Education & Preferred Qualifications Bachelor's degree in computer science or a related field. Expert Oracle Programming and DDL & DML knowledge Excellent knowledge on Oracle database objects (especially indexes, Partitioning and Views), database architecture and various components  Proven expertise in Oracle SQL Performance tuning and query Optimization Hands-on experience with Oracle Golden Gate implementation and support Strong experience in Oracle SQL and PL/SQL programming. Strong working knowledge of Exadata and Cloud environments. Experience in troubleshooting complex databases and application performance issues. Excellent analytical, problem-solving and communication skills. Additional requirements Knowledge of Azure and Snowflake services is a plus Knowledge in Financial domain is a plus Work Requirement Need to work in a hybrid work environment About State Street Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and