aiox-data-engineer

Plan a database migration by defining schema relationships, running dry runs, applying migrations, and verifying execution order to ensure data integrity. This process supports creating normalized schemas and planning migrations for smooth deployment.

Designing Row Level Security policies involves defining access control rules and applying security best practices to protect sensitive data. You can generate RLS policies, apply them to your schema, and test access using specific user contexts.

Optimize database performance by analyzing queries, suggesting indexes, and tuning database operations. This approach identifies bottlenecks and ensures your database operations remain scalable and efficient as your data grows.

Yes, you can test database access control by simulating specific users. This allows you to verify that security policies and Row Level Security rules function correctly before applying them to the production database environment.

Rollback a database schema migration by utilizing snapshot and rollback procedures. This allows you to capture the database state before applying changes and revert the schema if the migration deployment fails or introduces errors.

Seed a database with initial test data and load CSV files by executing specific seeding and data loading scripts. This populates your schema with baseline information for development, testing, and performance analysis.