Sujeet Kumar (SQL server DBA)

Cell :( +**)-******9882wE-mail: sujeetsomy777 @gmail.com

Microsoft SQL Server DBA having 1.6 yrs. of experience

Key Skills: Microsoft SQL Server DBA

PROFESSIONAL EXPERIENCE

Professional with around 1.6 years of experience in handling IT and Support with over 1.6 years as a Database administrator (SQL DBA)

Working as a Freelancer

Looking forward towards making a significant contribution in the area of Technology & Networking Function of a growing organization.

TECHNICAL SKILL

Database Administrator in SQL Server

Database: SQL Server 2017,2012, 2008, 2008R2, 2005.

Primary skill: 1) SQL Server Administrator

2) Java, C, C++

Utilities and tools: Microsoft SQL Server Management Studio, SQL Server Configuration Manager.

Other tools – Net-Beans, PyCharm, TurboC, CodeBlock.

Operating systems: Windows 7/8/10, Windows Server 2012, 2008, 2008R2.

Having Good Communication Skills, able to deal with Customers efficiently. Also good Management Skills.

CAREER PROFILE

Freelancer

(July 2019 till date)

Project and Client: Freelancing

Skills

1.6+ years Experience in MS SQL Server (2017,2012, 2008,2008 R2,2005) database administration daily activities like Installation, Configuration, Database design & development, Backup & Disaster Recovery and Database Security.

Having good experience in managing large production Databases.

Performing activity like sql server installation.

Patching of Standalone and clustered SQL Servers.

Manage and maintain database security, including create/remove account, Create, modify and maintain roles, permission lists and groups.

Setting up alerts, Maintenance Plans, Jobs etc.

Troubleshooting jobs with different failure issues.

Managing login security and permission.

Performing point in time recovery of the database.

Detecting and fixing of orphan users.

Performing database health check.

Setting up the sql server agent jobs.

Configure database mail and trouble shouting the issue reported by clients.

Proficiency in SQL Backup/Recovery.

Having knowledge of index and stats.

Moving Database Data and logs file to different drive

Performing Always On failover on the sql server.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Applying service pack and CU updates on the sql server.

Perform Full Backups and Transaction Log Backups. Restore them whenever necessary; creating back up strategies and scheduling them for execution.

Indexing, Import/export data, backup restore database, managing servers.

Identifying the blocking at the instance and at the database level.

Having knowledge of checkpoint and lazy writer.

Migrate database from one server to another server.

Having knowledge of migrate login from one instance to another instance.

Migrate the jobs and alert from one server to another sever.

Monitoring CPU and memory utilization.

Secondary Skill:

Having knowledge of java standard edition.

Having fundamental knowledge of python.

Knowledge of object-oriented programming.

Knowledge of C and C++ programming

TRAINING DETAILS

MSQL Database Administration

Oracle 10g.

EDUCATIONAL QUALIFICATION

Year

Degree / Qualification

Institution / School, City

Performance

2013

Matriculation

S.B.S.High School,Ismailpur

59.80

2015

Intermediate

S.D.College,Paraiya,Gaya

73.60

2020

B.E(C.S.E)

Corporate Institute of Science and Technology

86.20

SUMMARY

Notice Period: Immediate

Relocate: Yes

Personal Profile:

Date of Birth : November 3rd, 1997

Passport : No

Declaration:

I hereby declare that all the statements made in the Curriculum Vitae including Enclosures are true to the best of my knowledge and belief.

Date: 11/01/2021 Sujeet Kumar

Signature

Contact this candidate