PostgreSQL Senior Architect – AWS Database Migration
Job Title: PostgreSQL Senior Architect – AWS Database Migration
Location: Remote (Dallas, TX)
Employment Type: Contract
About Smart IT Frame: At Smart IT Frame, we connect top talent with leading organizations across the USA. With over a decade of staffing excellence, we specialize in IT, healthcare, and professional roles, empowering both clients and candidates to grow together.
Job Summary:
We are looking for a PostgreSQL Senior SME Architect with 12 years of database experience and strong expertise in PostgreSQL Amazon RDS for PostgreSQL Amazon Aurora PostgreSQL and enterprise database migration programs.
Required Skills:
- 12 years of database engineering administration architecture and migration experience
- Expertlevel knowledge of PostgreSQL architecture administration PLpgSQL schema design indexing partitioning performance tuning backuprecovery security and monitoring
- Handson experience with Amazon RDS for PostgreSQL Amazon Aurora PostgreSQL AWS DMS AWS SCT AWSCLI CloudWatch Performance Insights IAM KMS S3 and VPCnetworking concepts
- Strong experience in heterogeneous database migrations including assessment schema conversion data migration validation reconciliation and cutover planning
- Good scripting and automation skills using SQL PLpgSQL shell scripting Python Git and reusable migration validation frameworks
- Strong consulting communication stakeholder management documentation mentoring and technical
- Mandatory Skills : AWS Aurora, AWS DMS, AWS SCT, PostgreSQL-DB Administration