Kishore Datla
Castlegar,BC
Summary
Senior Database Administrator/Architect with 15+ years of experience in various database technologies including IBM DB2, MySQL, MariaDB, MongoDB, MS SQL Server, and more than 2+ years of experience on GCP and AWS Cloud database operational support.
Overview
17
17
years of professional experience
Work History
Senior Database Administration Specialist
Marsh & McLennan Companies
05.2023 - Current
- Support, Maintenance, Administration and Monitoring of MySQL, MongoDB, SQL Server DBs both on-prem and AWS cloud.
- Database upgrades, replication/HA setup, backup and recoveries etc.
- Designing, solutioning and supporting database builds along with migrations of on-prem databases to Cloud/AWS.
- Setup On-Prem, AWS EC2, RDS (Multi-AZ) systems, Aurora replica/migrations for MySQL, SQL Server platforms.
- Production Database support and occasional on-call support.
- Performance tuning & enhanced techniques to mitigate major production outages with standardized Incident & Change management process.
- Build automation using Ansible, OLAM, Terraform IaC etc., tools to reduce the manual intervention and monitoring overhead.
- Work on new generation technologies closely with customer and other stakeholders to improvise the overall growth and performance of databases.
- Manage and prioritize workflow with different client stake holders and Identify opportunities for improvement in the environment and database platform.
- Operational support along with team management of new members offshore.
Senior Database Administrator and Team Lead
Cognizant Technology Solutions
05.2014 - 05.2023
- Support, Maintenance, Administration and Monitoring of critical DB2 LUW, MySQL, MS SQL & MongoDB Production and Non-Production database systems.
- Database rationalization/migration from DB2 LUW to PostgreSQL.
- Database upgrades of critical MySQL and MongoDB landscape servers
- Designing, solutioning and supporting migration of on-prem DB2, MySQL and MongoDB databases to GCP cloud.
- GCP architectural review, design, build of VMs along with disaster recovery setup for GCP systems, automating backup/snapshots.
- Logshipping/replication/HADR/ProxySQL as HA techniques
- Mirroring/Orchestrator etc. as DR solutions
- Creating Tables, Views, Triggers, Cursors, Dynamic Stored Procedures, User Defined Functions and other Transact-SQL (DDL, DML) statements for various applications.
- Experience working with CI/CD teams for terraform automation and Ansible jobs/scripting.
- 24 x 7 Production Database on Call Support. Excellent Analytical, problem solving and communication skills.
- Performance tuning & enhanced techniques to mitigate major production outages with standardized Incident & Change management process.
- Build new scripts, and tools to reduce the manual intervention and monitoring overhead and to leverage the existing tools for new releases and on different migration projects.
- Manage operational and coordination/project management tasks leading 15+ offshore DBAs to track, guide and ensure services are met as per client SLA's.
SR. DB2 LUW DBA
IBM India
12.2010 - 04.2014
- Support, Maintenance & Monitoring of Critical DB2 LUW and SAP Prod & Non-Prod database systems.
- Day to day administrative activities like backup/restore, database utilities and major upgrade/install/migration/DR work with automation, scripting capabilities.
- Implement new features like TSA setup & management, owning end-end support on multiple functionalities like jobs/sap runs & proactive self tuning for zero percent downtime and hundred percent availability.
- Support SAP basis administration and consulting teams across the globe for database & application related issues/tasks.
SR. SYSTEM EXECUTIVE / DB2 DBA
COGNIZANT TECHNOLOGY SOLUTIONS
06.2007 - 11.2010
- Support, Maintenance & Monitoring of Critical DB2 LUW, Oracle Prod & Non-Prod database systems.
- Involved in day to day administrative activities like backup/restore, database utilities and major upgrade/install/migration/DR work with automation, scripting tasks.
Education
Master of Science - Statistics
Andhra University
India03.2007
Bachelor of Science - Computer Science And Statistics
Osmania University
India04.2004
Skills
- Database design, planning, architecture, build, maintenance and administration
- MySQL
- MongoDB
- IBM DB2
- SQL Server
- GCP
- AWS
- Agile
- Jenkins, OLAM, Ansible and Terraform
- Linux/Unix/AIX/Windows
- Bash, Python, SQL
- MS Office, BMC, Service now, JIRA, Kanban, OPAS
- Insurance, Retail, Banking and Financial domain
Accomplishments
- Total 15+ years of extensive experience on various RDBMS, NoSQL, and Cloud technologies.
- Architected, designed and completed Cloud migrations of 250+ database systems.
- Upgraded 1000+ database systems IBM DB2, MySQL and MongoDB database systems.
- Knowledge supporting DevOps technologies like Jenkins-Pipeline and enhancing/automating using Ansible scripts/roles and automating IaC using Terraform.
- Knowledge monitoring and logging ELK, Kibana, DataLog and PD.
- Knowledge on Cloud technologies GCP and AWS.
- Excellent team player and team leader for 15+ offshore team.
- Certified IBM DB2 Database Administrator, Oracle MySQL Database Administrator, Agile PM Crash Course Certified, Google Cloud Certified Cloud Architect, PMI Badge.
Residency Status
Canadian Citizen
Timeline
Senior Database Administration Specialist
Marsh & McLennan Companies
05.2023 - Current
Senior Database Administrator and Team Lead
Cognizant Technology Solutions
05.2014 - 05.2023
SR. DB2 LUW DBA
IBM India
12.2010 - 04.2014
SR. SYSTEM EXECUTIVE / DB2 DBA
COGNIZANT TECHNOLOGY SOLUTIONS
06.2007 - 11.2010
Master of Science - Statistics
Andhra University
Bachelor of Science - Computer Science And Statistics
Osmania University
Similar Profiles
KATYRA WHITE-JORDANKATYRA WHITE-JORDAN
Senior Customer Service Representative at Marsh & McLennan Companies, Inc.Senior Customer Service Representative at Marsh & McLennan Companies, Inc.
Julia SequeiraJulia Sequeira
Senior Operations Specialists at Marsh & McLennan CompaniesSenior Operations Specialists at Marsh & McLennan Companies
Katarzyna WalczakKatarzyna Walczak
Senior Operations Analyst at Marsh McLennan CompaniesSenior Operations Analyst at Marsh McLennan Companies