Oracle Database Developer

Job Title: Oracle Database Developer & Application Analyst

Location: New York, NY (100% Work from home)

Duration: 12 Months Contract with Potential Extension

 Must have with advance SQL, SQL*Plus, SQL*Loade, TOAD, Oracle PL/SQL, Linux shell scripting, Advanced Excel experience.

Job Description:

• This role is a hands-on Oracle Database Application Analyst supporting life insurance financial and actuarial reporting systems. The position sits within Corporate Finance / Financial Systems, maintaining and enhancing Oracle-based database applications that power monthly financial closes, actuarial valuation, and reporting for New York Life Insurance.
• The role is not theoretical—it is production-heavy, combining development + L2/L3 production support, with a strong expectation of SQL and Linux shell scripting proficiency.
• Develop and enhance Oracle database applications supporting life insurance financial and valuation reporting
• SQL queries, PL/SQL procedures, and Shell scripts
• Corporate Finance is looking for an Oracle Database Application Analyst with a minimum of 2 years of experience.
• The Financial Systems database team provides the data warehouse for life insurance financial and valuation reporting in support of New York Life’s Actuarial department.
• The Database Application Analyst position is responsible for maintaining and enhancing our internal financial reporting database applications for life insurance.
• Database applications include implementation and enhancements for new and existing products, automation of reporting requirements, ensuring the successful monthly load of the data warehouse, creation of control processes, producing reports, including automated reports and ad hoc analyses.
• The database application analyst translates complex business and actuarial requirements into programming specifications and technology solutions collaborating with business, finance and technology teams.
• This role includes both application development and production support (Provide L2 & L3 support for FMD oracle database applications)

Qualifications / Requirements:

• 4-year college degree with a minimum of 2 years in a database application development or database administrator role preferred
• Proficiency in Oracle (11g/19c) including Oracle SQL, and Oracle PL/SQL, SQL*Plus, SQL*Loader-REQUIRED-Minimum 2 years
• LINUX OS (including shell scripting)-REQUIRED--Minimum 2 years
• TOAD-REQUIRED--Minimum 2 years
• Advanced Excel (e.g. VLookup/macros)
• Knowledge of scheduling tools (ESP/Stonebranch UAC) preferred
• Knowledge of MS-Access, Python preferred
• Business knowledge of Life Products
• Ability to work on multiple projects with a sense of urgency and ability to change focus to complete critical systems
• Excellent oral and written communication skills
• Excellent interpersonal, organizational, and analytical skills with a problem-solution attitude
• Detail oriented, with a comprehensive approach to validating and proofing deliverables