Job Description

Experience in PostgreSQL Database administration, design, operating systems administration. Practical knowledge and experience in all aspects of PostgreSQL database administration including Installations, Patching and Upgrading the PostgreSQL server. Good expose on PostgreSQL architecture. Experience in replication setup with Streaming or other replication tools. Configuration of steaming, cascading and cross site replications. Database performance tuning, Troubleshooting database issues and memory tuning. Proficient with Backup and Recovery using hot and cold physical backup and recovery & traditional utilities like Pg_dump,pg_dump all, pg_basebackup and pg_restore utilities. Experience on planning and Routine Maintenance Tasks (Vacuum & vacuum full) and Moving data. Load balancing, Connection pooling and Master/slave replication in pgbouncer and pgpool. Experience on generate log analysis report in pgbagder. Automate repetitive tasks, such as database deployments, database health reports. Database performance tuning, Trouble shooting database issues, Basic knowledge on PSQL and PG/PLSQL. Performing on Routine Maintenance Tasks and Moving data. PGADMIN III &IV monitoring to postgres database. Perform the database Cloning using users manage. Load balancing, Connection pooling and Master/slave replication in Pgpool and pgbadger. Fine-tune configurations - MongoDB and servers for performance improvement. Implement optimal backup and recovery. Understand and optimize query performance. Create and publish database health checks to monitoring systems Evaluate, plan and perform the DB upgrades. Maintenance - during release/outage etc. Implementing best practices for backups, replication, and health checks \',

foundit