Job
Description
**Job Description:** **Role Overview:** Join a highly skilled and collaborative team dedicated to ensuring data reliability, performance, and security across critical systems. As a Database Administrator specializing in MySQL and Postgres within AWS environments, you will play a key role in architecting, deploying, and supporting the backbone of the data infrastructure. Collaborate across teams, stay updated with emerging technologies, and contribute directly to business success. **Key Responsibilities:** - Design, implement, and maintain MySQL and Postgres database instances on AWS, managing clustering and replication. - Write, review, and optimize stored procedures, triggers, functions, and scripts for automated database management. - Continuously tune, index, and scale database systems for optimal performance and growth handling. - Monitor database operations to ensure high availability, robust security, and optimal performance. - Develop, execute, and test backup and disaster recovery strategies aligned with company policies. - Collaborate with development teams to design efficient database schemas matching application needs. - Troubleshoot and resolve database issues, implementing corrective actions to restore service and prevent recurrence. - Enforce and evolve database security best practices, including access controls and compliance measures. - Stay updated on new database technologies, AWS advancements, and industry best practices. - Plan and perform database migrations across AWS regions or instances. - Manage clustering, replication, installation, and sharding for MongoDB, Postgres, and related technologies. **Qualifications Required:** - 4-7 years of experience in Database Management Systems as a Database Engineer. - Proven experience as a MySQL/Postgres Database Administrator in high-availability, production environments. - Expertise in AWS cloud services, especially EC2, RDS, Aurora, DynamoDB, S3, and Redshift. - In-depth knowledge of DR setups, including active-active and active-passive master configurations. - Hands-on experience with MySQL partitioning and AWS Redshift. - Strong understanding of database architectures, replication, clustering, and backup strategies. - Advanced proficiency in optimizing and troubleshooting SQL queries. - Familiarity with scripting languages such as Bash or Python for automation. - Experience with MongoDB, Postgres clustering, Cassandra, and related NoSQL or distributed database solutions. - Ability to provide 24/7 support and participate in on-call rotation schedules. - Excellent problem-solving, communication, and collaboration skills. (Note: Additional details about the company were not provided in the job description),
