AMITKUMAR MAHAJAN
Mumbai
Summary
Over 8 years’ of experience in Database Administration and Analytical profession with technical knowledge and critical thinking skills to thrive in data-driven environments. Dedicated and adaptable professional with a proactive attitude and the ability to learn quickly. Eager to contribute to a dynamic team and support organizational goals.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Business Intelligence Senior Specialist
NTT Data (Healthcare)
10.2021 - Current
- Managing Teradata data warehouse size of 20+ TB
- Managed user management activities, including ACL, security roles, contact creation and user groups.
- Migrated various MicroStrategy objects including events, schedule, and projects between non-production and production environments.
- Maintained database connections and ensured efficient MSTR project configuration.
- Upgraded MicroStrategy environment from version 4.1 to 5.1
- Managed and maintained Protegrity groups and servers for securing confidential data.
- Administration of Tableau Servers and carrying out installations, security fixes, and other project specific configurations.
Database Administrator
Teradata Corporation (Telecom)
01.2017 - 10.2021
- Database administration for Teradata and analyzing relational DBs to provide optimization insights
- Managed Teradata data warehouse size of 1+ PB
- Process automation and maintenance of Database objects
- Experienced in trouble-shooting techniques and Query Optimization
- Responsible for the migration activities under the qualified environments
- Cross team functional coordination to support product roll out
- Performed password resets on Teradata Nodes and updated them in secure places such as Secure Password Storage and CyberArk
- Ensured efficient backups and restores were performed using DSA.
- Troubleshoot and scheduled UNIX scripting for DBA activities
Technical Associate
Teradata Corporation (Travel & Hospitality)
01.2016 - 01.2017
- Administered various database maintenance activities including Checkable, Scandisk, and Packdisk.
- Ensured smooth ETL batch run and BO reporting by effectively managing space allocation, avoiding failures caused by Perm Space or Spool Space issues.
- Reviewed DDL/DML before deployment to test and production environments for quality assurance
- Managed all Planned and Unplanned Outages, coordinating with various teams throughout downtime.
- Collaborated with Teradata GSC to enhance TTCs through patch upgrades, issue resolution, and Incident Management using TAYS.
Junior Technical Associate
Teradata Corporation (Consumer Goods)
08.2015 - 01.2016
- Teradata session management – Blockings, Long running sessions, Batch- load jobs etc
- Notified concerned teams about running sessions and adjusted workload as needed
- Handled job failures and engaged with GSO for hardware failures.
Education
Master’s in computer applications (MCA) -
Narsee Moonjee Institute of Management Studies
05.2015
Bachelor’s in computer applications (BCA) -
Dharmsinh Desai University
05.2012
Skills
- Database Administration
- Performance tuning
- MicroStrategy
- Tableau
- Unix scripting
- DSA Backup & Restore
Accomplishments
- GDC Employee of the quarter Q2 - 2019
- GDC Project Team Quarterly Award Q2-2020
Certification
- Teradata 14 Certified Professional
- Teradata 14 SQL
- Teradata Vantage Certified Administrator
- Microsoft Certified Azure Fundamentals
BI Tools
- MicroStrategy
- Tableau
Teradata Tools
- BTEQ
- Load Utilities
- DSA
- Data Mover
- Viewpoint
Timeline
Business Intelligence Senior Specialist
NTT Data (Healthcare)
10.2021 - Current
Database Administrator
Teradata Corporation (Telecom)
01.2017 - 10.2021
Technical Associate
Teradata Corporation (Travel & Hospitality)
01.2016 - 01.2017
Junior Technical Associate
Teradata Corporation (Consumer Goods)
08.2015 - 01.2016
Master’s in computer applications (MCA) -
Narsee Moonjee Institute of Management Studies
Bachelor’s in computer applications (BCA) -
Dharmsinh Desai University
Similar Profiles
Sophia StewartSophia Stewart
Senior Medical Claims Examiner at NTT Data Healthcare Services (Centene Corp.)Senior Medical Claims Examiner at NTT Data Healthcare Services (Centene Corp.)
Alfredo CanteroAlfredo Cantero
Software QA Tester at NTT DATA - Client: U.S. Healthcare CompanySoftware QA Tester at NTT DATA - Client: U.S. Healthcare Company
Sana ShaukathSana Shaukath
Benefits Enrollment Specialist at NTT DATA – Tufts Healthcare OrganizationBenefits Enrollment Specialist at NTT DATA – Tufts Healthcare Organization
Priti SharmaPriti Sharma
Senior AVP (Senior Business Executive - Consultant), Audit and Governance at Wells Fargo International Solutions Private LimitedSenior AVP (Senior Business Executive - Consultant), Audit and Governance at Wells Fargo International Solutions Private Limited
Mohammad Kaif ShaikhMohammad Kaif Shaikh
Relationship Manager at ICICI BankRelationship Manager at ICICI Bank