*Must have strong Unix/Linux and shell Scripting exp, face to face required*
Location is Woodcliff Lake, NJ (northern NJ) 6+ month contract Provide Oracle DBA support for all projects, problems and incidents. Assist developers with data design, object creation, performance tuning, data movement, SQL reviews etc... Required Skills *•*8+ years Oracle Database Administration including Data Design, Object Maintenance, and Performance Tuning running on a Linux platform •8+ years *Data Warehousing experience* •6+ years *Unix/Linux shell scripting experience*. •8+ years coding *SQL, PL/SQL, Procedures/Functions, Triggers and Packages*. •Excellent design concepts for Dimensional Data modeling, Star Schema/Snowflake schema, Fact and Dimension tables •Excellent written and verbal communication skills Responsibilities •General database design •Create Logical/Physical Data Models as required •Create/Maintain database objects (Tables, Indexes, Views, Triggers, Procedures etc...) •Assist developers with the development of Stored Procedures/Packages •Research and exploit new database features •General performance tuning (SQL, PL/SQL Procedures/Functions, Triggers). •Performance optimization using materialized views, indexing, updating statistics, using hints/profiles and rewriting SQL as required. •Interpret access paths using Oracle explain plan and tune accordingly •Assist developers with general process design •Migrate objects/changes throughout the development environments •Refresh data to support testing efforts as needed •Ability to create, read and interpret Oracle Trace files •Perform SQL reviews using Oracle tracing •Promote objects/changes to production •Monitor/Trace to support load testing •Monitor production databases and resolve performance issues •Maintain Database utility jobs (Exports, Statistics, Index Rebuilds etc...) •Provide after hours on call support as needed •Develop Unix/Linux shell scripts as required for DB related activities •Document standards and procedures as required Preferred Skills •Automotive industry experience. •PERL coding experience •Mainframe experience (TSO, ISPF, JCL) Kind Regards *Fazal Mahmood* *Aspire Systems Inc.* *Certified Minority Owned Business Enterprise (MBE) * *E-Verified Approved Employer* *Four Time Award Winner ( 2009 & 2010 & 2011 & 2012) Best of Danbury Award* *Approved Inc. 500 Company* *Corp Office: * *36 Mill Plain Road, **Suite # 16, Danbury, CT 06811* *Ph : 732 414 2854* *Fax : 203 798 0060* *Email: **fa...@aspiresystem.com <a...@aspiresystem.com>* *Yahoo IM*:* fazalmrecruiter* *URL: **www.aspiresystem.com <http://mail.aspiresystem.com/exchweb/bin/redir.asp?URL=http://mail.aspiresystem.com/exchweb/bin/redir.asp?URL=http://www.aspiresystem.com>* [image: Signature_Asp] -- You received this message because you are subscribed to the Google Groups "java-core" group. To unsubscribe from this group and stop receiving emails from it, send an email to java-core+unsubscr...@googlegroups.com. To post to this group, send an email to java-core@googlegroups.com. Visit this group at http://groups.google.com/group/java-core. For more options, visit https://groups.google.com/d/optout.
