Nihit Kumar Email & Phone Number

Gurugram, Haryana, India

The client is an international specialty insurance firm that provides distribution, underwriting, product development, administration, and risk management services by acting as a wholesale broker and a managing underwriter.Serve as a MySQL/MS SQL administrator & developer to design, customize, and implement solutions for wholesale brokerage platforms within the organization.• Ensure performance, security, and availability of MySQL/ MS SQL databases.• replication configuration in MySQL/MS SQL• Knowledge of de-facto standards and best practices in MySQL/ MS SQL databases.• Installing & and re-configuring the MySQL 8.0, 5.1, and MS SQL Server 2017, and 2019 with more normalised integrated data.• Re-writing MySQL/ MS SQL Queries and tuning Stored Procedures in a more normalized way to suit the requirements of clients due to migration/ Import-Export from MySQL DB to MS SQL server.• Creating a new MySQL/ MS SQL Server Backup-Restore plan with Full, Incremental, and differential backup Job scheduling in SQL Server agents.• Use DML, DDL, and TCL Queries and maintain the MySQL/ MS SQL databases according to specified configuration.• Handling client inquiries directly via ticketing tools such as Jira, Service Now, Freshdesk, or team calls. • Profile server resource usage, optimize and tweak, as necessary.• Analyze SQL Scripts for performance improvement.

Jaipur, Rajasthan, India

Project Name: Enterprise Reporting & Client Loyalty Management • ER team is responsible for database & client-specific report development/maintenance for thousands of automotive dealers worldwide.• It involves Doing ETL (SSIS, SSAS), SQL Server along with Greenplum(PostgreSQL) on the reporting tool: Pentaho.• Dealing with data concerning all the vehicles in various Automobile OEMs ( PORSCHE, FORD, GENERAL MOTORS, AUDI, HYUNDAI & GENESIS, TOYOTA, SUBARU, BMW/ MINI, VOLVO, NISSAN & Infinity) corresponding to their dealers.• Project involves receiving data in raw files and then processing this data via SSIS and SQL server for analysis made through deploying SSAS cubes. • Providing application support to the entire Client site 24x7 (PST & EDT)• Responsible for preparing customer-facing reports(on-demand & Subscription) in various OEM’s specific Portals, based on processed data which in turn provides dealers an insight into their performance.• Handling clients directly via mail chat or team voice calls.• Project is targeted to provide business data to various vehicle dealers for better analysis which would be required to expand/improve their business.• Providing application support to the entire Client site 24x7.• Report generation as per requirement. • Writing SQL Queries and stored Procedures as per requirement of clients Vendors.

Chandigarh, India

Worked as an MS-SQL & MySQL DATABASE ADMINISTRATOR in VAYAM TECHNOLOGIES LTD under NIC (Govt of India). • Working on the CCTNS Project, where i have to perform everyday database various admin tasks.• Maintenance and configuration of migration.• Replication, Mirroring issues, Backup, and Recovery.• Creating. Logins, and assigning Roles & and permission. keeping the database up to date by keeping all the details of the user assigned, by providing 24/7 support.•Installing and configuring the SQL Server 2008 R2, 2012, PostgreSQL-12.5, PG-Admin 4, • SSRS, SSAS report generation as per requirement.• Analyze SQL Scripts for performance improvement.• Knowledge of MySQL features, such as its event scheduler in workbench.• Prepare documentation and specifications!

Indore Area, India

• Making daily reports like DB monitoring, backups, and health check reports.• Monitoring alert log files and instance status.• Cloning Database from production to test using database backup• Maintenance of the production database which includes table space management• Monitoring Cluster services for both instances, cluster status, and listeners• Writing & and tuning new PL/SQL Stored Procedures, Views, Triggers, Index, and Functions & and modifying existing ones and tuning them such that they perform well optimized.• Implemented auditing using triggers and enforcing business rules via checks and constraints.• Proper use of views to prevent unauthorized access to sensitive data by creating privileges to new user logins.• Creating and modifying SQL script to create the tables, views, Indexes, and Functions, implement new business rules, to populate the tables in a well-organized manner. • Established secure connection to various Servers.