We are looking to add an energetic and self-motivated Senior Cloud Database Engineer to our high performing global team of Database Engineering Experts . This role involves architecting, 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 for PostgreSQL Databas es 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.