Job Description

Req ID: 163275

NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.

We are currently seeking a PL SQL Developer to join our team in Noida, Uttar Pradesh (IN-UP), India (IN).

• 5+ years of DB technologies especially Oracle 12c/19c
• Proficient in Oracle SQL, PL/SQL, SQL PLUS, TOAD and SQL LOADER.
• Data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction.
• Effectively made use of Table Functions, Indexes, Collections, Analytical functions, Materialized Views.
• Created Tables, Views, Constraints, Indexes and Experience in SQL Performance Tuning
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables and expertise in Collections and Exception handling.
• Good hands on Shell scripting
• Experience on Tivoli or other scheduling tools.
• Liaise with developers to improve applications and establish best practices.
• Experience in working with Agile Scrum development teams, Agile Scrum principles and Agile delivery management tooling such as Atlassian JIRA

can include below requirements in addition to our regular DB resource JD:

• Oracle Golden Gate 19c
• Migration using Oracle Golden Gate
• 4+ years of Oracle Golden Gate hands-on experience in setting multiple servers data flow and Migration project experience
• Evaluating overall performance of Oracle database & Golden Gate and providing recommendations for improving/tuning
• Guidelines for migration of existing replication program (Oracle Golden Gate) to latest stable version.
• Knowledge in DB and Golden Gate performance tuning concepts.

About NTT DATA Services

NTT DATA Services is a global business and IT services provider specializing in digital, cloud and automation across a comprehensive portfolio of consulting, applications, infrastructure and business process services. We are part of the NTT family of companies, a partner to 85 % of the Fortune 100.

NTT DATA Services is an equal opportunity employer and considers all applicants without regarding to race, color, religion, citizenship, national origin, ancestry, age, sex, sexual orientation, gender identity, genetic information, physical or mental disability, veteran or marital status, or any other characteristic protected by law. We are committed to creating a diverse and inclusive environment for all employees. If you need assistance or an accommodation due to a disability, please inform your recruiter so that we may connect you with the appropriate team.

Job Segment:
Database, SQL, Oracle, Consulting, Information Technology, Technology