Rama Krishna K

ad0fon@r.postjobfree.com

Phone: 903-***-****

LinkedIn: https://www.linkedin.com/in/rama-krishna-k-094b3441/

Summary

Around 15+ years of IT experience as Oracle DBA (SME), providing 24/7 on call support at L4 level for both production and Non-prod databases on Various Platforms like Sun Solaris, Red hat Linux, HP-UX, AIX and Windows.

Experience in OLTP/DSS/DW database systems on oracle 11g,12c,18c,19c, managing large and high available Oracle databases up to 20TB in size for various projects supporting People soft, CRM, Telegence,SAS,SAP and voice portal applications.

Good working experience on improving query performance of peoplesoft applications by using PSCBO.

Experienced in implementing row level security and TDE in oracle databases.

Experienced in Database upgrades from 12c and 18c to 19c version with minimal down time and post upgrade support to improve performance on 19c version.

Expert skill in implementing advanced features of oracle 19c.Good knowledge on SAP Hana.

Migration Expert in Database migrations for Oracle from physical machines to Azure, AWS cloud (RDS) and VMWARE.

Good working knowledge on managing snowflake databases and cosmos on Azure cloud.

Golden-gate expert for replication implementations across oracle to oracle and oracle to other platforms like Postgres.

Implemented Goldengate unidirectional and bi-directional (ACTIVE-ACTIVE) replications fsor mission critical business applications like Argus.

Good experience in resolving conflict in goldengate active-active setups.

Expert in implementing oracle Active datagaurd for real time reporting on over 100+ mission critical databases.

Experienced on managing Oracle Golden gate 19c, 21.3 and 21.6

Configured uni-directional replications using Goldengate 21.3, 21.6 for Oracle 19 database schemas and tables.

Identified and fixed out of sync issues between primary and standby databases that are setup with ACTIVE-DATAGARUD.

Implemented Goldengate for DB migrations from on premise databases to OCI and Amazon RDS instances to accomplish near zero downtime migrations.

Managed OCI autonomous oracle databases and also worked on Goldengate replication process on OCI.

Good working knowledge on managing oracle DB’s on Exadata and PCA X9-2 machines.

Good working experience with Ansible playbooks and automation.

Expert level skill in identifying and resolving goldengate replication issues using LOGDUMP,GGSEVT utilities for both unidirectional and bidirectional replications.

Good working knowledge on OCI architecture and implementations.

Good working experience in implementing Oracle integration cloud (OCI)for integration of cloud based applications and on premise apps

Good knowledge and working experience on provisioning and managing ATP (Autonomous transaction processing) on Oracle Cloud Infrastructure(OCI).

Expert level skills in identifying Goldengate performance related issues and fixes.

Excellent experience in building VMWARE systems along with RHEL implementations.

Expert skills in migrating and managing Oracle Databases on AWS cloud infrastructure.

Expert in Database upgrades from 11g and 12c to Oracle 18c and 19c and have performed upgrades for over 500 + instances in recent years.

RMAN backup configuration expert and also experienced in recovering databases using RMAN whenever required.

Experience in using 12c and 13c OEM, TOAD, and Data Migrations using Export/Import, RMAN XTTS, benchmarking using Load testing tools.

Excellent experience in identifying and resolving Node evictions on Oracle 11g,12c,18c RAC production systems on VBLOCK machines and Engineered systems.

Excellent working knowledge of managing ORACLE RAC using CRSCTL, SRVCTL, ASMCMD utilities.

Strong experience in managing multiple oracle 12c and18c RAC databases on EXADATA x5-2,X6-2,X7 machines.

Strong working experience in applying patches to databases and storage layers on Exadata machines.

Migrated several databases from Physical machines to Exadata x6,X7 machines using Datapump and Physical data gaurd methedologies.

Performance Tuning expert for identifying and trouble shooting P1 issues on mission critical databases.

Identified and fixed performance issues for oracle databases on EXADATA X6,X7 and X8,X9 machines.

Experienced in working and coordinating with internal and external auditors for SOX audits.

Excellent working knowledge in handling SMART SCANS, Flash cache and Hybrid columnar compression in EXADATA machines.

Excellent knowledge and experience in installing and configuring Oracle 12c and OEM 13c cloud control.

Good working knowledge of PostgreSQL 10.* and 11.8 versions on Linux platforms.

Experienced in configuring Monitoring templates, Metrics and policy setting using 12c OEM and Oracle Enterprise Manager Cloud Control 13c Release 2.

Excellent experience in recovering databases and tablespaces using RMAN recovery strategies during storage corruptions and outages.

Technical Skills

Operating Systems

HP-UX 10.x, 11.x, Sun Solaris 9, 10, AIX 6.*,7.*

Red Hat Linux/7.*,8.* and Windows 95/98/ME/NT/2000/XP.

RDBMS

Oracle 19c,18c 12c,11g,10g/9i/8i,Postgresql 9*

Languages

SQL, PL/SQL, C, C++,Java, UNIX Shell Scripting,

Tools

RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp, TOAD,VB

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK

Database Modeling

Erwin 4.0, Rational rose

Other

EMC, NetApp, VERITAS NetBackup, Golden gate

Education

MBA information systems from Texas A&M university commerce TX USA-2007

Professional Career

Novartis/Alcon,Fortworth,TX August 2014 –Till Date

Sr. Lead Oracle DBA L4/SME/Architect

At Novartis/Alcon I am part of database engineering team of 18 oracle and sqlserver dba’s and working as SME/L4 supporting over 3000+ oracle databases with mission critical SAP,CRM,ARGUS,Peoplesoft applications. As part of engineering team and in my role as Lead dba I have supported testing new oracle products and prepare documentation (IQ’s, WI, SOP and standards) and certify them to be used by our operation teams. I am also engaged in providing L4 dba support during outages and major critical issue resolutions and recommend new technologies and products to enhance the services like MYSQL and PostgreSQL databases along with Oracle. We have wide range of oracle databases on AIX, WINDOWS and Linux with many mission critical databases ranging from 4 to 8 TB in size and on 4 node RAC clusters on VBLOCK and Exadata X6 and X7 machines. I am the lead for DC migration project for migrating over 800 + databases from Novartis domain to Alcon.

Provided 24/7 production dba support at L4 level for Oracle 19c,18c,12c,11g database versions in lead role for over 3000+ Mission critical production and non-prod databases on various Linux/Unix environments and windows servers.

Created over 80+ two node oracle 12c,18c and 19c RAC databases for various mission critical applications on AIX 7.* LPARS and Exadata machines and provided end to end support.

Involved in 300+ oracle database upgrades for mission critical SAP, CRM, peoplesoft oracle databases from 11.2.0.4 and 12cR2 to 18c and 19c and provided post upgrade support.

Performance tuning specialist, Worked and fixed several performance issues after database upgrades to 12c and 18c using AWR, ADDM, ASH reports.

Worked on Amazon aurora Postgre sql and also installed and managed Postgresql databases on premise.

Worked on supporting azure SQL and cosmos database and migrated few oracle databases to azure sql.

Fixed Post upgrade performance issues due to change in optimizer behavior for few sql’s on 19c.

Implemented uni directional Goldengate replication for Mission critical production tables using integrated model of Golden gate 21.6 version.

Tuned the golden gate replication speed using multiple extracts and replicates

Upgraded golden gate 19c to 21c on Linux VM’s.

Configured Oracle Exadata database backups to ZDLRA.

Good working knowledge of onboarding and setting up oracle databases backups in ZDLRA.

Worked along with SAP HANA team to support SAP databases, and have good knowledge and understanding of SAP HANA.

Worked on managing cosmos databases on Azure cloud and good working knowledge on migrations from oracle to azure sql.

Installed and managed Mysql databases for one of our reporting applications.

Configured and implemented Mysql backups and also performed upgraded and recoveries.

Maintained version control and source code using GIT. And JIRA.

Worked om automation using Ansible play books.

Worked closely with oracle platinum support during Exatada and PCA patching cycles.

Implemented HA and always on or many sql server databases for mission critical databases.

Worked on database mirroring for MS sql server databases as required by application teams.

Worked on API’s before release cycles to maintain the application code integrity.

Implemented active datagaurd for mission critical databases and reporting databases using 19c Active datagaurd utility.

Implemented Goldengate unidirectional and bi-directional replications for mission critical business applications like Argus, Oracle fusion application suporting databases.

Worked with application teams in implementing Oracle cloud integration(OCI) to perform integration of Cloud based applications.

Managed ATP oracle databases and Goldengate on OCI.

Conducted POC for implementation of PCA X9-2 for one of our mission critical databases.

Identified and fixed Goldengate replication issues like abend and process lag, also finetuned goldengate setup to use multiple replicats to speedup recovery process when needed.

As part of the data center migration i have leverage datagaurd and Goldengate to accomplish near zero down time migrations for multi terabytes databases.

Implemented Goldengate for DB migrations from on premise databases to Cloud.

Expert level skill in identifying and resolving goldengate replication issues using LOGDUMP,GGSEVT utilities for both unidirectional and bidirectional replications.

Implemented Oracle database Audit for SOX and GXP compliant databases to protect any data breaches.

Hands on experience in Amazon Web Services (AWS) provisioning and good knowledge of AWS services like EC2, S3.

Involved in migrating Oracle databases to AWS RDS using utility AWS Database Migration Service

Worked on installing and configuring Active DataGuard for AWS instances.

Developed scripts to harden and secure oracle databases and also automated the process to harden new builds.

Created over 70+ VMware machines and installed RHEL 7.*,8.* and setup oracle 18c and 19c databases.

Developed shell scripts using Korn shell to automate the oracle builds and daily monitoring alerts for production databases.

Configured RMAN backups for more than 300+ oracle 12c and 18c databases using NETBACKUP media management layer and IBM TIVOLI for some databases and DDBOOST.

Designed and implemented oracle backups to EMC datadomain storage system for over 600+ databases.

Lead the Moon stone project for database migrations from Novartis domain to Alcon domian for over 600+ oracle systems.

Recovered many databases using RMAN during database clock corruptions and storage corruptions.

Designed and migrated several databases to AWS public cloud. Also coordinated efforts with application teams during the app migrations to AWS.

Tested and documented various recovery scenarios using RMAN and back end tape systems like NetBackup and Data domain.

Applied PSU patches for oracle 12c and 18c multitenant and non-container databases on a regular basis and sucessfully rolled back the patches whenever required.

Tested and prepared WI and IQ’s for installing and configuring oracle 12c,18c and 19c on windows and Linux OS.

Worked along with SAP and Peoplesoft application teams during application deployments and upgrades.

Designed and Installed and configured OEM 13c with high availability architecture and lead a project to deploy 13c OEM agents to over 2000+ oracle databases.

Installed and implemented FSFO for some of mission critical production systems using dataguard broker and performed switch over drills.

Provided L4 dba support to HCL dba’s whenever they needed expert advice to troubleshoot and fix critical issues while providing production support to some of the productions systems owned by engineering team.

Migrated the current Linux environment to AWS/RHEL Linux environment and used auto scaling feature.

Provided support for oracle Exadata X5, X6-2,X7 half RAC machines for GENMEDS project.Also worked on various advanced features of exadata like SMART scans, flash cache and HCC.

Migrated mission critical production database upto 5TB to Exadata x6 and x7 machines and provided support for both database nodes and storage cells.

Worked along with oracle support during Patching of exadata compute nodes,storage cells.

Provided application dba support to ARGUS application which has 4 (8TB) oracle 11g 2 node rac databases and physical standby setup.Involved in resolving many RAC outages

Resolved many outages of oracle 12c and 18c RAC databases caused due to Node evictions resulting from voting disk and OCR file corruptions and ASM related issues.

Configured oracle wallets for SOX compliant databases to enhance security.

Set database auditing and worked on streamlining privileges suing role based security model.

Performed several database refreshes using RMAN cloning process and schema level refreshes using datapump.

Worked on identifying and resolving Golden gate issues due to network issues, and replication failures.

Upgraded golden gate from 11.1 to 12.2 and also configured veridata for monitoring out of sync issues for Golden gate setups.

Implemented Disaster recover using Physical datagaurd for many mission critical production and validation databases, also automated the process of client failover during switch over drills.

Worked on fixing out of sync issues for datagaurd instances due to network failures and log shipping issues in several cases.

Worked on automation of database builds and patching for standalone databases using silent and

Cloning methods and automated the process using CHEF.

Worked on migrating tns names architecture to LDAP and also worked on user migrations to active directory.

Implemented Database auditing using FGA for GXP and SOX compliant databases.

Installed and managed sqlserver 2012 on windows server 2012 R2 and also provided support for app teams in managing sql instances.

Worked closely with sql dba teams in implementing mirroring and replication for sql server databases.

AVAYA,COPPELL,Texas March 2014 –AUGUST 2014

Sr. oracle DBA L4/SME

At Avaya I worked a principle dba for a data center migration project to move over 300 oracle 10g and 11g databases from Westminster datacenter to Lebanon (Ohio) DC and also did upgrades to oracle 12c.I also provided production dba L4 support to build new two and four node 11g and 12c rac clusters on Linux. Also performed several database upgrades from 10g to 11g and also migrated 15+ prod and 85 non-prod databases from physical servers to oracle VM’s.

Provided 24/7 production dba support at L4 level for over 600+ Mission critical production and non-prod databases on various Unix environments like Linux, Solaris 10, HP-UX and Aix and windows platforms.

Installed and configured oracle 12cR1 databases using multitenant option on AIX LPARS and Vblock machines.

Installed and created oracle 12c databases for peoplesoft applications.

Worked on improving oracle db issues for peoplesoft by implementing PCBO to tune the optimizer decision improvement.

Identified and fixed the Database configurations for optimal performance of peoplesoft applications.

Extensively used RMAN for back up and recovery strategies and also for Database clonings.

Configured and managed ACTIVE datagaurd setups for 30 production systems.

Upgraded over 100+ oracle databases supporting SAP and voice portal applications from 11.2.0.4 to oracle 12.1.0.2 and later converted some of these databases to multitenant databases.

Set up of physical standby databases for more than 30 production databases and also configured FSFO and data guard broker.

Successfully migrated over 100+ oracle databases from one premises to AWS.

Managed AWS EC2 instances for application deployments.

Installed and configured more than 50 oracle 11gR2 and 12cR1 2 node rac clusters on Linux 6.4.

Lead a project for datacenter migrations to move over 300 databases to new data center in Texas.

Migrated around 30+ mission critical production databases over 2 TB using log shipping with minimal downtime.

Migrated some production databases from Solaris to Linux using rman XTTS and datapump due to endian format difference.

Migrated more than 100 databases from physical to Virtual machines as part of consolidation project.

Identified and fixed performance issues after upgrades and migrations to 11g and 12c

Applied PSU patches for standalone and rac databases using traditional and rolling upgrade methods.

Supported application upgrades and deployments and also provided SME guidance for better database designs

Installed and configured both unidirectional and bidirectional replication using Golden gate 11.1 and 12.1 versions.

Recovered databases using rman and datapump in several situations and document the process.

Expert level skills identifying and troubleshooting rac related issues like node evictions and performance issues.

Implemented flashback technology on all production systems and also worked on oracle 11g RAT to benchmark performance during migrations.

Implemented TDE and wallets for securing the databases using oracle advanced security options.

Installed and configured oracle OEM 12c to replace existing monitoring systems using scripts.

AT&T, Richardson Texas March 2012 – MARCH 2014

Sr. oracle DBA

Responsibilities

At At&t I worked in a team of 64 production DBA’s(ACSI PDBA Run Team) supporting around 3600 databases for various applications like telegence, CRM ( clarify), Horizon, Mycomp,NCI Enabler and MOport. Dba support for major applications like PeopleSoft Financial management module and for Telegence which is the main billing project with 32 markets on nearly 350 prod and non-prod databases. Moport project is designed for 400 standalone database migrations from HP-UX to Linux 2 node Rac clusters residing in different datacenter. For clarify project I have installed and configured 10 (2 node) 11g Rac clusters on Aix 6.1.I have upgraded around 80 production and Non prod 10.2.0.4 and 11.1.0.7 databases for Mycomp reporting and Horizon agent commission projects to 11.2.0.2 and also provided support for post upgrade maintenance and fixed performance issues. Configured and installed Goldengate version 11.1 for NCI databases with unidirectional table level replication for 32 replicat sites. Worked along with team in managing oracle goldengate on over 60 databases for replicating data to DR sites.

Provided 24/7 production dba support for over 200+ Mission critical production and non-prod databases on various unix environments like Linux, Solaris 10, HP-UX and Aix 6.1.

Installed and configured more than 80 stand-alone 11.2.0.2 databases and 20+ Rac databases for various projects.

Configured and installed nearly 20 oracle 11gR2 rac 2 node databases on Linux and Aix.

Added extra nodes to existing 2 node Rac clusters as part of upgrading them to 3-4 node clusters.

Monitored the cluster and database health using crsctl and srvctl utilities.

Managed the databases hosting PeopleSoft Financial management application in both nonprod and production environments.

Worked along with peoplesoft app teams to tune the sql queries for best performance and also tune the databases to get the best response time.

Involved in PeopleSoft Financial management module deployments for mobile division of AT&T.

Installed oracle 11gR2 Rac one node databases on more than 16 Linux boxes (DL980 HP boxes each with 2tb RAM and 20tb storage) each supporting 20 databases in each cluster of 4 nodes.

Migrated few small standalone databases on Hp to 11g 2 node Rac databases on Linux boxes using Goldengate schema level and table level replication with multiple pumps for Zero down time migrations.

Migrated some large ( more than 2TB) 11g standalone databases from Hp to Hp conversion host using BCV copies and then from there to oracle 11g Rac on Linux using datapump schema level export / import.

Configured and managed ASM instances on both 10g and 11g Rac clusters using ASMCA, ASMCMD and various sql commands.

Upgraded nearly 80 production databases from 10.2.0.4 and 11.1.0.7 to 11.2.0.2.

Worked on installation and configuration of oracle 12c databases and 12c (12.1.0.2) OEM cloud control.

Worked on fixing the performance issues for both stand alone and Rac databases using OEM grid control and command prompt using various performance views.

Fixed several performance issues for slow running queries and batch jobs using sql tuning advisor (both with OEM and DBMS_sqltune package).

Installed and configured Exadata x2-2 half rack machine hosting 2 node 11g Rac clusters.

Migrated standalone databases to Exadata machine using Datapump.

Identified and resolved performance issues using various database reports like AWR, ADDM, explain plan and TKPROF reports.

Good knowledge in working on performance issues using various dynamic performance and data dictionary views.

Applied one off and quarterly PSU patches for resolving oracle bugs and fixing security issues for standalone and Rac databases.

Installed and configured Oracle goldengate v11.1 on nearly 30 servers for implementing unidirectional replication at table level across different data centers.

Configured extract, pump and replicat parameter files for various goldengate setups.

Identified Goldengate issues like extract, pump and replicat abend issues based on information available in ggserr.log file and provided the necessary fixes.

Configured bi-directional replication at table level and schema level for few databases.

Upgraded Goldengate from 10.2 to 11.1 for oracle 11gR1 and 11gR2 databases.

Configured oracle 11g active dataguard (Physical standby’s) for more than 30+ production databases and also participated in several switch over drills.

Metlife, Dallas Texas May 2011- march 2012

Sr. Oracle dba

Responsibilities

Provided 24*7 production database support for mission critical databases.

Installed and maintained oracle EE 11.2.0.1 databases on AIX 5.3 and 6.1 and Linux 6*.

Setup the complete database environment for CRM project which involved DEV, UAT and 7 TB of production database.

Worked closely with architects in preparing the database design and layout for new projects like PeopleSoft HRMS and also documented the process.

Provided support for PeopleSoft application team during installation of various modules of HRMS(HR/ NA and Global Payroll/ Base Benefits/ Benefit Administration)

Fixed performance issues for oracle databases hosting major applications like PeopleSoft and CRM.

Worked on user remediation project to migrate around 2000 user accounts to new standard naming convention.

Handled p1, p2, p3 database tickets related to various projects and regular maintenance work.

Experienced in applying PSU patches and one off patches for fixing software and security bugs.

Successfully configured and Implemented RMAN as part of our backup strategy, which replaced the existing hot backup method.

Successfully identified and fixed logical and physical block corruption using RMAN.

Database, table and schema refreshes using data pump and export/import utilities.

Expertise in database monitoring and performance tuning using various OS level and database utilities.

Participated in client meetings for database design and capacity planning.

Implemented and maintained Active dataguard using physical standby on 11.2.0.1 for reporting purpose.

Identified and fixed performance issues using AWR reports and ADDM reports on both stand-alone and RAC databases.

Expertise in identifying and resolving query performance using TKPROF and SQL trace utilities.

Prepared and documented database standards for enterprise wide databases as per OCC regulations.

Successfully cloned and refreshed databases suing RMAN control file method from production to UAT environments that resided on 2 different networks.

Implemented Role based security for most of the critical databases.

Installed and created MSSQL server 2005 on windows server 2003 SP2 Dev and UAT environments as per application requirements.

Verizon,DallasTexas Dec 2008 – May 2011

Sr. Oracle dba

Responsibilities

Worked as production DBA for various customer support applications for PeopleSoft CRM,SCM applications,Blue hill, Freehold, Fairland, Tampa and Sacramento data centers. This project is for deploying IPACD in various data centers to enhance the business flow. I have successfully set up UAT, DEV and Production environments for this projectwhich involved installing Oracle 10.2.04 databases and 11.1.0.7 in Solaris10. I was actively involved in all the development and production activities like user management, tablespace management, performance tuning, backups and replication

Provided 24*7 production database support for mission critical databases.

Successfully installed and managed oracle 10.2.0.4 and 11.1.07 databases in UAT, Dev and Production environments.

Successfully upgraded some of the 10.2.0.4 databases to 11.1.0.7 and also applied patches as and when required.

Configured and set up of 11g OEM grid control monitoring for all production databases and also Deployed 11g OEM agents on all target machines

Configured hot backup and rman backups for most of our production systems that were backed up using VSU snaps.

Provided database support for PeopleSoft applicications in terms of user management and performance tuning.

Worked on Data loads in to PeopleSoft datbases using SQLLOADER and tuned the database parameters to get best response time.

Supported PeopleSoft app teams during code migrations from Nonprod to Production environments.

Configured SNAP backups for larger PeopleSoft and SAP databases to minimize backup time.

Implemented Goldengate 9.5 on 10gR2 database to reduce the load on production database.

Involved in database design for most of our applications and participated in resource planning meetings.

Installed and maintained sql server 2005 on windows server 2003 sp 2 for some of our test and Dev environments especially for mobile app development.

Also Installed and maintained IBM db2 v.9.1databases on Solaris 10 for some of the voice portal applications.

Good working knowledge on exporting and importing data for db2 databases using control center.

Cloned several production databases using hot backup and Rman methods for testing and development activities.

Implemented two node oracle 11g rac on solaris10 for some of the mission critical databases.

Successfully implemented and maintained physical standby for oracle 10.2.0.4 database using datagaurd.

Taking periodic Backup of the Database and the software using RMAN and Hot backup methods.

Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Contact this candidate