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
Kolkata08.2018
12th/Higher Secondary - Science
Council of Higher Secondary Education
Odisha03.2012
10th Secondary -
Board of Secondary Education
Odisha03.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