PostgreSQL DBA
About THE ROLE
We are looking for an experienced PostgreSQL Administrator with expertise in database schema design, query optimization, performance optimization, cloud service management of AWS Aurora PostgreSQL. The role is essential for supporting our product development teams in building efficient and scalable data-driven applications for our container shipping industry.
Key Responsibilities:
- Database Design & Management:
- Collaborate with the product development team to design, implement, and maintain scalable database schemas that meet business and application requirements.
- Develop and maintain data models, ensuring consistency and optimal performance.
- Design tables, indexes, and constraints for high data integrity and performance.
- Performance Tuning & Optimization:
- Analyse slow-running or poor performing queries and optimize performance through proper indexing, query restructuring, or caching mechanisms.
- Conduct performance tuning, including tuning the PostgreSQL parameters for optimal database performance.
- Work on improving database performance, scaling database operations, and addressing bottlenecks.
- Cloud Database Management (AWS Aurora PostgreSQL):
- Manage and administer AWS Aurora PostgreSQL clusters, ensuring high availability, backup, recovery, and disaster recovery planning.
- Optimize the use of cloud-based resources in AWS Aurora to ensure cost-effective and efficient use.
- Monitor and maintain database systems in cloud environments, ensuring data security and availability.
- Security & Compliance:
- Ensure that the database architecture complies with organizational security policies and best practices.
- Implement database encryption, user management, and access controls.
- Monitor database security and address any vulnerabilities or compliance concerns.
- Automation & Maintenance:
- Automate routine database tasks such as backups, failovers, maintenance windows, etc.
- Develop and maintain database monitoring and alerting mechanisms to ensure system stability.
- Documentation & Training:
- Create and maintain detailed documentation for database designs, performance optimizations, and cloud database configurations.
- Provide technical guidance and training to developers on best practices for schema design, query development, and database management.
what we are looking for
- Experience:
- Over 7 to 11 years of technology experience working in a multi-national company.
- 5+ years of experience in PostgreSQL database administration, with a strong focus on query optimization, schema design, and performance tuning.
- Proven experience managing PostgreSQL on AWS Aurora.
- Technical Skills:
- Strong expertise in PostgreSQL database design, including normalization, indexing, partitioning, and data modeling.
- In-depth knowledge of SQL, PL/pgSQL, and advanced PostgreSQL features like triggers, stored procedures, and replication.
- Familiarity with AWS services (Aurora, RDS, EC2, S3, etc.) and cloud database management practices.
- Experience with query tuning tools such as pg_stat_statements and EXPLAIN for query analysis.
- Experience with database backup, recovery, replication, and failover strategies.
- Performance Tuning:
- Expertise in tuning PostgreSQL databases for high performance, including memory usage optimization, connection pooling, and query optimization.
- Proficiency in analyzing and resolving database performance issues, especially in high-traffic and high-volume production environments.
- Soft Skills:
- Excellent problem-solving skills and the ability to work closely with developers, DevOps, and architects.
- Strong communication skills to convey technical solutions to both technical and non-technical stakeholders.
- Education:
- Engineering degree in computer science, Information Technology, or related field.
- Nice to Have:
- Experience with containerized databases using Docker or Kubernetes.
- Familiarity with event-driven architectures using Kafka.
- Experience with CI/CD pipelines and Flyway Script.