About the job
About the Role
We are seeking a talented Database Engineer to spearhead the migration of more than 25 custom SAP tables into an Aurora PostgreSQL environment. This position emphasizes the design of efficient database schemas, the execution of reliable data migrations, and the assurance of optimal performance within a cloud-based architecture.
In this role, you will transform legacy SAP data structures into a scalable, high-performing database solution while maintaining data integrity, security, and system reliability. Your responsibilities will include focusing on performance tuning, ensuring high availability, and planning for long-term capacity.
Key Responsibilities
Design and implement database schemas in Aurora PostgreSQL based on existing SAP custom table structures.
Develop and execute data migration scripts, including validation and reconciliation procedures.
Optimize database performance through query tuning and efficient indexing strategies.
Configure and manage read replicas to support reporting and analytics workloads.
Implement robust database security measures, including encryption and access control mechanisms.
Design and maintain backup and disaster recovery strategies to ensure data resilience.
Engage in ongoing performance tuning and capacity planning to support system scalability.
