Key Responsibilities :

1. Data Modeling & Database Design :

- Design and implement logical and physical data models in PostgreSQL.

- Transform Couchbase document-based data structures into normalized relational schemas.

- Define tables, relationships, primary and foreign keys, indexes, constraints, and data types.

- Optimize database schemas for application performance, scalability, and data integrity.

2. Data Mapping & Migration :

- Analyze existing Couchbase collections, documents, and JSON structures.

- Develop detailed source-to-target mappings between Couchbase and PostgreSQL.

- Design and develop data extraction, transformation, and migration scripts.

- Implement migration processes using SQL, Python, Ruby, or other appropriate scripting technologies.

- Perform data validation, reconciliation, and integrity checks to ensure accurate migration.

- Identify and resolve data inconsistencies, schema mismatches, and migration failures.

- Support migration testing, cutover planning, and production deployment.

3. PostgreSQL Database Administration:

- Install, configure, maintain, and administer PostgreSQL databases.

- Perform SQL query tuning, indexing optimization, and execution plan analysis.

- Manage database backups, recovery, replication, security, and access controls.

- Monitor database performance, availability, capacity, and resource utilization.

- Troubleshoot database issues and implement corrective actions.

- Manage database schema changes, upgrades, and maintenance activities.

4. Cloud Database Management (AWS Preferred):

- Work with PostgreSQL databases hosted on AWS, particularly Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL.

- Configure and manage cloud database environments, including connectivity, monitoring, security, backup, and recovery.

- Optimize database performance and resource utilization in cloud environments.

- Support database migration and deployment across development, testing, and production environments.

5. Ruby on Rails Integration:

- Work with Ruby on Rails applications that interact with PostgreSQL.

- Understand ActiveRecord ORM, Rails database migrations, models, and associations.

- Collaborate with application developers to ensure database schema compatibility and application performance.

- Troubleshoot database-related application issues and optimize SQL queries generated by Rails.

Required Qualifications :

- Minimum 7 years of overall experience in database engineering, data modeling, development, migration, and administration.

- Strong hands-on experience with PostgreSQL database design, development, and DBA activities.

- Experience working with Couchbase, including JSON document structures, N1QL/SQL++ queries, and data extraction.

- Proven experience in data mapping and migration between NoSQL and relational databases.

- Strong proficiency in SQL, PL/pgSQL, stored procedures, functions, and query optimization.

- Experience developing automated data migration and validation scripts using Python, Ruby, or similar technologies.

- Experience with cloud-hosted databases, preferably AWS RDS or Aurora PostgreSQL.

- Working knowledge of Ruby on Rails, including ActiveRecord and database migration mechanisms.

- Understanding of database security, backup/recovery, performance monitoring, and production support.

- Strong analytical, troubleshooting, and problem-solving skills.

Preferred Qualifications :

- Experience with large-scale Couchbase-to-PostgreSQL migration projects.

- AWS database migration experience using AWS Database Migration Service (DMS) or similar tools.

- Experience with ETL/ELT processes, bulk data loading, and incremental data synchronization.

- Familiarity with CI/CD pipelines and database deployment automation.

- Experience with PostgreSQL monitoring tools, such as pg_stat_statements, pgAdmin, and AWS CloudWatch.

- Familiarity with database high availability, disaster recovery, and infrastructure automation.