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 activitiesIdentify 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 viewsDevelop scalable and efficient PL/SQL solutions adhering to coding standards and best practicesSupport 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 targetProvide production support for database-related incidentsConduct 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.

What We Value

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 knowledgeExcellent knowledge on Oracle database objects (especially indexes, Partitioning and Views), database architecture and various components Proven expertise in Oracle SQL Performance tuning and query OptimizationHands-on experience with Oracle Golden Gate implementation and supportStrong 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 plusKnowledge 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 profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success.

We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future.

As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law.

Discover more information on jobs at StateStreet.com/careers

Read our CEO Statement

Job ID: R-790195