דרושים sql

Database Developer:

A large retail company in the luxury goods industry with about 150 locations across the US, Caribbean and Mexico is looking for a Database Developer who will be responsible for the collection, analysis and communication of data and associated functional requirements and producing the reporting needs of the client. Duties will include the design, development, and maintenance of the data, stored procedures, functions, cubes and reports and to support business requirements.

Requirements:
• Experience with database MS SQL or SAP BI required.
• At least 2 years of experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments.
• Strong analytical skills in determining and defining reporting needs.
• Experience in designing and working on writing cubes
• Extensively involved in generating multi-dimensional cubes and reports using OLAP services.
• Skills in CUBE design and development using SSAS.
• Knowledge of ETL Integration with solid dimensional modeling skills to assist in the design and development of new data structures to support advanced analytics
• Knowledge and experiences in developing and deploying SSAS and performance management solutions and assisting in developing a BI architecture and components for all BI, reporting and dashboard technologies
• Work closely with business analysts and executive leadership to assist in solutions analysis, prototyping and testing of reports
• Develop, test and maintain defined reports and ad-hoc queries
• Provide technical assistance by responding to inquiries from client regarding issues and/or questions about reports
• Create and maintain technical documentation
• Lead and document the results of data, business processes, and other research in formal and informal reports for review

Database Developer:

A large retail company in the luxury goods industry with about 150 locations across the US, Caribbean and Mexico is looking for a Database Developer who will be responsible for the collection, analysis and communication of data and associated functional requirements and producing the reporting needs of the client. Duties will include the design, development, and maintenance of the data, stored procedures, functions, cubes and reports and to support business requirements.

Requirements:
• Experience with database MS SQL or SAP BI required.
• At least 2 years of experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments.
• Strong analytical skills in determining and defining reporting needs.
• Experience in designing and working on writing cubes
• Extensively involved in generating multi-dimensional cubes and reports using OLAP services.
• Skills in CUBE design and development using SSAS.
• Knowledge of ETL Integration with solid dimensional modeling skills to assist in the design and development of new data structures to support advanced analytics
• Knowledge and experiences in developing and deploying SSAS and performance management solutions and assisting in developing a BI architecture and components for all BI, reporting and dashboard technologies
• Work closely with business analysts and executive leadership to assist in solutions analysis, prototyping and testing of reports
• Develop, test and maintain defined reports and ad-hoc queries
• Provide technical assistance by responding to inquiries from client regarding issues and/or questions about reports
• Create and maintain technical documentation
• Lead and document the results of data, business processes, and other research in formal and informal reports for review

To join the development team as a leading developer for web technologies and specialist of web analytics and optimization tools.

Responsible for implementing and enhancing a robust global web analytics system for all A/B testing tools etc.

To work closely with other members of the team and the Business to ensure any developments are fully integrated with other systems across the Business.

To be involved in project design, developments and integration.

• Minimum 5 years of industry experience in building mid to large scale web application.
• Experience with web analytics implementation, strong knowledge of systems like Google Analytics, Unica, Omniture, Piwik etc.
• Expert of JavaScript and Ajax technologies.
• Good knowledge of XHTML, CSS by WC3 standards.
• Experience working in Linux/Unix environments.
• Experience of SQL and working with data base (at least 2 years)
• OO programming experience in major language like PHP, Java, C# etc.
• Experience with CMS systems.
• Experience with source/version control software as SVN.
• Excellent levels of communication. Both written and verbal, with team members and customers, a team player.
• High level of English, verbal and written.
• Delivery focused, able to plan and execute projects according to strict timelines, organized.
• Enthusiasm, innovative and creative thinking.

Advantages:
• PHP programming.
• Implementing marketing conversion goals / funnels.
• Experience working in the online marketing arena
• BI experience and working with Big Data
• Working with cloud infrastructure

TEAM VISION: Being a team of professionals to provide our clients with high quality products

REPORTING TO: QA manager

THE ROLE:
• Review design/requirements and understand business process
• Understanding of data warehouse design and methodologies.
• Proficient with SQL language and be able to demonstrate intermediate to advanced query writing skills.
• Create Test Plans and Test Strategy documents
• Set up or modify test input data if necessary.
• Verify and document test results utilizing testing tools and utilities.
Experience in using configuration management tools, defect tracking tools, debugging tools, and testing tools
Experience in maintaining Virtual Machine testing environments

2 years experience in QA in general and specifically in:
• DWH/BI.
• Client/Server testing
• Automatic testing tools
• High level of English both verbal and written.
• Experience writing QA documentation and methodologies.
• Well organized and pay attention to details.
• Passion for quality assurance of end-user applications.
• Experience diagnosing, reporting, tracking and resolving quality issues.
• Ability to communicate clearly in writing, by phone, and in person .
• High productivity.
• Willingness and ability to create and adapt to new technologies .
• Ability to launch new projects and follow through to completion.
• Proven ability to work independently and pro-actively with sense of business and technical motivation
Advantages :
• Knowledge in JavaScript, Html, PHP
• Experience in the gaming arena
• Knowledge in TestPartner.

• Manage and design Cloud Storage solution utilizing NetApp Storage
• Deploy and operate large scale cloud infrastructure and application services in our own data centers
• Operational support of virtualized Linux environment comprised of more than 300 physical servers in multiple datacenter worldwide
• Work with our Engineers and Systems Architects on infrastructure projects
• A team member who is all about working with the latest and greatest technologies
• Participate in on-call rotation to support 24x7 coverage of our services

Residency in Jerusalem – an advantage

Relevant education:
• B.S./B.A./M.S. degree or equivalent technical training

• A minimum of 3-5 years of proven NetApp Administration experience with virtualization (KVM or Vserver preferable)
• A minimum of 1-2 years of Unix/Linux Administration experience
• Experience with designing and deploying virtualized infrastructures such as KVM, Vservers
• In depth knowledge of NetApp hardware and configuration
• In depth knowledge of NetApp technologies such as Snapmirror, Snaplock, Snapvault, Flexclone, OSSV a plus
• In depth knowledge of NetApp cluster technology for iSCSI and FC a plus
• Experience with EMC, an advantage
• Must have excellent communication skills
• Must be a team player and able and willing to roll up sleeves
• High level of English, mostly for reading and writing
• Ability to work with heavy reliance on open-source software
• Understanding of modern IT production datacenter and Internet (ISP/ASP) hosting operations
• Demonstrable experience in configuring, troubleshooting, and administering Storage and IT networking solutions
• Knowledge of web development (SOAP, REST) – an advantage
• Knowledge of databases (MySQL, Oracle) – an advantage
• Familiarity with systems management concepts, processes and standards (e.g. SNMP); capacity/performance management and tuning – an advantage
• Knowledge of lightweight configuration and management technologies such as Chef and Puppet – an advantage
• Knowledge of web development (SOAP, REST) – an advantage

Develop, manage and support the multiple collocation infrastructures in which our Linux-based application servers operate
Design & build tools to automate critical but repetitive processes in daily production operations
Design, develop and deploy tools to automate the monitoring & alerting of new systems and applications
Design, develop and deploy a graphing and trending solution for systems and applications
Assisting with support of Oracle DB environments
Contribute to the development of automated application server deployments, updates, maintenance and administration processes
Create and maintain Linux Shell and Perl scripts
Monitor system activity, performance, and growth
Support, trouble-shoot & monitor our 24x7x365 production environment
Ability to participate in on-call rotation

Relevant education:
BA/BSc or equivalent desirable
Required professional experience:
At least 5 years proven in-depth experience in Linux systems administration
Proven, in-depth UNIX scripting abilities – especially Perl and BASH
Excellent knowledge of TCP/IP, DNS, DHCP, NAT, Subnetting, etc.
Knowledge of Oracle and MySQL highly desirable
Experience with NetApp storage environment a plus
Knowledge of Automation tools – Chef / Puppet a big advantage
Experience with Apache, JBOSS, Lucene desirable
Knowledge of Nagios monitoring/alerting and Zabbix graphing/trending apps a big plus

Required Languages
English at a very high level preferably mother tongue - spoken and written

Required skills/characteristics:
Broad, systematic prospective and ability to characterize complex solutions
Must have excellent troubleshooting skills and be able to support a high availability production environment
Excellent interpersonal and communication skills, both face-to-face and on the phone
Fast learner, attention to detail, good team player
Initiative and responsible
Ability to work in a team
Ability to work independently and under pressure
Self-learning abilities
Curiosity
Detail oriented
Be innovative and creative!