Database Architect
Location: Gurugram, HR
Workplace Type: Onsite
Role Description
We are looking for a hands-on Database Developer with deep expertise in database migration AWS RDS, AWS DMS, and NoSQL databases. The ideal candidate will have experience working environments and leading the transformation of legacy data platforms to modern cloud-native .
Key Responsibilities
1. Design and develop database solutions for enterprise-scale applications using PostgreSQL and NoSQL databases (e.g., DynamoDB, MongoDB)
2. Lead and execute end-to-end database migration projects using AWS DMS (Database Migration Service)
3. Perform schema conversion, data transformation, and migration planning from on-premise or legacy databases (e.g. Oracle, MySQL, SQL Server) to AWS RDS / Aurora PostgreSQL
4. Configure, monitor, and optimize RDS/PostgreSQL environments for performance, availability, and cost
5. Develop stored procedures, functions, and data pipelines to support application needs and reporting
6. Analyze and resolve data-related issues including quality, integrity, and performance bottlenecks
7. Collaborate with cloud architects, application developers, and DevOps teams on data migration and integration strategies
8. Ensure adherence to security, backup/recovery, and compliance best practices in cloud-hosted databases.
Required Skills & Qualifications:
• Bachelor's degree in Computer Science, Information Systems, or a related field
• 11- 17 years of experience as a database developer
• Strong hands-on experience with:
◦ PostgreSQL development and optimization
◦ AWS RDS/Aurora PostgreSQL administration
◦ AWS DMS for data replication and migration
◦ NoSQL databases such as DynamoDB or MongoDB
• Experience migrating databases from on-premises to AWS cloud (rehost/refactor)
• Solid understanding of data modeling, normalization, and indexing strategies
• Familiarity with ETL tools, SQL performance tuning, and cloud-native data solutions
• Strong scripting skills in SQL, Python, or shell for automation and transformation
Exposure to CI/CD pipelines for database changes (Flyway, Liquibase, etc.)