Summary
Overview
Work History
Education
Skills
Certification
Timeline
ABHIJEET BARMAN

ABHIJEET BARMAN

Waterloo,Ontario

Summary

Experienced Database Administrator proficient in SQL Server, UNIX Shell Scripting, and Linux Environments. Skilled in ensuring data accuracy, resolving issues through Root Cause Analysis, and utilizing Atlassian Jira for efficient workflow management. Strong knowledge and basic experience in Azure SQL DB.

Overview

3
3
years of professional experience
1
1
Certification
2
2

Years of post-secondary education in Cloud Computing

4
4

Months of experience as a Full Stack Java developer in Trainee

Work History

Database Administrator

Broadridge Financial Solutions
2019 - 2021

• Managed PostgreSQL, and Microsoft SQL Server databases, and made adjustments to meet application requirements.
• Successfully migrated data from MSSQL and Oracle to GCP Cloud SQL and Azure SQL, ensuring smooth transition to new environment.
• Utilized SQL/MySQL queries to handle trade errors and temporarily resolve product defects in backend database.
• Improved database performance by optimizing SQL query plans, resulting in 30% improvement in software performance.
• Monitored and optimized SQL query plans by recompiling PL/SQL stored procedures, ensuring high performance and availability.
• Implemented data maintenance procedures that reduced data-related errors by 20%.
• Ensured databases were consistently backed up and implemented reliable recovery procedures to safeguard against data loss in memory-related events.
• Proficient in UNIX/Linux scripting for automation, facilitating batch jobs, and end-of-day processes.
• Streamlined database operations through automation and issue tracking using Atlassian JIRA, resulting in
15% reduction in manual tasks and improved overall efficiency.
• Primary point of contact for various clients, providing excellent customer support and promptly resolving critical issues during bridge calls.
• Achieved outstanding 99.99% uptime rate by quickly resolving critical issues in client production environments during bridge calls.
• Ensured data accuracy and completeness through Root Cause Analysis (RCA) and efficient data maintenance procedures.
• Complied with security procedures and contributed to access and user account management within database.

Full Stack Java Developer Trainee

TalentSprint
2018 - 2019
  • Acquired expertise in the technologies and skills required to design and develop web applications
  • Mentored and trained junior developers on web development best practices and technologies
  • Project
  • Developed a web application for a school for tracking and managing performance of students using HTML, CSS, and JavaScript, and the backend is built using Java and a MySQL database
  • Designed and developed an e-commerce website “HouseJoy” which provides household related services.

Education

Graduate Certificate - Cloud Computing

Loyalist College in Toronto
2021 - 2023

Bachelor of Technology - Mechanical Engineering

Malla Reddy Engineering College, Hyderabad, India
2014 - 2018

Skills

  • Proficient in Linux/Unix environments
  • Azure Cloud and MS SQL server
  • Automation and Shell/Powershell Scripting
  • MySQL Database server administration
  • System Performance monitoring and tuning
  • Efficient data manipulation queries with better understanding in using joints
  • Database Backup Strategies
  • High Availability (HA), replication, and Disaster Recovery (DR) Solutions
  • Troubleshooting and Problem-solving
  • Backup, Restore, and Recovery Models
  • Proficient in implementing security measures to safeguard databases against threats and unauthorized access
  • Familiarity with Azure DevOps, Oracle database, PostgreSQL, Data Factory, System Centre Operations Manager, and Azure Synapse
  • Problem-solver and Excellent verbal and written communication skills
  • Capable of working under pressure
  • Highly organized and responsible

Certification

Microsoft Azure Fundamental AZ-900

Timeline

Loyalist College in Toronto - Graduate Certificate, Cloud Computing
2021 - 2023
Database Administrator - Broadridge Financial Solutions
2019 - 2021
Full Stack Java Developer Trainee - TalentSprint
2018 - 2019
Malla Reddy Engineering College - Bachelor of Technology, Mechanical Engineering
2014 - 2018
ABHIJEET BARMAN