Database Administrator - PostgreSQL

Key Skills: PostgreSQL, SQL Server, Oracle, MySQL, MongoDB, Database Administration, Performance Tuning

Roles and Responsibilities:

• Install, configure, and upgrade PostgreSQL databases on-premises.
• Perform performance tuning and query optimization to enhance database efficiency.
• Develop and implement backup and recovery strategies using tools like pg_dump and PITR.
• Set up and monitor replication (Streaming, Logical) to ensure data integrity.
• Troubleshoot database issues and analyze logs for effective resolution.
• Manage user access and control permissions to maintain security.
• Conduct routine maintenance tasks such as VACUUM and REINDEX.
• Utilize monitoring tools like pg_stat_statements and pgBadger for performance insights.
• Collaborate with development teams to automate processes using scripting languages like Shell and Python.

Skills...