About

Rishika Jaiswal is a highly skilled Database Specialist and DBA with over 5 years of experience in the industry. She has a strong background in various database environments, including MYSQL, greenplum, Postgres, Vertica, and Teradata. Rishika has also worked with Business Intelligence Tools such as MS-BI, Pentaho, Abinitio, and Informatica for over 4 years. She is proficient in writing Bash and Powershell scripts and has a good understanding of reporting tools like Pentaho and Microsoft Power BI. Rishika has experience in designing and implementing data warehouse solutions by doing data modeling and implementing ETL using technologies like Pentaho PDI and Abinitio. She is skilled in optimizing/tuning ETL objects, indexing, and partitioning for better performance and efficiency. She has hands-on experience in installing, configuring, managing, monitoring, troubleshooting, upgrading, and migrating Greenplum Servers, Postgres, MySQL, and Greenplum on Clustered and Standby Environments. Rishika has implemented different types of DR (disaster recovery) scenarios and Backup/Recovery models. She is also experienced in writing Stored Procedures, Functions, and Triggers using T-SQL/PL-SQL and is an expert in tuning Complex Queries. Rishika is proficient in using tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning database performance and resolving Deadlocks/Long running queries. She has expertise in implementing security models, Database authentication modes, creation of users, configuring permissions, and assigning roles to users. Rishika has excellent problem-solving and communication skills. She is a strong time manager and an excellent team player with the ability to work on multiple technologies. She is proficient in features of Abinitio like EME, Components, Graphs, plans, etc. Rishika has experience in delivering solutions in the Telecom domain. She also has good knowledge and experience in Unix, Java, J2EE, JSP, JDBC, Bootstrap, HTML, CSS, JavaScript, Teradata, and Informatica. Rishika is certified in Java, PHP MySQL, Bootstrap & CSS, Scrum Master. She has experience working with Operating Systems such as Windows 7/Vista/XP/, Windows Server 2003/2008/2012, Linux RHEL 6.6. Rishika has worked with databases such as MS SQL Server 2008R2/201