Senior Cloud Database Engineer

We are looking to add an energetic and self-motivated Senior Cloud Database Engineer to our high performing global team of DatabaseEngineeringExperts.This roleinvolvesarchitecting, implementing and supporting technological solutions within Technology like Oracle/PostgreSQL environment for revenue generating applications that drive the TR business. The candidate should have strong technical, excellent communication and collaboration, as well as time and project management skills to provide direction to the database team(s).

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

• Bachelors Degree - Computer Science, technical or engineering degree preferred.
• 6-8 years experience including providing support for mission critical production databases, developing database Engineering Services forPostgreSQL Databases onAWS
• 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 goalswith 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.