Sql Server Management

CURRICULAM VITAE

Mayank Soni

(Electronics and

Communication Engineering) Permanent Address: L-2/77-A (Near-Geeta Mandir)

Mohan Garden (Uttam Nagar)

Passport: K7303613 New Delhi 110059

Date of Birth: 18/07/1988

Marital Status: Unmarried

Contact No: +91-997*******, 971-***-****

Primary E-mail: ******.***@*****.***

Career Objective

“To give my best efforts towards the success of organization with my skills and knowledge in every prospect and thus, contribute towards organizational goals.

Work Experience

1. Organization : ITC InfoTech (Alight Solutions-Hewitt)

Designation : Database Administrator-SQL

Duration : Jun 2017-Till Date

Projects : FTS-SQL DBA

Job Profile : Team member

Role : SQL DBA-L2 + Support

2. Organization : Pinaki Softcon Pvt.Ltd (HCL Technologies Limited)

Designation : Database Administrator-SQL

Duration : Mar-2016-June 2017

Projects : JTI-Transformation (Geneva)

Job Profile : Team member

Role : SQL DBA-L2 Support

3. Organization : TCS Limited (Merge CMC Limited)

Designation : Customer Services Engineer

Duration : Jan2013-Mar2016

Projects : L’Oreal, Parle, Croma

Job Profile : Project Coordinator (North Region)

Role : SQL DBA-L2 Support

Territory cover : Pan India (Mostly North India)

4. Organization : CMC Limited

Designation : Customer Services Engineer

Duration : Sep 2011-Jan 2013

Projects : L’Oreal, Parle, Croma

Job Profile : Project Coordinator (North Region)

Role : SQL DBA

Territory cover : Pan India (Mostly North India)

Professional Summary

6 + years of experience in SQL DBA(L2 + Support) for very Large databases in SQL Server2016, 2014, 2012, 2008 R2, 2008.

Knowledge technical background along with the ability to perform business analysis and write effective documentation and specifications

Basic Knowledge of Mongo DB, AWS (Amazon Web Services)

Expert in data Transformation services like BCP and Bulk insert

Experience on 32/64 bit SQL Server 2016,2014, 2012 systems and MSCS Configurations.

Experience in Batch Processes, Import, Export, backup, Database Monitoring tools and application support

Strong experience in mentoring team members and writing documentation.

Online Call support for Distributors/Client

Role/Responsibilities

Installation and configuration of database instances and instances as well as clients

Responsibilities as a SQL Server Database Administrator include installation, creation, maintenance and optimization of databases for various clientele projects.

Database instances configuration, change, for example DB recovery model, DB or server collation, memory allocation, CPU allocation, degree of parallelism, and any other potential configuration option

Security management, database instances configuration as well as logins creation, change, removal

SQL Jobs management, creation, change, removal and monitoring

Knowledge of SQL – data extraction, updation and maintenance

Performance monitoring and tuning of SQL server instances and databases. Regular review of database health checkup and Backup monitoring for SQL database

Monitoring the server for High availability of the servers.(Mirroring, Log shipping, Replication, Always On-HADR, Clustering)

Basic Experience on SSRS, SSAS, SSIS

Solving the request raised by user support.

Participate in implementation of new releases into production.

Configuration and management of database cluster environments for high availability services

Designed and implemented Security policy for SQL Servers.

Used Stored Procedures, DTS packages, BCP for updating Servers.

Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.

Database maintenance

oProactive space allocation management of the data files and log files

oIndex maintenance (rebuild or reorganization) must be performed on a regular basis (weekly and monthly) based on the activity, downtime windows and usage patterns

oTable / Index Partitioning management, DOP settings criteria

oMaintain up-to-date database statistics

oRegular review of index usage (missing indexes, unused indexes), provide recommendation

oPerform weekly or monthly database integrity check

oData or log file reorganization and management

oTransactional or merge replication monitoring and management

oManage database and objects compression (PAGE)

Database upgrade with latest patch levels in accordance with JTI’s needs

Backup and recovery, creation and management of ADMIN database management

Maintenance of database management scripts (backup, fragmentation analysis)

Management of JTI’s disaster recovery configurations including but not limited to clustering, log shipping, SQL server mirroring, SQL Server Always On and etc.

RDBMS under management

Knowledge: MS OFFICE, SQL Server (Indexes, Stored Procedures, Tables etc), Database Administrator, Basic Networking, SAS(Data mining)

Operating System: Microsoft Window

Prior Client facing experience

Academic Credentials

Degree

Name of Institute

University/

Board

Year of Exam

Percentage

Master of Business Administration(MBA)

-Information Technology(IT)

Sikkim Manipal University

Sikkim Manipal University(SMU-DE)

2013-2015

72 %

Bachelor of Technology(B.Tech)

-Electronics and communication(ECE)

Swami Devi Dyal Institute of Engineering & Technology

Barwala, Distt.Panchkula (Haryana)

KURUSHETRA UNIVERSITY (Haryana)

2006-2010

74%

Intermediate

Govt Boys Sr Sec School Rajouri Garden (Main),New Delhi

CBSE Board

2005

55%

High School

Sarvodaya G SSS-1 C Block,Janak puri, New Delhi

CBSE Board

2003

58%

Project Undertaken / Experience

Project of core java & Asp.net

Designed a Multifunctional Robot

Completed a project on IR sensors using Atmel microcontroller

Major project of “Biometric Fingerprint Based Attendance system”

Design a RF transmitters and receiver.

Design operational amplifier based circuitry.

Four Days (2-Jan-2014 to 7-Jan-2014) Cadence (CIC Flow) Training in CMC Limited.

6 Weeks Industrial Training in Creative Automation (Ghaziabad-201001) under PLC

3 days Workshop conducted by TECNOPHILIA SOLUTIONS in association with INNOVISION’08 ON fundamental of robotics held at PUNJAB ENGG. COLLEGE

SEMINAR –Cruise control system.

Appreciate Award for HCL Technologies for Jan2017 (JTI Project).

Appreciate Award for CMC Limited in 7 Oct 2013.

Won prize in painting competition at district level in school.

Participated and won second prize in a remote controlled robotic race event at a robotic workshop

Organized by Technophilia solutions.

Won second prize in “national children science congress” at science center no 3, New Delhi.

1st prize of LAN gaming in festival of SDDIET Engineering College

Work systematically with a pre planning to just complete the work within time.

Confidence, Good team player & Positive Attitude

Ability to perform under pressure

Ability to multitask working

Work collaborates with different people.

Honesty & Ability to absorb Technology Faster.

Declaration

I hereby declare that all the statements made above are correct to the best of my knowledge and belief.

(MAYANK SONI)

Contact this candidate