Badges

55 Points
7 Years

User Activity

Over 7 years ago
Contributed a review of Vertica: Replication is the main feature for my use.

Reviews

About me

4+ years of managing large scale (100+nodes, over 180 TB ~600 users) Production experience with HP Vertica Database.
7+ years of Database admin experience with Oracle Databases.
Good understanding on vertica DB and spread configuration, projection design, segmentation, partitions, purging, Move out, Merge out, ROS, WOS, and delete vectors, in vertica.
Expertise with migrating data to Vertica from Natezza and Sql Server Database
Experience with install, create and setup huge vertica clusters up to 100 nodes and 300TB size Db clusters.
Experience in migrating the vertica DB cluster from one site to another site using the vertica copy cluster tool.
Experience in setting up the DR sites for huge clusters sized up to 150 TB with Both Dual loads and Copy cluster setups.
Experience in Running the DBD and creating the needed projections/query specific projections using the proper encoding and segmentations to keep the sql’s run with no issues.
Experience in upgrading the vertica to the newer versions and applying hot patches.
Proficient in expanding and rebalancing the cluster by adding nodes to a vertica cluster to scale up the capacity.
Experience with using the Vertica DC/System tables to keep the clusters run with no performance issues .
Deep knowledge and experience with Diagnosis vertica performance issues,
Expectance in capacity planning for DW systems.
Involved in design and Experience with vertica external tables setup.
Experience in setting up the Ldap Authentication in vertica DB’s.
Experience with toga/oem to monitor the DB clusters.
Involved in all development, qa and production support.
Experience with Oracle Production logical and Physical Standby systems.
Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TNS Names, SQLNet, V$ and DBA views.
7+ years of RAC (9i, 10g&11g) with proficiency in setting up and administering 9i, 10g&11g RAC.