Senior Oracle Database Engineer – Assistant Manager

State Street; Hyderabad; Hybrid; INR 1,700,000 - 2,600,000; Full time

Job summary

State Street in Hyderabad is seeking a Senior Oracle Database Developer / Oracle Performance Tuning Specialist with 10+ years of hands-on Oracle experience. You will optimize complex SQL/PLSQL, review code, and implement GoldenGate replication and Exadata optimizations to support our in-house ETL apps.

The role emphasizes data integrity, on-call support, and collaboration across application and infrastructure teams, with a hybrid work arrangement and opportunities to influence platform-wide

Qualifications

• Bachelor's degree in computer science or a related field.
• Expert Oracle Programming and DDL & DML knowledge
• Excellent knowledge on Oracle database objects (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.

Responsibilities

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

Skills

Oracle SQL Performance tuning

SQL

PL/SQL development

Oracle GoldenGate

Exadata

Education

Bachelor's degree in Computer Science or related field

Tools

Oracle GoldenGate

Job description

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

• 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

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