Shashi Pratap

Experience

• 

  A J infotek

  Sept 2004 - Jan 2006

  Developer

  Web based application work for Northen Railway, Excise

• 

  Iterate India Private Limited

  Feb 2006 - Feb 2007

  Sr. Web Developer

  Web application for Automobile company (General Motors, JCB, Maruti)

• 

  FCS Software Solutions Ltd

  Feb 2007 - May 2010

  Sr. software Engineer

  • Database administrative work cum development as leading project• Innovation, speed and Quality work & Delivery• Advice to developer and provide solution on the most efficient database design as tables, stored procedure, UDF etc.• Project management, documentation, make plan (OPDC), logical thinking, and derive it.• Worked in Teams and supervised the team.• Make RDMS as per business logic and requirement with future scope.• Technically leading the project and maintenance as well as server work (Database Admin).• Standards while coding after requirement analysis. Involved in R&D work as per demands of the project.• Help testing team for testing of the worked done by the development team.• Worked closely with the clients to define the specification and document and features required for the system. Able to take orders and get the job done promptly• Strong works Ethic and always getting the job done on time.• Designing Database, Coding, Deploying the project are the aspects of my profile delivering them on time.• Worked with major clients like Maruti Suzuki India Ltd., General Motors India Ltd., Canon Singapore-Japan -china, Northern Railway, Excise Department (Delhi Head Quarter). Show less

• 

  Canon India

  Jun 2010 - now

  Tech Lead

  • Database recovery and backup management as routine basis (Make further plan for restoration).• Troubleshoot SQL server service as occurring, Performance issue, deadlock, disk etc• Configure SQL server Monitoring utilities to minimize false alarms• DBA experience working in a highly available, reliable, secure and high transaction /up-time Clustered Production environments. (Installation and configure as Clustering, Replication, Log shipping).• Database design, Requirements analysis, Database analysis, Develop (PL/SQL) and deploy database solutions using Microsoft SQL Server, 2014/2012/2008 /2005 /2000, and T-SQL.• Maintain document and update company database environments.• Experience in designing, developing, deploying, administering, Query optimizing, Performance tuning and maintaining SQL Server databases and ETL (From Heterogeneous Database source) like Oracle, PostgresSQL. • Whenever performance issue arise, determine most effective way to increase performance including hardware, server configuration change, index or query change. • Design indexes for existing applications, selecting when add or remove indexes.• Strong analytical & research skills. Involved in database design, form validation, procedures & function.• Strong experience designing and implementing ETL solutions using Microsoft SQL Server Integration Services (SSIS) and Microsoft Visual Studio (3.5, 4.0, 4.5).• Incident management, backup and restoration management, disaster management (Business continuity plan). • Experience in Database performance monitoring, tuning and troubleshooting, index management and Maintenance, and setting up alerts.• Equally effective working independently or collaboratively, Work well under pressure and enjoy challenging projects.• Expiries in Technologies (SQL server (2000/ 2005/ 2008 /2014), PostgresSQL, PL/SQL, SSIS, SSRS, Oracle9i-11g, also little bit knowledge of ASP.net C#, Classic ASP). Show less

• 

  Canon Singapore Pte Ltd

  Jul 2019 - now

  ASP.net, SQL Sever 14 years Exp