Enable job alerts via email!
Postgres DBA/Developer
Luxoft
United Kingdom
Remote
GBP 45,000 - 75,000
Boost your interview chances
Create a job specific, tailored resume for higher success rate.
Job summary
An established industry player is seeking a skilled Database Administrator/Architect to drive the modernization of their Murex systems. This exciting role involves architecting an AWS RDS Postgres environment, migrating databases from Sybase to Postgres, and automating operations for efficiency. You will collaborate closely with business analysts and testing teams, ensuring the integrity of data migrations and post-migration reporting. This position offers a unique opportunity to work within the financial services sector, contributing to significant projects that enhance operational capabilities. If you have a passion for database technologies and cloud migrations, this role is perfect for you.
Qualifications
- Über 4 Jahre Erfahrung als Datenbankadministrator oder Architekt.
- Umfangreiche Erfahrung mit Postgres in einer AWS-Umgebung.
Responsibilities
- Architektur der AWS RDS Postgres-basierten Umgebung.
- Migration bestehender benutzerdefinierter SQL von Sybase nach Postgres.
Skills
Datenbankadministration
Postgres
AWS RDS
Sybase Migration
Automatisierung von RDS-Operationen
PL/pgSQL
Finanzdienstleistungen Erfahrung
Tools
AWS
Postgres
Sybase
Job description
Project description
Luxoft has been engaged by a leading UK Financial Services organisation to partner on their ambitious Murex modernisation roadmap. This includes three major streams of work: upgrading to the latest version of MX 3.1, migrating from a legacy Sybase deployment to Postgres and migrating from on-premises infrastructure into public cloud.
Responsibilities
- Architecting the AWS RDS Postgres based environment
- Working with the database migration stream of the project and working closely with the Murex reporting SMEs on the project
- Migrating existing custom SQL from Sybase to Postgres
- Validating the post-migration reporting that runs on top of SQL queries
- Technical analysis of changes, solution design, development and unit testing
- Participate in fixing production and test defects
- End to end ownership of tasks in cooperation with Business Analysts and Testing team
SKILLS
Must have
- 4+ years working as a database administrator / architect
- Extensive experience in working with Postgres in an AWS environment, specifically using RDS
- Experience in migrating from Sybase to Postgres
- Experience in automating RDS Postgres operations including backups, data migrations and imports
- AWS migration experience focused on data migrations between database technologies
- Experience in writing and debugging PostgreSQL PL/pgSQL code and syntax
- Financial services experience
Nice to have
• Understanding of Murex reporting and Datamart is a significant bonus
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
job faster
