Database Engineer

We are looking for a skilled Database Engineer with expertise in Amazon Aurora PostgreSQL to design, implement, manage, and optimize database systems.

You will be responsible for database performance tuning, ensuring high availability, and developing efficient solutions to support business operations.

You will collaborate closely with the development and infrastructure teams to ensure seamless integration and data integrity.

Key Responsibilities:

• Design, deploy, and maintain database solutions using Amazon Aurora PostgreSQL.
• Optimize database performance through indexing, query tuning, and partitioning strategies.
• Manage database security, including user roles, access controls, and encryption.
• Perform regular database backups, restore processes, and disaster recovery procedures.
• Ensure database availability, scalability, and disaster recovery for mission-critical systems.
• Automate database operations, including backups, monitoring, and scaling.
• Collaborate with developers to design efficient queries, data models, and schemas.
• Monitor database performance and troubleshoot issues to ensure smooth operations.
• Maintain documentation on database architecture, processes, and procedures.
• Stay updated on new features and improvements in PostgreSQL and Amazon Aurora.

Required Skills and Qualifications:

• 8+ years of experience working with PostgreSQL databases, including Amazon Aurora PostgreSQL.
• Strong understanding of database design, indexing, and optimization techniques.
• Experience with database monitoring tools and performance tuning.
• Proficiency in writing complex SQL queries, stored procedures, and functions.
• Familiarity with AWS services, such as EC2, S3, IAM, and CloudWatch.
• Knowledge of database security, including encryption and access controls.
• Experience with database migration and upgrades, especially between different database engines or versions.
• Ability to troubleshoot database-related issues, including connection problems, query slowdowns, and replication failures.
• Strong problem-solving skills and attention to detail.
• Experience with database clustering, replication, and failover strategies in Aurora.
• Familiarity with infrastructure-as-code (e.g., using Terraform or CloudFormation).
• Knowledge of DevOps principles and experience with CI/CD pipelines.