Skill : PostgreSQL and OracleExp : 4-7yrsJob Location : Trivandrum
Should have experience in PostgreSQL and Oracle.
Strong proficiency in PostGres database administration and should have worked on 9.5 to latest versions 10.x, 11.x for both EDB and Open source flavors.
Must have experience in PostgreSQL database architecture, logical and physical design.
Good understanding of EPAS and PPAS architecture.
Installation and configuration of PEM.
Should be expert at User security and database security.
Creating and managing table spaces, tables and other database objects.
Should have experience in PosgreSQL upgrade between major versions and minor version upgrades.
Should have experience in PostgreSQL
Should be expert at configuring and maintaining replication.
Monitor and tune the Database performance on going basis .
Must have expertise in system tuning, resource contention analysis, backup and recovery, standby, replication.
Should have experience in PostgreSQL HA setup and multi node replication with standby fail overing.
Ability to pro actively identify, troubleshoot and resolve live database systems issues.
Strong understanding of command line and server administration.
Expertise in Oracle SQL server to PostgreSQL migration is a plus.
Experience in AWS RDS instance is a plus.
Oracle Database Administration Maintenance on Linux.
Oracle Bug fix, Patchset update and CPU Patching
RMAN Backup Recovery online Offline Archivelog backup
Export Import using exp imp and oracle data pump
Configuration and management of Oracle Net Services Listener
Experience in database level and session level Performance analysis.
Experience in Oracle RAC environment is a plus
Able to write Basic SQL statements .
Must have good knowledge of Linux.
Knowledge of shell scripting python.
BACHELORS OR MASTERS DEGRESS IN SCIENCE MATHS ENGINEERING COMPUTER APPLICATION