*Respond me at ke...@itecsus.com* * *
*Position - pl/sql developer* *Location - NJ, PA and DE * *Duration – 6-12 + months * Devon Consulting has an exciting opportunity for a contractor for a client that is located in Wilmington, DE. Devon Consulting has been offering top IT talent to direct clients located in NJ, PA and DE for the past 30 years! This is a 6-12 + mth contract. Responsible for: - Design and development of PL/SQL packages, functions or stored procedures to support the needs of application developers. - Analyzing and tuning PL/SQL packages, functions, stored procedures and add-hoc SQL through the use of explain plans, SQL trace, optimizer hints etc. - Assist in the design, modeling, development, and support of relational database in a team oriented environment. - Reviewing and make architectural recommendations on all physical design layouts of logical models - Maintaining version control of database objects and their integration with other application components - Proposing and implementing recommended physical object structures and their design, i.e. materialized views, indexes, partitioned tables, IOT, etc. - Reviewing, recommending and implementing appropriate statistical analysis for objects as needed, such as items relevant to histograms, ranges of data or frequency for CBO, outlined plans, etc. Collaborates with: - Vertical development team members in the development and tuning of packages and procedures. - Data modeling and development team to assist in the review of relational and non-relational database models and their physical generation. - Database administers and application support to communicate and coordinate production release plans. Working experience in Agile development environment · Extensive SQL DML, DDL, and UNIX scripting skills with experience of PL/SQL, stored procedure, packages · Ability to debug and troubleshoot Java applications with embedded SQL statements and DB function calls · Experience with SQL performance tuning and root cause analysis. · Experience using AnthillPro, Subversion or other software packages for version control and deployment build · In depth knowledge OLTP application development · knowledge of Oracle database, relational data modeling, and full life cycle database design and application development · Fundamental database administration concept including maintaining a large database, data cleansing, indexing and constraint strategies · Solid interpersonal skills · Ability to communicate clearly in written and verbal form · At least 5 years of experience in database and application development Graduate level and/or equivalent work experience preferred Thanks & Regards, *Kelly* ITECS *IT & EBusiness Consulting Services Inc.* Ph: 516.323.5681 | Fax: 347 602 9084/866 515 6599 *ke...@itecsus.com* | www.itecsus.com -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To post to this group, send email to sap-basis@googlegroups.com. To unsubscribe from this group, send email to sap-basis+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sap-basis?hl=en.