Database Engineer with Amazon Aurora, PostgreSQL Exp

Kaizen Technologies

Full-time

Professional, Scientific, and Technical Services

About the position

The Database Engineer position focuses on designing, implementing, managing, and optimizing database systems, specifically using Amazon Aurora PostgreSQL. The role involves ensuring high availability and performance tuning of databases to support business operations, while collaborating with development and infrastructure teams for seamless integration and data integrity.

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.

Requirements

• 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.