Plsql Admin{Contra}

Exp: 3-6 years; 3 years relevant working experience in Databases primarily Oracle and PostgreSql.
• Installation, HA/DR Configuration, PGBouncer and Troubleshooting of PostgreSQL 9.4 / 9.6/ 10/ 11/ 12 databases.
• Perform backup and recovery for PostgreSql.
• Perform cross database data migration and troubleshooting.
• Perform periodic Database refresh from Production.
• Monitoring of database using various tools (Nagios, SCOM, grafana, pgbadger report).
• Knowledge of cloud (GCP/Azure/AWS) DB services.
• Basic understanding of networking fundamentals.
• Experience with establishing and integrating development, test and production environments.
• Current or actively pursuing related professional certifications.
• PostgreSQL tools installation, Configurations PGAdmin III, IV, rep manager, PGPOOL, PGBouncer, pgbadger.
• Used pg_dump, pg_resotre, pg_basebackup,po_copy and other PostgreSQL built-in packages.
• Check the load Balancing and Replication and connection.
• Re-indexing and Vacuuming on Database from time to time.
• Knowledge on patroni, docker, etcd.
• Good hands on manage pg distributed tables.
• Experience on Linux and Windows platforms.
• Very good SQL and Shell scripting knowledge, cron jobs, database jobs.
• Write Shell script/Batch Script for monitoring, backup and day to day DBA automation.
• Work with new solution, design for new requirements and perform POC as per business requirement
• Experience to work in DBA pool and supported multiple clients 24*7 Production Database.
• Ability to multi-task and manage simultaneous projects, and function in a highly productive environment.
• Good with analytical and problem solving skills.
• Self-driven with excellent command in both spoken and written English. Bonus attributes Experienced as an Oracle database Administrator with specialization in ASM and RAC. Good expertise in Oracle s/w installation, configurations DB upgrades/patching/migrations in Oracle 11g, 12c and 19c. Oracle RAC administration & Configuration /backup recovery/performance trouble shooting. Working experience in Oracle RAC clusters, Data guard, 10g/11g/12c/19c Grid control. Experience to perform impdp/expdp at schema, table and database level. Develop archival, backup, recovery and DB refresh strategy. Perform database/instance tuning including monitoring, troubleshooting and optimizing performance of the databases. Excellent in DB troubleshooting skills and Performance Tuning, AWR, ADDM. OEM configuration and troubleshooting. Experience in Flashback & Rollback. Other Details Keywords