Summary
Overview
Work History
Education
Skills
Certification
Languages
Personal Information
Hobbies and Interests
Projects
Disclaimer
Timeline
Generic

VIJAY KUMAR

Noida

Summary

Would like to work as a team member with an organization where I can utilize my skills and expertise in the interest of the organization and in the process, be able to consistently grow in the hierarchy ladder to become a good professional. Keen to learn new skills during the work process.

Highly accomplished and deeply dedicated Microsoft SQL Server Database Administrator / application Support with successful 14 years with track record of successful implementations with MSSQL 2017,2019,2022 database software including database architecture database design, database replication, data mirror\HA, data migration, performance tuning and disaster recovery planning. Proven ability to accomplish highly technical and complex endeavors in high security, multi-tasking, team-oriented environment.

Overview

19
19
years of professional experience
1
1
Certification

Work History

MS-SQL DBA

Kyndryl
09.2021 - Current
  • Administration and maintenance of MS-SQL Server Database.
  • Manage Backup and Recovery process of the databases.
  • Database Security and integrity with proper ITIL process.
  • Current Project: ABM AMRO BANK (Onprimise/Azure SQL Managed Instance).
  • Role & Responsibilities: Work from client location ABN AMRO Bank Neither land.
  • Have experience of code optimization to improve performance.
  • Defining suitable methodology to undertake the project with the available inputs for the requisite output; providing technical guidance/support to the SQL Application Development & Database Development Team for troubleshooting and debugging of applications.
  • Undertaking code review, debugging, and troubleshooting of the application; extending post go-live and application maintenance support to the client.
  • Migration Treatment (Lift & shift Rehost/Replat form/Retain).
  • Azure Migration PAAS, IAAS (DMA, DMS, SSMS, Backup-Restore using URL).
  • SQL Database Backup/Restore through Azure blob storage.
  • High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
  • Installation and Configuration of SQL server version (2008/2012/2014/2016/2017).
  • Experience with backups, restores and recovery models.
  • SQL Automated Health check Report through (SQL Script).
  • Database Migration/Up gradation/Downgrade.
  • Performance Optimization(Reorganize/Rebuild/Update Stats/Integrity Check) and Tuning.
  • Alwayson with DR drill.
  • Controlling access (login, User) permissions and privileges.
  • Monitoring performance and managing parameters to provide fast query responses to front-end users.
  • Applying SQL Server database service packs and patches and troubleshooting all database related issues.
  • Troubleshooting with (DBCC, DMVS, System SP, SQL Profiler, Perfmon, Trace, X-Event)

MS-SQL DBA

IBM
05.2016 - 08.2021

SQL Database Administrator

Briskon
10.2013 - 11.2014
  • I worked with profile of Database Administrator L2-L3 support.
  • I am managing more than 1000 of databases of size varying from 50GB to 2 TB.
  • Installing, Configuring and Administering SQL server 2005.
  • Installing latest service packs and patches on production server.
  • Perform database backups and database restores.
  • Troubleshooting any SQL related issues in MS SQL database Servers.
  • Manual Monitoring and maintenance of the index fragmentation through DMVs.

Application Support

DION
03.2007 - 09.2013
  • My work profile assists with troubleshooting and issue resolution relating to current applications, providing assistance to the development.
  • Provide ongoing internal reporting of performance measures and service levels.
  • Champion and promote service improvements on an ongoing basis to continually improve the quality of services delivered and customer satisfaction.
  • Manage and coordinate hot fix and maintenance releases.
  • Dion Global Solutions is a leading technology solution provider, partnering with global banking and financial institutions to optimize the processing of business operations and transform their customer experience. With over three decades of experience in building creative software solutions for Trading; Distribution Products like Mutual Fund, IPO, OFS, Bond & FD, risk and compliance, we understand the needs of our customers and build customized solutions to address their specific requirements.

Education

Azure Cloud Administration Training -

Ducat Noida
Noida
07-2018

MCA -

01-2005

BCA -

01-2001

12th -

01-1995

10th -

01-1993

Skills

  • Dedication to work
  • Commitment to meet deadlines
  • Hardworking
  • Patience
  • Learner
  • Optimistic
  • Determination
  • Database migrations
  • Performance tuning
  • Backup management
  • Disaster recovery
  • Security management
  • SQL optimization
  • Process improvement
  • Client support
  • Project coordination
  • Database Performance Tuning
  • Database upgrading
  • Database administration
  • Database analysis
  • Database automation

Certification

  • Microsoft Azure Fundamental Certified, AZ-900
  • Microsoft Azure Database Administrator Certified, AZ-104
  • Microsoft Azure Data Fundamentals Certified, DP-900
  • Microsoft Azure SQL SOLUTION DP-300

Languages

English
Hindi

Personal Information

Father's Name: Jagdish Prasad

Address: H/16060, 16Th Avenue Gaurcity 2

                  Greater Noida West

Hobbies and Interests

  • Listening to music
  • Playing Cricket
  • Cooking
  • Indian History

Projects

  • ABM AMRO BANK, Onpremise/Azure SQL Managed Instance, Technical Specialist
  • Dion Global Solutions, Leading technology solution provider for banking and financial institutions

Disclaimer

I hereby declare that the information furnished above is true to the best of my knowledge.

Timeline

MS-SQL DBA

Kyndryl
09.2021 - Current

MS-SQL DBA

IBM
05.2016 - 08.2021

SQL Database Administrator

Briskon
10.2013 - 11.2014

Application Support

DION
03.2007 - 09.2013

Azure Cloud Administration Training -

Ducat Noida

MCA -

BCA -

12th -

10th -

VIJAY KUMAR