Technical Support Manager
Resume:
Mooresville NC - ***17
Satish R. Bhonsle
(479) 685- 0349
*************@*****.***
Employment and Technical Experience
IT Analytics and BI Engineer
Lowe’s Companies, Inc.
Oct 2015 till date
Teradata:
Load jobs/Business reports optimization:
Optimized performance impacting batch loads, critical business reports (Micro strategy) and saved a lot of resources and time which helped business to complete the loads and reports way before the SLA deadline.
With the saved resources, we were able to push more workload with the same capacity.
Teradata Active System Management (TASM) optimization:
Optimized workload settings which helped to avoid AWT flow control situation, helped tactical queries to meet the required SLAs and helped to resolve critical report delay issues.
New workload was setup to accommodate business requirements without impacting other workloads.
Database design:
Demonstrated experience with designing data architectures for integrated projects and ensuring the table structure (with proper Indexes, PPIs, SET, MULTISET etc.) is designed perfectly to get maximum performance and make the best used of sophisticated Teradata optimizer.
Data Stream Architecture (DSA) – Backup and Recovery Solution (using NetBackup):
Successfully planned, tested and implemented the Data Stream architecture solution for Backup and Recovery replacing the current backup and recovery solution which we had. Also, planned and implemented the Backup and Restore strategy along with retention.
Also worked on NetVault, TARA, Arcmain.
PDCR maintenance and retention:
Successfully implemented the PDCR retention specific to our company requirements.
Installation and maintaining PDCR.
In-depth knowledge of ResUsage and DBQL.
Teradata loading utilities:
Fastload, Multiload, Fast Export, BTEQ, Tpump, TSET, Visual Explain, Teradata Administrator, GDO, Viewpoint, DBSControl, DIP, CTL, Reconfig, statistics wizard, index wizard, etc.
Teradata Software and Hardware upgrades (node expansion)
Protegrity:
Involved in yearly protegrity key rotation process and working on protegrity related issues.
Performance report analysis
Monitoring KPIs and working on KPIS making sure all business SLAs are met.
Capacity planning and Performance monitoring
All Teradata DBA administration tasks on Linux environment including shell scripting (creation of reusable components).
Support Security audits for Teradata, Aster.
Streamlining process, creating new processes and procedures and documenting as per industry best practices, services and methodologies.
Setting up various alerts through Viewpoint
Translates business requirements into technical requirements.
Experience in software development methodology and software development life cycle
Mentoring and guiding development team during the complete life cycle to develop projects.
Investigates and provides insights about new Teradata features and new technologies to meet organization business needs.
Working on POCs for new features and implement them accordingly if it benefits the business.
Teradata training for Business teams
Providing Teradata training sessions for Business users and guiding them to script performance efficient SQLs.
Teradata Aster:
All Aster database administration tasks
Database/Schemas/User/table/view creation.
Managing access rights through roles
Space management
Automation – Table and user retention process
Software upgrades
Moving data from one system to another Aster system
Installing and configuring database connectors to connect to various data sources and extract data from Aster.
Installing Aster functions used for various analytics as per business requirements.
Asteron Hadoop (Aster Analytics on Hadoop):
Successfully installed Asteron Hadoop
LDAP configuration:
Successfully configured LDAP.
Installed and configured required database connectors to connect to various sources from Aster
Installed required Aster analytics functions.
Hadoop Administration:
Excellent knowledge of Hadoop architecture and various components such as HDFS, Name Node, Data Node, YARN Resource manager, Zookeeper, H-Base, Sqoop, Oozie, Hive etc.
Provisioning, managing and monitoring Hadoop cluster using Ambari.
Maintaining security policy controls for HDFS, YARN, HBASE, Hive, SOLR.
Upgrading Hadoop cluster
Commissioning and decommissioning nodes
Self-Learning:
Data science – R programming:
Completed course on R programming
Associate Lead Consultant
Teradata Operations, Inc.
Jun 2008 till Oct 2015
Performance Tuning specialist:
Leading a team of 8 Performance DBAs for Walmart.
Achieved required business critical SLAs by optimizing various loading jobs, application and reporting queries with various performance optimization techniques (Stats, PPI, Indexes, Join Indexes, Horizontal and vertical partitioning, derived tables, volatile tables etc.)
Saved millions of CPU due to which our client is able to run more workload on the system with the same capacity.
Analyzing workload and recommending suggestion so that system performs at its optimal best.
Database design.
Guiding the development, application teams, and Business IT users to rewrite queries and provide suggestions to make the best of sophisticated Teradata optimizer.
Responsible for presenting performance reporting (weekly, monthly, quarterly) and analysis using PDCR and Tableau.
Was also leading a team of 3 Performance DBAs for DirecTV and a team of 2 Performance DBA for Sony Pictures
Coaching team members.
Production support DBA:
Leading a team of 7 Operational DBAs for Walmart.
Also worked as Operational DBA for Apple
Actively involved in software and hardware upgrades.
Responsible for monitoring the system, management of users, space, access, statistic collection, database clean up, roles and profiles, databases/table creation and defining the indexes depending on the details from DA document, suggesting PPI, SI etc.
Preparing backup strategies, monitoring scheduled backups, restoring objects as per user requirements using NetVault and TARA GUI.
Viewpoint alert configuration.
PDCR installation and maintenance.
Responsible for preparing and presenting weekly, monthly and quarterly reporting (using PDCR).
Shell scripting.
24*7 support.
ERP consultant
Cognizant Technology Solutions
May 2007-May 2008
Worked as an Oracle Applications DBA responsible for end to end maintenance of Oracle Applications business suite.
Implement and maintain database security (creating and maintain user, profiles, roles, assign privileges)
Monitoring the system through OEM, managing tablespaces (adding datafiles), monitoring jobs.
Configuring Enterprise Manager Grid Control
Cloning, upgrade of Oracle Application business suite and troubleshooting.
Patch management and version control.
Set up and maintain documentation and standards.
Coordinating with Oracle Corporation for technical support.
Oracle DBA/Oracle Applications DBA Eternett Software Systems June 2003 – May 2007
As an Oracle Apps DBA, was responsible to monitor and maintain Oracle Applications business suite.
Cloning, Upgrade of Oracle Applications business suite.
Implement and maintain database security (create and maintain user and roles, assign privileges)
Installation, configuration and upgrading of Oracle database and standby databases.
Backup using RMAN and traditional backup.
Perform general technical troubleshooting and give consultation to development teams.
Interface with Oracle Corporation for technical support.
Shell scripting.
24*7 Support.
Education
Bachelor of Engineering in Electronics and Communications - First Class
University: Visveswaraiah Technological University, Belgaum, Karnataka, India.
Diploma in Computer Science and Engineering – First Class
Board: Board of Technical Education, Bangalore, Karnataka
Certifications and Awards
Teradata 14 Certified Professional
Teradata Certified Master V2R5
Oracle Database 10g Administrator Certified Professional
Oracle 9i Database Administrator Certified Professional
ITIL V3 Certificate in IT Service Management
ADC (Americas Development Center) – Consulting Excellence Award
Outstanding Performance Award (Walmart project)
ADC Employee Of The Quarter (DirecTV)
ADC Long Service Award (Apple project)
LinkedIn URL: https://www.linkedin.com/in/satish-bhonsle-aa07506/
Contact this candidate