Team Lead/Manager - Database || PostgreSQL

Key Responsibility Areas:

• Work closely with programming teams to deliver high quality software
• Analyze application problems and provide solutions.
• Participate in the creation of development, staging, and production database instances and the migration from one environment to another.
• Review requirements with the users and provide time estimates for task completion.
• Responsible for the monitoring and uptime of all production databases.
• Responsible for regular backups and recovery of databases including PITR.
• Responsible for High Availability Failover Replication.
• Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving).
• Responsible for Query tuning, Process Optimization and preventative maintenance.
• Provide support in different phases of software development.
• Develop and Schedule cron jobs as per requirement.

Experience:

• 5-7 years of experience in Postgres Database Administration 9/10/11.
• Working knowledge of AWS/GCP environments will be an added advantage.

Skillsets :

• Strong knowledge of Postgre Architecture 9/10/11 including Master-Slave Replication.
• Hands on experience in Postgre installation, configuration and upgradation.
• Good understanding of data and schema standards and user/application security concepts.
• Must have experience in monitoring, troubleshooting and fixing Postgres issues.
• Experience with regular maintenance tasks automation (e.g., Vacuum, Reindexing, Archiving) and proactive intervention, reducing any downtime
• Good working experience of SQL Query Optimization
• Experience in Postgres Backups, restore and recovery (including PITR).
• Strong knowledge of UNIX/LINUX platforms and shell scripting.
• Knowledge of High Availability Failover Replication , pg-pool.
• Ability to quickly learn new business and technical concepts in a fast paced service focused environment.
• Demonstrated analytical and problem-solving skills.
• Good customer service and communication skills.
• Must be comfortable interacting with Internal clients and internal staff.
• Highly motivated with the ability to work well independently and within a team environment.
• Ability to work under pressure and to handle several tasks efficiently