Previous Job
Previous
Sr Application developer
Ref No.: 18-55013
Location: New York, New York
Position Type:Contract
Start Date: 08/02/2018
 
  • Design Logical Data Models and their physical schema design in Oracle 11g/10g database, SQL Server Database
  • Build databases depicting the physical design
  • Create Tables, Views, Indexes and Sequences
  • Develop Packages, Stored Procedures, Functions, Triggers, SQL statements in Oracle 11g/10g and SQL Server Databases
  • Manage database security
  • Performance Tuning including tuning/optimizing SQL, PL/SQL, T-SQL code
  • Work with XML, large objects
  • Develop routines in Oracle and SQL server, third party vendor APIs to load/integrate data between systems
  • Preparation of development estimates and design documents
  • Support and maintenance of existing solutions
  • Experience/Good understanding with Big Data ETL/technologies – Hadoop, Hive, Spark
  • Experience/Good understanding working with structured, semi-structured, and unstructured data sources
  • Experience with NoSQL solutions such as MongoDB is preferred