*Please respond to [email protected]* * *
*Required Oracle Developer* *Location: New York, NY* *Duration: 6-12 Months* *Need only GC's or Citizen's* *SCOPE OF SERVICES:* • This programmer is to perform database development work with Oracle 11 g RDBMS, Oracle PL/SQL, Oracle Reports lOg, OBIEE. • Prepares and implements database structure including but not limited to tables, indexes and storage structure. • Works with the business analysts and programmer to design and implement database specifications. • Creates and maintains physical design document • Analyzes and optimizes application performance. • Assists with application support documentation • Assists Programmer with ETL (Extraction Transformation and Load) processes, as well as unit, integration testing • Plans backup and recovery • Performs database audit when required • Applies data normalization rules in data modeling. • Develops and modifies database procedures and functions for application business logic. • Develops and modifies data loading and data comparison scripts • Designs, implements, and documents database specifications. • Creates logical data model diagrams such as entity-relationship diagrams and physical data model diagrams using data modeling tool. • Creates and populates the data dictionary by documenting data elements and their attributes. • Prepares scripts for database creation from physical data model. • Plans and creates elements for physical database objects including but not limited to tables, indexes,storage structure and constraints. • Analyzes the user requirements and prepares the data security implementation plan. • Prepares the data conversion plans and executes the data conversions. • Monitors database performance. Analyzes and optimizes application performance and tuning plan to execute it. • Performs unit and integration testing. • Uses and manages the version control of application code by using PVCS version manager software. MANDATORY SKILLS/EXPERIENCE: • 5+ years experience- Oracle PL/SQL, Oracle 1 Ig RDBMS, TOAD, OBIEE publisher, ERWIN/ER Studio, Unix Shell Scripting. Knowledge of Windows XP/7. • Create database logical and physical design, perform SQL programming/tuning. *DESIRABLE SKILLS/EXPERIENCE:* • Oracle JDeveloper, Oracle Application Server, Java, J2EE, HTML, DHTML, PVCS version manager software, Oracle Reports. Best Regards *Chandrakant* -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sap-abap?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
