Database Developer

Ampcus - New York, NY

Full-time - Entry Level

New York, NY

Professional, Scientific, and Technical Services

About the position

The Database Developer position at Ampcus Inc. involves maintaining and enhancing internal financial reporting database applications specifically for life insurance. The role requires collaboration with various teams to translate complex business requirements into effective technology solutions, ensuring the successful operation of the financial systems database.

Responsibilities

• Maintain and enhance internal financial reporting database applications for life insurance.
• Implement and enhance new and existing products.
• Automate reporting requirements and ensure successful monthly data warehouse loads.
• Create control processes and produce reports, including automated reports and ad hoc analyses.
• Provide L2 & L3 support for FMD Oracle database applications.

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 PL/SQL, SQLPlus, SQLLoader - REQUIRED - Minimum 2 years.
• Experience with LINUX OS (including shell scripting) - REQUIRED - Minimum 2 years.
• Experience with TOAD - REQUIRED - Minimum 2 years.
• Advanced Excel skills (e.g. VLookup/macros).
• Knowledge of scheduling tools (ESP/Stonebranch UAC) preferred.
• Knowledge of MS-Access and Python preferred.
• Business knowledge of Life Products.
• Ability to work on multiple projects with a sense of urgency and adaptability to changing priorities.
• 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.

Nice-to-haves

• Knowledge of scheduling tools (ESP/Stonebranch UAC) preferred.
• Knowledge of MS-Access and Python preferred.