Raj Kumar Singh

Background

About Raj Kumar Singh

Currently working in EY as a Data Modeler and Database Architect having 13 years of experience in application design, development, enhancement and maintanance using multiple database like Oracle 9i, 10g, 11g and SQL Server 2008, 2012. • Experience in various domains like Investment Banking, Finance, Pension and Insurance. • Experience in all phases of Database life cycle(DBLC). • Expertise in MSSQL / SQL Server Internals (DM Views, DBCC Commands…etc.) and Architecture. • Good Experience in Database Migration, Data Scrubbing. • Good Experience in Handling large Scale Databases Sizes in More than 1 TB (per database) Under Heavy Pressure and High Concurrency. • Experience in creating stored procedures, PL/SQL packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling. • Good exposure to Advanced PL/SQL (Collections, RefCursors, Analytical functions and Partitioned Tables). • Experience in Performance Tuning (Explain Plan, Query Optimizer, TKPROF and SQL Trace using AWR). • Experience in implementing index and table partitioning, hands on exposure to global and local partitioning. • Experience in using SQL Profiler for debugging database objects like procedures, functions and packages. • Experience in SQL* Loader and External tables. • Experience in designing and developing OLTP and OLAP databases. • Good Experience in Logical, Physical Data Modeling & Re-Modeling Complex Data Models (More than Entities) with High Degree of Normalization & De-Normalization. Good in Forward and Reverse Engineering. • Good Experience in Data Modeling tools – Erwin, Microsoft Visio and Oracle Data Modeler.