PostgreSQL DBA

Job Description

About Innovecture Innovecture, a U.S. based Information Technology and Management Consulting company, founded in 2007, brings a wealth of expertise and experience in Technology Consulting and Technology Services across various technologies and across multiple industry domains. With innovation embedded in its consulting and services approach, Innovecture has delivered great results for its Fortune 500 clients. With development centers in Salt Lake City, USA and Pune, India, Innovecture leverages the Global Agile Delivery model effectively to deliver the projects within time and budget. Our best in class processes and people ensure the highest quality deliverable. Rol e : PostgreSQL DBA Experience: 5 to 8 years Location : Remote Drive end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using different tools. Support in Installation, configuration and upgrading PostgreSQL software and products as per guidelines given. Implement automated methods and industry best practices for consistent installation and configuration of PostgreSQL for production and non-production environments Planning for and actual backup and recovery of database information. Ensure performance, security, and availability of databases. Prepare documentations and specifications. Experience in backup and recovery procedures including familiarity with PBBACKUP, pgdump and BARMAN. Experience in Master and slave replication setup. Experience in setup hot standby. Experience in PostgreSQL db upgrade. Experience in managing PostgreSQL on cloud (PAAS/IAAS). Experience in Managing PostgreSQL via DOCKER. Health checkup of PostgreSQL database. Experience in Performance Tuning. Experienced in integrating with AD for user management Experience in managing PostgreSQL via PGBAGER and DATADOG. Writing Cron Jobs/Shell scripting for DBA Administrator tasks Manage Disaster Recovery environment. Identify and resolve incidents and address user problems/concerns. Ability to generate reports of all processes and jobs currently running on PostgreSQL Should have worked on Linux platform. Should have worked on cloud AWS and Azure (IAAS and PAAS ) Should have worked on managing PostgreSQL on Docker Container. Good to have Familiarity with other SQL/NoSQL databases such as MySQL, MongoDB, etc will be added advantage