Send me more jobs like this

PostgreSQL DB administration

Keywords / Skills : PostgreSQL Db administration, PostgreSQL, pem, efm, cdc

5 - 8 years
Posted: 2019-07-17

IT/Computers - Software
Software Engineer/ Programmer
Posted On
17th Jul 2019
Job Description
Job Description:

  • Installing and configuring POSTGRESQL of Versions 8.1.; 8.3.; 8.4.X; 9.2.X; 9.3.X; 9.4.X; 9.5.X.
  •   Configuring and maintaining replication and configuring Scripts for DB related Automation activities in POSTGRESQL
  •   Have Complete Knowledge on PostgreSQL Memory and Process Architecture
  •  Experience on Configuring PostgreSQL Rsync and Streaming Replication Cluster Concepts
  • Experience on PostgreSQL Enterprise Manager Tool (PEM)
  •  Experience on EDB PostgreSQL Failover Manager (EFM)
  •  Experience on Logical and Physical Backup
  • Configuration setup and Monitoring  Working Knowledge on PostgreSQL High Availability and Failover Scenarios
  •  Worked on CDC (Change Data Capture) tool on daily basis to capture the changes on the Critical production database and replicate to low level production to reduce performance issue POSTGRESQL
  •  Enrolling new users and maintaining system security (Profiles), Roles, System and object Privileges and managing user quotas in POSTGRESQL
  •  PostgreSQL Upgrade and Migration Experience.
  • Management and maintenance of recovery procedures, Good Knowledge of Recovery Scenarios Like
  • PITR and Complete Recoveries
  •  Creating Database link to access the object on remote database.
  •  Responsible for pro-active remediation of database operational problems.
  • Responsible for Query tuning and preventative maintenance. .
  •  Working Knowledge on PGPOOL, PGADMIN
  •  Preferable knowledge on Hot-standby Warm Standby Cluster Configurations
  •  Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving, Gatherstats,Analyze and Unbloat).
  •  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.

About Company

Tech Mahindra represents the connected world, offering innovative and customer-centric information technology experiences, enabling Enterprises, Associates and the Society to Rise™. We are a USD 4.7 billion company with 115,200+ professionals across 90 countries, helping over 903 global customers including Fortune 500 companies. Our convergent, digital, design experiences, innovation platforms and reusable assets connect across a number of technologies to deliver tangible business value and experiences to our stakeholders. Tech Mahindra is amongst the Fab 50 companies in Asia (Forbes 2016 list).

We are part of the USD 19 billion Mahindra Group that employs more than 200,000 people in over 100 countries. The Group operates in the key industries that drive economic growth, enjoying a leadership position in tractors, utility vehicles, after-market, information technology and vacation ownership
Similar Jobs
View All Similar Jobs
Walkin for you