PostgreSQL

PostgreSQL Database Administrator / Developer

Key Responsibilities

• Database Management & Maintenance:

• Install, configure, and maintain

  PostgreSQL database instances

  , ensuring optimal performance and stability.
• Perform regular

  database backups, restores

  , and ensure

  disaster recovery readiness

  .
• Implement and manage database security, including user permissions, roles, and encryption.
• Conduct routine

  database health checks, monitoring

  , and maintenance tasks such as vacuuming, indexing, and integrity checks.

• Performance Tuning & Optimization:

• Monitor

  database performance

  , identify bottlenecks, and implement solutions for

  performance tuning

  (e.g., query optimization, proper indexing, analyzing execution plans).
• Optimize

  SQL queries, stored procedures

  , and database schemas for improved efficiency.
• Analyze and troubleshoot complex database-related issues, ensuring minimal downtime.

• High Availability & Scalability:

• Implement and manage

  high availability solutions

  like

  streaming replication, logical replication, PgBouncer

  , or other clustering technologies.
• Plan and execute database scaling strategies to support growing data volumes and user loads.

• Development Support & Integration:

• Collaborate with development teams to design efficient database schemas, write optimized queries, and support application integration.
• Assist in database migrations and upgrades.

• Troubleshooting & Support:

• Provide expert-level support for all

  PostgreSQL database issues

  , responding to incidents and requests in a timely manner.
• Work closely with application teams to resolve database-related problems.

• Documentation & Best Practices:

• Create and maintain comprehensive documentation for

  database configurations, processes, and procedures

  .
• Ensure adherence to industry best practices and internal standards for database administration.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven experience as a

  PostgreSQL Database Administrator or Developer

  .
• In-depth knowledge of

  PostgreSQL architecture, concepts, and features

  .
• Strong proficiency in

  SQL, PL/pgSQL

  , and database schema design.
• Experience with

  performance monitoring and tuning tools

  for PostgreSQL.
• Familiarity with

  Linux/Unix operating systems

  for database environments.
• Excellent

  analytical, problem-solving, and communication skills

  .
• Ability to work independently and collaboratively in a fast-paced environment.

Preferred Skills

• Experience with

  cloud database services

  (e.g., Azure Database for PostgreSQL, AWS RDS for PostgreSQL, Google Cloud SQL for PostgreSQL).
• Knowledge of

  containerization

  (Docker) and

  orchestration

  (Kubernetes) in a database context.
• Experience with

  database migration tools and strategies

  .
• Familiarity with other database technologies.