PL SQL Tech Lead @ Orcapod

POSITION GENERAL DUTIES AND TASKS: -
Exp - 5 + Yrs
Location - Bangalore - Work from Office
- About 5+ years of Core PL/SQL development/support experience.
- Must have several years of working experience with relational databases (Oracle) and must have experience writing stored procedures and functions.
- Must have experience in Writing, modifying Oracle PL/SQL stored procedures.
- Excellent communication skills.
- Develops new programs and enhances existing programs to support various team initiatives.
- Contributes to technical documentation and follows standard version control procedures.
- Works effectively with various technologies.
- Good to have Java exp / working in Java projects
- Build utilities/ tools to onboard new client
PAS2
- Materialized Views, Partitioning tables, DB Links
- Autosys, Control-M, Cron-tab
- SQL loader, performance tuning utilities like Explain plan
- Added advantage to have knowledge of any scripting languages like Shell Script, Perl Script
- Execute queries in the Dev / Integration Test / Prod environments
- Has to work within the client's ODC and adhering to the client's InfoSec policy
-