Plsql Admin{Contra} Jaipur

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