Database DeveloperLocation: Jersey City, NJ
Involve in creating and managing tables, indexes, db links and privileges.Coordinate with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks.Used subversion tools, BitBucket version management to manage various versions of the procedures and functions of the application.Coordinate with the team of java developers to accomplish complex financial calculations.Work on the oracle SQL queries and PL/SQL objects like functions, procedures, packages, triggers, views, cursors.Implement procedures to install and deploy large numbers of Linux / Unix servers.Create database tables, create various db queries and assist in data mapping/testing activities in support of project.Develop and optimize database structures, store procedures, dynamic management views, DDL triggers and user define functions.Develop complex PL/SQL packages, procedures, functions for the application.Modify, maintain and develop PL/SQL codes for new customer requirements which involve cursors, functions, procedures triggers and collections.