PostgreSQL DBA

The Opportunity:

We are looking for smart & creative candidates who want to Learn and Grow and to Innovate because they love the challenge of solving business problems.

Objectives aligned to this role:
Maintain a laserfocused direction for each sprint cycle ensuring efficient progress towards product release and fostering strong collaboration with the development team to achieve this goal.

What would you do

• Installation and configuration.
• Expert in Backup and Recovery including pgdump pgdumpall setting up WAL (Write Ahead Log) archiving Point in time recovery.
• Management of PostgreSQL server security and Database health checks.
• Performance tuning Query tuning by generating and explaining plan for SQL queries.
• Analyse recommend and implement configuration for Optimized Performance.
• Creation managing and migrating PostgreSQL schema tables tablespaces and users roles and group.
• Ability to plan hardware capacity requirements for storage memory and CPU Cycles.
• Setting up replication setup for 3 nodes (Master Slave and Disaster Recovery).
• Ability to configure and troubleshoot log shipping cascading standbys partial replication continuous recovery detach and reattach slaves.
• Pg pool configuration for connection pooling and load balancing.
• Understanding of UNIX environment with shell scripting.
• Trouble shooting and resolving database issues.

Required Skills

• Expertise in high availability and scalability products and solutions
• Experience in working on large scale enterprise environments.
• Strong technical problemsolving skills
• Experience in working with and in technical teams.
• Positive attitude and excellent communication skills to manage customer calls
• Good to have any of the following PostgreSQL certification:
  • PostgreSQL Associate
  • PostgreSQL Professional

Behavioural Attributes:

• Demonstrated problem solving analytics and troubleshooting skills.
• Able to do multitask and meet deadlines in a fastpaced environment.
• Ability to work seamlessly in a team environment and creating excellent team dynamic.

Academic Qualification:

• Engineering/ equivalent technical qualification from a reputed college/ university
• Good understanding of current technology trends along with ultrascalable systems
• Proficient in effectively communicating with internal stakeholders across various domains including technology and business.