Senior PostgreSQL Database Engineer/Senior Migration Specialist
First seen by Alion on Nov 4, 2026.
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.
Skills
PostgreSQL, Data Migration, DBA, Database Modeling, Database Design, Database Installation, System Configuration, Ruby on Rails, SQL, PL-SQL, Python