KRISHNA PALAGIRI Email: Krishna.oracledba1986@gmail.
com
Oracle & PostgreSQL DBA Cell No: 91+ 9108853937
LinkedIn: https://www.linkedin.com/in/chenna-krishna-b32a3128b/
Work Experience:
Working as an Oracle and PostgreSQL DBA with 12c, and 19c for “Cognizant technology
solutions”, Bangalore from OCT 2022 to till Present.
Worked as an Oracle Database Administrator with 11g and 12c for “Harman India Pvt
Ltd”, Bangalore from APR 2021 to OCT 2022.
Worked as an Oracle Database Administrator with 10g,11g versions for “Oracle India Pvt
Ltd”, Bangalore from Jan 2017 to APR 2021.
Technical Skills:
• 8+ Years of experience on Oracle 11g,12c &19c as Database Administrator using
Real Application clusters (RAC) and PostgreSQL 14,15,16.
• Having Good Experience in Architecture in Oracle and PostgreSQL database.
• Exporting and Importing database backups in EXPDP & IMPDP using Parfile
method utilities.
• Having good experience with Oracle backup, recovery, transportable table space,
RAC, data guard, and performance tuning.
• Good experience on database & User creation in PostgreSQL
• Having experience on applying the database PSU patches & RU Patches using
Opatch Utility.
• Having good Experience backup database & schema and tables using PG_DUMP,
PG_basebackup utilities in PostgreSQL
• Having Good Experience to up gradation of database from 11g, 12c & 19c.
• Having Good Knowledge on performance tuning in PostgreSQL.
• Experience on DATAGUARD Configuration, and maintaining Physical standby
databases Active data guard & Snapshot standby database.
• Having Experience on streaming replication and logical replication on PostgreSQL
• Experience supporting production databases in AWS and experience with RAC
• Expert in Oracle RAC, data guard, TDE, PDB.
• Experience in Gathering statistics in schema level and table to improve the
performance.
• Having Experience on Reorganization of tables to improve the performance
• Postgres Database Installation
• Postgres performance monitoring and troubleshooting
• Experience with Postgres Data Loading
• Experience with Production Support and working on shifts/on-call rotation.
• Perform database administration tasks including backup and recovery,
troubleshooting,
• performance tuning and SQL optimization
• Willing to work in a 24x7 environment and participate in on-call rotation.
• Experience in Oracle Security products like Data Vault, Key Vault.
• Having Good Experience on Rebuild the indexes to improve the performance.
• Expert Managing RAC Databases, patching of Databases, Standby databases (Oracle
Data Guard). Troubleshooting RAC or cluster ware environments.
• Experience on applying the Patch for RAC database using Opatch.
• Experience on handling multiple instance Databases with RAC and familiar with
CRSCTL and SRVCTL commands.
• Familiarity with Oracle Enterprise Manager (OEM)
• Regularly checking sync up primary with physical Standby Database.
• Worked with Oracle support services for fixing the issues on requirement.
• Experience with Oracle AWR, ADDM, and ASH reports
Academic Qualification:
MCA (computers) from RIIMS College with aggregate 78% in the year 2010-2013 from
S.V. University, Tirupati.
Skill set:
Operating Systems : RHEL, HPUX, IBMAIX
Databases : Oracle 11g/12c/19c, PostgreSQL 13–16
Tools & Utilities : OEM13c, Service Now, SQL developer, PostgreSQL Streaming
Replication, PgAdmin, Pg_dumpall, pg_restore.
Project #3
Client : One America & Kaiser Permanente
Organization : Cognizant Technologies Solutions
Work Location : Bangalore
Designation : Senior Database Administrator
Duration : Oct 2022 to till Present.
Responsibilities:
• Interacting with Oracle Corporation for technical support through Meta link.
• Backup and recovery using RMAN methodology.
• Having experience on Grid patching in RAC Database
• Good Experience on Configured Data guard and tested for switchover & failover
Activity.
• Rebuilding the indexes to improve the performance.
• Checking the health of database daily and prepare the backup status report to
client as per Agreement.
Project #2
Client : PepsiCo
Organization : Harman India Pvt Ltd
Work Location : Bangalore
Designation : Oracle Database Administrator
Duration : APR 2021 to OCT 2022
Responsibilities:
• Planning and Scheduling Physical and Logical & RMAN Backups based on
environment.
• Performing Backup, restore and Recovery using RMAN.
• Performances tuning using Oracle utilities like EXPLAIN PLAN.
• Gathering statistics on schema and schema objects.
• Experience in RMAN cloning.
• Having Experience in schema refresh and Database refresh using Logical
backups.
• Having experience on schema creation and provide the privileges based on client
requirement in PostgreSQL.
• Experience in Expdp/Impdp and Data pump utilities.
• Handling responsible for both manage and support for all production, development
and staging instances.
• Handling issues on RAC and ASM, managing disks and disk groups using ASM.
• Starting & stopping RAC instance with SRVCTL.
• Performing daily health checks of RAC instances and databases Regular monitoring
of Alert log file on day-to-day basis.
• Cloning/Refresh from PRODUCTION instance to TEST instances using both Hot and
Cold Backup& Rman.
• Setup in configuring of Data Guard Involved in switch over.
• Maintaining the Physical Standby database & troubleshooting with problems
regarding the Data Guard issues.
• Provided all kinds of DBA support to development teams to various applications.
Project #1
Client : GE Health Care
Organization : Oracle India Pvt Ltd
Work Location : Bangalore
Designation : Database Administrator
Duration : Jan 2017 to APR 2021.
Responsibilities:
• Performing daily health checks of RAC instances and databases.
• Taking OCR and Voting Disk backups manually if required.
• Patched & upgraded databases in a 2 Node RAC environment.
• Monitoring health check of Cluster databases.
• Escalate database issues to Oracle Support via Meta link.
• Tuning the application and database according to the company policies.
• Perform Backup and Recovery on Oracle databases.
• Checking Alert Log file for errors and making necessary actions to rectify them.
• Monitoring of Table spaces based upon alerts.
• Troubleshooting with problems regarding the Data Guard issues.
• Applying CPU and PSU Patches on stand-alone environments.
• Monitoring the RAC database using SRVCTL commands.
• Handling issues on RAC and ASM, Managing disks and disk groups using ASM.
