Lead Database Engineer

Position: Lead Database EngineerExperience: 3+ YearsMandatory Skills: Amazon Aurora PostgreSQL, MySQL, NoSQL, AWS RDS, DMS, Performance Tuning, Replication Strategies, Query OptimizationJob Description:Database Administration: Manage and administer Amazon Aurora PostgreSQL, MySQL, and NoSQL databases, ensuring high availability, performance, and security.AWS Expertise: Proficient in AWS services such as RDS, Aurora, and DMS, with a strong understanding of cloud database architectures.Optimization: Implement optimization strategies at the database, query, collection, and table levels for PostgreSQL/MySQL. Expertise in performance monitoring and tuning.Configuration Management: Configure and fine-tune RDS parameter groups to enhance database performance and security.Monitoring & Troubleshooting: Proactively monitor database performance, identify bottlenecks, and perform root cause analysis (RCA) for issues.Access Control: Manage PostgreSQL/MySQL user permissions and roles, ensuring strict data security and access control protocols.Replication Strategies: Hands-on experience with master-master and master-slave replication setups.Collaboration: Work closely with development teams to provide guidance on database design, query optimization, and performance tuning.Backup & Recovery: Establish and maintain robust backup and recovery procedures to ensure data integrity and availability.Database Upgrades: Perform major version upgrades for MySQL and PostgreSQL to leverage new features and improvements.Problem Solving: Troubleshoot and resolve complex database performance issues, implementing innovative and effective solutions.Note: Expertise in database performance tuning, AWS database services, and advanced replication strategies is essential.