Showing posts with label pl/sql. Show all posts
Showing posts with label pl/sql. Show all posts

Thursday, October 11, 2007

Software Engineer at MLB

MLB Advanced Media, L.P. (MLBAM) is the interactive media and Internet Company of Major League Baseball. MLBAM manages the official league site, MLB.com, and the 30 individual club sites to create the most comprehensive Major League Baseball resource on the Internet. MLBAM is seeking a Software Engineer, Fantasy Games and Stats for an immediate opening.

Requirements
  • Have experience creating highly trafficked, dynamic web sites using Java technologies with an Oracle backend in a fast paced environment
  • Be able to create and tune SQL queries, including an understanding of how to extract and interpret an Oracle explain plan
  • Be willing to take ownership over existing products as well as assist in scoping and design of new products
  • Be willing to interface directly with customers for the purposes of uncovering bugs and constructing desired feature lists
  • Able to effectively communicate requirements in a collaborative development environment and describe processes and issues to other team members, both written and verbally

Desirable:
  • Have experience using Oracle PL/SQL in a production environment
  • Have an understanding of JSP markup
  • Understand the sport of baseball, including the significance of often-used statistical categories and the general rules of the game
  • Familiarity with fantasy games, specifically fantasy baseball, and understand the mindset of people who play them
  • Have experience with AJAX applications or have a strong understanding of how AJAX technology is used
Link

Oracle Developer/ Data Modeler at MLB

Responsibilities / Qualifications
  • Strong in Oracle 9i/10g SQL & PL/SQL.
  • Strong data modeling skills with ability to translate business requirements into logical and physical design.
  • Experience in handling large volume of data both in Warehouse and OLTP Environments.
  • Experience in creating and maintaining schema objects such as tables, procedures & functions and good understandings of inter schema relationships within oracle.
  • Must have worked on Oracle in Solaris platform and experience in Unix Shell Scripting.
  • Minimum 3-4 Yrs of experience in Core PL/SQL Development.
  • Good verbal and written communication skills.
  • Experience in ERWIN or similar Data modeling tool.
Link

Oracle 10gAS Developer at MLB

Responsibilities / Qualifications
  • Strong in Oracle 9i/10g SQL & PL/SQL.
  • Strong in Forms/Reports development and deployment.
  • Experience in creating and managing Discoverer workbooks.
  • Strong in Portal development and deployment with experience in incorporating Discoverer reports in Portal.
  • Must have worked on Oracle in Solaris/Unix platform.
  • Strong verbal and written communication is a must.
  • At least 3 years experience in development of Forms, Reports, Discoverer, Portal and deployment in 9iAS/10gAS Environment.
  • Experience on Other Reporting tools is a Plus.
Link

Sunday, October 7, 2007

Classic ASP Developer at TEKsystems

Location: Mississauga, Ontario

Job Description:
One of TEKsystems clients, a major multinational Pharmaceutical company located in Mississauga, has an immediate need for a Classic ASP/.NET Developer to join their team for a three month opportunity.

Skills:
  • Classic ASP
  • .NET development (C#, VB.NET in both .NET 1.1 and 2.0 Frameworks for potential extension)
  • Oracle 9i
  • most logic is in the front end, but needs to be able to set up tables, maintain tables, set up triggers and stored procedures
  • PL/SQL
  • Javascript
  • Intranet application experience preferred
  • Exposure to JD Edwards is an asset
  • Must have worked in a team environment (team of 10)
  • Must be able to code independently as part of that team
  • Great communication skills – no comprehension issues allowed as compliance is a major issue
  • Quick to learn internal processes
  • MCSD or MCAD is an asset
Link

Friday, October 5, 2007

Senior ETL Developer at Stamford Consultants AG

Location: Geneva

Description:
Stamford Consultants AG is a dynamic company specifically created to offer a fresh approach to recruitment. With over 20 years experience in recruiting personnel, we specialise in sourcing high quality technical and business professionals to fulfill demanding and critical business roles.We are currently looking for a Senior ETL Developer to join a team of developers working on a global project for out customer, an international bank based in Geneva.

Role & responsibilities:
  • Analyzing source systems and creating mappings to the target database schema
  • Optimizing ETL performance
  • Identifying and managing data quality issues
  • Prepare key project documents and technical specifications
  • Provide mentoring to other developers
  • Working with project teams to plan, design, develop, test, and implement solutions and/or enhancements to existing systems to meet current and future needs
  • Collaborate with other teams involved in the ETL projects, such as Business Systems Analysts, architects, DBAs and testers.
Requirements:
  • In depth experience with data analysis, modeling and design specific to a data warehouse / Business Intelligence environment
  • Experience with the design of large scale ETL solutions integrating multiple source systems
  • Good understanding of overall data warehouse design principles and best practices
  • Experience as ETL developer using ETL tools such as Informatica / PowerCenter
  • Proven experience with Oracle PL/SQL and/or Sybase/TransactSQL
  • Ability to communicate design solutions to both technical and nontechnical audiences
  • Must be able to work independently and provide coaching and direction to junior staff
  • Excellent communication and analytical skills required
  • Ability to communicate with people in different sites in written and oral English
  • Demonstrated experience working successfully on project teams
Nice to have:
  • DBA expertise
  • Experience with ESB architecture and technology platforms (e.g. Tibco)
  • Understanding of SOA and Information Architecture concepts
  • Leadership and project management
  • Expertise in the field of financial / banking systems
  • Good UNIX fundamental skills and experience
  • Experience with one or more "best of breed" BI tools, e.g. Cognos, Hyperion
Languages:
English, French is a plus

Link

Sunday, September 30, 2007

Software Development Engineer - Datawarehousing at Amazon

Place : India
Software Development Engineer - Datawarehousing should be able to:
  • Design and build reliable, scalable and high performing enterprise systems.
  • Possess sound understanding in data modelling, implementation details in a target database (Oracle - SQL & PL/SQL) & its features for data warehousing.
  • Bring 3-8 years of software engineering and product delivery experience, with strong background in high performance distributed systems.
  • Good knowledge of data warehousing & ETL processes.
  • Good knowledge of Oracle Database internals - to develop high performance code.
  • Unix shell scripting with perl, python or other scripting languages.
  • Knowledge of other databases like MySQL is a plus.
  • Knowledge of BI tools for ETL or reporting is a plus.
  • Knowledge of java is a plus.

Required : B.E/B.Tech/M.E/M.Tech degree in computer science is required.

Saturday, September 22, 2007

Senior Database Engineer at Snocap, Inc

Country: United States

Responsibilities:
  • Analyze, define, and document requirements for data, workflow, logical processes, hardware and operating system environments as well as interfaces with other systems, internal and external checks and controls, and outputs
  • Develop and maintain project plans outlining steps and time tables for database development initiatives
  • Perform data modeling and database design
  • Perform hands-on coding in PL/SQL and other programming languages, and direct others in the same
  • Perform XML data integration, mapping, and transformation
  • Analyze and estimate feasibility, costs, time, and compatibility with hardware and other programs
Requirements:
  • Twelve or more years proven and recent experience in creating well documented high performance Oracle PL/SQL code
  • Experience developing high volume and heavy transaction databases where extensive knowledge of SQL performance tuning is required
  • Experience working in an agile test-driven development environment with a cross functional team where project coordination, code re-use, and excellent communication skills are critical
  • Strong data modeling experience with in-depth knowledge of at least one of the popular CASE tools (e.g. QDesigner, Erwin)
  • Experience developing with database-driven Web applications is required
  • Experience developing Java applications communicating with an RDBMS
  • Experience developing database interfaces with OCI and C++ is a plus
  • Experience with XML and Oracle XML extensions required. Experience using one or more XML transformation tools is a big plus - Allora, Stylus, Mapforce or other.
  • Experience in designing and implementing data warehouses
  • Experience with tools such as SQL Navigator and TOAD is a plus
Link

Sunday, September 16, 2007

Database Programmer at WebSideStory

Overview:
Visual Sciences is seeking a talented database programmer to develop and maintain database projects. Responsibilities include supporting and tuning existing database schemas, developing internal tools and components for server/data administration and reporting. Responsibilities also include coordinating with other departments (web, network operations, etc.) during the development and deployment of future data-base related projects.

The ideal candidate will enjoy a fast paced environment and be creative, problem solving, motivated, and self-directed individual.


Job Detail:

Required knowledge, skills, education and experience:
  • BS in Computer Science or related field.
  • 2+ years of professional relational database programming experience.
  • 3+ years of Java programming experience.
  • 3+ years of professional experience in the design, implementation and continuing support of client/server database applications.
  • Experience in database schema design and architecture in Oracle.
  • Experience and knowledge of database procedural programming and the internals of database engines.
  • Experience with PL/SQL.
  • Experience in Unix/Linux environments.

Preferred Additional Skills:
  • Excellent verbal and written communication skills.
  • Experience with Oracle performance tuning.
  • Data analysis and statistics.
  • Experience in coding object oriented web-enabled/Internet-based applications in Java or C++ on UNIX based systems.

Location: San Diego-CA

Experience (Years): 3

Link