Database Expert

The primary goal of this role is to ensure the high availability, security, and performance of PostgreSQL databases.

• Key Responsibilities:

• Database Installation & Configuration:

  Ensure timely installation and configuration of PostgreSQL databases in production and development environments.

  Perform database migrations from older systems or versions to the latest PostgreSQL versions, thereby streamlining database operations.

  Set up replication and failover processes for high availability, guaranteeing continuous service delivery.

• Database Maintenance & Administration:

  Monitor database performance to optimize it, focusing on query performance, indexing, disk I/O, and other factors that impact system efficiency.

  Regularly perform backup and restore operations to maintain data integrity and enable seamless disaster recovery.

  Update and patch the database to the latest version to ensure optimal security and performance.

  Conduct data integrity checks, manage schemas and tables, and perform data migrations as necessary.

• Performance Tuning & Optimization:

  Utilize performance monitoring tools to identify and resolve performance issues, such as slow queries and resource bottlenecks.

  Optimize SQL queries and database design to ensure efficient performance at scale, thereby minimizing delays and maximizing throughput.

  Create and maintain indexes and optimize the query execution plan for critical applications, ensuring seamless operation.

• Security Management:

  Implement robust access control measures, including user roles and permissions, to safeguard the database.

  Encrypt data in transit and at rest to prevent unauthorized access and protect sensitive information.

  Audit database access and activities regularly to ensure compliance with security standards.

• Replication & High Availability:

  Configure and maintain PostgreSQL replication setups, including master-slave and multi-master configurations, for high availability.

  Manage clustering and failover procedures to ensure uninterrupted database operation.

• Backup & Recovery:

  Develop a reliable backup strategy using tools like pg_dump, pg_basebackup, or continuous archiving.

  Set up point-in-time recovery (PITR) and perform periodic testing of disaster recovery procedures.

• Troubleshooting & Support:

  Provide day-to-day support for PostgreSQL databases, diagnosing and resolving database-related issues promptly.

  Troubleshoot database connectivity issues, performance bottlenecks, and integrity problems, ensuring minimal downtime.

  Respond to critical issues or outages promptly to restore database availability.

• Collaboration & Documentation:

  Collaborate with development teams to optimize database queries and ensure database performance.

  Document database configurations, procedures, backup strategies, and changes made to the system.

  Maintain clear and accurate records of database incidents, tickets, and resolutions.

• Capacity Planning & Scalability:

  Plan for capacity and growth in database storage and resources to meet organizational needs.

  Perform scalability testing to ensure the database can handle increasing loads efficiently.

• Required Skills and Qualifications:

  • Minimum 2-5 years of experience as a PostgreSQL Database Administrator or similar database management role.
  • Solid experience with PostgreSQL installation, configuration, and maintenance.
  • Proficient in SQL, including complex queries, joins, and PostgreSQL-specific functions.
  • Hands-on experience with PostgreSQL replication, clustering, and high availability setups.
  • Experience with backup and restore strategies, disaster recovery procedures, and point-in-time recovery.
  • Strong troubleshooting skills for database performance issues, including query optimization and indexing.
  • Experience with monitoring tools to analyze database performance.
  • Knowledge of security best practices and managing user roles and permissions in PostgreSQL.
  • Familiarity with PostgreSQL extensions like PostGIS or pg_partman is a plus.
  • Familiarity with cloud platforms like AWS RDS or Azure Database for PostgreSQL is an advantage.
  • Bachelor's degree in Computer Science, Information Technology, or related field.