We are seeking an experienced AWS RDS PostgreSQL Architect to lead the design, migration, and optimization of our database environment. In this role, you will play a critical part in migrating existing SQL from Sybase to PostgreSQL, ensuring data integrity, optimizing performance, and collaborating closely with Murex reporting SMEs to validate post-migration reporting. This position requires strong expertise in AWS RDS, database migration, automation, and financial services. If you have a passion for database architecture, automation, and seamless cloud migrations, this role is for you.
Key Responsibilities
Database Architecture & Migration
- Architect and design the AWS RDS PostgreSQL-based environment, ensuring it aligns with best practices for security, scalability, and performance.
- Lead the migration of existing custom SQL from Sybase to PostgreSQL, ensuring minimal disruption and maximum efficiency.
- Automate RDS PostgreSQL backup processes, data migrations, and imports to enhance operational efficiency and reliability.
- Work closely with Murex reporting SMEs to validate the post-migration reporting framework that runs on top of SQL queries.
Technical Analysis & Development
- Conduct in-depth technical analysis of the Sybase-to-PostgreSQL migration process, identifying potential challenges and devising robust solutions.
- Develop, test, and optimize PL/pgSQL code, ensuring efficiency, performance, and compliance with industry best practices.
- Work on debugging, performance tuning, and troubleshooting of PostgreSQL queries and stored procedures.
- Provide technical recommendations for database design, indexing strategies, and query optimization.
Collaboration & Problem-Solving
- Engage with Business Analysts, Testing teams, and key stakeholders to ensure seamless data migration and reporting accuracy.
- Participate in fixing production and test defects, ensuring smooth database operations post-migration.
- Take end-to-end ownership of tasks, proactively identifying and addressing challenges during the migration and post-migration phases.
Required Skills & Experience
Technical Expertise
- 4+ years of experience working as a Database Administrator / Architect, specializing in PostgreSQL in an AWS RDS environment.
- Strong hands-on experience in migrating from Sybase to PostgreSQL, ensuring a seamless transition.
- Expertise in AWS-based database migration, particularly focusing on RDS PostgreSQL operations such as backups, data migrations, and imports.
- Proficiency in writing and debugging PostgreSQL PL/pgSQL code, stored procedures, and complex queries.
- Experience with AWS database services and best practices for cloud-based data management.
Industry & Functional Knowledge
- Financial services experience is essential, with an understanding of compliance, data security, and regulatory requirements.
- Exposure to Murex reporting and Datamart is a plus, as it will be beneficial for post-migration validation and reporting enhancements.
Nice-to-Have Skills
- Prior experience working with Murex reporting and Datamart, enabling better insights into post-migration validation.
- Familiarity with automation tools and scripting for database management and migration.
- Strong problem-solving skills with a proactive approach to troubleshooting and performance optimization.
Why Join Us?
- Cutting-edge technology. Work with AWS cloud databases and modern migration strategies.
- Challenging projects. Lead complex database migrations that have a direct impact on business operations.
- Collaborative environment. Work alongside SMEs, Business Analysts, and Testing teams to ensure seamless migration and reporting.
- Career growth. Enhance your expertise in AWS, database migration, and financial services.
If you are a seasoned PostgreSQL Architect with a passion for cloud migration and database optimization, we would love to hear from you! Apply now and be part of an innovative and fast-paced team.