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.
