Summary
Overview
Work History
Education
Skills
Timeline
Generic

Abhiteja Gajawada

WINDSOR,Ontario

Summary

Highly skilled Database Administrator with experience in managing, maintaining and troubleshooting databases. Equipped with strong problem-solving skills, adept at overseeing database design, structuring data security measures and ensuring optimal performance. Previous work resulted in improved system efficiency, increased data accuracy and reduced downtime through successful implementation of effective database management strategies.

Overview

5
5
years of professional experience

Work History

Database Administrator

Invafresh
Mississauga, Ontario
06.2023 - Current
  • · As a Database Developer, responsible for overseeing, maintaining, and providing operational support for the entire database portfolio, encompassing Development, QA, Customer Support, and Customer Production databases. Ensure the reliability, stability, and data integrity of the databases.
  • Using Azure SQL databases creating and maintaining databases, Also, worked on migration of databases ON-PREM
  • Handled common database procedures such as upgrades, backups, restores recovery, migration, installation/configuration.
  • Designed and Built database systems of high availability, scalability, performance and security.
  • Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source and SQL server using SSIS.
  • Actively monitored and respond to database Alerts.
  • Maintaining database documentation and specification as required, such as Data Dictionary on each product release using Erwin data modeler tool, DAS crystal reports tool

Data Associate

Nextbrain
Bangalore, India
07.2019 - 07.2024
  • Maintained accurate records of all data collected and stored in the database.
  • Work closely with business users to congregate and comprehend requirements.
  • Design and develop SSIS packages, Store Procedures, configuration files, tables, views, functions and to implement best practices to maintain optimal performance.
  • Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source and SQL server using SSIS.
  • Proficient in using Power BI to create interactive and visually appealing dashboards, reports, and data visualizations, enabling stakeholders to gain insights and make informed decisions.
  • Experienced in designing and implementing data models in Power BI, including relationships, hierarchies, and calculations, to support complex analytical requirements and business needs.
  • Utilising SSIS to extract, transform, and load (ETL) a substantial amount of data from multiple data sources.
  • Architected and implemented SSIS Templates with customizable parameters for seamless deployment into various environments, resulting in a 50% reduction in deployment time and enhanced scalability
  • Developed SSIS programmes for data extraction from Excel and for copying tables, schemas, and views.
  • In order to guarantee mapping accuracy and address problems in SSIS packages, cross validation rules were created.
  • Involved in extracting the data using SSIS from OLTP to OLAP.
  • Designed cubes with star schema using SQL Server Analysis Services (SSAS).
  • Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • Created different chart reports helped in analyzing perform counters using SSRS.
  • Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by drill through, sub-reports, navigation reports (Hyperlink) etc.
  • Proficient in using Power BI to create interactive and visually appealing dashboards, reports, and data visualizations, enabling stakeholders to gain insights and make informed decisions.
  • Experienced in designing and implementing data models in Power BI, including relationships, hierarchies, and calculations, to support complex analytical requirements and business needs.

Education

Masters -

University of Windsor
Windsor, ON
05-2023

Skills

  • Power BI
  • Crystal Reports XI
  • Erwin Tool
  • MS Excel
  • MS SQL
  • Visual Studio
  • GIT
  • Tableau
  • Azure Data Factory
  • SQL Server 2016/2014
  • JIRA

Timeline

Database Administrator

Invafresh
06.2023 - Current

Data Associate

Nextbrain
07.2019 - 07.2024

Masters -

University of Windsor

Similar Profiles

CREATE PROFILE
Abhiteja Gajawada