Kiran PS

Interacting with Product Managers for identification of Non-Functional Requirements (NF

• Experience in capacity planning (Estimating CPU cores, Memory Size, Storage Size, JVM parameters)
• Generating test scripts using Load Runner
• Performed different load tests to check the Application and Database response: Baseline, Benchmarks, Stress
  Tests, and Longevity Tests.
• Expertise in analyzing nmon data (CPU, Memory, IOPS) and identifying the resource usage over the test.
• In-depth knowledge in generating and analyzing AWR Reports from standalone Oracle DB and Oracle RAC DB
• Expertise in running performance tests to certify Oracle’s Quarterly Critical Patch Updates (weblogic, database patches) on Oracle HSGBU products.
• Have worked with Oracle RDBMS team for solutions on various Database related performance issues.
• Have used cx_oracle python extension module and automated gathering stale stats on 50 Database servers.
• Have automated generating tablespace utilization report from 50 Database servers using cx_oracle and Oracle Client
• Have automated running nmon binary to capture resource utilizations of the Linux Servers using Shell Scripts and download them using SimpleHTTPServer python module.
• Utilized Ansible to automate password resets for hundreds of users across numerous Windows hosts.
• As part of a performance use case, have written shell scripts to copy/Load files of various sizes to a common location where the application services can pick them up for data processing.
• Have written shell scripts that can capture and insert the Shared_Pool Utilization, PGA and SGA utilization of the Oracle PDB and CDB during the performance tests.
• As a POC, have written Terraform scripts (Infrastructure as Code) to provision several Oracle Cloud Resources (VM’s, Availability Domains, DVH, adding SSH public Keys, boot volume, block volumes etc)
• Have written simple Batch scripts to start and stop application services on Windows Machines
• Have written simple Shell scripts to start and stop application services (Weblogic, DB) on Linux Machines
• Have automated the process of generating the DB parameters from Oracle PDB and CDB. This helped in identifying any changes in the DB Parameters between the releases/builds/patch sets.
• Have setup Elasticsearch service, filebeat and metricbeat to collect, analyze and visualize log data and system utilization metrics for real-time monitoring and performance analysis.
• Performance bottlenecks Identified during the tests:
  ▪ Increasing Heap (On Middle Tier Hosts)
  ▪ PGA Limit exhausted
  ▪ LMS Packet Drops
  ▪ OutOfMemory Exceptions
  ▪ Row Locks
  ▪ Deadlocks
  ▪ Timeouts
  ▪ Asynchronous Job Failures
  ▪ Issues with rngd, crowdstrike services
  ▪ enq:CB > DFS Locks impacting install jobs
  ▪ Increasing Shared Pool Usage
  ▪ Degradation with DB Editions
  ▪ High AE Locks impacting Loads and Transformations
  ▪ Performance Degradation because of NUMA parameters
  ▪ Issues with Tablespace utilization
  ▪ DB grants causing performance issues

• Interacting with Product Managers for identification of Non-Functional Requirements
• Installing and Configuring Application servers: Apache Tomcat
• Deploying and Configuring Web Applications in to Application Servers: Apache Tomcat
• Developing load profiling using WebLog Expert.
• Experience in capacity planning (Estimating CPU cores, Memory Size, Storage Size, JVM parameters)
• Generating test scripts using Neoload
• Preparing Test Data for Performance executions
• Enhancing scripts by Parameterization, Correlation and JavaScripts.
• Creating and executing scenarios in Neoload Controller
• Analyzing performance test results (Response Times, Availability, Scalability), preparing reports and giving suggestions
  to the Dev team
• Analyzing full diagnostic details of every transaction/requests, their network data, server data deep down to code and database level using APM’s (Riverbed SteelCentral AppInternals)
• Monitoring JVM, Heap Utilization using jvisualvm.
• Design and Run performance test scenarios for baseline tests, benchmark tests, load tests, scalability tests and Longevity tests.
• Conducting load tests to validate the response and script stabilization.
• Engineering review meetings, explaining bottlenecks found during the load tests.

• Completely Validated JDBC Driver, an Identity Manager Driver for Java Database Connectivity (JDBC) which provides a generic solution for synchronizing data between an Identity Vault and relational databases.
• Data Migration from Postgres 8.X to Postgres 9.X using pg_upgrade and psql utilities.
• Installing and Configuring eDirectory, Identity Manager Engine, Identity Applications, Identity Reporting and
  Sentinel on Windows, SUSE Linux and Red hat Linux
• Completely Validated Identity Reporting Module on Oracle 12.2 and PostgreSQL Databases.
• Validated Data Collection Service Driver and Managed System Gateway Driver that are used to collect data about changes made to user accounts, roles, resources, group memberships, and other objects in the vault.
• Validated custom REST endpoints to collect data from third-party applications.
• Validated audits, reports and logs using Sentinel, a Security Information and Event Management.
• Worked on Authorization Protocols: OAuth 2.0, SAML that provides access tokens and Single Sign On capabilities.

• Environment: Windows 7, JAVA technologies, JBoss server and Oracle Database
• Products: MagIC3 Management System7.X, MagIC3 Management System 8.X versions
• Domain: Point of Sale
• Tools: LoadRunner, WebLog Expert, Fiddler, Postman, Jconsole, JIRA, Mantis

• Environment: Windows 7, JAVA technologies, JBoss server and Oracle Database
• Domain: eCommerce(B2B)
• Tools: Load Runner 9.0/9.5