{"schemaVersion":"jobsearcher.job.v1","id":"dc5c666bd150bda3f3d6a2be","url":"https://jobsearcher.com/jobs/dc5c666bd150bda3f3d6a2be","canonicalUrl":"https://jobsearcher.com/jobs/dc5c666bd150bda3f3d6a2be","title":"Senior PostgreSQL Database Administrator (AWS Cloud & Migration Specialist)","description":"Job Title: Senior PostgreSQL Database Administrator (AWS Cloud & Migration Specialist)\nLocation: Oakland, CA\nDuration: August 17, 2026 – February 26, 2027\nPay Rate: $74.00/hr. on W2\nNEED Local CANDIDATE\n\nAccount Manager Notes:\n\nJob Description:\nPosition Summary\nWe are seeking an experienced Senior PostgreSQL Database Administrator with 12+ years of database administration experience to migrate and support mission-critical database environments across on-premises and AWS cloud platforms. The ideal candidate will be responsible for the administration, performance tuning, security, backup and recovery, high availability, automation, and migration of PostgreSQL databases.\nThis role requires deep expertise in PostgreSQL database administration along with strong hands-on experience in AWS services, Infrastructure as Code (Terraform), AWS CLI automation, monitoring, and large-scale database migration initiatives, including Oracle to AWS RDS/Aurora PostgreSQL, SQL Server to AWS RDS/Aurora PostgreSQL, and On-Premises PostgreSQL to AWS RDS/Aurora PostgreSQL.\nThe successful candidate will work closely with application teams, infrastructure teams, cloud architects, and project stakeholders to ensure highly available, secure, and performant database environments.\nSenior PostgreSQL Database Administrator (AWS Cloud & Migration Specialist)\nPostgreSQL Administration & AWS Cloud Experience\nExtensive experience installing, configuring, upgrading, patching, and maintaining PostgreSQL databases in enterprise environments.\nProven experience monitoring database performance, availability, capacity, and storage utilization to ensure optimal system health.\nStrong expertise in performance tuning, query optimization, indexing strategies, and execution plan analysis.\nExperience managing database security, user roles, permissions, access controls, encryption, and compliance requirements.\nSkilled in troubleshooting database issues, performing root cause analysis, and resolving production incidents.\nExperience supporting production, development, test, QA, and disaster recovery environments.\nStrong background in capacity planning, workload analysis, and database growth forecasting.\nExperience providing on-call support and managing critical database operations.\nExtensive experience implementing and managing PostgreSQL backup and recovery solutions.\nHands-on experience with pg_dump, pg_basebackup, WAL Archiving, and Point-in-Time Recovery (PITR).\nExperience performing backup validation, restoration testing, and disaster recovery exercises.\nDevelop and maintain disaster recovery procedures and documentation.\nEnsure adherence to RTO/RPO requirements and business continuity standards.\nExperience configuring and administering PostgreSQL replication technologies.\nDesign, implement, and support High Availability (HA) and disaster recovery architectures.\nMonitor replication health, troubleshoot synchronization issues, and optimize replication performance.\nExecute failover, switchover, and recovery activities with minimal downtime.\nDesign and support highly available PostgreSQL architectures across on-premises and AWS cloud environments.\nAWS Database Administration Experience, Migration, Monitoring & Automation Experience\nHands-on experience administering Amazon RDS PostgreSQL, Amazon Aurora PostgreSQL, and EC2-hosted PostgreSQL environments.\nExperience provisioning, configuring, and managing cloud database infrastructure within AWS.\nMonitor, analyze, and optimize database performance using AWS-native monitoring tools.\nImplement database security controls, encryption, auditing, and compliance best practices.\nExperience managing AWS database backups, maintenance activities, upgrades, and patching.\nStrong understanding of AWS architecture, networking, IAM, KMS, and cloud operational best practices.\nExtensive experience with AWS database administration, migration, monitoring, and automation across enterprise PostgreSQL environments.\nHands-on experience utilizing AWS Lambda, Amazon CloudWatch, Amazon SNS, AWS Systems Manager, and AWS CLI to implement automated database management solutions.\nExperience developing automated database health checks, proactive monitoring, and custom alerting solutions to improve database uptime and operational efficiency.\nStrong background in automating routine DBA tasks, operational processes, and infrastructure provisioning using Terraform and AWS-native services.\nExperience integrating monitoring, notification, and reporting platforms to provide real-time visibility into database performance and availability.\nCreate and maintain operational dashboards, performance reports, and key metrics for database operations and service health.\nExperience in handling complex PostgreSQL, Oracle, and SQL Server migration projects across on-premises and cloud environments.\nExperience migrating On-Premises PostgreSQL databases to Amazon RDS PostgreSQL and Amazon Aurora PostgreSQL.\nPerform Oracle-to-PostgreSQL assessments, schema conversions, compatibility analysis, and performance optimization.\nSupport PostgreSQL version upgrades, platform migrations, and cloud modernization initiatives.\nExtensive experience using AWS Database Migration Service (AWS DMS), AWS Schema Conversion Tool (AWS SCT), and native database migration utilities.\nExecute end-to-end migration activities including assessment, planning, testing, cutover, validation, and post-migration support.\nDesired Outcomes & Deliverables\nMaintain highly available, secure, and scalable PostgreSQL database environments.\nDeliver optimized database performance, reliability, and operational excellence.\nImplement automated monitoring, alerting, reporting, and operational processes.\nEnsure disaster recovery readiness, backup compliance, and adherence to RTO/RPO requirements.\nDrive infrastructure automation and cloud adoption using Terraform and AWS services.\nSuccessfully execute database migration projects with minimal downtime and business impact.\nRequired Qualifications\nBachelor's degree in Computer Science, Information Technology, Engineering, or related field.\n12+ years of Database Administration experience.\n8+ years of PostgreSQL Database Administration experience.\n5+ years of AWS & Azure cloud database administration experience.\nStrong experience managing mission-critical production databases.\nProven experience with PostgreSQL upgrades, migrations, and performance tuning.\nStrong troubleshooting and problem-solving skills.\nExcellent verbal and written communication skills.\nAWS Certified Database Specialty.\nAWS Certified Solutions Architect Associate/Professional.\nPostgreSQL Professional Certification.\nExperience with Enterprise Monitoring tools.\nExperience supporting large-scale utility, financial, or regulated environments.\nExperience with DevOps and CI/CD pipelines.\nKnowledge of Kubernetes and containerized PostgreSQL environments.\nExperience with pgBouncer, Pgpool-II, Patroni, or similar PostgreSQL HA solutions.","company":"Global Software Resources","rawCompany":"global software resources","city":"Oakland","state":"CA","isRemote":false,"isActive":false,"createdAt":"2026-08-05T15:13:07.938Z","occupations":[{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1244.00","title":"Network and Computer Systems Administrators","slug":"network-and-computer-systems-administrators"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"518210","title":"Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services","slug":"computing-infrastructure-providers-data-processing-web-hosting-and-related-services"},{"code":"541519","title":"Other Computer Related Services","slug":"other-computer-related-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Senior PostgreSQL Database Administrator (AWS Cloud & Migration Specialist)","description":"Job Title: Senior PostgreSQL Database Administrator (AWS Cloud & Migration Specialist)\nLocation: Oakland, CA\nDuration: August 17, 2026 – February 26, 2027\nPay Rate: $74.00/hr. on W2\nNEED Local CANDIDATE\n\nAccount Manager Notes:\n\nJob Description:\nPosition Summary\nWe are seeking an experienced Senior PostgreSQL Database Administrator with 12+ years of database administration experience to migrate and support mission-critical database environments across on-premises and AWS cloud platforms. The ideal candidate will be responsible for the administration, performance tuning, security, backup and recovery, high availability, automation, and migration of PostgreSQL databases.\nThis role requires deep expertise in PostgreSQL database administration along with strong hands-on experience in AWS services, Infrastructure as Code (Terraform), AWS CLI automation, monitoring, and large-scale database migration initiatives, including Oracle to AWS RDS/Aurora PostgreSQL, SQL Server to AWS RDS/Aurora PostgreSQL, and On-Premises PostgreSQL to AWS RDS/Aurora PostgreSQL.\nThe successful candidate will work closely with application teams, infrastructure teams, cloud architects, and project stakeholders to ensure highly available, secure, and performant database environments.\nSenior PostgreSQL Database Administrator (AWS Cloud & Migration Specialist)\nPostgreSQL Administration & AWS Cloud Experience\nExtensive experience installing, configuring, upgrading, patching, and maintaining PostgreSQL databases in enterprise environments.\nProven experience monitoring database performance, availability, capacity, and storage utilization to ensure optimal system health.\nStrong expertise in performance tuning, query optimization, indexing strategies, and execution plan analysis.\nExperience managing database security, user roles, permissions, access controls, encryption, and compliance requirements.\nSkilled in troubleshooting database issues, performing root cause analysis, and resolving production incidents.\nExperience supporting production, development, test, QA, and disaster recovery environments.\nStrong background in capacity planning, workload analysis, and database growth forecasting.\nExperience providing on-call support and managing critical database operations.\nExtensive experience implementing and managing PostgreSQL backup and recovery solutions.\nHands-on experience with pg_dump, pg_basebackup, WAL Archiving, and Point-in-Time Recovery (PITR).\nExperience performing backup validation, restoration testing, and disaster recovery exercises.\nDevelop and maintain disaster recovery procedures and documentation.\nEnsure adherence to RTO/RPO requirements and business continuity standards.\nExperience configuring and administering PostgreSQL replication technologies.\nDesign, implement, and support High Availability (HA) and disaster recovery architectures.\nMonitor replication health, troubleshoot synchronization issues, and optimize replication performance.\nExecute failover, switchover, and recovery activities with minimal downtime.\nDesign and support highly available PostgreSQL architectures across on-premises and AWS cloud environments.\nAWS Database Administration Experience, Migration, Monitoring & Automation Experience\nHands-on experience administering Amazon RDS PostgreSQL, Amazon Aurora PostgreSQL, and EC2-hosted PostgreSQL environments.\nExperience provisioning, configuring, and managing cloud database infrastructure within AWS.\nMonitor, analyze, and optimize database performance using AWS-native monitoring tools.\nImplement database security controls, encryption, auditing, and compliance best practices.\nExperience managing AWS database backups, maintenance activities, upgrades, and patching.\nStrong understanding of AWS architecture, networking, IAM, KMS, and cloud operational best practices.\nExtensive experience with AWS database administration, migration, monitoring, and automation across enterprise PostgreSQL environments.\nHands-on experience utilizing AWS Lambda, Amazon CloudWatch, Amazon SNS, AWS Systems Manager, and AWS CLI to implement automated database management solutions.\nExperience developing automated database health checks, proactive monitoring, and custom alerting solutions to improve database uptime and operational efficiency.\nStrong background in automating routine DBA tasks, operational processes, and infrastructure provisioning using Terraform and AWS-native services.\nExperience integrating monitoring, notification, and reporting platforms to provide real-time visibility into database performance and availability.\nCreate and maintain operational dashboards, performance reports, and key metrics for database operations and service health.\nExperience in handling complex PostgreSQL, Oracle, and SQL Server migration projects across on-premises and cloud environments.\nExperience migrating On-Premises PostgreSQL databases to Amazon RDS PostgreSQL and Amazon Aurora PostgreSQL.\nPerform Oracle-to-PostgreSQL assessments, schema conversions, compatibility analysis, and performance optimization.\nSupport PostgreSQL version upgrades, platform migrations, and cloud modernization initiatives.\nExtensive experience using AWS Database Migration Service (AWS DMS), AWS Schema Conversion Tool (AWS SCT), and native database migration utilities.\nExecute end-to-end migration activities including assessment, planning, testing, cutover, validation, and post-migration support.\nDesired Outcomes & Deliverables\nMaintain highly available, secure, and scalable PostgreSQL database environments.\nDeliver optimized database performance, reliability, and operational excellence.\nImplement automated monitoring, alerting, reporting, and operational processes.\nEnsure disaster recovery readiness, backup compliance, and adherence to RTO/RPO requirements.\nDrive infrastructure automation and cloud adoption using Terraform and AWS services.\nSuccessfully execute database migration projects with minimal downtime and business impact.\nRequired Qualifications\nBachelor's degree in Computer Science, Information Technology, Engineering, or related field.\n12+ years of Database Administration experience.\n8+ years of PostgreSQL Database Administration experience.\n5+ years of AWS & Azure cloud database administration experience.\nStrong experience managing mission-critical production databases.\nProven experience with PostgreSQL upgrades, migrations, and performance tuning.\nStrong troubleshooting and problem-solving skills.\nExcellent verbal and written communication skills.\nAWS Certified Database Specialty.\nAWS Certified Solutions Architect Associate/Professional.\nPostgreSQL Professional Certification.\nExperience with Enterprise Monitoring tools.\nExperience supporting large-scale utility, financial, or regulated environments.\nExperience with DevOps and CI/CD pipelines.\nKnowledge of Kubernetes and containerized PostgreSQL environments.\nExperience with pgBouncer, Pgpool-II, Patroni, or similar PostgreSQL HA solutions.","datePosted":"2026-08-05T15:13:07.938Z","dateModified":"2026-08-05T15:13:07.938Z","hiringOrganization":{"@type":"Organization","name":"Global Software Resources","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Oakland","addressRegion":"CA","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"dc5c666bd150bda3f3d6a2be"},"url":"https://jobsearcher.com/jobs/dc5c666bd150bda3f3d6a2be"}}