Job Description :
Hello,
We have an urgent opening of Oracle PL SQL Position and I have sent you job description, please go through it and let me know your comfort with it and also send me your updated resume ASAP with following details
Full name:
Current location:
Visa Status:
Total experience in years:
Relevant experience in mentioned skills:
Relocation:
Currently on project:
Availability for joining
Availability for Interview:
Skype ID:
SSN (last 4 digits):
DOB(mm/dd/YYYYY):
LinkedIn Link:
Start date : ASAP
Duration : Full time
Role : Oracle PL SQL
Location : NYC, NY
Interview : telephonic/Skype
Job description:
· Create Physical data models using industry standard tools, e.g. ER/Studio
· Code packages, functions, stored procedures, views in Oracle PL/SQL
· Performance/Tuning of Oracle SQL
· Physical architecture of database tables, partitions, load balancing, parallel queries, etc.
· Code Review of stored procedures and scripts written by other team members
Person Requirements
Experience:
· Solid understanding of Oracle 10/11g from a Development perspective
· Solid understanding of Data Warehouse and Data Mart concepts with proven experience in both
· Expertise in SQL and PL SQL
· Strong Oracle performance tuning experience preferably in the data warehouse space
· Strong Data modeling background with emphasis on Physical modeling
· Star schema
· Physical architecture (partitioning, cluster)
· Working with large databases - multi terabytes
· Unix /Linux command line interface and shell / perl scripting
· Data Modeling skills using standard tools: ER/Studio, ERWin, Enterprise Architect
· Interpretation and understanding of functional specifications
· Writing technical design documents, adhering to firm standards
· Source code control tools such as Perforce