Home

Rahul Reddy - Oracle DBA

[email protected]

Location: Dallas, Texas, USA

Relocation: remote /TX onsite

Visa: H1B

Email:[email protected] PHN:469 598 1989 10 years of professional experience as an Oracle Application and Database Administrator having hands on experience in administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, database security, cloning, migration, shell scripting and documentation. Summary: Excellent experience in Installation, administration and troubleshooting of Oracle 19c/12c/11g/10g for OLTP (multiple instances)/ OLAP environment on Very Large Databases (VLDB). Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM), TOAD, Oracle PL/SQL Developer in various versions. Experience in Oracle 19c/12c/11g RAC implementation, administration and troubleshooting RAC databases including Oracle Clusterware setup and configuration. Performed Migration and Upgrade of databases to 19c, 12c and 11g. Configuration and Management of Data Guard on RHEL, OEL and Windows. Experience in setting up DDL/Bi-directional replication between source and target databases. Experience in configuring Integrated Extract and Co-ordinated Replicate after upgrading Golden gate software to 12.1. Experience on Amazon Web Services (AWS) provisioning and good knowledge of AWS services like EC2, S3, Elastic Beanstalk, ELB (Load Balancers), RDS, VPC, Direct Connect, Route53, Cloud Watch, Cloud Formation, IAM, SNS etc. Used Ansible to manage Web applications, Environments configuration Files, Users, Mount points and Packages. Expertise in handling company audits and providing answers to the auditors. Installation of the web services like Tomcat and Apache. Responsible for Installation and maintains of Microstrategy reporting tool. Troubleshooting of the web services and tuning of the web services. High level trouble shooting in the Database and Application level performances. Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard. Experience is setting up GoldenGate to migrate large databases. Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies. Testing and implementing different physical (hot/cold) and logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import. Data loading using SQL*LOADER, Logical backups using export/import and DATAPUMP. Performed Database refresh from production to QA, development databases and testing environments. Experience in using 13c/12c OEM cloud control, TOAD, Data Migrations using export/import, benchmarking using load testing tools Monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM, ASH and 13c/12c OEM cloud control. Implemented database monitoring alert scripts for database status and sizing issues using OEM. Experience in SQL Tuning, Optimization, cost-based optimization and Hints. Extensive experience on Jenkins (Jenkins Pipelines) for continuous integration and end to end automation for all build and deployments. Experience on automating the build, test, and deployment of an application and implement Continuous integration and deployment (CI/CD) pipeline. Writing scripts in the UNIX based environments for managing the user's roles and privileges, scheduled backups (using data-pump /cold backups), manage statistics, Disk space management. Experience in writing PL/SQL Stored Procedures, Functions Packages and Triggers, various UNIX Shell Scripting. Proficient in raising TAR with Oracle Support and using Metalink(MOS) to resolve the bottlenecks in the database environments. Knowledge of Public Cloud technology: DBaaS, SaaS, PaaS, IaaS Extensively used JIRA ticketing systems. 24/7 on-call production database support. Excellent communication skills, interpersonal, strong architectural skills, hardworking and have ability to effectively communicate with all levels of the organization such as technical, management and customers. Technical Skills: Databases : Oracle 19c/12c/11g/10g, MS Sql Server. Operating Systems : Sun Solaris, RHEL, OEL, Development Tools : RAC, OEM Grid Control, SQL* Loader, ASM,OEM, SQL Server, Export/Import, RMAN, NETCA, DBCA, TOAD, Patch Management, Export/Import, Data pump, DataGuard,GoldenGate. Tuning Tools: : TKPROF,EXPLAIN PLAN.STATSPACK,ADDM,AWR Others : NetBackup, Erwin, MS Suite. Experience: The Railroad Commission of Texas, Austin, TX Sep 2021 - Current Role: Sr. Oracle DBA ________ Responsibilities: Installed and administered Oracle 12c/19c multi-tenant databases. Implemented DataGuard with maximum availability, protection and performance configurations and worked with DataGuard Fail over and Switch over cases at the times of up gradation and migration. Responsible for setting up a RMAN report that details all RMAN backups happened to databases for different time intervals Have installed and setup Oracle 12c databases on test servers to test the multi tenancy and other new features Monitored DR (Data Guard) implementations regarding connectivity issues and "log shipping" to failover site Along with regular Production support work, also participated in 24*7 oncall rotation shifts and off-hour production problem tickets and change requests. Work closely with System Administrators to recommend appropriate Hardware Changes (Server Level mostly for disk spaces) while providing support for both NON-PROD and PRODUCTION environments Participated in various deployments to both non prod and PROD environments Used TOAD as a third-party software for analyzing the database issues and generating result sets in xls formats. Regular Data Refresh from Production to Test and Development environments using RMAN Duplicate Database Cloned databases using RMAN Utility Involved in Query tuning and providing application tuning recommendations on batch jobs and ETL reports. Provided technical assistance for all GIS users, including troubleshooting, diagnostics, documentation and problem solving. Manage existing design templates GIS schema structure for the GIS systems in development, QA and Production environments. Looking into day-to-day activities of Production database, Monitoring its growth and performance. Daily incremental backups and weekly cumulative backups using RMAN. Performed SQL tuning, System tuning, Database and Instance tuning by root cause analysis. Monitoring the instance statistics and tuning the database to improve performance. Shell scripting and PL/SQL programming to resolve business problems of various natures. Proactively managed the databases; set up notifications, alarms using shell scripts for managing any exceptions in day-to-day management of the databases. Neiman Marcus, Dallas, TX Dec 2020 Sep 2021 Role: Sr. Oracle DBA ________ Responsibilities: Installation, Configuration and maintenance of Oracle 12c/19c Databases in non-RAC/RAC environments. Upgraded databases from 12.2.0.1/12.1.0.1 to 19.1.0 in Dev/Test and Prod environments. Responsible for setup, implementation and migration of two node RAC on Oracle 19c. Worked on AWS DMS for Migrating Oracle databases. Worked on S3 buckets and Cloud trails to monitor logs and backups. Configured AWS Virtual Private Cloud(VPC), SGs, Subnet groups which acted as virtual firewalls that controlled the traffic. Planning and implementing DR & high availability solutions with DataGuard Fail over and Switch over cases at the times of upgradation and migration. Installation and configuration of 12c container databases on standalone servers and cluster on windows and AIX platforms. OEM Cloud Control 13c Agent installations, plug-ins installations and adding targets to OEM. Monitoring the databases using OEM 13c. Worked on new features on 12c databases such as recovering tables, masking the fields, using advanced optimization parameters for good performance of 12c databases. Install Oracle audit scripts across all high profile and low profile categorized servers over GMRT region (Global Markets and research technology). Refreshing or cloning databases from production to development using RMAN and OS level scripts. Performed switchover/switchback from primary database to standby database for testing purpose for the application teams when required. 24X7 support for databases and production operations teams Interacted with Functional & Technical experts, system administrators, security analysts and other members of the project team to ensure optimum operation of the database. Documentation of the new strategies, procedures used for migration and maintenance of databases. Monitoring the ticketing queues and taking an appropriate action based on urgency. Maximus Inc, Austin, TX Jun 2014 Nov 2020 Role: Sr.Oracle DBA __ ______ Responsibilities: Installation, Configuration and maintenance of Oracle 12c/11g Databases in non-RAC/RAC environments. Installed, managed and monitored the Oracle Real Application Cluster (2 node RAC) Experience in RMAN recovery in RAC and standalone database. Implemented DataGuard with maximum availability, protection and performance configurations and worked with DataGuard Fail over and Switch over cases at the times of up gradation and migration. Monitored and supported the DataGuard Standby Databases using OEM/grid Control and DataGuard Broker Installed and administered Oracle 12c multi-tenant databases and created Clones of PDB s from one database to another. 24/7 on-call production database support. Installation of the Tomcat and Apache-based web services. Refresh the test and development databases from the source production databases on a regular basis using export/import utility. Setup of Jobs using the Oracle Enterprise Manager (OEM) database control. Used SQL *Loader for loading the data into database tables. Experience in OEM cloud control installation, configuration and administration and regular database management. Extensive use with 13c/12c OEM cloud control for monitoring, administration and performance tuning. Upgrade and manage oracle 12c OEM cloud control to 13c OEM Cloud Control. Data modeling for OLTP database using CA ERwin tool. Provide technical assistance and support for all GIS users, including trouble shooting, diagnostics, and problem solving. Worked closely with development team in resolving database, application performance. Experience in Online and Offline backups and recovery. Implemented and Managed Data masking using Oracle Enterprise Manager 12c to maintain PHI, PII data. Experience in contributing and participating in the RFP document preparation. Configure and Manage Jenkins for automated web server deployments across all working environments. Monitoring & Scheduling jobs for the daily activities for all the databases using CRONTAB. Table space monitoring, Performance monitoring and tuning for performance improvement. Managing, troubleshooting and resolving oracle database and application issues. Performed Explain Plan analysis for Query Optimization and SQL tuning. Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, AWR, TKPROF, Explain Plan, TOAD from Quest software (DB Tuning). Austin Energy, Austin, TX July 2013 Jun 2014 Role: Oracle DBA Responsibilities: Installation, Configuration, Designing and Maintaining of Oracle 11g and 12c on Solaris. Involved in migrating single instance databases to RAC databases. Implemented and Monitored Data Guard (physical standby) for standalone Oracle 11g/12c. Responsible in leading the project and writing shell scripts to automate the process of upgrading Enterprise level GoldenGate software from 11.2 to 12.1 Experience in configuring Integrated Extract (to support Compressed table extraction) and Co-ordinated replicate after upgrading Golden Gate to 12.1. Responsible in implementing Oracle s Transparent Data Encryption (TDE) in production/lab instances and performing relevant changes to support GoldenGate. Have a deep understanding of Oracle Enterprise Manager (OEM) 12c, command line and GUI Articulate monitoring and management of technologies via OEM 12c to customers and stakeholders Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.) Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases. Daily incremental backup and weekly full backup of databases using RMAN. Responsible for refreshing and cloning of databases per customer requirements using RMAN, export/import, Data Pump and physical(hot/cold) backups. Supported development by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager (OEM). Troubleshooting the OEM Agent issues and fixing. Performing clear state of the OEM Agents whenever required to keep the target and destination agents in sync. Responsible for monitor GIS Server capacity, usage, CPU, hardware, storage, and services statistics. Continuously monitoring Production and Staging databases for optimal performance. Provided 24*7 Production Support. Worked with Oracle Support on Sev1 issues to keep business running. Responsible for Making Documentation on collaboration site for every monthly release changes. CSGI, Omaha, NE June 2012 July 2013 Role: Oracle DBA Responsibilities: Involved in gathering user Requirements, application design, and analysis of hardware requirements to meet business needs. Implementation of High Availability solutions with Oracle 10g Physical and Logical Standby Databases (Data Guard). Configuration of system to achieve High Availability, Load balancing and automatic fail over functionality. Install, upgrade and maintain Oracle 10g on RHEL. Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g. Hands on experience configuring, installing, deploying, and maintaining OEM Agents Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc. Implementing Database Security, Management of role-based security. Database Restore using RMAN, Cold Backup and Export. Recovery of Database (Recovering from Media Failure, recovering tables dropped accidentally, recovering data files, Recovering from Block Corruption). Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc. Cloning of databases from production to test environments. Periodic data refresh from production to testing environments, Re-organizing database structures etc. Performed database Cloning using hot backup and cold backup to setup test and development database. Usage of Partitions to improve the query performance and manageability. Involved in taking logical backup using Data pump and Exports/Imports Utility Responsible for continuous database monitoring and reorganization for ensuring performance. Tuning and balancing I/O by monitoring file system and table-space I/O statistics. Tuning SGA, I/O Tuning, identifying contention, waits and tuning. Expertise in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK using OEM. Writing Shell Scripts for managing day-to-day activities and automation of backup. 24/7 on-call production database support. EDUCATIONAL QUALIFICATION: Master s in computer science from Bellevue University in Omaha, Nebraska 2013 May. Bachelors in Electronic and communications from JNTU(H) 2011 May. Keywords: continuous integration continuous deployment quality analyst business intelligence sthree database microsoft procedural language California Colorado Nebraska Texas