4337 Sr Oracle Developer

Location: Charlotte, NC, United States
Date Posted: 11-21-2017
Role - Sr Oracle Developer
Term - Fulltime permanent position

Required Skills

• Strong knowledge of Oracle database release 11 and higher. Exadata/12c knowledge is Plus.
• Knowledge of SQLPlus
• UNIX skills: work through command line and shell scripting
• Collaborate with developers, business analysts, and business users in conceptualizing and development of new technical objects
• Analyze and assess existing procedures to allow the application to respond to business changes.
• Evaluate requirements from functional specifications to create efficient technical design.
• Develop complex technical objects in accordance with the technical development standards and best practices.

Should be expert on  most of the below Oracle concepts
• Strong understanding of SQL objects like View, Materialized Views, Roles, Synonyms, grants, Access controls
• Aggregate & Analytical functions and working experience with them.
• ETL Merge options and must have used in earlier projects.
• DW – Dimension Models, Slowly Changing Dimension
• SQL Data loading option different ways of doing, Multiple tools used for same 
• Global Temporary Tables and scope management.
• Performance tunings ,Query tuning/Procedural tuning, Explain plans, etc.
• Job scheduling – AutoSys, DBMS Scheduler, JAMS etc.,
• Oracle Exception Handling
• Differences between Oracle versions and  solve issues during migration
• PL/SQL basics like Cursors, Types etc.,
• Exception / Error / Audit Logging
• PRAGMA – Autonomous, Exception Unit etcs
• CTE – Common table expression

If you bring willingness, flexibility and a desire to impress please apply now.
Technical Recruiter: Sajita Sreerangam
Phone: 4087574337
Companies across U.S. have engaged ReqRoute, Inc to deliver skilled, dedicated IT professionals. Recruiting is our passion and we support Fortune 1000 companies with their hiring needs. We always seek to deliver competitive and sought-after career opportunities to our potential consultants and employees. We invite you to review the position requirements and apply today if your skills match our needs.  
ReqRoute, Inc is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law. (www.reqroute.com)
this job portal is powered by CATS