Summary
Overview
Work History
Education
Skills
Websites
Personal Information
Accomplishments
Timeline
Generic
Rajib Lochan Das

Rajib Lochan Das

Balasore

Summary

To be part of a fast-growing esteems organization. Highly self-motivated and goal-constant learning process. To put on efforts and knowledge for self-development-oriented professional committed to pursuing a long-term career and make my job and for organization growth Successful. SQL Database Administrator with 4+ years of experience in database development and production environments.

Equipped with strong problem-solving abilities, willingness to learn, and excellent communication skills. Poised to contribute to team success and achieve positive results. Ready to tackle new challenges and advance organizational objectives with dedication and enthusiasm.

Overview

5
5
years of professional experience

Work History

Senior Engineer - Database Administration

Marsh & McLennan
05.2024 - Current
  • Currently working in a product-based company, gaining extensive experience in managing critical DBA tasks under pressure, and handling multiple issues simultaneously.
  • Hands-on expertise in pre/post AWS migration activities, onboarding new servers, and implementing monitoring checks with tools like Datadog.
  • Performed SQL Server patching, SSL certificate renewals, and database access management.
  • Improved performance tuning and resolved database slowness issues.
  • Handled SQL connectivity, NetBackup job failure issues, and SQL Agent job failure resolution.
  • Delivered SQL BAU activities and provided on-call production support.
  • Supported user problem investigations (P1 issues), delivering timely resolutions.
  • · Managed space alerts, disk utilization, and database housekeeping tasks.
  • Worked closely with the QA and Ops teams to streamline database operations.
  • Basic knowledge of MongoDB, including space issues, and ops-manager

Database Administrator Engineer Cloud & Infra Management

LTIMindtree
12.2020 - 04.2024
  • Having three years of experience as a Database Administrator professional in a production environment.
  • Performed daily tasks associated with a production/development DBA role on a large-scale system.
  • Performed installation and configuration of SQL servers as per customer requirements.
  • Create and schedule jobs and maintenance plans according to requirements.
  • Performed backup and restoration.
  • Upgrading the database to a newer version with prechecks.
  • Creating and managing user/group and logins.
  • Resolving blocking processes-related issues.
  • Monitor, schedule, and verify backups, and perform ad-hoc backups.
  • Responsible for refreshing databases as per client requests.
  • Perform validation checks for the onboard database and the decommission database.
  • Perform SQL Server patching as per Microsoft's release.
  • Good knowledge of mirroring, log shipping, and Always On high availability solutions for SQL Server.
  • Performing the failover and failback operations in the cluster environment.
  • Good experience in applying service packs and hot fixes.
  • Daily, check the issues like backup failures, failed logins, and resolve the issues.
  • Monitoring alerts, disk space of all the servers, and freeing up space as per SQL Server, i.e., older backups, unused files, etc.
  • Troubleshoot log space issue.
  • Experience with SQL Server 2008, 2008 R2, 2012, 2014, 2016, and 2019.
  • Good communication skills with the system administrator and development team.
  • Good knowledge of all incident and change management processes.
  • Experience with building a highly available environment (log mirroring, log shipping).
  • Good hands-on experience with different ticketing tools, like ServiceNow.

Education

B.Tech - Electronics & Instrumentation engineering

Narula institue of Technology
Kolkata
08.2018

12th/Higher Secondary - Science

Council of Higher Secondary Education
Odisha
03.2012

10th Secondary -

Board of Secondary Education
Odisha
03.2010

Skills

  • SQL Database maintenance
  • Installation of SQL Server
  • SQL Server Upgradation
  • User Management
  • Backup and Recovery
  • Create/Schedule Job/Maintenance Plan
  • SQL Server Patching/SSL renewal
  • performance tunning
  • SQL BAUL activity /handling P1 call
  • OS knowledge - Windows 2008/2008R2/2012/2016/2019
  • Log shipping
  • Always on High availability solutions for SQL server
  • DR Drill Activity
  • Good knowledge on all incident and change management process
  • MONGO DB
  • Datadog
  • Ops-manager
  • ServiceNow

Personal Information

Accomplishments

  • Received an award from the Internal client my first company for extraordinary efforts in managing their server.

Timeline

Senior Engineer - Database Administration

Marsh & McLennan
05.2024 - Current

Database Administrator Engineer Cloud & Infra Management

LTIMindtree
12.2020 - 04.2024

B.Tech - Electronics & Instrumentation engineering

Narula institue of Technology

12th/Higher Secondary - Science

Council of Higher Secondary Education

10th Secondary -

Board of Secondary Education
Rajib Lochan Das