Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Kishor Pannala

West Chester,PA

Summary

  • Experienced engineer with over 16 years of IT experience, specializing in database administration and cloud computing.
  • Extensive experience in using NoSQL databases (MongoDB, Cassandra), SQL Server and PostgreSQL.
  • Proficient in Cloud techonologies Openstack and CCP private cloud.
  • Capable of operating on leading cloud platforms such as AWS and Azure.
  • Good experience in Linux and shell/bash scripting, Python.
  • Proficient in database administration including design, implementation, performance tuning, backup/recovery, security, data modeling, and advanced query optimization.
  • Familiar with CI/CD automation, Terraform, Ansible, Kubernetes, and Docker.
  • Experience installing, configuring, maintaining, and upgrading Apache technologies (Kafka, Flink, Spark).
  • Experience with various logging mechanisms, such as logstash, Prometheus, Kibana ELK, and Grafana.
  • Familiar with ServiceNow Change Management, Rally, and Jira.
  • Proven ability to manage and respond to project-related alerts and incidents 24/7 for system stability.
  • Holding a team lead role in project coordination and execution.

Overview

19
19
years of professional experience
1
1
Certification

Work History

Database administrator

Comcast
12.2019 - Current
  • Responsible for MongoDB installation, administration, maintenance, performance analysis, and capacity planning, as well as upgrades to newer versions
  • Working on security (Users creation), backup, data export and import, replication and sharding to increase data availability and performance
  • MongoDB migration from one cloud to another
  • Performance tuning and indexing strategies using Mongo utilities like Mongostat and Mongotop
  • Working on Cassandra installation and configuring a multi-datacenter cluster, and monitoring all environments
  • Adding a new datacenter to the existing Cassandra cluster and upgrading the Cassandra
  • Cassandra DB migration from one cloud to another and data copy from one environment to another using dsbulkloader
  • Cassandra repairs using Nodetool and using DevCenter UI to access data
  • PostgreSQL installation and maintenance
  • Also, configured patroni is used to monitor the health of PostgreSQL instances and to change the dynamic configuration
  • Managed and monitored databases using pgAdmin
  • Performing core DBA tasks such as creating roles, granting privileges, and creating tables
  • Upgrading databases servers leveraging PG dump, PG restore, and PG upgrade
  • Creating VMs in Openstack and maintenance like rescue, resize VMs, and security group updates
  • Configure and maintain AWS services such as EC2, S3, RDS, and VPC
  • Design and implement automated testing and deployment of AWS Lambda functions
  • Azure Virtual Machines creation, configuration, and setup of Azure Blob Storage
  • DeployedKafkabrokerson a Kubernetes cluster and Kakfa connector configuration
  • Also, Kinesis stream validation and post and read test data from those streams
  • Installation of Flink and Spark, including end-end maintenance and upgradation
  • Configured Docker in VM and added to Grafana using Prometheus as a data source, for instance, availability check
  • Develop and maintain automation scripts using Python and Shell scripting for repeated tasks
  • Collaborate with DevOps, Security, and Development teams to support cloud-based applications and services
  • Working on various Apache technologies and logging mechanisms: logstash, vector, and Grafana
  • Work on change management in service now and Jira for user stories
  • Provided 24
  • 7 support for all critical production environments
  • Gathering requirements for the infrastructure to run the applications
  • Providing time estimates for infrastructure development and upgrades in cloud environments, as requested by the application development team
  • Handling the offshore infrastructure team and tracking and reporting on the progress of infrastructure-level developments and upgrades
  • Providing support for infrastructure-related issues.

System Administrator

IQVIA
09.2017 - 12.2019
  • Designed, Installed and configured multi node MongoDB sharded cluster and replica sets
  • Creation of users and assigning custom roles to provide access
  • Configured MongoDB LDAP/Kerberose authentication for security
  • Configured SSL keyfiles to implement security across all mongod instances
  • Experience with Ops manager installation, configuration helps to manage, monitor, back up, and deploy MongoDB deployments
  • Experience with MongoDB tools, mongodump, mongorestore and mongoexport, mongoimport
  • Setting up job scheduling using cron jobs, writing and running a Bash/Shell script
  • Created and managed indexes in MongoDB as part of query optimization/tuning to improve performance
  • Use MongoDB's aggregation framework to generate client-specific data trends
  • Configure BI Connector with MySQL Connector to provide SQL-based access to MongoDB databases
  • Resolution of day-to-day issues, including documentation of Mongo DBA routine tasks
  • Migrated databases from on-premise to cloud, providing high availability and scalability
  • Developed a disaster recovery plan that ensured data availability and integrity in the event of an outage
  • Data conversions with node.js and Java script based on data validation rules
  • Managed user accounts, passwords, and access privileges to ensure secure access to applications and data
  • Collaborated with developers and stakeholders to ensure database requirements are met
  • Provided 24/7 on-call support for critical MongoDB production environments
  • Experience in various DB tools like MongoDB Compass, Studio 3T.

Application Consultant

IBM Royal Dutch Shell
12.2016 - 09.2017
  • Installed and configured MongoDB in multiple datacenters as cluster
  • MongoDB's backup and recovery methods have been configured
  • Replica set configuration provides redundancy and improves data availability
  • Configure Sharding to distribute data across multiple machines
  • Daily health check of MongoDB database, identifying issues and providing root cause analysis
  • Potentially long running index building operations performed by creating Index in background
  • Monitored various issues related with Database, Monitoring at Server, Database, Collection Level
  • Experienced with MongoDB monitoring tools such as database profiling, locks, memory usage, and number of connections
  • Performed database migrations and upgrades, as well as server performance tuning and recommendations
  • Replica sets and sharding were recommended as high availability solutions
  • Performed Export and Import of Data to and From MongoDB, Run time configuration of MongoDB
  • Worked on HA and DR configuration issues
  • Tracing connections to the Mongo database and monitoring utilization of resources for each process
  • Enabling profiling level to debug issues and tuning long running queries.

SAP BASIS Administrator

IBM GrainCorp
10.2014 - 12.2016
  • System monitoring (daily checks, logs, dumps, locks, updates, IDOCS)
  • Batch job management
  • Output/Spool monitoring and management
  • Performance monitoring and analysis and improvement
  • Landscape management (RFC destinations, transports ABAP & JAVA, apply OSS notes, client settings, client copy, client refresh)
  • Environment management (system restarts, parameter changes)
  • Database administration, working with Oracle DBAs to define data archiving steps and performing the same using TCs, SAP DBA integration with SAP DBA
  • Database performance analysis and tuning (ST01, STO2, STO3, ST04, STO5, ST22), RFC and ALE configuration
  • (SM59, SALE) Administering lock entries and update records
  • (SM12, SM13, SM14)| SQL Server 2008 performance monitoring and management
  • Input to functional team for problem resolution where necessary
  • Helpdesk call monitoring and resolution, Service desk and Bug host Call resolution
  • Responsible for creating R/3 users with defined Role based authorizations
  • Thoroughly understanding the requirements of the business and technical architects, carrying out the Role design, Role Configuration, Role Derivation as per the specification of clients
  • Maintaining authorizations, determining authorization failures and resolving
  • Supporting Post Go-live of the deployments.

SAP BASIS Administrator

IBM Celestica
06.2010 - 10.2014
  • Installed and configured SAP R/3 4.6C
  • Configured the Transport Management System of newly created SAP systems
  • Applied R3 Support Packs, upgraded Kernel and OSS notes
  • Performed homogeneous system copies
  • SPAM update, plug-in installation, Imported profiles, Client Copy Client creation and management, Profile management and configuration System monitoring tuning and troubleshooting (SMO4, ST06, ST03, AL08) Database monitoring and problem solving (DB02, ST04, DB12, ST04) Troubleshoot the R/3 security problem by using different scenario such as system trace, parameter change, buffer reset, SU53, and SU56 in order to find security problem
  • Configure and maintain system operation modes & profiles, apply SAP Patches and support package application, resolve SAPGUI issues
  • Performed workload analysis and tuning Involved in Printer Setup and Spool Administration
  • SQL Server DBA activities like backup, recovery and daily jobs monitoring.

SQL Server Database Administrator

Sysnet technology solutions
09.2005 - 10.2009
  • Extensive experience in Installation, Configuration and Updates of SQL Server
  • Responsible for backup management of SQL database
  • Provided 24/7 support for all production environments
  • Managed Database shrink to recover the unused space
  • Modified the initial size of data files
  • Managed transaction logs shrink/truncate
  • Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS
  • Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Standards
  • Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler
  • Experienced in solving real-time issues with indexing, fragmentation, DBCC checks, Query Tuning, error handling and Event Handling
  • Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshooting migration issues
  • Experienced in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
  • Troubleshoot of all day-to-day issues across the landscape supporting prod break fix
  • Daily monitoring and health check of all production system
  • Resolved incidents tickets raised by the users.

Education

Master of Computer Applications -

Bachelor of Computer Science - undefined

Skills

  • AWS, Azure, Openstack, CCP
  • SQL Server,PostgreSQL, MySQL
  • Logstash, Prometheus, Elastic Search ELK, Grafana
  • SAP BASIS
  • MongoDB,Cassandra
  • Windows
  • ServiceNow, Rally, Jira
  • Linux, Shell Scripting
  • Python, MQL, T-SQL
  • Kafka, Kinesis, Flink, Spark

Certification

Microsoft Certified Professional in Administering Microsoft SQL Server 2012/2014 Editions

Languages

English

Timeline

Database administrator

Comcast
12.2019 - Current

System Administrator

IQVIA
09.2017 - 12.2019

Application Consultant

IBM Royal Dutch Shell
12.2016 - 09.2017

SAP BASIS Administrator

IBM GrainCorp
10.2014 - 12.2016

SAP BASIS Administrator

IBM Celestica
06.2010 - 10.2014

SQL Server Database Administrator

Sysnet technology solutions
09.2005 - 10.2009

Master of Computer Applications -

Bachelor of Computer Science - undefined

Similar Profiles

CREATE PROFILE
Kishor Pannala