Tech Lead

Onsite hiring for U4 band, PID: 000000000045395, NNA AMO COE ICS, Requested by: Herald John(306316) Job Responsibilities: Manage PostgreSQL databases and collaborate with our Application team and customers on their projects. Perform Architectural health checks and suggest optimizations and design changes through a detailed summary. Optimize the performance of postgres databases using your knowledge in PostgreSQL Internals. Tune SQL¿s and write complex scripts for day to day administrative tasks. Flexible in managing PostgreSQL databases on Cloud such as ¿ AWS RDS & Aurora,Azure, etc. Upgrade and Migrate PostgreSQL databases to Cloud and between Cloud platforms. Technical Skills required: Must have expertise on managing PostgreSQL for at least 5 years. If you have been an Oracle DBA for more than 5 years, at least 2 years of experience in PostgreSQL is preferred. Need have a deeper understanding of the PostgreSQL architecture and internals. Should have an understanding of the limitations and the work arounds for managing PostgreSQL deployed on DBaaS platforms. Must have knowledge on implementing Automatic failover, Parallel backups and Connection Pooling using Open Source tools. Must be able to handle Catalog Corruptions, Database Corruptions and Point in time recovery. Must be able to analyze the logs and optimize the time consuming SQL¿s. Must have knowledge on the most widely used extensions in PostgreSQL for monitoring, analyzing and maintaining the databases. Must be able to perform PostgreSQL Upgrades from legacy to latest versions with least possible downtime. Must have the mindset of helping customers to implement Community PostgreSQL and Open Source solutions for regular activities.