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 explicit technical updates.

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

- Install, configure, and upgrade Oracle database software.
- Configure and maintain standby database.
- Monitor database performance and implement optimization strategies.
- Ensure database security and compliance with organizational policies.
- Perform regular backups and recovery operations.
- Collaborate with developers to design and implement database solutions.
- Troubleshoot and resolve database-related issues promptly.
- Develop and maintain database documentation and standards.
- Plan and execute database migrations and upgrades.
- Setup Oracle golden gate both uni-directional and bidirectional.
- Maintain Oracle Golden Gate synchronization with source.
- Identify the Oracle Golden Gate sync related issues and implement the best practices.
- Identify the performance issues and implement the best practices.
- User creation and access management.
- Storage capacity planning to ensure ASM and tablespace were maintained under threshold and avoided repetitive space related incidents.
- Create and maintain RAC with Data guard.
- Administration of RAC database.
- AWS RDS instance administration, Rehydration, engine upgrade and certificate renewal

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