Job Description :
We are seeking an experienced Database Developer with deep expertise in Amazon Redshift and PostgreSQL to support our data infrastructure and analytics teams.
Key Responsibilities :
- Design and implement scalable database schemas to support high-performance data processing.
- Develop and maintain migration scripts for versioned schema updates.
- Optimize indexing strategies to ensure efficient query execution.
- Collaborate with analytics teams to support ETL processes and modern data warehousing needs.
- Tune complex queries and ensure data integrity across staging, development, and production environments.
- Maintain documentation and follow database best practices.
Mandatory Skills :
Strong hands-on experience with Amazon Redshift and PostgreSQLExpertise in schema design, migrations, indexing, and performance tuningExperience in modern ETL processes and data warehouse optimizationGood to Have :
Experience with cloud platforms (AWS) and BI toolsFamiliarity with data modeling tools and DevOps pipelines for DB deployments(ref : hirist.tech)