Senior Cloud Database Engineer

About The Role

• Experience in PostgreSQL database schemas and database design
• Extensive experience in PostgreSQL Performance Tuning and SQL Tuning
• Hands-on experience with Postgres replication, backup, recovery, and hot standby
• Expert Level SQL, PL/pgSQL, including stored procedures, functions, triggers, and views.
• Experience on community-supported tools like Pgbadger, Slony, PGadmin, Pgpool, Pgbouncer, Pgbench, Pgpartman.
• Hands of experience with RDS/Aurora database technologies on AWS
• Experience with Disaster Recovery (Multi-Region failovers)
• Ability to detect and troubleshoot database-related CPU, memory, I/O, disk space, and other resource contention issues. Have proficiency with Linux for basic administrative tasks.
• Experience working with AWS Cloud infrastructure with EC2, lambda, Systems Manager, Cloudwatch & SAM
• Experience in maintaining cloud security IAM Policies, Secret management, Key Management Service
• Experience with CI/CD pipelines in AWS.
• Development Experience
• Extensive code development experience with Python, bash and boto3 programing.
• Knowledge of Devops tools like AWS Cloud Formation Template and Git
• Knowledge on creating and managing RestAPI
• Migration experience from oracle to PostgreSQL using AWS SCT and DMS services.
• Develop/Automate migration patterns.
• Experience in Agile software development framework
• Nice to have key Oracle database technologies.

About You

• Bachelor's Degree - Computer Science, technical or engineering degree preferred.
• 6-8 years experience including providing support for mission critical production databases, developing database Engineering Services for PostgreSQL Databases on AWS
• Complete knowledge and experience on developing and automating PostgreSQL database services
• In-depth knowledge of AWS Aurora/RDS PostgreSQL databases and other AWS key services for database management.
• Good understanding of Database Migration and Re-Platforming strategies
• Prior working experience using agile development framework and best practices
• Ability to work under pressure and tight deadlines independently toward assigned goals with minimum supervision
• Strong interpersonal, written, and verbal communication skills. Ability to make presentations to professional peers and work closely with management
• Display ability to learn rapidly and adapt quickly to changing situations
• Be a role model to the rest of the members within and outside the team in technical, personal, behavioural and corporate citizenship.