Job Details

ID #45895289
State New York
City New york city
Job type Permanent
Salary USD $180,000 - $220,000 180000 - 220000
Source The Astor Group
Showed 2022-09-22
Date 2022-09-16
Deadline 2022-11-14
Category Et cetera
Create resume

Oracle 12(+) database developer for asset manager

New York, New york city, 10016 New york city USA

Vacancy expired!

The Senior Database Developer is responsible for all phases of software development for Applications from analysis and design through coding, testing, documentation and implementation to production. The individual is expected to act as backup for various job responsibilities within the department as directed as well as assuming training responsibilities when necessary.The Senior Database Developer will develop, and test application software based on industry best practices as defined by the Software Development Lifecycle (SDLC) Methodology. The individual will operate independently to ensure that developed code is maintainable, efficient, reliable, understandable, secure, and fault tolerant and once in production support and troubleshoot issues as necessary. Functions include but are not limited to the following:

Analytic Functions
  • Responsible for translating functional design into technical specifications ensuring functionality and integration with existing systems/platforms
  • Develop and maintain all documentation pertaining to a programming project that is detailed and accurate
  • Perform detailed impact analysis and provide estimates for change requests across one or many complex projects

Design/ Development Functions
  • Design, and implement software solutions that are structured and easily maintained
  • Create requests and provide governance to promote code to different environments based on firm standard
  • Ensure code is versioned and checked into source control system
  • Follow coding standards

Implementation Functions
  • Provide oversight to, as well as create deployment scripts and verify correctness within integration environment
  • Troubleshoot production issues, document incidents, and provide timely fixes and drive problem resolution.

  • Perform additional application support as required
  • Influence solutions by recommending and exploring alternate solutions
Job Requirements and Qualifications
  • Bachelor Degree in Computer Science or IT related field
  • 5 - 10 years of software development experience using relational databases
  • Development experience with Oracle version 12 or above
  • Experience generating complex result sets using SQL including familiarity with:
    • analytic functions
    • window functions
    • set operations
    • subquery factoring
  • Experience optimizing/tuning SQL queries including familiarity with:
    • generating and interpreting execution plans
    • query processing, including selecting the optimal join execution methodology
    • specifying optimizer hints
    • proper use of indexes
  • Experience coding stored procedures in PL/SQL including familiarity with:
    • exception handling
    • cursors
    • table functions
  • Strong analytical skills, including a thorough understanding of how to interpret business needs and translate them into application requirements

Vacancy expired!

Subscribe Report job