Cloud DB Administrator: PostgreSQL & Data Migrations

Programmers.io; San Antonio (TX); On-site; USD 95,000 - 130,000; Full time

Job summary

Programmers.io is seeking a seasoned Database Administrator to manage installation, upgrades, migrations, patching, and repository maintenance. You will lead data migration initiatives across legacy systems, validate data, and provide post-migration support.

The role requires strong SQL, PostgreSQL troubleshooting, and extensive log analysis across application, database, and server logs. You will ensure high availability, performance optimization, and DR readiness in cloud and z/OS environments.

Qualifications

• Experience in Database Administration and Data Migration concepts.
• Familiar with log analysis, monitoring, and change management.
• Experience with mainframe DB2 and z/OS environments.

Responsibilities

• Perform admin tasks including installation, upgrades, migrations, patch management, and repository maintenance.
• Lead data migration initiatives, including legacy system transformation, validation, and post-migration support.
• Analyze production issues via application, database, and server logs; perform root cause analysis.
• Ensure high availability, load balancing, reverse proxies, session persistence, and performance optimization.
• Collaborate with cloud database services (AWS RDS PostgreSQL or Azure PostgreSQL) and DB2 utilities.
• Provide production support and create RCA and incident reports for issues.
• Manage backup, recovery, and disaster recovery processes.

Skills

Database Administration

Data Migration concepts

Server Administration and log analysis

Monitoring & Alerting Tools

Shell Scripting

Change & Release Management

Mainframe DB2

Job description

Programmers.io is seeking a seasoned Database Administrator to manage installation, upgrades, migrations, patching, and repository maintenance. You will lead data migration initiatives across legacy systems, validate data, and provide post-migration support.

The role requires strong SQL, PostgreSQL troubleshooting, and extensive log analysis across application, database, and server logs. You will ensure high availability, performance optimization, and DR readiness in cloud and z/OS environments.