Database Developer

Job Summary:

Senior Database Administrator/Developer

Key Responsibilities:

- Lead the end-to-end migration of IBM DB2 databases from on-premises environments to

AWS RDS Aurora PostgreSQL.

- Design, implement, and optimize database schemas and migration strategies for

performance and reliability.

- Work closely with cloud architects, application developers, and DevOps teams to ensure

smooth data transitions.

- Develop scripts and tools to automate data conversion, transformation, and validation

processes.

- Assess existing database structures and suggest improvements to align with AWS best

practices and PostgreSQL standards.

- Monitor and tune database performance post-migration.

- Troubleshoot complex migration issues and data anomalies.

- Ensure security, compliance, and data governance standards are met throughout the

migration lifecycle.

- Create detailed documentation including migration plans, data mappings, and rollback

strategies.

- Provide guidance and mentorship to junior database engineers as needed.

Required Qualifications:

- Bachelor’s or master’s degree in computer science, Information Systems, or related field.

- 5+ years of experience in database development and management.

- Strong hands-on experience with IBM DB2 database architecture and administration.

- Proven experience in migrating DB2 databases to AWS RDS Aurora PostgreSQL.

- Expertise in PostgreSQL development, including stored procedures, functions, indexing,

and performance tuning.

- Proficient in ETL tools, data transformation, and scripting languages (Python, Shell, or

equivalent).

- Familiarity with AWS services such as DMS (Database Migration Service), Schema

Conversion Tool, RDS, and Aurora.

- Strong understanding of data modelling, normalization, and database optimization

techniques.

- Excellent problem-solving skills and attention to detail.

- Strong verbal and written communication skills.