Hi Friends, Need help to fill below requirement in NYC.
1---DB2 DBA Database Consultant in NYC 2---Informatica Admin /Engineer in NYC JD - below __________________________________________________________________________________________ Location: NYC RATE: nego Duration: 6 months+ Position is for a senior database application DBA/Infrastructure architect on the OTCDB team. The team is tasked with producing business critical transactional database systems as well as large Data Warehouses/Data Marts to meet scalability, stability and performance requirements for Trade Capture and Lifecycle Management applications within Institutional Sales & Trading. Work will include designing, enhancing and developing databases across different database environments. The job will involve considering all aspects of the project life cycle and includes proof-of-concept evaluations, coding, designing, testing, implementing, deploying, and continued support of project releases as well as on-call Level 2 support. Collaboration with the Firm’s engineering teams is expected for storage/communication solutions. Major Roles & Responsibilities: Database Infrastructure Engineering for stability and scalability, capacity planning Application DBA functions: plan & execute database schema changes, bottlenecks analysis, outage prevention/resolution, server/database performance improvements, database maintenance, database recovery Database development (stored procedures, ETL, tools) and queries/stored procedures review and optimization Enforce database security, standards & guidelines Skills Required The candidate will have the ability to propose/review innovative solutions and implement them in production to achieve significant improvements. They will be an expert in performance optimization on server, database, query, data structures and data flow levels, with advanced database architecture knowledge and hands on expertise in OLTP and Data Warehouse design, Federated database systems. They will have excellent Database Administration skills including in depth knowledge of new and existing features to provide effective solutions for critical systems. They will act as a leader in outage resolutions and multi-team global turnovers. They will be the escalation point for major issues. Required Knowledge: At least 5 years experience in DB2 Linux relational database work, must have exceptional hands-on application DBA skills. DB2 Linux version 9 and above (SQL, Temp tables, plan explains, MQTs, MDCs, referential integrity constraints, etc) The candidate must be familiar Erwin or some similar modeling tool The candidate must be familiar with scripting language such as Perl and Unix / K-Shell . The candidate must have strong knowledge base of relational database performance and tuning such as: proper use of indices, database statistics/reorgs, de-normalization concepts, Personal skills: Integrity & ownership, good team player, ability to work under time and resource dependencies and constraints, ability to find simple and effective solutions, high degree of motivation to expand technical and business knowledge. Skills Desired Communications skills are important as the candidate will need to work with other internal/external developers who will be accessing the databases and have change requests. Knowledge of other relational databases, especially solid Sybase expertise is a plus Versioning tools such as perforce, etc.. is a nice to have Knowledge of the transactional database requirements of multiple financial asset classes would be a great benefit If you are Interested on above position please send me updated CV with all skills asking in the position with below details- Short Write up(why you think you are suitable for this position?) MUST send: Consultant Name- Cell- Email- Alternate no# Availability- Hourly Rate/Expected Salary: Best time to call : Relocation at own expenses Yes/No- Face to Face Interview at own cost Yes/no: Current location(City&State)- Visa Status(H1b,EAD,OPT EAD,Green Card, Us Citizens,TN VIsa or others): +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Job - 343, Lead ETL Engineer(Very Urgent) Client need informatica ETL admin or engineer for below position Employment Type: Contract City: nyc State: New York Description: Rate: billing on per day basis Duration: 6+ months NYC Job Details: This position is a hands-on, technical position with a leadership role. The ideal candidate will have a diverse background in data integration technologies, with a specialty in Informatica. The candidate will have a solid architectural background and a firm grasp on the various database architectures for OLTP, ODS and Data Warehouse databases. Additionally, the candidate will have experience working with application architects and engineers to optimize data access paths while at the same time maintaining solid structural integrity and performance for integrating with backend data stores. The candidate will also possess excellent communication and presentation skills that are required for socializing technical concepts and building consensus. RESPONSIBILITIES: Perform hands-on application integration data engineering tasks in the development of application integration solutions that involve complex, large-scale, (multi-terabyte size) data footprints leveraging ETL technologies Perform capacity planning activities as related to application usage of resources that include storage, CPU, memory and network utilization Optimize the ETL environments with respect to data access methods, access performance, storage, data integrity, system performance and system availability Work closely with developers to optimize for, and efficiently integrate application into the ETL environment Work closely with application developers to optimize data access and integrate the database platforms with application server environments Develop tooling to better automate the application integration tasks Liaise with the vendor and external support on issues such as upgrades, technical problems and solutions Provide technical support to developers in the development environment Document application integration standards for the ETL environments and processes Provide engineering support for Informatica Data Quality, Informatica Data Explorer, and Informatica Power Exchange Upgrade of existing Informatica plant v8.6 to v9.1 Skills Required Required Skills and Experience: 7+ years of solid Informatica administration and engineering 7+ years of solid relational database experience on MPP database systems Experience with clustering technologies for performance and availability Hands on experience with Informatica PowerCenter Enterprise Grid option on RedHat Linux platform; upgrade Informatica to v9.1 from 8.6; Informatica Data Quality, Informatica Data Explorer, and Informatica Power Exchange Experience in designing and configuring data solutions that scale in the terabyte range Performance tuning skills for large MPP and non-partitioned databases Understand RI concepts and real world trade-offs of the varying implementations SQL coding skills Understand dimensional data modeling, star and snowflake schema Good analytical ability, strong consultative and communication skills Ability to work in a team environment College degree in computer science/related fields or equivalent experience Required Management Skills Excellent verbal and written communication skills, as well as organizational skills Experience with project management software Ability to manage multiple high priority projects simultaneously Skills Desired DB2/UDB, Microsoft SQL Server and Teradata experience, knowledge of Informatica 9.x is a plus Skill Proficiency Advanced If you are Interested on above position please send me updated CV with all skills asking in the position with below details- Short Write up(why you think you are suitable for this position?) MUST send: Consultant Name- Cell- Email- Alternate no# Availability- Hourly Rate/Expected Salary: Best time to call : Relocation at own expenses Yes/No- Face to Face Interview at own cost Yes/no: Current location(City&State)- Visa Status(H1b,EAD,OPT EAD,Green Card, Us Citizens,TN VIsa or others): * Regards, Suman Bakshi Resource manager email- suman.bak...@harriersys.com Alter- sa...@harriersys.com Phone- 732-637-0815 Yahoo IM--sam.harriersys * -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. To unsubscribe from this group, send email to sap-or-oracle-financials+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sap-or-oracle-financials?hl=en.