Position: Postgres Database Lead/Senior Engineer
Company: Luxoft
Category: Other
Experience required: 5y
English level: upper
Published: 2022-03-01T00:00:00+02:00

Our client is a leading global Financial Market data provider who runs several change programs to deliver high-quality software that connects Financial Markets across the globe in a real-time, high frequency, and low-latency data management chain. The projects are technically challenging in a very engaging environment making the most of cutting-edge technologies covering the domains of Real-Time, Big Data, Cloud, and Machine Learning.

This role is intended as the Solution Architect - Postgres lead in the Post Trade division working with application teams to develop or migrate solutions based on Postgres.
It might be interesting for Senior Developers/Leads with good problem-solving and communication skills.
The successful candidate will be responsible for defining best practices and standards for the development of Postgres solutions across the division. This will be a hands-on role, developing database code for resolving complex Postgres issues that are beyond the capabilities of application teams.
Responsibilities:
• Provide expert skills on the development of solutions using Postgres technology
• Implement database code for resolving complex issues or application tuning
• Define best practices for the development of Postgres solutions
• Assist teams in their migration to Postgres - particularly from Oracle
• Provide oversight and assurance over Cloud Service Providers and their support of Postgres
• Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc.
• Work with application teams to ensure efficiency of database code, integrity of data structures and quality of data content.
• Review database application design and application code
• 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.
Mandatory Skills Description:
• 5+ years working as a database developer - including at least 2+ years working with Postgres
• Expert Level SQL, PL/pgSQL, including stored procedures, functions, triggers, and views.
• Knowledge of XML and JSON and Postgres support for complex data types
• 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
• Demonstrable experience working with huge, interdependent, complex datasets and data structures
• Ideally experience of Postgres deployments provided by cloud service providers - particularly Postgres Aurora
• Experience with other database technologies - particularly Oracle and Snowflake - would also be useful
• Able to handle multiple tasks in a fast paced environment
• Excellent verbal, written, and interpersonal communication skills
Nice-to-Have Skills:
• Ability to evaluate alternative solutions and/or workarounds
• Work with people across multiple locations as part of a global team
• Experience in working in an agile environment
Languages:
English: B2 Upper Intermediate