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 clear 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.
Apply quarterly patches for Grid and Oracle home
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
