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
Noida07-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