Beruk Solomon

- Provided expert-level support as a Senior Database Administrator, specializing in database management and optimization.

-     Installed, configured, and maintained PostgreSQL clusters on Linux and Windows, including tuning postgresql.conf parameters for performance (e.g., shared_buffers, work_mem, checkpoint_completion_target).

-     Performed backup and recovery operations:

-     Logical backups with pg_dump / pg_restore.

-     Physical backups and Point-in-Time Recovery (PITR) using pg_basebackup and WAL archiving.

-     Monitored and optimized performance using:

-     pg_stat_activity, pg_stat_statements, and pg_profile (Query Store–like workload analysis).

-     EXPLAIN (ANALYZE, BUFFERS) for query plan tuning.

-     Implemented high availability and replication:

-     Configured streaming replication (synchronous/asynchronous).

-     Evaluated failover frameworks like Patroni and repmgr.

-     Handled database maintenance tasks:

-     Autovacuum/VACUUM tuning to reduce table/index bloat and prevent transaction ID wraparound.

-     Regular ANALYZE for statistics freshness.

-     Index optimization (B-Tree, partial, GIN, BRIN).

-     Developed automation and job scheduling with pg_cron, pgAgent, and OS-level cron for recurring maintenance.

-     Worked with PostgreSQL extensions including pg_stat_statements, dblink, and pg_hint_plan to extend database functionality.

-     Compared and migrated workloads from SQL Server to PostgreSQL, mapping key features (buffer pool vs shared_buffers, Query Store vs pg_profile, filegroups vs tablespaces).

• Company Overview: (Remote)
• Spearheaded database administration tasks, including maintenance, optimization, and troubleshooting.
• Implemented security protocols and ensured compliance with industry standards.
• (Remote)

• Company Overview: (Remote)
• Managed SQL databases remotely, ensuring optimal performance and reliability.
• Collaborated with cross-functional teams to implement database solutions tailored to business needs.
• (Remote)

• Ensured smooth operations and maintenance of data center infrastructure.

• Administered SQL databases, optimizing performance and ensuring data security.
• Collaborated with IT teams to troubleshoot and resolve database-related issues.