Key Responsibilities:

-Design and implement a horizontally scalable read-only DataMart using AWS Aurora PostgreSQL

-Manage the continuous replication of data from Oracle to PostgreSQL DataMart (approximately 40TB total, with 3-6TB daily updates)

-Optimize database performance to handle high-volume, low-latency API requests -Implement and manage AWS Aurora Read Replicas for APIs Perform complex SQL operations, DML, and schema translations between Oracle and PostgreSQL

-Ensure data integrity and security throughout the migration and operational processes -Collaborate with cross-functional teams to integrate the new DataMart with existing systems

Required Skills and Experience:

-Extensive experience with AWS services, particularly Aurora PostgreSQL and RDS -Expert-level knowledge of Oracle and PostgreSQL database management systems

-Strong proficiency in SQL, including complex queries, performance tuning, and optimization -Experience with large-scale database migrations

-Familiarity with continuous data replication techniques and tools

-Experience with monitoring tools like Datadog or similar for database performance tracking

Bonus Qualifications:

-Understanding of FedRAMP compliance requirements for database systems

-Knowledge of Fivetran or similar ETL tools Experience with Python for database management and automation tasks

-Familiarity with HVR or similar replication tools