Direct Client Rek : (Job) Oracle DB2 DBA in Woodcliff Lake, NJ
*Hello,* * * *Kindly reply to this email id **alle...@hmny.com* * * *Role : Oracle DB2 DBA* *Location : Woodcliff Lake, NJ* *Duration : 6 Months * *Responsibilities *• General database design/reuse • 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 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 Trace files • Perform SQL reviews using tracing • Promote objects/changes to production • Monitor/Trace to support load testing • Monitor production databases and resolve performance issues • Maintain Database utility jobs (Export/Image Copy, Statistics/Runstats, Index Rebuilds etc...) • Provide after hours on call support as needed • Develop Unix/Linux shell scripts as required for DB related activities • Experience with setting up jobs using JCL under TSO/ISPF • Experience with Oracle SQL*Net client software • Experience with DB2 Connect client software and Stored Procedure Builder • Document standards and procedures as required * * *SKILLS Required Skills : *• 8+ years Oracle and DB2 Database Administration including Data Design, Object Maintenance, and Performance Tuning running on Linux and Mainframe z/OS platforms • 8+ years Data Warehousing experience • 6+ years Unix/Linux shell scripting experience. • 6+ years Mainframe z/OS 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* Preferred Skills : *• Automotive industry experience. • PERL coding experience • COBOL coding experience *Please fill in the below details for correct submission to the client:* *Candidate Details* *Mandatory* Full Name: Phone1: Phone2: Email: Authorization(*visa status): * Rates: *(Hourly)* Availability for telephonic/Skype Interview: Skype ID/ Video call ID: Current Location: Ready to work or relocate to *Woodcliff Lake, NJ* - *(Yes/No) * The interview process would take at least a week's time, will you be fine with this - *(Yes/NO) * How soon can you start a project? - Why are you looking for Job change: End Date of your current/ recent project: Do you have any prior plans or commitments which might stop you from taking this position, *if yes, pl share: * Also, be aware that our client conducts a criminal background check/ Test for drug of abuse on candidates who are extended offers of employment. Therefore, before we proceed with your candidacy regarding this project opportunity, please advise us now if you have any felonies or misdemeanors. *if yes, pl share:* Regards, Allen Technical Recruiter Email : alle...@hmny.com I Phone : 518 620 6850 Helios and Matheson Information Technology Inc,. www.hmny.com * * *The cardiologists diet - If it tastes good, spit it out.* * * -- You received this message because you are subscribed to the Google Groups only.SAP group. To post to this group, send email to onlysap@googlegroups.com. To unsubscribe from this group, send email to onlysap+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/onlysap?hl=en.
Direct Client Rek : (Job) Oracle DB2 DBA in Woodcliff Lake, NJ
*Hello,* * * *Kindly reply to this email id **alle...@hmny.com* * * *Role : Oracle DB2 DBA* *Location : Woodcliff Lake, NJ* *Duration : 6 Months* *Responsibilities *• General database design/reuse • 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 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 Trace files • Perform SQL reviews using tracing • Promote objects/changes to production • Monitor/Trace to support load testing • Monitor production databases and resolve performance issues • Maintain Database utility jobs (Export/Image Copy, Statistics/Runstats, Index Rebuilds etc...) • Provide after hours on call support as needed • Develop Unix/Linux shell scripts as required for DB related activities • Experience with setting up jobs using JCL under TSO/ISPF • Experience with Oracle SQL*Net client software • Experience with DB2 Connect client software and Stored Procedure Builder • Document standards and procedures as required * * *SKILLS Required Skills : *• 8+ years Oracle and DB2 Database Administration including Data Design, Object Maintenance, and Performance Tuning running on Linux and Mainframe z/OS platforms • 8+ years Data Warehousing experience • 6+ years Unix/Linux shell scripting experience. • 6+ years Mainframe z/OS 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* Preferred Skills : *• Automotive industry experience. • PERL coding experience • COBOL coding experience *Please fill in the below details for correct submission to the client:* *Candidate Details* *Mandatory* Full Name: Phone1: Phone2: Email: Authorization(*visa status): * Rates: *(Hourly)* Availability for telephonic/Skype Interview: Skype ID/ Video call ID: Current Location: Ready to work or relocate to *Woodcliff Lake, NJ* - *(Yes/No) * The interview process would take at least a week's time, will you be fine with this - *(Yes/NO) * How soon can you start a project? - Why are you looking for Job change: End Date of your current/ recent project: Do you have any prior plans or commitments which might stop you from taking this position, *if yes, pl share: * Also, be aware that our client conducts a criminal background check/ Test for drug of abuse on candidates who are extended offers of employment. Therefore, before we proceed with your candidacy regarding this project opportunity, please advise us now if you have any felonies or misdemeanors. *if yes, pl share:* Regards, Allen Technical Recruiter Email : alle...@hmny.com I Phone : 518 620 6850 Helios and Matheson Information Technology Inc,. www.hmny.com * * *The cardiologists diet - If it tastes good, spit it out.* -- You received this message because you are subscribed to the Google Groups only.SAP group. To post to this group, send email to onlysap@googlegroups.com. To unsubscribe from this group, send email to onlysap+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/onlysap?hl=en.
