Oracle11g Certified Associate

Oracle8i certified professional

Oracle Autonomous Database Cloud 2021 Certified Specialist

My experience includes 17+ years of work on Oracle database administration, Microsoft SQL Server administration, Oracle Cloud infrastructure.
Have worked on banking domain for clients like GECIS, Ericsson, Deustch bank and have worked on data flow from Upper streams to lower streams using CDC (change data capture).
I have good experience on data architect, data movement using CDC tools (change data capture)
Good understanding of IT activities, working on change management processes, Agile methodologies

Bachelors degree in Sciences (biology + chemistry)

Vivek vardhini College

Post graduate diploma in computer applications from CAT Academy, Hyderabad, India

CAT Academy

·      Worked with application teams to predict DB growth and future load profiles.
·      Upgrade Oracle12c to Oracle19c
·      On premise DB migration to OCI using Oracle ZDM tool
·      Performed switchover of Primary RAC database to standby during DR drills
·      Worked on multitenant databases, creation of PDBs, migration of PDB to remote CDB using plug unplug methods.
·      Created automated TDE wallet and encrypted few required tablespaces
·      Setup client-side wallet using MKSTORE command to run PL/SQL queries using automated password.
·      Refresh of Development/Test databases from production backup
·      Performance tuning of SQL queries checking for deadlocks, AWR, ADDM, explain plan, SQL tuning advisor and implementing SQL profiles
·      Setup password less authentication using ssh keygen for service users to connect remote servers
Setup unidirectional configurations for Oracle Goldengate, monitoring of the same
·      Worked in DEV, SIT environment and provided on-call and day-to-day support.
·      Upgrade of Oracle 11.2.0.4 database to Oracle 19c
·      Performed switchover of Primary RAC database to standby.
·      Setup FRA and flash back option with restore points which are quite useful during database recovery.
·      Refresh of Development/Test databases from production backup
·      Performed flashback of database using the created restore points
·      Used online conversion methods like alter move online, DBMS\_REDEFINITION commands to perform online conversion of basicfile segments to securefile/securefile Binary XML of 56000 tables
·      Helped Temenos application to setup OJDBC connectivity and run the java unload and Java load scripts

experiencecertificate_LTIMindtree.pdf

Senior Specialist - System Management

·      Setup Oracle RAC 12c two node RAC on RHEL servers based on client requirements.
·      Setup Oracle RAC 12c two node DataGuard setup.
·      Performed monthly Switchover of RAC databases to standby as part of DR activity
·      Resolving the log gaps between Primary and Standbydatabase
·      Refresh database from product database to QA DB through RMAN.
·      Schema level refresh based on client request.
·      Transfer of Large data performed by setting up data guard and then doing switchover
·      Exadata management using Enterprise manager.
·      Patching of Exadata including DB, Cell servers and infiniband
·      coordinating with Server team during the server reboots.
·      Applying latest database patches/patch bundles
·      Resolving issues in RMAN backups, cataloging backup pieces
·      Upgrading Oracle Databases from Oracle12c to Oracle19c.
·      ASM disk rebalancing.
·      Worked on OCI (Oracle Cloud Infrastructure) activities like creation of VCN, Subnets, Gateways, Security list.
·      Performed migration of database schema using SQL developer

Experience certificate from DXC Technology

DXC-(RL&EC)-combined.pdf

Advisor Emerging Practices

·      Discussed with client and provided specifications for setup of Oracle database on HP-UX machines Migration of Microsoft SQL Server 2005 to 2008R2 and further to SQL Server 2014
·      Applying Oracle Patch set Updates (PSU Patches)
·      Used Oracle Golden Gate to transfer data between different schema in the unidirectional method
·      Configure and build Extract/Replicates for multiple databases
·      Monitoring of different components of OGG using the directories and log files
·      Tuning production Jobs and long running queries using SQL tuning advisor.
·      Managing Database Performance using (AWR, ADDM).
·      Performing Database Backup using RMAN, physical and logical backup.
·      Configure and manage active standby databases using RMAN Duplicate command
·      Resolving archive gap issues in Data Guard.
·      Perform Switchover activities to the standby servers during
·      Setup Oracle RAC 12c two node RAC on RHEL servers
·      Setup Oracle RAC 12c two node Data Guard setup
·      Switchover of RAC Primary database to standby database
·      Huge data transfer between databases using Standby, Transportable tablespaces
·      Patch Oracle RAC servers
·      Create new users, user profiles and manage privileges and monitor user access to the databases.
·      Upgradingdatabasefrom11.2.0.4 to12c
·      DecommissioningofDatabasesfollowedbydefaultchecklistrequestedbytheclient.
·       Performing regular maintenance on database such online/offline re-org. Prepared OS for Oracle database including Disk space check, Memory sizing. Performing Schema refresh using exp/imp utility and Datapump.
·      Closely working with Testing and DEV team to troubleshoot their issues such as locks, privileges, tablespace issues etc.
·      Worked on refresh of database for SQL Server database, tackled issue of Orphan logins, migration of data from Microsoft access to SQL Server

IBM - Experience Letter.pdf

Database Administrator

·      Performing backup and recovery using RMAN, creating, configuring and utilizing Recovery manager catalog (RC).
·      Configured and maintained RMAN backups for all environments.
·      Responsible for Installing, Configuring, Managing and Supporting all Production, Development environments of Oracle Version11gdatabases on Linux.
·      Generating Explain Plan, AWR, ASH andADDM reports and finding top wait events and top query for tuning purpose.
·      Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.
·      Applied regular Security Patching on Oracle products and interim patches for various bug fixes on database products.
·      Implemented Oracle Data guard on Oracle11g in maximum performance mode.
·      Used Oracle Enterprise Manager (OEM)and Grid control for performance, administration, and maintenance of databases.
·      Monitored database usage and reported on database performance and system availability.
·      Diagnosed Oracle bugs and coordinated with oracle support to resolve the min timely manner.
·      Monitor database performance and identify problems and improvements.
·      Automated DBA related jobs using shell scripts.
·      As per the client requirements performed Data guard switch over activities.
·      Performed database upgrades from Oracle9i to Oracle10g
·      Worked on Standby lag and associated issues
·      Created MySQL databases, schemas from the scratch for the GE project

Relieving letter from Genpact India pvt ltd

Genpact_relieving_letter.pdf

Consultant

·      Prepared OS for Oracle database including Disk space check, Memory and Page file sizing
·      Create Oracle database on Linux and Windows systems
·      Create tablespaces, Users for the newly created databases
·      Performing Schema refresh using exp/imp utility
·      Closely working with Testing and DEV team to troubleshoot DB Issues such as lock, privileges, tablespace/temp tablespace issues etc.
·      Troubleshoot TNS connectivity issues on windows by opening firewall settings
·      Upgraded their QA and DEV Oracle databases from Oracle10g to Oracle11gR2 on Linux Platform.
·      Monitoring Disk space on PROD Server and DR Server.

Experience letter from Intelligroup india pvt ltd

CHANDRA SEKHAR RAO DHARMAPURI NAGARAJA

#1 Video-Talent Marketplace

Ready to discover your perfect career?