Job Description

PostgreSQL:- The Postgres DBA will primarily be responsible for the performance, reliability, and scalability of the Postgres databases in a production environment. Collaborate with the development team to implement and refine operational processes like local and remote replication, backup, failover, etc., establish optimal hardware and database tuning profiles, and monitor overall database health and performance. Work with the Development team on database design and schema changes, contribute significantly to performance initiatives like table partitioning, and will perform ongoing query optimization. Primary Role and Responsibilities  Ensure performance and scalability of PostgreSQL databases.  Implement, refine and maintain database replication and failover.  Install, tune and monitor Postgres database instances.  Develop, refine and monitor recurring database jobs/scripts.  SQL and PL/pgSQL coding. Query analysis and optimization.  Conduct Data import and data migration. Perform database load/stress/performance testing;  Responsible for Scraping, spidering, and other forms of loosely structured data collection.  Responsible for configuring alerts and notifications.  Responsible for managing Postgres extensions.  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 the creation of development, staging, and production database instances, and the migration from one environment to another.  Responsible for regular backups and recovery of databases  Responsible for regular maintenance on databases  Responsible for pro-active remediation of database operational problems.  Responsible for Query tuning and preventative maintenance  Participate in a 24×7 support rotation  Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.  PostgreSQL certification  Experience with BARMAN (Backup and Recovery Manager).  Produce clear documentation for delivered solutions. Experience: 5 - 7 Years