PostgreSQL Senior SME Architect

Role: PostgreSQL Senior SME Architect

Location: Remote with in-person interview in any of these location (Hartford, CT/Dallas, TX/Edison, NJ/ Bellevue, WA)

Duration: 6 Months Contract

Note: In-person interview in any of these location (Hartford, CT/Dallas, TX/Edison, NJ/ Bellevue, WA)

Job Description:

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 The role requires deep technical leadership across architecture migration strategy performance engineering HADR security automation and production cutover for largescale modernization initiatives

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 AWS
• CLI 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
• migrationvalidation frameworks
• Strong consulting communication stakeholder management documentation mentoring and technical
• leadership skills
• Experience in implementing HADR architecture in AWS environments