Postgress Database Engineer

  • Pune
  • Cgi

Job Description: -

Postgress Database Engineer should be able to perform below roles

- Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.

- Develop Stored Procedures and Database Triggers in support of application development.

- Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.

- Responsible for Query tuning and preventative maintenance.

- Responsible for the monitoring and uptime of all production databases.

- Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.

- Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.

- Participate in application development projects and be responsible for the database architecture and design.

- Responsible for regular backups and recovery of databases.

- Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving). - Responsible for pro-active remediation of database operational problems.

- Support complex web-based applications.

- Write performant SQL’s as per the requirement.

- Knowledge and proven work experience on managing PostgreSQL instance on Azure cloud.

- Participate in support rotation 8 AM to 10 PM IST.


SKILLS PREFERRED (Technical & Behavioural) –

Mandatory

• Good communication (verbal and written)

• Ability to provide technical solutions • Experienced in working with enterprise customers

• Understanding and knowledge of working of PAAS component in Azure.

• Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.

• Strong understanding of working and management of database in Azure.

• Planning & Organizing • Teamwork & Collaboration

• Customer Focus

• Continuous learning SKILLS DESIRED (Technical & Behavioural)


– Secondary

• Azure Database Administrator Associate or Administrating Relational Databases on Microsoft Azure

• Exp range: 5+ years