Overview
PostgreSQL Database Administrator (DBA) - 10 Years Experience Key Responsibilities:
Install, configure, upgrade, and maintain PostgreSQL database systems across development, testing, and production environments.
Monitor and optimize database performance, including query tuning, indexing, and resource management.
Implement and manage backup, recovery, and disaster recovery strategies to ensure data availability and integrity.
Manage database security, access control, roles, and privileges.
Troubleshoot and resolve complex database issues, including performance bottlenecks and locking conflicts.
Automate routine DBA tasks using scripting languages such as Shell or Python.
Participate in capacity planning and scaling to meet growing business needs.
Ensure compliance with security policies, data privacy regulations, and audit requirements.
Provide technical guidance, mentorship, and knowledge sharing to junior DBAs and development teams.
Maintain detailed documentation of database systems, procedures, and best practices.
Support high availability and replication setups, such as streaming replication or other clustering technologies.
Required Qualifications:
Bachelor’s degree in Computer Science, Information Technology, or related field.
At least 10 years of hands-on experience with PostgreSQL administration.
Deep knowledge of PostgreSQL architecture, backup & recovery, and performance tuning.
Expertise in SQL and PL/pgSQL programming.
Experience with Linux/Unix operating systems and shell scripting.
Strong analytical and problem-solving skills.
Familiarity with database monitoring tools (e.g., pg_stat_statements, Nagios).
Knowledge of security best practices for databases.