Job Description
Job description Roles and Responsibilities:
· 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
· Develop Stored Procedures and Database Triggers in support of application development.
· Participate in application development projects and be responsible for the database architecture and design
· Participate in the creation of development, staging, and production database instances, and the migration from one environment to another
· Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release
· Responsible for regular backups and recovery of databases
· Responsible for regular maintenance on databases (e.g., Vacuum, Rendering, Archieving)
· Responsible for pro-active remediation of database operational problems
· 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
· Develop Stored Procedures and Database Triggers in support of application development.
· Participate in application development projects and be responsible for the database architecture and design
· Participate in the creation of development, staging, and production database instances, and the migration from one environment to another
· Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release
· Responsible for regular backups and recovery of databases
· Responsible for regular maintenance on databases (e.g., Vacuum, Rendering, Archieving)
· Responsible for pro-active remediation of database operational problems
· Responsible for Query tuning and preventative maintenance
💡 Quick Summary
Seeking a career-building opportunity? The Postgresql DBA position is now open for candidates interested in the Database Administrator sector. This role in Bangalore offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.
