AWS Database Administrator

This role is for one of the Weekday's clients. You are an experienced PostgreSQL Database Administrator who will be responsible for managing and optimizing database systems hosted on AWS. Your main focus will be on ensuring high availability, performance, scalability, and security of the infrastructure supporting technology-driven applications in healthcare and other industries. Your key responsibilities will include designing, implementing, and maintaining PostgreSQL database instances on AWS to ensure optimal performance and availability. You will manage AWS RDS for PostgreSQL, including provisioning, performance tuning, version upgrades, and maintenance. Additionally, you will be responsible for configuring robust database backup, disaster recovery, and failover strategies, as well as monitoring database performance using AWS tools and making necessary adjustments to enhance speed and reduce costs. You will work closely with engineering teams to refine database schema, optimize queries, and create efficient indexing strategies. Leveraging AWS services like EC2, S3, IAM, CloudWatch, and CLI, you will automate routine administrative tasks using scripting languages such as Python or Bash to improve system reliability and efficiency. Your expertise will also be utilized to provide guidance to development teams on best practices for database usage, query optimization, and data governance. To succeed in this role, you must have strong expertise in PostgreSQL database administration, including architecture design and performance tuning on AWS. Hands-on experience with AWS services like RDS, Redshift, Aurora, EC2, S3, IAM, CloudWatch, and AWS CLI is essential. You should possess in-depth knowledge of database security, data integrity, and disaster recovery best practices, as well as proficiency in scripting for automation using Python, Bash, or similar languages. Familiarity with networking fundamentals and the ability to document technical processes clearly are also required. Ideally, you should hold a Bachelor's degree in Computer Science, Information Technology, or a related field, or have equivalent work experience. A minimum of 10 years of experience in database administration with a focus on PostgreSQL in cloud-based environments, especially AWS, is preferred. Additionally, skills in AWS, PostgreSQL/Postgres, database security, performance tuning, automation, scripting, and database architecture optimization will be beneficial for this role.,