Postgresql DBA| AWS- Aurora, RDS, S3

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