A new Job, ID: 105777 <http://www.ejobsville.com/display-job/105777> was added at eJobsVille.com - For the Best Tech Jobs in Town<http://www.ejobsville.com>
Title: PL/SQL DEVELOPER posted on 2014-02-04 14:02:40 Job Description:*Hi, * We are looking for* PL/SQL Developer* for one of my client in *MD* kindly go through the below job opening and let me know your interest. Please send resume in word format along with pay rate details. *Job Title: PL/SQL Developer* *Location: Bedminster,NJ* *Length: 6 Months Contract * *Client : Travelers* *Environment* - *Oracle 10g/11g, PL/SQL, TOAD, Alteryx,* J*ava 6, UNIX* Ø Created Logical / Physical data models for new requirements after discussions with technical team and application users. Ø *Created and maintained Database* Objects (Tables, Views, Indexes, Sequences, Database triggers, stored procedures etc). Ø Used PARTITIONS heavily to improve performance and for easy archiving. Ø Exclusive Oracle tuning (indexing, materialized views, Analyzing, Stat collection, Bulk binding, Hints, Implicit cursors, Bulk Insert/Update/Delete etc) was done to decrease load on remote DBs and enhance execution speed of the algorithms. Ø Maintained database objects for development, training (UAT) and production databases. Ø Made changes in existing *PL/SQL* functions, procedures, and packages and also wrote new code to suit new requirements. Ø Used metadata model based-concept of SDO Ø Used Oracle Analytic Functions to assist complex data mining operations. Ø Wrote ad hoc SQL queries to assist in JAVA coding according to application requirements. Ø Worked with *Geo Spatial package* in Oracle for one of the location module. Ø Wrote complex SQL queries using joins, sub queries and correlated sub queries. Ø Used V$ views, *TKPROF, Explain Plans, Managing Optimizer Statistics to assess and find solutions to performance related issues.* Ø Developed numerous programs using PL/SQL and many packages to do the validations as per requirements. Ø Analyzed all of the data by performing advanced analytics using Alteryx and converted Alteryx Modules to PL/SQL. Ø Wrote complex SQL queries using joins, sub queries and correlated sub queries. Ø Dealt with heavy weight tables which are appended with millions of records daily. Ø Moved / manipulated data from one environment to another for development, testing and debugging of application. Ø *Scripting in UNIX* for developing jobs that would be run nightly to get latest data from flat files, remote databases. Ø Involved in *Data Loading and Data Migration (ETL). Used SQL*Loader* to load data from flat files and Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables. Ø Developed Java modules to interact with Stored Procedures using hibernate and spring. Salary: Open Click here to view full job description and apply<http://www.ejobsville.com/display-job/105777> (Guest users can also apply) ------------------------------ Best regards, eJobsVille.com - For The Best Tech Jobs In Town -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/groups/opt_out.
