PostgreSQL

Teamware Solutions is looking for a skilled PostgreSQL Database Administrator / Developer to manage, maintain, and optimize our critical PostgreSQL database environments. You'll be responsible for ensuring the high availability, performance, and security of our data, playing a vital role in our data infrastructure. This position is ideal for an experienced professional who thrives on optimizing complex database systems and safeguarding valuable data.

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.