Rajesh Garg

Experience

• 

  IOL Chemicals and Pharmaceuticals Limited

  Aug 2002 - Jul 2006

  Software Developer

  o Configuration and Installation of sql server 2000 database.o Develop successful backup strategies based on recovery model for accomplishing optimal data safety and to ensure nil loss of information.o Provide data to different department according to their requirements with the help of query Analyser.o Implement Replication Process to provide facility for transferring data between two different servers at different location.o Monitor jobs on daily basis and troubleshoot them whenever necessary.o Creation of users, logins, Database Objects as per Requirements.o Identifying technical bugs related to database, servers and networks and determining feasible solutions to them.o Implement new technology in the organization as per the company requirement.o Team management, training and coordinating with team members on technical issues and initiating result-oriented outputs.o Design, Document and Implement SOP (Standard Operating Procedure) for GMP (Goods Manufacturing Process)o Pivotal in installing Lotus Domino Server 6.5 on Windows 2000 Server and alleviating the issues related to Lotus Domino Server, Data of the users and NSF Files of Lotus client. Show less

• 

  Kinmart Supermarket

  Aug 2006 - Jul 2007

  IT Administrator

  o Configuration and Installation of sql server 2000 database and Lotus Domino 6.0o Develop successful backup strategies based on recovery model for accomplishing optimal data safety and to ensure nil loss of information.o Updating of Legend software from Softech South Africa specially use for supermarket, according to dual currency based on daily Base Exchange rate.o Test all the modules in ERP ebizframe by ESS (Eastern Software Services) and Point of Sale by Softech ( South Africa )o Provide training to all departments in super market about all the functions and working procedures of different modules in ERP i.e. sale, purchase, inventory, finance, costing and pay roll.o Successfully install Oracle9i as Database Server and Oracle 9ias as Application Server on Windows 2000 Server.o Implement unique identity of product (10000), inserting new product, transfer data, price updating, price verification for cash counter and balance machineo Implement new scheme to get more profit and save the daily loss due to exchange rate up-down between dual currencies. ( $ and local currency )o Control the security aspects of IT systems within the employees of organization and different areas of supermarket.o Solve all issues related to connectivity and installation of cash counter dual display machine, bill printers, cash drawers attach with printers and scanners.o Successfully setup whole network containing computer, laptop, cash counters and balance machine in Kin mart supermarket with the help of wireless router - Eusso and d-link access points.o Manage, monitor and maintain security for wireless routers, access point, operating systems/database and other technologies. Show less

• 

  Tech Mahindra

  Aug 2007 - Nov 2009

  SQL DBA : Technical Lead

  o Attend weekly meeting with release manager, senior programme manager, problem management team, network infrastructure team, change management team, development team, engineering team and senior support team.o Team management, training and coordinating with team members on technical issues and other general issues. o Responsible to solve all the technical issues and SR (service request) which escalated by members of Tier2 team related to SQL Database and IIS Servers.o Supporting day-to-day operations of the product, as well as performing backup and restore, initiating and confirming proper data grooming, running queries and scripts, assessing overall system performance, and identifying alerts and errors. Reference is made to troubleshooting procedures, where appropriate, which are detailed in KB articles or procedure documents.o Monitor jobs on daily basis, Creation of users, logins and Provide necessary credentials for jobs, users, logins and services.o Take care of all the performance related issues with the help of performance counter logs.( i.e. processor, physical disk, memory, sql server jobs, services, agents & sql server errors) o Maintain and Modify password for all service account used to running services in different applications.o Contact with Development team and provide permanent solution of the problem to the client if there is bug in any applications.o Hot fix Deployment for fixing Bugs, creating new Agents and run different sql scripts on servers given by development team.o To aware Network and Security team members, in case connectivity problem between any of the servers in different locations.o Support day-to-day operations of the product, as well as for routine maintenance, installation and upgrade. performing backup and restore, initiating and confirming proper data grooming, running queries and scripts, assessing overall system performance and identifying alerts and errors for different 7 applications having 70 servers. Show less

• 

  Wipro

  Nov 2009 - Apr 2011

  SQL Database : Project Lead

  o Installation of SQL 2008, Integration, Analysis & Reporting Services on Windows 2008 Server. o Setup mirroring for sql server 2008 databases and troubleshoot all the issue related to mirroring.o Deploy changes in Prod, UAT and COB servers manually and through internal application tool ‘Hermes Portal’ as per RFCo Create different type of reports for performance of servers, database growth and capacity planning.o Based on the request through incident ticket, provide the definition of database objects and different type of scripts (Database, Table, SP and permissions granted for logins)o Build new servers in Non Production Environment(Pre-Prod, Pre-UAT) and get ready for Production Environment (Prod, UAT) including adding of domain id in local administrator, installation of sql server, apply patches and creation of required logins, migration of database and mirroring setup.o Migrate the entire databases to another server before de-commission and rebuild new servers with the existing information. Show less

• 

  IOL Chemicals and Pharmaceuticals Limited

  Apr 2011 - Nov 2014

  Sr. System \ Database Administrator

  o To determine the strategic capabilities of the organization and plan, design and implement the information technologies.o To conduct the feasibility study for the new projects and further design a project schedule and allocate jobs to developers & to co-ordinate with the end user and development team throughout the Software Development Life Cycle.o Responsible for installation, testing, commissioning, and trouble shooting on production and development servers, Disaster Recovery, Backup & SQL Server database migration.o Database Administrator: Understand, develop and maintain the layout and process of the database of the organization and ensure that the data stored in the database is backed up from time to time and maintain high level security of the stored data and grant permissions to end users to view and access database. o Design, maintain, and implement database management systems which provide the organization with orderly methods of data storage and controlled access to critical data.o To install new/rebuild existing servers and configure hardware, peripherals, services, settings, directories, storage, etc. in accordance with standards and project/operational requirements.o To perform daily system monitoring, verifying the integrity and availability of all hardware, server resources, systems and key processes, reviewing system and application logs, and verifying completion of scheduled jobs.o To troubleshoot and maintenance of existing systems and infrastructure and to ensure that no work suffers due to maintenance deficit.o Implemented User, Application, Internet & Database Level Security for all the users & developers to avoid misuse of all running projects and to monitor data changes occurring in all the databases. Show less

• 

  Cintra: The Multi-Cloud Database Architects

  Jan 2015 - Apr 2016

  Sr. SQL Database Architect
• 

  HCLTech

  Apr 2016 - now

  SQL Server Database Architect & Infrastructure Support