*Please send the resumes to : [email protected]* *Title : PL/SQL Resource needed *
*Location : New York, NY Interview : F2F * *Overview*: This position requires a strong PL/SQL Development with an understanding of basic DBA activities. This resource will be responsible for the design, development, and implementation of database structure as well as the data manipulation. This encompasses various levels of reporting using complex queries and views, which need to execute at maximum performance. Database development work is done using Oracle PL/SQL on an Oracle 11g RDBMS. It will be necessary to maintain and enhance database structure, perform SQL programming/tuning, *Responsibilities* -Develop and maintain PL/SQL code, primarily as store procedures. -Read, write and test complex DML (insert, update, delete) -Read, write and test SQL*Plus , UNIX Shell scripts -Perform deployment and versioning of Oracle packages and objects -Prepare system design documents, use cases, test cases and other systems documentation -Communicate clearly both verbally and through documentation *Required Technical Skills * - 8+ years of PL/SQL development - 8+ years writing packages, procedures, functions and triggers - 8+ years creating tables with constraints that are indexed - 5+ years writing SQL*Plus and UNIX Shell scripts - Capable of understanding and writing ANSI and traditional Oracle inner and outer joins - Capable of working with and writing nested queries and subqueries - Capable of tuning high performance queries - Moderate knowledge of data modeling - Experience with TOAD or SQL Developer - Experience with ERWIN, Visio or other data modeling tools - Excellent documentation experience using appropriate tools - Excellent written, verbal , organizational and presentational skills - ETL Experience is a plus *Education * - Bachelors Degree in Computer Science or related discipline. - Oracle Certification is a plus. *Skill Matrix* Total years of IT Exp: (we are seeking minimum 8 years) Any Certifications, especially on Oracle Do you have Educational Degrees in Computer Science or related topics Years as Oracle Developer (PL/SQL) Years as Oracle Administrator (Basic Level) Exp working on Oracle 11G RDBMS Exp in SQL*Plus, UNIX Shell scripts Exp in maintain, enhance database structure, perform SQL programming/tuning Exp in system design documents, use cases, test cases and other systems documentation Exp in writing packages, procedures, functions and triggers Exp in creating tables with constraints that are indexed Exp in writing SQL*Plus and UNIX Shell scripts Exp in writing ANSI and traditional Oracle inner and outer joins Exp in writing nested queries and subqueries. Thanks and look forward to your prompt and positive response... *Sumanth Pittu* | Account Manager Office: 732 777 0800 ext. *504* Gtalk/ Yh: sumanth.p151 *BS**M* Learn More <http://bsm.us.com/> • Facebook<https://www.facebook.com/pages/BSM-Business-Success-Management/186763063930>• LinkedIn <http://www.linkedin.com/company/bsm-business-success-management>• Twitter <https://twitter.com/BSM_now> - 13 years in business with referable clients - Minority & Women Owned Business Enterprise - Microsoft Certified Partner - Oracle Certified Partner - SWaM – Small, Women and Minority Vendor for State of VA - APICS Corporate Member HQ: 2 Tower Center Blvd., 20th Floor, Suite # 2004 | East Brunswick, NJ – 08816 | United States Global: United States | Europe | MEA The information contained in this e-mail transmission is confidential and may be privileged. It is intended only for the addressee(s) stated above. If you are not an addressee, any use, dissemination, distribution, publication, or copying of the information contained in this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately notify us in reply *with the word "REMOVE" in the subject line*. We apologize for inconvenience, if any caused. -- You received this message because you are subscribed to the Google Groups "it req" 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/it-req. For more options, visit https://groups.google.com/groups/opt_out.
