Postgresqloracle

Job Description

PostgreSQL + Oracle  JD

Must gave have relevant experience and in-depth knowledge in any PostgreSQL administration task

A database administrator's responsibilities can include the following tasks:

• Perform installations and upgrades of PostgreSQL (Preferably PPAS 9.4+)

• Plan and perform DB Patching.

• Knowledge of Database backups / Troubleshoot failures, query execution plans, performance tuning techniques

• Define maintenance plans.

• Configure / Troubleshoot Replication (BSR / xDB SMR / xDB MMR)

• Set up disaster recovery

• Perform Fail-over and Fail-backs

• Hands-on knowledge in Oracle to Postgres DB Migration

• Monitor servers through PEM

• Capacity planning

• Script database changes

• Knowledge of NOSQL databases

• Experience with latest versions PostgreSQL EDB versions

• User Administration and Security

· Install, configure, upgrade, and manage Oracle database systems

· Oracle 10, 11g, 12c

· Strong Experience in managing large databases, partitioning, Data warehouse experience

· Configure / Troubleshoot Oracle replication (Oracle GG)

· Hands-on knowledge in Oracle DB Migration

· Monitor servers through Oracle OEM

· Proficient in backup & restore methodologies, Tuning databases, refreshes, Reorgs and script writing.

· Apply patches, Proficient in managing RAC cluster and DataGuard databases.

· Coordinate with various teams and customer to schedule database activities

· Maintain detailed documentation of DBA processes and procedures.

· Experience in executing DR activities, database upgrades and patching along with all the regular database maintenance activities.

· Accountable for performance and capacity management for databases

· Should have worked with backup appliance zfs & zba configuration

· Experience with Linux OS

· Remediation of Security Vulnerabilities