Naresh Gowda Email & Phone Number

Longview, Tx, Us

Bengaluru, Karnataka, India

•Developed Linux and SQL automation scripts to migrate the oracle databases to different platforms ,which reduces the traditional work flow.· Implemented the advanced oracle v4 method to migrate databases with less down time.· Cross platform of databases migration form HP-UNIX to RHEL LINUX.· Upgrading databases from 10g to 11g and 11g to 12c.· Constructed database security policy using passwords, privileges, user profiles; implemented auditing policies as well as data redaction and data masking.· Championed database migration from 11g to 19c using the Oracle Datapump and RMAN respectively. Cloned databases for testing using RMAN and DATAPUMP utilities for all database sizes.· Worked in a cross functional team that oversaw Oracle 5 node RAC installation and configuration on Linux servers. Configured and managed ASM instances on Oracle 11g and 12c databases.· Generated shell scripts with developers to automate maintenance and backup jobs.· Installed and administered Physical Standby databases for single and multiple instances to achieve high availability and disaster recovery solution (DATA GUARD).· Supported daily administration, monitoring, tuning, and troubleshooting on single instance on UNIX/Linux (Database sizes range 100GB to 40TB).· Monitored AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS_STATS, Trace Files, System Event Logs for unusual events and took appropriate action according to company policies of incident reports.· Designed backup strategies following company SLA; execution of backup schedule for both physical and logical backups using Rman and Datapump utilities respectively.· Implemented table and index partitioning and materialized views to minimize DB time, increase disk load balancing, improve query speed.

Banglore

· Installed and configured software for Oracle 10g, 11g, 12c on both Windows and UNIX platforms using Oracle OFA. Also installed, administered and maintained PostgressSQL,MYSQL and mongo dB. · Established and implemented backup/recovery and patch scheduling as well as exported and imported databases frequently into the development and test environments and for archiving purposes. · Managed database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security related tasks including Transparent Data Encryption.· Performed instance tuning by changing init.ora parameters and managed region parameters such as shared_pool_size and db_cache_size with the use of AMM and ASMM.· Configured Oracle tools like SQL*Net, oracle client to access the database across the network.· Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances.· Maintaining highly reliable 24x7x365 Linux production servers for AWS EC2 instances.· Experience migrating database objects from development through test and into production environments.· Configure and manage CloudWatch alarms to monitor resources in AWS for Disk, Memory, and CPU utilization.· Capacity planning (supported 3 tier architecture, planning of tables, indexes, tablespaces and databases) to allow for growth potential and analyze data growth trends for capacity and resources.· Created, tracked, and closed service tickets using REMEDY ticketing system and developed a defect prevention process including but not limited to root cause analysis and corrective action.· Assisted developers with SQL code troubleshooting as well as tweaked applications, procedures and SQL when necessary. · Developed RMAN backup and recovery strategies and procedures.

Master'S Degree, Computer Science

Bachelor Of Engineering - Be, Electronics And Communications Engineering