Axcelus Financial Life Insurance Company - Philadelphia, PA

posted about 2 months ago

Full-time - Mid Level
Philadelphia, PA

About the position

The Database Developer will be responsible for designing databases and ensuring their stability, reliability, and performance. This role involves collaborating with other developers to optimize in-application SQL statements and establish best practices. The successful candidate will develop MS-SQL queries, procedures, and reports while working closely with SQL Administrators. The Database Developer will also address database usage issues and provide innovative solutions to prevent future problems. In this position, the candidate will develop high-quality database solutions, implement and optimize stored procedures and functions using TransAct SQL, and review ongoing business report requirements. They will research required data and build useful reporting deliverables in MS Excel. Additionally, the role includes analyzing existing SQL queries for performance improvements, developing procedures and scripts for data migration, and applying data modeling techniques to ensure that development and implementation support efforts meet integration and performance expectations. The Database Developer will independently analyze, solve, and correct issues in real-time, providing end-to-end problem resolution. They will refine and automate regular processes, track issues, and document changes. The candidate will assist developers with complex query tuning and schema refinement, prepare technical documentation, provide work package estimates, and manage delivery expectations. There may also be opportunities to interface directly with clients to clarify requirements or discuss alternative solutions, as well as design and develop automated processes, workflows, and schedules.

Responsibilities

  • Development of high quality database solutions.
  • Develop, implement, and optimize stored procedures and functions using TransAct SQL.
  • Review and interpret ongoing business report requirements.
  • Research required data.
  • Build appropriate and useful reporting deliverables in MS Excel.
  • Analyze existing SQL queries for performance improvements.
  • Develop procedures and scripts for data migration.
  • Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
  • Independently analyze, solve, and correct issues in real-time, providing problem resolution end-to-end.
  • Refine and automate regular processes, track issues, and document changes.
  • Assist developers with complex query tuning and schema refinement.
  • Prepares technical documentation.
  • Provides work package estimates and manage delivery expectations.
  • May interface directly with clients to clarify requirements or discuss alternative solutions.
  • Design and develop automated processes, workflows, and schedules.

Requirements

  • 5+ years of experience as a SQL Developer, MySQL or similar role.
  • Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
  • Participate in requirements analysis working collaboratively with IT Business Analysts and business subject matter experts across various departments.
  • Participate in code reviews and validation of deliverables as warranted by SDLC.
  • Excellent written and verbal communication skills.
  • Flexible, team player with the ability to organize and plan work independently.
  • Ability to multi-task and context-switch effectively between different activities and teams.
  • High level of energy and passion with a strong sense of professional accountability and integrity.
  • Strong technical background.
  • Bachelor's degree in Computer Science or a related discipline.
  • A background in finance/insurance is preferred.
  • 3+ years of hands-on experience with AWS services like S3, EC2, ECS, IAM, CloudWatch, Lambda, and other AWS services.
  • Familiarity with Azure cloud services/DevOps is a plus.
  • Familiarity with developing custom workflows using Microsoft Power Automate is a plus.

Nice-to-haves

  • Background in finance/insurance is preferred.
  • Familiarity with Azure cloud services/DevOps is a plus.
  • Familiarity with developing custom workflows using Microsoft Power Automate is a plus.

Benefits

  • Paid time off
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service