Software Engineer Sql Server
Resume:
Vaibhav Chavan
****************@*****.***
Career Profile
A qualified IT Professional having 6 years of experience, with effective communication skills, who can work well in a busy environment and especially, enjoys being part of a team, a capable person who is willing to learn new skills and methods of working. Seeking to build my career where I can use my practical skills to its full potential.
Career Objective
To apply information technology skills to contribute to the success of a leading edge organization in a globally competitive environment.
Career Experience : 6.2 years
Working with Xchanging Malaysia Sdn Bhd, A DXC Technology - YTL Company (Kuala Lumpur, Malaysia) since August 2016 – Till Date.
Designation : Database Administrator
Worked with Rolta India Pvt Ltd (Mumbai, India) since March 2015 – August 2016.
Designation : Software Engineer
(Worked with Onsite client SAP HUNGARY KFT., in Budapest, Hungary, Europe from 17th Nov 2015 to 11th Feb 2016)
Worked with Capgemini India Pvt Ltd. (Mumbai, India) since September 2012 – March 2015.
Designation : Senior Software Engineer
Technical Proficiency:
Database Skills
RDBMS
SQL Server 2005, 2008 R2, 2012, 2014, 2016 and 2017
Database Systems
SQL server 2000/2005,SQL server 2008 r2,SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, Microsoft Azure, Amazon Web Services, MYSQL 5.6 and 5.7, Oracle 11g, SYBASE, Golden Gate, SAP HANA
Operating System
Windows Server 2008, 2008 R2, 2012, 2016, Red Hat Ent Linux 7.4
Education
Degree
University
Year
Percentage
Bachelor of Engineering (Computer)
Mumbai University
2012
70%
Higher Secondary Certificate (Science)
Maharashtra State Board
2008
67.67%
Secondary School Certificate
Maharashtra State Board
2006
89.06%
Other Activities/Achievements
1.MCTS (Microsoft Certified IT Professional): Exam 70-462 Administering Microsoft SQL Server 2012 Databases.
2.1Z0-883 MySQL 5.6 Database Administrator: Completed training in March 2017.
3.Amazon Web Services: Completed Hands on Practical Labs. Infrastructure & Developer session conducted by Amazon Web services in Kuala Lumpur, Malaysia in May 2017.
4.ITIL V3: Certified in ITIL® Foundation Certificate in IT Service Management.
5.Lean Six Sigma white belt certification
Current Employee Duration
Designation : Database Administrator
August 2016 to Till Date
Company: Xchanging Malaysia Sdn Bhd, A DXC Technology - YTL Company, Kuala Lumpur, Malaysia.
www.xchanging.com
MSSQL Clients : YTL PowerSeraya, Express Rail Link, Kaspersky, Enterprise data warehouse, NSMI, Symantec Endpoint Protection Manager(SEPM), YESMON
Job Profile & Responsibilities
Database administrating with proficiency in SQL Server 2008 & 2008 R2, 2012, 2014, 2016 & 2017 Production Environment.
Providing support to 460 Production databases on a cluster environment with 24*7 DBA support and same number of Staging, Development and QA Environment databases. Size of the production databases range from 1GB to 4 TB with total size of 20 TB for all databases.
Deftly manage Installation, Upgradation, Migration and configuration of MS SQL Server 2008, 2008 R2, 2012, 2014, 2016 & 2017 on Windows Server 2008, 2008 R2, 2012, 2016 environment.
Ensuring that all databases are backed up on a regular basis by monitoring full, differential, transactional log backups, fixing backup failures.
Scheduled and maintain routine jobs, alerts and maintenance plans.
Identifying and resolving Blocking and Deadlocking issues by using Activity Monitor, System Stored procedures and profiler.
Responsible for planning and organizing database, Database creation, manage users, password security, privileges & roles, performance tuning, restoration, user creation, script running, patch installation etc.
Implementing and monitoring of high availability solutions like Log shipping, Implemented Mirroring, Replication, Always On HA, Clustering, Creating Linked Server etc., Importing data to Databases through SSIS and configuring SSRS.
Implement and monitor of Always on SQL server.
Having knowledge of SQL azure and Power BI.
MYSQL Clients: YES 4 G, Frogasia, KLIA Ekspres, Ministry of education Malaysia(MOE), Edu Cloud-Virtual Learning Environment
Job Profile & Responsibilities
Installation, Upgradation, administration and maintenance of MySQL 5.6 & 5.7 databases.
Managing and Supporting Backup, Restoration, User creation & privileges, changing parameters in my.cnf as per DB and OS requirement.
Configuring and troubleshooting issues on Master Slave replication.
Responsible for space management, monitoring, and DB performance.
Implementing DB Audit, password policy in mysql 5.6 & 5.7
Tuning MySQL DB
Perform maintenance related activities during scheduled maintenance windows.
Working on as per the client request.
Oracle Clients: CCA, SAP, OBRM, MRM, MNP
Job Profile & Responsibilities
Installation, administration and maintenance of Oracle databases.
Managing and Supporting DB Maintenance activity like Shutdown and startup the DB.
Create Users and Provide privileges to users
Previous Employee Duration
Designation : Software Engineer
March 2015 to August 2016
Company: Rolta India Pvt Ltd. Mumbai, India.
Onsite worked Company: SAP HUNGARY KFT., Budapest, Hungary, Europe
www.rolta.com
17th Nov 2015 to 11 Feb 2016
SQL Clients : Success Factors(SAP), International Flavors & Fragrances Inc., University of Pennsylvania, National Express Corporation, Rainking, Valeant Pharmaceuticals, Danfoss, Briggs, Data2Logistics
Job Profile & Responsibilities
Involved in Installation and configuration of MS SQL Server 2008 & 2008 R2 on Windows Server 2003, 2008 and 2008 R2 environment.
Ensuring that all databases are backed up on a regular basis by monitoring full, differential, transactional log backups, fixing backup failures.
Managed Logins, Users, Roles and User permissions.
Implementing and Monitoring of high availability solutions like Log shipping.
Implementation and Configuration of complex transaction replication
Creating and Managing Databases and its Objects. Giving role to database according to requirement.
Shrinking database & Transaction logs.
Setting up maintenance tasks for integrity, consistency checks and Database optimizations.
Backup, Restoring and Recovering Databases
Implementing Database Security
Configuring and Maintaining Log Shipping
Created and transferred Logins with passwords and its mapping with users.
Performance and Tuning (Performance Monitor, SQL Profiler, Query analyzer, Index Tuning Wizard)
Email Configuration to send database mail.
Attending & resolving tickets from ITSM (BMC Remedy user) and CASDM and Service Now
Monitoring using Insightsd.
SYBASE and HANA Client: Success Factors(SAP), IFF
Installation of SYBASE/HANA
Backup and restore the databases
Providing output to the client as per requirement
Responsible for user creation, user privileges, mount point space issue.
Checking replication is in sync
Worked on SYBASE Replication
Migrated the data from Oracle to HANA by SYBASE Replication with SCN based.
Golden Gate: Success Factors(SAP)
Installation of Golden Gate
Enable Golden Gate replication for the replicates.
Migrate OLTP MSSQL Databases for the Golden Gate replication.
Troubleshoot the replicates issue with Oracle and MSSQL OLTP Databases.
Checking the replicate status and troubleshoot the issue
Previous Employee Duration
Designation : Senior Software Engineer
Sep 2012 to March 2015
Company: Capgemini India Pvt Ltd. Mumbai, India.
www.capgemini.com
SQL Clients : AkzoNobel, Eneco(Multi client Netherland), ABINBEV, Kesko, Amsterdam, Fairfax
Job Profile & Responsibilities
Responsible for the Management of 350 Database Servers with size up to 20TB
Deftly manage installation and configuration of SQL Database Windows, various applications, configuration of SQL Application and necessary SQL upgrades. Database Administration in SQL Server, taking backup, creating roles, giving rights to users, up gradation and migration.
Implementing Log shipping (As a Part of Disaster Recovery Plan), Implemented Mirroring, Creating Linked Server
Responsible for planning and organizing database, Database creation, manage users, password security, privileges & roles, performance tuning, restoration, user creation, script running, patch installation etc
Accountable for Planning and implementing database Backups and Recovery strategies and Run Integrity checks
Importing data to Databases through SSIS. Performance monitoring and tuning
Security Management for Databases. Shrink database & Transaction logs.
SQL Server Job Management. Availability Management, Create and Test Disaster recovery Plan
Disk Space management, Database Design and also perform maintenance and Log shipping
Creating Maintenance Plan and SQL Jobs
Database space management & finding growth per day
Deftly handling the task of database access, roles, users and privileges
MYSQL Clients: eKo(Coca-cola), Gefco, Sequana, NL Multiclient (Canon, RDC, Regelhulp,CIBG VIR, Logius )
Job Profile & Responsibilities
Installation of MYSQL
Backup and restore the databases
Providing output to the client as per requirement
Responsible for user creation, user privileges, mount point space issue.
Checking replication is in sync
Personal Details
Date of Birth
23rd March, 1991
Gender
Male
Nationality
Indian
Languages-Known
English, Hindi, Marathi
Marital Status
Unmarried
References
Contact this candidate