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.
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 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 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
