Oracle Database Developer

Veterans Sourcing Group, LLC; New York (NY); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading staffing company is seeking an experienced Oracle Database Developer & Application Analyst. The role focuses on supporting life insurance financial and actuarial reporting systems, maintaining Oracle databases, and providing production support. Ideal candidates should possess at least 2 years of experience with Oracle SQL, PL/SQL, and Shell scripting. This fully remote position offers an opportunity to work on critical financial applications within a collaborative environment.

Qualifications

• Minimum of 2 years in a database application development or database administrator role.
• Proficiency in Oracle (11g/19c), SQL, and PL/SQL.
• Experience with LINUX OS and shell scripting.
• Familiarity with scheduling tools (ESP/Stonebranch UAC) preferred.
• Detail-oriented with a comprehensive approach to validating deliverables.

Responsibilities

• Support life insurance financial and actuarial reporting systems.
• Maintain and enhance Oracle database applications.
• Develop SQL queries and PL/SQL procedures.
• Provide L2 & L3 production support for database applications.
• Translate complex business requirements into technological solutions.

Skills

Advanced SQL queries

Shell scripting

Oracle SQL

Oracle PL/SQL

Linux OS

TOAD

Advanced Excel

Business knowledge of Life Products

Excellent oral and written communication skills

Excellent interpersonal skills

Organizational skills

Analytical skills

Education

4-year college degree

Tools

TOAD

MS-Access

Python

Job description

Job Title: Oracle Database Developer & Application Analyst

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

Duration: 12 Months Contract with Potential Extension

Must have Advance SQL queries, SQL Script Experience and proficiency with Shell scripting

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 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 insurance'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