As DBA on data warehouse project, use Greenplum installed in four 18-node clusters with 30 TB data on each, to provide full cycle of development, testing and production. Work under database and hardware maintenance and upgrade. Provides technical expertise and oversight regarding Greenplum solutions.
Provides overall Greenplum installation and maintenance strategy
Designs Greenplum database server farms infrastructure for high load
Optimizes Greenplum database objects and table structures
Optimizes Greenplum query structures
Define role-based workload management
Monitor , backup and restore
Contact with EMC technical support to resolve complex issues
Deployment EMC recommendation
Develop scripts for automation activity
Monitor, install and upgrade Oracle DB
Achieve stability and best performance in four Greenplum clusters.