Overview:
PostgreSQL Administration & Maintenance

Assist with the installation and basic configuration of PostgreSQL instances on Linux/Unix environments.

Execute database upgrades and minor version patching under the guidance of senior DBAs.

Perform AWS RDS administration tasks, including instance rehydration, engine upgrades, and SSL/TLS certificate renewals.

Monitor storage and space management, ensuring tablespaces and disks do not reach critical thresholds.

Replication & High Availability

Monitor and maintain replication health using tools like repmgr or pgpool-II.

Support the setup of basic physical and logical replication; monitor lag and restart failed replication slots.

Understand and observe complex concepts like Multi-master or Group replication while assisting in their daily operational checks.

Troubleshooting & Performance

Identify performance bottlenecks using pg_stat_activity, pg_badger, and basic pgAdmin dashboards.

Troubleshoot common user issues, including connection limits, permission errors, and "generic" database errors.





Diagnose basic OS-level issues using Unix commands (CPU, Load, I/O) to ensure the database has sufficient resources.

Utilize monitoring tools like oswatcher to collect system-level metrics for senior review.

Backup, Recovery & Security

Perform and verify routine backups and restores using standard PostgreSQL utilities (pg_dump, pg_restore, or pg_basebackup).

Manage user access, roles, and privileges (RBAC) to ensure security compliance.

Respond promptly to system alerts and incidents to minimize service disruptions.

Documentation & Collaboration

Maintain detailed documentation of database configurations, standard operating procedures (SOPs), and troubleshooting logs.

Collaborate with L1/L2 support teams to resolve escalated tickets and provide transparent technical updates.

Interface with storage and network teams to help isolate issues affecting database connectivity or performance.
- Oracle DBA:
- Install, confi

📌 Software Engineer-postgres-and-oracle (Guindy)
🏢 Prodapt
📍 Guindy