Database Architect (WFH)

Job Title : Database Architect

Overview : We are seeking an experienced Database Migration Specialist to lead the conversion of an existing SQLite database to PostgreSQL . The role focuses primarily on database migration, optimization, and documentation, ensuring a smooth and efficient transition with minimal data discrepancies.

Key Responsibilities

• Convert all SQLite tables and views to PostgreSQL , applying appropriate data types and structures where necessary.
• Optimize database performance through indexing and other tuning techniques.
• Refactor and optimize views to reduce dependencies on deeply nested views .
• Develop a repeatable and automated process to migrate existing data from SQLite to PostgreSQL.
• Implement a data verification process to ensure data integrity and consistency between the two databases.
• Prepare comprehensive documentation outlining changes made to tables, data types, and indexes, including justifications for each modification.

Requirements

Additional Information

#J-18808-Ljbffr