Kshitij Agarwal Email & Phone Number

Mumbai Area, India

Formulate Technology Strategy in close alignment to Business Strategy and performing the role of technical advisory to business.Updating and upgrading with the latest Technologies. To ensure that company assets are well maintained.Oversee the administration and maintenance of IT infrastructure. Implementing IT security policies. Developing and deploying IT policies, standards and procedures, and assured users’ awareness.Implementation of best practices for cyber security like encryption,2FA, application security, SSL/TLS.Installation, Configuration and Troubleshooting of Domain Controller and Additional domain controllers.Group policy implementation for domain and auditing. IIS administration for the local site / Application.Troubleshooting and resolution of issues identified with ODP.NET and/or Oracle, Silverlight and IIS.Providing technical support for hardware/software configurations and applications.Administering change management related to server upgrades and software installation. Preparing and maintained documentation of technologies, standards and procedures.Prepare Software Architecture Document with team.Prepare Project Implementation Plan with team.Ensure the Application Hardware, Software, Framework, OS, Browser Compatibility. Perform VAPT for .Net Applications.Provide 24X7 onsite and remote database support.Install, upgrade, and configure database.Manage Disaster Recovery sites using standby database.Implement new Oracle version. And suggest the developer for required changes.Develop and implement scripts for routine tasks, diagnose problems and remediate problems when they occur.Ensuring Database backup (Logical, Cold, Hot) using RMAN and Data Pump.Database Recovery.Performance Tuning & Monitoring.Capacity PlanningCoordinated extensively with applications development team in day-to-day problem solving relate to database and applications.Conduct knowledge transfer sessions time to time to guide support team.

Indore

Lead and supervise the EDP Department members.I am maintaining complete IT back office system like LD, LD ASP, LD Diet, LD Digital, LD LTM, LD Rakshak.Maintaining all back office computer systems.Maintaining Backoffice / front office local area network / internet through AMC Vendor.Maintaining production database.Ensuring Database backup (Logical, Cold, HOT) using RMAN and Data Pump.Mainstay with database recovery / restoration techniques either point-in-time, archive log missing, loss of datafile, block corruption, or many other scenarios as per requirement.Daily Database monitoring which includes Alert log checking, Locks checking, Jobs/Scheduler checking, Tablespace monitoring, Wait events monitoring, Backup management, Top session monitoring, Top SQL monitoring etc.Handling the capacity issues, planning the current and future storage requirements for the database management system.Prepare Training Materials and conduct training sessions for configure, use & trouble shoot the application.Continuously following up with the key accounts to understand their requirements, and accommodate change requests.

Noida, Uttar Pradesh, India

Maintaining complete back office system like LD, LD ASP, LD Diet, LD Digital.Install, upgrade, and configure database and application software.Installing product at remote sites through tools like Remote Admin / VPN / VNC etc.Maintaining production database.Maintaining system security at various level by granting and keeping track of privileges and roles to the users and auditing to reduce overhead, improve throughput and promote security.Ensuring Database backup (Logical, Cold, HOT, RMAN) and RMAN recovery process.Mainstay with database recovery / restoration techniques either point-in-time, archive log missing, loss of datafile, block corruption, or many other scenarios as per requirement.Perform Database Refresh using RMAN.Maintain Test Database Environment for software update management to check new functionality or check some critical tasks before deploying to the Production server.Database upgradation.Work on Migration project. Moved server from one production site to another. Database cloning using RMAN.Disaster recovery using standby database in failover situation.Multiplexing control files and archive log files for recovery purpose.DDL and DML activities like Table creation, Index creation, Compiling invalid objects, Synonym creation, copying data from one database to other, Database links creation etc.Writing VB scripts, DOS scripts to manage jobs for RMAN backups, Export database, Analyze database and other tasks with status email notification using Windows scheduled tasks utility.Daily Database monitoring which includes Alert log checking, Locks checking, Jobs/Scheduler checking, Tablespace monitoring, Wait events monitoring, Backup management, Top session monitoring, Top SQL monitoring etc.Database Statistic Maintenance. Handling the capacity issues, planning the current & future storage requirements for the database management system.Monitoring system performance and maintaining good system response at all time.

Noida, Uttar Pradesh, India

• Managed IndiaMART Adwords Account.• Data Mining and Data Analysis.• Categorization of Automobile, Medical, Electrical, Sports, Industrial Supplies and all other categories.• Find 40,000 new products, review existing 20,000 products, retain actual products and mapped into relevant categories.• Research, reviewing, analyzing, organizing & cleaning searched data keywords and transform it to Product Categories.• Gathered data - product categories from websites and entering it into excel spreadsheets.• Searched the web, creating lists of target websites, and collecting information from these sites.• Gathering precise and updated information about competitors' website, research data and blogs.• Quality checking to maintain consistent accuracy.• Worked as Editor, Proof-Reader on Auto-Sourcing Guide, Apparel Sourcing Guide, Engineering Sourcing Guide, Medical-Sourcing Guide and Handicraft Sourcing Guide.• Page content selection, cross checking the facts, spellings, grammar, writing style, design pages.• Edit and query/reject all inconsistencies found between source data, completed proof and all relevant reference information.• Follow established guidelines to proofread source data and final printer ready pages prepared for Product Category, Product index, image listing sections of a published directory and mark up correction as needed on final pages.• Test the Client Websites & MDC.• Test the Indiamart Directory, Catalogs & Trade Modules.• Test the relevancy of Product-Category Mapping.

B.Tech, Computer Engineering

Activities and Societies: Ideas, Innovation

10+2, Mathematics

Activities and Societies: New Study and Teaching methodology