Harish K R
Bangalore
Summary
Senior database administrator with over 12 years of experience in IBM DB2 LUW administration and cloud migration. Expertise in designing efficient database solutions and executing data migrations to lakehouse platforms for performance optimization. Demonstrated success in managing scalable AWS deployments using Terraform and improving data integration through advanced analytics support.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Sr. Database Administrator
Infor India Pvt. Ltd
Bangalore
07.2019 - Current
- Currently leading the migration of on-premises data center servers to the AWS cloud, utilizing Terraform and SaltStack for automated, scalable, and reliable infrastructure provisioning and configuration management.
- Led data replication efforts from DB2 and MSSQL to Databricks using HVR and Fivetran tools, enabling real-time data integration and analytics readiness.
- Configured SingleStore environments, ensuring consistent deployments using Terraform.
- Upgraded MemSQL 6.8 to SingleStore 8.0, enhancing database scalability, performance, and access to new features.
- Migrated tables from row store to column store format in SingleStore, significantly improving analytic query response times and overall system efficiency.
- Configured all-purpose clusters and SQL Warehouse clusters in Databricks, optimizing environments for workload performance and scalability.
- Automated auto-loader jobs in Databricks for continuous data availability.
- Configured service principals in Databricks for automated deployments via Jenkins, streamlining CI/CD pipelines, and improving deployment reliability.
- Managed secure AWS S3 buckets for scalable cloud storage solutions.
- Converted large tables into partitioned tables to enhance query performance and simplify data maintenance.
- Developed scripts to detach and drop old partitions, optimizing storage management and maintaining database efficiency.
- Set up Q-Replication for large databases, enhancing data replication efficiency.
- Executed DB2 migration from version 10.5 to 11.5, achieving minimal downtime while leveraging new features.
- Performed HADR rolling upgrades across multiple standby environments to maintain high availability during system upgrades.
- Migrated large tables to individual tablespaces using the ADMIN MOVE procedure for improved storage management.
- Fine-tuned Data Warehouse configurations by setting DB CFG parameters to optimal values, enhancing performance, and stability.
- Configured TLS (SSL) encryption for secure communication between primary and standby HADR servers.
- Collaborated with data engineering teams to resolve code release and IT build issues, improving overall deployment success.
Senior Operations Professional
IBM INDIA PVT. LTD
Bangalore
11.2015 - 07.2019
- Ensuring successful completion of all DB2 production job streams
- Monitored application database growth and implemented necessary actions to maintain efficiency.
- Monitored and resolved snapshot backup failures to ensure data integrity.
- Created and scheduled utilities like load, reorg, and runstats to optimize database performance.
- Hands on experience with EMC networker for DB backups, Performed the redirect restores from Production to Pre-Prod and Sandbox servers.
- Monitoring the schedule jobs like backups, data loads
- Provided 24/7 on-call support for critical systems, addressing issues promptly.
- Developing and maintaining database standards and naming conventions
- Handling the multiple HADR production databases
DB2 DBA
IBM India Pvt. Ltd, (Maintec Technologies)
Bangalore
10.2013 - 11.2015
- Tuned SQL queries on Data Warehouse DB to enhance query performance and data retrieval speed.
- Performed online and offline backups of databases and tablespaces to maintain data integrity and availability.
- Managed user authorizations to ensure compliance with ITCS104 standards and secure data access.
- Maintained Database security (GSD-331 Standards)
- Upgraded DB2 Fixpack and DB2 connect/client.
- Provided 24x7 support and on-call assistance.
- Participated in the resolution of incidents and changes to maintain system stability.
- Created and updated documentation and standards for database management processes.
- Compiled and distributed daily and weekly reports and handover documents to team members.
Education
Bachelor Of Engineering - Computer Science & Engineering
BIT Institute of Technology
Hindupur01-2012
MPC -
LRG Naidu Junior College
Hindupur03-2008
Secondary School Certificate -
Sri Balaji Vidya Vihar
Hindupur03-2006
Skills
- DB2 LUW database management
- Cloud database management
- Database security management
- Data backup management
- Cloud migration with AWS services
- Cloud infrastructure automation using Terraform
- Singlestore management
- Experience with Databricks
- Cloud Storage Management
Certification
- IBM Db2 for LUW V11.x Database Administration
- IBM Db2 for LUW V11.x Advanced Database Administration
- IBM Db2 for LUW V11.5 Administration for Database Professionals
- SnowPro Associate: Platform Certification
Hobbies and Interests
- Motor Cycling
- Travelling
- Mountain Climbing
Languages
- English, C2
- Telugu, C2
- Hindi, B2
- Kannada, B2
Timeline
Sr. Database Administrator
Infor India Pvt. Ltd
07.2019 - Current
Senior Operations Professional
IBM INDIA PVT. LTD
11.2015 - 07.2019
DB2 DBA
IBM India Pvt. Ltd, (Maintec Technologies)
10.2013 - 11.2015
Bachelor Of Engineering - Computer Science & Engineering
BIT Institute of Technology
MPC -
LRG Naidu Junior College
Secondary School Certificate -
Sri Balaji Vidya Vihar