Resume

Sign in

Software Engineer Sql Server

Location:
Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia
Posted:
September 13, 2018

Contact this candidate

Resume:

Vaibhav Chavan

ac61fo@r.postjobfree.com

+60-187******

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