Oracle Developer / DBA,
Bangalore

Project Description

---

The engagement is for Large International Investment Bank, Fixed Income & Currencies line of business. There is a list of application that is in use for many years. According to banks policies, the applications should be recertified on regular basis from perspective of Enterprise IT Governance, method and tools, asset and configuration management, information security, etc. In particular, it should be complaint against Target Roadmap Compliance report. Current infra setup doesn't allow to get "green" TRC report. Main aim of the person on this position is to apply all required fixes related to databases setup and perform data migrations from legacy databases to new ones. Develop PL/SQL code if necessary.

Responsibilities

---

o Data migration from old database to new one
o Database copy as part of environment preparation
o PL/SQL Development

Skills

---

Must have

Must Have -
• Oracle
• PL/SQL
• RHEL
• Basic & Advanced SQL concepts SPs, Functions, Triggers, Indexes, Constraints, Joins (All types), Unions, Sub-queries
• Ability to write & migrate SQL objects/Stored Procedures
• Performance tuning knowledge, ability to investigate issues through query plans etc
• Migration experience between Oracle versions

Preferable:
• Preferably having Oracle 11 to 12 migration experience
• Transaction management knowledge
• Understanding of oracle dynamic performance views ( v$lock, v$session, v$process).
• Concept of basic Oracle layers-{Database/Segment/Tablespace/Data block}
• Postgres

Nice to have

·       Experience in projects for banking domain

Languages

---

English: B1 Intermediate

Seniority

---

Regular

Relocation package

---

If needed, we can help you with relocation process. Click here for more information.