I am a Database Consultant with 20+ years of experience on various RDBMS and NoSQL databases like Oracle, MS SQL Server, DB2 UDB, Hyperion Essbase and Cassandra. I've data modeling experience using ERWin on both OLTP and OLAP i.e., ER and Dimensional modeling. Extensively used PL/SQL and T-SQL programming to develop small business applications. I worked on various data migration projects and deployed HADR solution (Oracle Data Guard, RAC, Oracle Streams, etc.) for various customers on both hardware and virtual environments (VMWare). Moreover, used advanced security features like Oracle Advance Security (ASO) to configure SSLs between servers and clients. Also, engineered the high performance and zero downtime hardware and virtual appliances. Involved in capacity planning (i.e., sizing the hardware) activities to recommend the sizing needs depending on the customer workloads. Resolved numerous customer production database performance issues (related to infrastructure, design, application etc.) after thorough root cause analysis using AWR, ASH, DMV, SQL Profiling, etc.