DataBase Developer Job in Pune at Michelin

Michelin is hiring for the role of DataBase Developer!

Responsibilities of the Candidate:

• 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.
• 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 for 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 of databases (e.g., Vacuum, Reindexing, Archiving).
• Responsible for proactive remediation of database operational problems.
• Support complex web-based applications.
• Write performant SQL as per the requirement.
• Knowledge and proven work experience in managing PostgreSQL instances on Azure cloud.
• Participate in support rotation from 8 AM to 10 PM IST.

Requirements:

• Good communication (verbal and written)
• Ability to provide technical solutions
• Experienced in working with enterprise customers
• Understanding and knowledge of working on the 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 databases in Azure