Lead Engineer - IT - Military Veterans
at Guardian Life Insurance Co. of America
Job Description:
Qualifications:
The PostgreSQL Database Developer is responsible for developing database code. Will be involved in analyzing existing PL/SQL code and rewriting it PostgreSQL. Will be part of the modernization project and will work closely with Technical Architect and Front end developers.
Responsibilities:
Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc.
Work with front end developers to define simple yet powerful APIs.
Work with DBAs to ensure efficiency of database code, integrity of data structures and quality of data content.
Work with product managers to ensure database code meets requirements.
Work with DBAs and data analysts to ensure database code is accurately documented.
Participate as a member in Agile teams, and work with other team members to review user stories, estimate effort to build functionality supporting user stories, and participate in sprint reviews.
Required Skills:
5 to 8 years working as a database developer working with PostgreSQL
Expert Level SQL, PL/pgSQL, including stored procedures, functions, triggers, and views.
Knowledge of JSON and PostgreSQL support for JSON.
Ability to efficiently write database code without compromising data quality, privacy or security.
Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels
Able to handle multiple tasks in a fast paced environment
Excellent verbal, written, and interpersonal communication skills
Ability to evaluate alternative solutions and/or workarounds
Location:
This position can be based in any of the following locations:
Gurgaon
Current Guardian Colleagues: Please apply through the internal Jobs Hub in Workday
Gurgaon, Delhi
Who we are Guardian makes a difference in the lives of people when they need us most. With over 160 years of stability and fiscal integrity, we are a trusted resource to generations of families and business owners, inspiring well-being and helping build financial confidence. Today, we stand behind 29 million consumers, helping them prepare and plan for a bright future for themselves and their families. We help business owners care for their employees. And we help people recover and thrive in times of unexpected loss. As a modern mutual insurance company, we believe in driving value beyond dividends. We invest in our colleagues and are building a progressive, innovative and inclusive culture. We uplift individuals and communities through thoughtful social and environmental programs. What we stand for In 1860, a community of immigrants joined together to insure and protect their businesses and families. They were guided by powerful ideals that we’ve continued to stand behind and evolved throughout the years: we do the right thing, we believe people count, we courageously shape the future together, and we go above and beyond for the people we serve. Guardian employees embrace and live by these values every day. They remind us to put people at the heart of all we do so that we can help protect what matters most to you. Want to help bring these values to life? Join us for a rewarding career and the opportunity to shape the future.