Description

Lead the re-architecture and redesign of database structures to support a new reporting platform.

Responsibilities

• Redesign and re-architect database organization to facilitate new reporting functionality.
• Optimize databases and SQL queries to improve reporting performance.
• Execute large-scale database migrations from Oracle to AWS Aurora and Redshift.
• Implement and fix critical database performance and structural issues.

Required Skills

• 12+ years of experience in database administration and architecture.
• Extensive experience with Oracle database 11g and above.
• Deep expertise in Oracle SQL and Oracle Advanced PL/SQL.
• Hands-on experience with AWS data services including Aurora, Redshift, S3, Athena, Glue, and Redshift Spectrum.
• Proven track record of migrating large-scale databases to AWS environments.
• Advanced knowledge of data modeling, ETL processes, tables, indexes, partitions, and DB links.
• Expertise in tuning SQL queries and PL/SQL code for optimum performance.
• Strong understanding of cloud-native data architecture principles and best practices.

Key Skills

Education

Any Graduate