Shivakrishna Kamarapu

database administrator with 15+ years of experience in various databases administration like Postgres, SAP Sybase ASE , replication, Oracle, SQL Server .

IT professional with 14+ Years of comprehensive experience as a Database Administrator on Sybase , PostgreSQL and SQL Server databases, managing Standalone and clustered Environments with SAP HADR replication and supporting Sybase database versions 15/16 databases on various OS platforms - RHEL, Solaris, AIX and windows, SUSE and implemented HADR in all environments – Production/UAT/Dev.  14+ years of experience in Sybase ASE, replication, HADR switch over, switch back.  Worked on Postgres Patroni clustered Environment.  Worked on ETL loading data from flat files to the database.  6 years of experience in PostgreSQL Database Administration.  Worked on PostgreSQL 10.x,11.x,12.x,13.x,14.x,15.x versions.  Expertise in Installation, Implementation and Sybase databases and replication technologies HADR, Homogeneous and heterogeneous replication setup.  Strong Technical skills include SAP products – Sybase ASE Database, IQ Server, SQL Anywhere and replication.  Expertise on various Installation, configuration, patching and upgradation of ASE server.  Expertise in SAP HADR configuration and perform DR drills.  Proficient in development of log-based replication using replication server.  Adept in software installation, Configuration, Monitoring, Backup and Recovery.  Experience with AZURE PostgreSQL.  Flat file loading /exporting using BCP utility.  Database Refresh from Production to UAT based on requirement.  Daily check of Sybase error log and backup server log of all databases servers.  Experience in handling production database support and maintenance.  Migrated Azure database for PostgreSQL.  Performance Tuning of Databases by analyzing Sysmon and regular deep dive reports.  Monitoring performance using Sysmon Reports.  Monitoring and assisting in optimizing the SQL/Database to attain peak performance.  Experience with switchover and switch back.  Created Container and pluggable databases and migrated databases from non-PDB to PDB  Performed auditing setup.  Implemented database security by creating user specific groups, roles.  Installed, configured, and migrated existing PostgreSQL databases.  Maintained and optimized PostgreSQL database application performance through tuning.  Manage and administer PostgreSQL databases, including Database and schema management.  Handle PostgreSQL Roles Administration, managing user access and privileges.  Perform backup and restore operations for PostgreSQL databases.  Manage PostgreSQL tablespaces for efficient storage organization.  Utilize PostgreSQL tools like PGADMIN, PEM, BART, EFM, BARMAN, REPMGR, PGBACKREST, etc.  Configure and set up High Availability, Load Balancing, and Replication for PostgreSQL.  Ensure reliability and manage the Write-Ahead Log for data consistency.  Optimize performance and tune queries for efficient database operation.  Perform regular database maintenance tasks such as Vacuuming, Reindexing, and managing log and WAL files.  Develop automation scripts for PostgreSQL database management.  Excellent Team player with good communication.  Provided technical troubleshooting and gave consultation to development teams.  Experience in automating jobs through shell scripting.

Completed Master of technology on software Engineering.