At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you.
And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.
The PostgreSQL Database Developer Lead is responsible for developing database code powering our cloud platforms that we develop and maintain.
This is a central role in our development team that will build effective APIs that access and manipulate very large datasets, many of those working with product managers, front end developers, business analysts, DBAs and data scientists as needed.
Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc.
Work closely with the CTO to implement effective and maintainable database coding practices that form an architectural foundation.
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 :
12 - 15 years working as a database developer with working knowledge in PostgreSQL
A strong individual contributor with the ability to administer work across a small team of 2-3 resources
Expert Level SQL, PL / PgSQL, including stored procedures, functions, triggers, and views Part / complete ETL Routines developing transformation logics of varied complexity for execution in DB Design & Create Aggregate / Summary / Dimensional tables creations for the purpose of reporting Recommend optimizations to queries / procedures running on large data volumes 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 workaround