Summary
Overview
Work History
Education
Skills
Timeline
Generic

Kiran kumar Salla

Summary

Professional Objective Looking forward to a challenging career that gives better exposure to my skills and abilities in an organization that offers Professional growth Professional Summary Having 9 years of Extensive and Varied Experience in the Database Administration. Proficient in DBA activities such as Administration, Monitoring and Database Backups. Expertise in MariaDB. Expertise in ORACLE. Expertise in MySQL. Experience in MSSQL. Experience in PostgreSQL. Having Knowledge on HADOOP Administration. Good experience on Linux Scripting and Automation. Experienced in ORACLE, MSSQL, MariaDB , MySQL , PostgreSQL , Bash , Python , Terraform , GitLab , AWS and GCP Cloud Technologies. Installation and Upgrading MYSQL, MariaDB, Maxscale. Setting up Master Slave REPLICATION in MYSQL,MariaDB. Expertise in Installing and Configuring MAXSCALE with multi-cluster. Having experience in RAC and DATAGUARD. Experienced in RMAN Backup, Cloning, Report Generation and a wide range of other DBA activities. Experienced in DB UPGRADE. Experienced in performance Tuning using AWR,STA,ADDM . Configuration of DATAGUARD (DR) Physical Standby Database. Configuring Backup Jobs in MSSQL using Packages. Scheduling REPLICATION in MSSQL for tables and for full DB. Experienced in AIX and LINUX scripting for housekeeping in ORACLE,MySQL. Experienced in AWS RDS , GCP SQL and Compute Engines , Github CICD pipelines. Excellent Interpersonal skills, confident and poised in interactions with individuals at all level readily developing support with clients and peers. Supportive Individual capable of Managing incidents, being proactive in terms of preventive maintenance and knowledgeable in terms of risk management Good knowledge on AIX,LINUX & Solaris. Possess excellent analytical and communication skills.

Overview

9
9
years of professional experience

Work History

Senior Database Engineer

Grab
01.2022 - Current
  • Tools & Utility
  • MariaDB,MySQL,PostgerSQL , Gitlab , Terraform
  • Environment
  • AWS , EC2 , GCP SQL , Compute
  • Responsibilities
  • Clustering and tuning databases for performance, reliability, high availability and scalability
  • Daily BAU tasks on MySQL, MariaDB database engines and PostgreSQL
  • Benchmarking, Testing New features , Upgrade versions
  • Working proficiency in Python for automation projects
  • Docker deployments using jenkins and docker updates
  • Knowledge on Atlas MonGODB cloud
  • Key activities and changes global on AWS and GCP for all Databases
  • Gitlab deployments for CI/CD pipelines
  • Migrations from EC2 to RDS for stability and automation
  • Upgrades using parallel stack which reduces downtime
  • Logical replication in PostgreSQL for upgrades
  • Cost Optimisation techniques in cloud platforms.

Senior Associate

DBS Bank
03.2020 - 12.2021
  • Routine proactive maintenance of MariaDB using shell scripts and standard data collection mechanisms
  • Managing and administrating Production and Test instances.
  • Working with team on production issues & and escalate the issues to appropriate team if required.
  • Cross Platform Migration.
  • Installed, configured and maintained MariaDB in RHEL 6&7.
  • Taking HOT and COLD backups using xtrabackup and shell scripts.
  • Proactive monitoring and health checking of all TESTING/PROD databases.
  • Connectivity and locking issues.
  • Handled performance related issues.
  • Good at Memory tuning in all the DB level performance.
  • Index level jobs.
  • MariaDB/Maxscale Upgrade.
  • Automated Backups through Cronjob.
  • Handling BAU day to day acivities.
  • Recover / Restore the database if required.

Senior Database Administrator

OPTIMUM Solutions To DBS Bank
09.2017 - 03.2020
  • Routine proactive maintenance of MariaDB using shell scripts and standard data collection mechanisms.
  • Managing and administrating Production and Test instances.
  • Working with team on production issues & and escalate issues to appropriate team if required.
  • Cross Platform Migration.
  • Installed, configured and maintained MariaDB in RHEL 6&7.
  • Taking HOT and COLD backups using xtrabackup and shell scripts.
  • Proactive monitoring and health checking of all TESTING/PROD databases.
  • Connectivity and locking issues.
  • Handled performance related issues.
  • Good at Memory tuning in all DB level performance.
  • Index level jobs.
  • MariaDB/Maxscale Upgrade.
  • Automated Backups through Cronjob.
  • Handling BAU day to day acivities.
  • Recover / Restore database if required.

L2 DBA

MINDTREE Ltd
06.2015 - 09.2017
  • Routine proactive maintenance of Oracle Database using shell scripts and standard data collection mechanisms
  • Managing and administrating Production and Test instances.
  • Working with team on production issues & and escalate the issues to appropriate team if required.
  • Cross Platform Migration.
  • DB Upgrade from 10G to 11G 04.
  • Installed, configured and maintained Oracle 10g,11g Databases on AIX,LINUX Platform.
  • Creation of tablespaces, Adding and resizing datafiles.
  • Taking HOT and COLD backups using RMAN and shell scripts.
  • Proactive monitoring and health checking of all TESTING/PROD databases.
  • Connectivity and locking issues.
  • Handled performance related issues.
  • Good at Memory tuning in all the DB level performance.
  • Index level jobs.
  • Mssql Migration from 2000 to 2008R2.
  • Mysql Upgrade from Standard edition to ENTERPRISE.
  • Automated Backups through Cronjob.
  • Monitoring Users access, Tablespace usage, CPU usage on server.
  • Recover / Restore the database if required.

Database Administrator

BNP, with HCL Infosystems Ltd
09.2014 - 06.2015
  • Creating Primary Database storage structures (tablespace, datafiles) and objects like Tables, Indexes, and Profiles
  • Identifying Blocks in DB level and acting accordingly.
  • Enrolling new users and maintaining system security (Profiles), Roles, System and Object Privileges and managing user quotas.
  • Monitoring physical and logical backup strategies.
  • Monitoring database and collecting statistics by using EXPLAIN PLAN.
  • Creation of Clone database for test database environment.
  • Logical Backup of Databases using Export and Import Utility.
  • Modifying stored procedures/function on request for enhancement of Business Logic.

Education

Master of Science - Computer Science

SRM University
Chennai
05.2014

Bachelor of Science - Computer Science

JNTU Anantapur
AndhraPradesh
06.2012

High School Diploma -

State Board
Andhra Pradesh
04.2006

Skills

  • AIX , LINUX
  • TOAD , SQL Developer,Sqoop,Hive
  • Databases
  • Oracle10g,11g,19c, MSSQL 2008 R2, MYSQL 57,8,MariaDB , PostgreSQL, Aurora MySQL,Maxscale
  • SQL,PL/SQL,python,Bash
  • Gitlab CI/CD
  • AWS EC2, Lambda, RDS, GCP Compute and CSQL
  • Percona-tool-kit

Timeline

Senior Database Engineer

Grab
01.2022 - Current

Senior Associate

DBS Bank
03.2020 - 12.2021

Senior Database Administrator

OPTIMUM Solutions To DBS Bank
09.2017 - 03.2020

L2 DBA

MINDTREE Ltd
06.2015 - 09.2017

Database Administrator

BNP, with HCL Infosystems Ltd
09.2014 - 06.2015

Master of Science - Computer Science

SRM University

Bachelor of Science - Computer Science

JNTU Anantapur

High School Diploma -

State Board
Kiran kumar Salla