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.- Robust 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. (ref:hirist.tech)

📌 Senior PostgreSQL Database Engineer/Senior Migration Specialist (Bengaluru)
🏢 Value Lane Consulting Private
📍 Bengaluru