Oracle/PostgreSQL DBA

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Hallmark Global Technologies, is seeking the following. Apply via Dice today!Please refer below the JD of an open position for Oracle/PostgreSQL DBA. Let me know if you have anyone with these skills.Duration: 6 monthsLocation: Onsite Plano, TX.Technical Requirements: PostgreSQL database Administration, in-depth hands-on experience is a must.Good experience PostgreSQL DBA activities.Strong experience in PostgreSQL Performance Tuning and OptimizationOracle DBA experience managing databases on Linux/AIX/HPUXOracle 11g, 12c, 18c and 19c Database AdministrationOracle Real Application Clusters (RAC)Oracle Exadata and Oracle Database Appliance (ODA) administration.Database, Hardware/Appliances Migrations, Upgradations and PatchingOracle Goldengate Replication.Oracle OEM 12C (Oracle Enterprise Manager).Oracle Data Guard.ASM/ACFS (Automatic Storage Management/ASM Cluster Filesystem).Good troubleshooting skills.RMAN Backup & Recovery.Database & SQL Tuning and Performance analysis skills.Automations using Ansible, Python and Unix Shell Scripting.Oracle Certification in Exadata, Oracle RAC and Oracle 12c or higher Versions.Hands on experience backup strategy and high availability in production databasesSkilled at optimizing large, complicated SQL statements in PostgreSQL. Strong experience in performance tuning on SQL queries.Experience in table partitions Strong experience in JOINS and Sub QueriesSkilled at optimizing large, complicated SQL statements and stored procedures, functions.Strong with common database procedures such as upgrade, patch, recovery, migration, HighAvailabilityEnsure performance, security, and availability of databases.Need to have strong experience in PostgreSQL HIGH Availability Solutions.Design and develop PostgreSQL systems including statements, data modelling, tables, views, and indexes.Knowledge of best practices when dealing with relational databases PostgreSQL. Setting up the configuration parameters in PostgreSQL Database.