Summary
Overview
Work History
Education
Skills
Timeline
Generic

Goutam Balimane

New York

Summary

14+ years experienced & result- oriented Database Administrator possessing a proven track record of effectively administering Relational database & Data Warehouse, Data Lake architecture and managing data distribution systems in Big Data and Cloud arena. Proficient in liaising with key customers & stakeholders to create, administer, upgrade, secure and optimize Database environments. Seasoned Database administrator with extensive experience supporting application development, database design, cloud migration, performance tuning, monitoring, data security and integrity, backup and recovery, disaster recovery & capacity planning for end-to-end data management & performance optimization.

Overview

16
16
years of professional experience

Work History

Senior Database Administrator

Astra Zeneca
2021.10 - 2023.12
  • Participate in the Implementaion of Snowflake Data lake.
  • Administer, Manage and Design the Security model for Snowflake.
  • Migrate AWS RDS PostgreSQL Databases to Snowflake by usin python and SnowSQL.
  • Assist in AWS Redshift Database Migration to Snowflake.
  • Work on the performance improvement of RDS Postgresql,MySQL and Redshift databases.
  • Automate maintenance jobs for PostgreSQL and Redshift databases through Apache Airflow.
  • Implement CI/CD pipeline for code deployment using GitHub and Airflow.

Senior Database Administrator

Cap Gemini
2020.11 - 2021.09
  • Lead the Data migration project from GE Data center to IBM cloud for MAXIMO
    application.
  • Manage end-to-end heterogeneous data migration, conversion and data modeling.
  • Ship database from On-Prem DB2 to IBM cloud using DB2MOVE utility.
  • Migrate Oracle to PostgreSQL and Convert Oracle PL/SQL objects to compatible PostgreSQL PL/pgSQL.

Senior Database Administrator

Target Corporation
2019.03 - 2020.11
  • Lead the Data migration project from Target Data center to IBM cloud for MAXIMO
    application.
  • Perform 12 TB heterogeneous database migration from Oracle Exadata to DB2 on IBM Cloud.
  • Single point of contact managing end-to-end complex on going data migration,
    conversion and data modeling.
  • Setup up process for capturing delta changes on source and applying it on target
    on-Prem system through Federation and SQL scripts for continuous data sync.
  • Define the migration strategy and plan for data movement from On-Prem DB2 to
    IBM cloud using HADR replication.

Senior Database Administrator

Scholastic Corporation
2013.09 - 2017.12
  • Primarily worked on migrating databases from on-prem data center to AWS cloud.
    Manage and maintain multiple products and projects across e-Commerce and e-
    Scholastic.
  • Responsible for database migration from DB2 on AIX to AWS cloud for COOL and
    STORES application.
  • Work on reporting database conversion and migration from DB2 to AWS Redshift
    using Pentaho and S3 bucket.
  • Implement TSA/HADR as a storage automation and high availability and disaster
    recovery measure in AWS cloud for DB2.
  • Implementation of Commvault for backup and restore solutions.
  • Setup system Analysis and database performance monitoring tools like Solarwinds
    DPA, Nagios, Amazon cloud watch and Amazon EBS snapshots.

Database Administrator

AP Moller Maersk
2011.05 - 2013.08
  • Work with application development team to design new and re-engineer existing
    OLTP and OLAP applications like EDW, CODS, GCSS, NAMDWH, YODA, and OTD.
  • Covert DB2 V9.7 standalone system to DPF partitioned environment.
  • Create volume groups, shared filesystem in HACMP resource groups and mirror
    pools for replication of data at hardware level on P7 systems.
  • Upgraded current system from DB2 v9.1, v9.5 to DB2 v9.7.
  • Setup SQL Replication through CDC Capture and apply program.

Database Administrator

Wells Fargo Bank
2009.09 - 2011.04
  • Support various Integration projects in Wells Fargo for Wells Fargo and Wachovia merger.
  • Upgraded current system from DB2 v9.1 to DB2 v9.7 for MDM data mart.
  • Setup federation from DB2 databases to various heterogeneous sources like
    Oracle, SQL, Teradata and automated jobs to extract and refresh data on daily,
    weekly and monthly basis.
  • Setup NDM Secure+ connections between Wells Fargo and Wachovia servers and
    scheduling jobs for secured file transfers for various downstream applications and
    vendors.
  • Widely used Data Pump to refresh Production data into lower environments at
    object and schema level.

Database Administrator

American Express
2008.04 - 2009.08
  • Participate in Design and Implementation of various Data Warehousing solutions
    for the Global Merchant Analytics and Reporting databases.
  • Proficient use of MDC's and MQT's in improving query performance.
  • Create logical and physical design for the databases using forward and reverse
    engineering with data modelling tools.
  • Perform scaling of database, partitioning databases and relocating db containers.
  • Support various RDMS like DB2,Oracle and SQL Server.


Education

Bachelor of Engineering - Computer Science

Visvesvaraya Technological University
Belgaum, INDIA
01.2008

Skills

  • Heterogeneous Database and Cloud Migration
  • Data Warehouse and Data Lake Architecture & Processing.
  • Performance Tuning.
  • Backup Recovery and Maintenance and Disaster Recovery.
  • Data Modelling,Reporting & Documentation.
  • Databases:
    DB2UDB V11.1,V11.5,10.5,9.7,9.5,9.1,8.2
    Postgresql 9/11/12/13
    SnowFlake
    Oracle 9i,10g,11g,12c
    SQL Server 2012/2014/
    MySQL 5/8
    Redshift
    Hadoop Cluster.

Timeline

Senior Database Administrator

Astra Zeneca
2021.10 - 2023.12

Senior Database Administrator

Cap Gemini
2020.11 - 2021.09

Senior Database Administrator

Target Corporation
2019.03 - 2020.11

Senior Database Administrator

Scholastic Corporation
2013.09 - 2017.12

Database Administrator

AP Moller Maersk
2011.05 - 2013.08

Database Administrator

Wells Fargo Bank
2009.09 - 2011.04

Database Administrator

American Express
2008.04 - 2009.08

Bachelor of Engineering - Computer Science

Visvesvaraya Technological University

Similar Profiles

  • Katarzyna Kubasik

    Katarzyna KubasikKatarzyna Kubasik

    Central Business Support Team Manager at Astra Zeneca Pharma PolandCentral Business Support Team Manager at Astra Zeneca Pharma Poland

    View Profile
  • SANTHALINGAM PIRASANNA

    SANTHALINGAM PIRASANNASANTHALINGAM PIRASANNA

    Senior Field Manager at Hemas Pharmaceuticals Astra ZenecaSenior Field Manager at Hemas Pharmaceuticals Astra Zeneca

    View Profile
  • Sharon Keating MHA, BSN

    Sharon Keating MHA, BSNSharon Keating MHA, BSN

    EXECUTIVE ACUTE CARE HOSPITAL SALES at ASTRA ZENECA PHARMACEUTICALEXECUTIVE ACUTE CARE HOSPITAL SALES at ASTRA ZENECA PHARMACEUTICAL

    View Profile
Goutam Balimane