Senior Associate - Data Engineer

New York Life•Lebanon, NJ

63d•$124,000 - $177,000•Hybrid

About The Position

We are seeking a Database Engineer to join the team managing a critical application. The ideal candidate will have hands-on experience developing and maintaining database solutions using both SQL and NoSQL technologies. You will be responsible for writing and optimizing database queries, developing stored procedures, functions, and views, and supporting application development through robust data models. Additional responsibilities include implementing data validation rules, ensuring data integrity and performance, and collaborating closely with application developers and analysts to translate business requirements into scalable database solutions. A strong foundation in relational database design, scripting, and performance tuning is essential, along with familiarity with cloud-based database platforms.

Requirements

6+ years’ experience as a developer
Experience in build business logic using SQL, stored procedures and triggers.
Experience in building Database system for High Availability
Experience working with both SQL (PostgreSQL) & NoSQL DB (Elastic Search & DynamoDB) solutions
Model & Design Database components in PostgreSQL
Develop DB Functions, Stored Procedures, Triggers
Analyze & Tune SQL scripts for handing High volume transactions
Experience enabling CDC solutions & AWS DMS
Experience working with Messaging systems AWS MSK
GitHub & CI/CD using Terraform
Monitoring and optimizing DB system performance, space utilization, data security
Strong analytical, problem solving, debugging skills.
Demonstrable experience of being able to work to very tight timelines on multiple detailed activities simultaneously
Ability to work in team in diverse environment
Good verbal and written communication and organizational skills

Nice To Haves

AWS or Industry Certification credentials
Life Insurance domain knowledge

Responsibilities

Implement functional requirements into efficient and maintainable database solutions (e.g. via SQL, stored procedures, triggers).
Design, model, and develop database objects such as tables, views, stored procedures, and user-defined functions that align with application logic and business needs.
Develop and optimize complex SQL queries to ensure performance, accuracy, and scalability.
Build and manage SQL and NoSQL databases, ensuring reliability, security, and data integrity across systems.
Support and implement data integration processes, including Change Data Capture (CDC) and AWS Database Migration Service (DMS) for syncing and migrating data.
Work closely with cross-functional teams to deliver consistent and reliable data services as part of broader application and analytics solutions.
Continuously monitor and tune database performance, manage storage capacity, and troubleshoot issues in a fast-paced production environment.
Leverage GitHub & CI/CD using Terraform
Identify root cause analysis leading to solutions that correct defects, security concerns or performance problems.
Establish and maintain monitoring, logging, alerting, and cost-control procedures to ensure optimal platform performance.
Work closely with Business Analysts, Architects, Engineers, DBAs, and other stakeholders to understand requirements and build flexible, scalable solutions.
Participate in quarterly on-site planning and strategy sessions.
Participate in Level 3 on-call support rotation.
Ensure systems are highly available, secure, resilient, and designed to scale efficiently.