Database Administrator Oracle
Resume:
Venkateshwarlu Yadavalli
Email: ********@*****.***
LinkedIn - https://www.linkedin.com/in/venkatesh-yadavalli-7740ba12b/
Summary:
Over 16+ years of experience as Oracle database Administrator working on various database activities like database management,Upgradation,Patching,Backup and Recovery, Performance Tuning,RAC,DataGuard, Installation and Configuration, support and DR.
Experience working with data warehousing (OLAP) applications, transactional database (OLTP) development, installing, configuring, administering, managing oracle databases, implementing solutions like High Availability (HA), Disaster & Recovery, Cloning, and Database Security.
Excellent communication and interpersonal skills
Installation, configuration and Upgradation of Oracle Server including Setup Maintenance.
Performing Server Space and Database Space Analysis as a part of Continuous Improvements and accordingly doing capacity planning
performed more than 100+ upgrades of different versions to databases to its next version like 8i to 9i, 9i to 10g, 10 to 11g.11g to 12c,12c to 18c,19c etc
Configuration of oracle extract, data pump and replicat process according to client requirement and criticality of the tables.
Handling Scenarios of adding new tables in existing Replication setup in OGG.
Handling Scenario of GoldenGate Home Corruption/Lost and Data issue in Replication
Experience in Performance Tuning databases using various techniques. Collected performance statistics memory usage,data storage, data manipulation, physical / logical storage, network traffic and implement / manage parallelism for optimum performance using Explain Plan, SQL Trace, AWR & ADDM.
Extensively worked on Oracle 19c, 12c, 11g and 10g production support activities in HA environment.
Configuring DataGuard and performing Switchover and failover activities for zero loss .
Performing Oracheck at database and server level and fixing issues reported in Oracheck, applying patches and one-off patches and resolving ora-600 and 0ra-07445 critical errors
Creating active Standby databases for Reporting purpose. Resolving gaps in between primary and standby databases.
Experience in working 24x7 client support, mission critical, and Hi-Pressure working environments.
Conducting DR drill for databases to verify backup integrity.
Using Shareplex tool to replicate databases on Cloud
Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for configuration parameters.
Installation and configuration RAC Multinode databases and Implementation of Rac One-node .
Provide solutions for physical/logical database structure and functional capabilities, database security, data back-up, and recovery specifications.
Experience in Configuration of RMAN.
Oracle performance tuning considering Oracle wait event, optimizer and Histogram and clustering factor.
Exposure to Oracle Utilities and Tools like OEM, Import-Export, DBCA, RMAN, Netapp.
Performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration, and synchronization.
Experience in handling large databases (size in TB) and also large number of databases in multi OS environments & OLTP.
Built and configured a virtual data center in AWS cloud to support Enterprise systems including VPC, NACL rules, public and private subnets, security groups, route tables, elastic load balancer, internet gateway, Route53 as DNS, NAT gateway and Transit Gateway.
Installation and setup of Oracle Golden Gate. One way and two way Replications
Prepare Method of Process (MOP) and get approvals on same from CAB (Change management).
Participate in on-call support of production databases on a rotational basis.
Databases :Oracle 19c/12c/11g/10g.9i, RAC, DataGaurd, Sql server, AWS RDS,Dynamo DB, Postgresql
Tools: rman,Sql*Loader,Sqldeveloper,Toad,Export/Import,DBUA,DBCA,putty,Datapump,dataguard broker,OEM Other[AWS] : EC2, EFS, VPC, RDS, S3, IAM, Cloud Watch, Route53, SNS, SQS, API Gateway, NAT Gateway, Internet Gateway,Elastic Search, IAM, CLI etc
Ticketing Tools :Snow,Jira,HP-DS,Expresso,Remedy
Operating Systems :RHEL, AIX, Linux, Solaris, Oracle Linux, Ubuntu,Windows 2000/NT.
Languages:SQL, unix shell scripting, PL/SQL,C, Terraform, Ansible
Tuning Tools :TKPROF,EXPLAIN PLAN, STATSPACK,AWS and ADDM, SQL TUNING ADVISOR
Domain Skills: GE Infrastructure, Aviation, Energy & Transport Solutions, Apple IS DBA,BP IST operations, JCI, GDM operations
Professional Experience:
COX COM Atlanta Oct 23 – Jan-25
Senior Oracle DBA
Responsibilities:
Experience in managing and administering oracle databases running on Exadata Machines X6,X7, X8-M and X9-M versions.
Resolving performance issues of query by analyzing how they performed over a period of time making necessary changes to run the query fast by adding hints, join methods,creating indexes etc.
Working experience on creating and managing the oracle partitions for large or LOB tables in oracle database and performing routine partition activity
Pro-Active Monitoring of the Databases using 11g,12cand 19cEnterprise Manager and fixing the issues, also working on Root Cause Analysis and documenting the issue resolution steps for future reference.
Involved in installation and maintained the Oracle Data guard Setup for a production environment and did support the Data guard related issues till date.
Performing day-to-day database administration tasks like tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
Creation, configuration and setting up of RMAN catalog databases and registering target databases with the catalog.
Experience in installation and configuration of Oracle Audit Vault and managing and administering audit vault appliances and configuration of Audit vault for all oracle databases.
Experiencing in configuration of IORM plan and cell smart scan on Exadata cell
SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, Stats pack, Explain Plans and monitor the database performance on daily basis. Having stored outlines before and after Database tuning to stabilize and optimize the database by changing the parameters.
Creation and Administration of High Availability Services using SRVCTL and Administrating Cluster using CRSCTL & Administrating ASM Instance
Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN
Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts.
Proficient in raising SR’s with Oracle Support and using Metalinkto resolve the bottlenecks in the database environments
Adding tables to existing GG replication using expdp or Initial load methods And splitting existing extract to reduce gap by segregating heavily used tables to new extract .
Experience in Upgradation of Key Vault appliances from 12c to 18c multi-Master cluster.
Experience in upgrade of all key vault endpoints and deploying endpoint for new oracle databases.
Experience in upgradation of Key Vault from 18c to 21c Versions and upgrading the key vault endpoints.
Experience in implementation of Transparent Data Encryption for oracle databases and storing the master keys in Key Vault appliances.
Performing utilization analysis of Onprem DB to correctly identify the instance type/resource in cloud.
Maintaining Oracle databases on AWS RDS.
Performing end to end activities on AWS RDS .
Handling scenarios of adding additional tables to existing replication setup.
Performing DB migrations using open source tool ORA2PG
Performing DB migrations from to Aurora Postgres using AWS DMS
HPE Americas Texas Oct22 – Aug23
Oracle Performance Consultant
Responsibilities:
Optimizing the usage of RAM allocated on the server by setting HUGE pages and accordingly using ASMM on Linux Servers.
Analyzing OS Level bottlenecks using commands like SAR,IOSTAT,VMSTAT,TOP,FREE.
Using OSWatcher various logs to find the issue at OS Level and involving OS,VM and Storage teams to working in co-ordination to resolve the issue.
Indentified Underlying IO issue by analyzing AWR report, IOSTAT, SAR etc and successfully resolved the issue by Moving Storage from 3PAR to NIMBLE.
Involved with application team and created purge script to remove data older than 3 years and thus reducing the time taken for query completion.
Generating and Analyzing AWR over a period of time comparing BAD and GOOD time of given queries and identifying the issues and resolving them.
Analyze and understanding different explain plan of same query with different plan hash values and creating indexes or use of Hints to make run faster.
Proactively analyzing different advisories in AWR Report and tune the database from potential bottlenecks.
Identifying and performing re-org of huge tables on which huge DML operations takes place.
Creating histograms and extended statistics on tables which are having skew data .
Influencing execution plans by using hints and make use of best execution plan which consumes less resources and gives better throughput.
Working with application developers to tune queries resulting in taking less time, CPU and resources.
Analyzing data growth regularly and do capacity planning accordingly to avoid potential issues.
Converting CDB database to PDB database from 11g to 19c Multitenant database .
Unplug database from 12c and plugging to 19c databases .
Cloning of PDB from one CDB to Another CDB.
Netcracker Technologies Jul-2021 – April 2022
Client: Telenet
Senior Technology Engineer
Responsibilities:
Installation and configuration of 18c and 19c databases on Linux and Ubuntu operating Systems
Converting of CDB to PDB databases on 19c and making changes accordingly so as to make application accessible on 19c.
Performing database monitoring using OEM, shell scripts, and resolving reporting issues on replicate databases as reported by Reporting Management system.
Upgradation of legacy 11g databases to18c and 19c .
Migration of oracle on premises database to Oracle OCI using migration methods like RMAN Backup and restore,
DataPump and transportable tablespaces .
Application installations on the database as per requirements
Migration completed successfully for heterogeneous databases from on premises database ORACLE to AWS Aurora PostgreSQL using DMS, ORA2PG and Shell scripting.
Resolve database performance issue using Active workload repository (AWR) report and Active Session History (ASH) report.
Unplug and plug of PDB’s on 19c from one CDB to another .
Hands-on in writing the Docker files for building images.
Managed docker orchestration and docker containerization using Kubernetes
Used JIRA to keep track of all the ongoing tasks and maintain bug resolutions.
Creating infrastructure using Terraform. Maintaining Mutable infra with IAC.
Performed infra automation tasks using Ansible.
Configurations of new servers from Using Ansible .
Using Ansible Automations of daily tasks like user creation, package installations etc
Created high- and low-level documentation, explaining builds and overviews on the release process in general
Worked in all areas of Jenkins setting up CI for new branches, build automation, plugin management and
securing Jenkins master and slave configurations.
Experience with Docker and Kubernetes on multiple cloud providers, from helping developers build and
containerize their application (CI/CD) to deploying either on public cloud.
Monitor and analyze database activity to proactively identify and prevent potential Incidents and also recommend performance improvements.
Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for configuration parameters.
Raising /follow up on platinum SR with oracle support for issues during oracle exadata database support
Validating and monitoring database during batch jobs execution and taking care for smooth execution
Support and Rebuild physical and logical standby databases as per requirement.
Provide DBA support to assigned projects.
Environment:RAC, DATAGUARD, ASM, DATA PUMP, EXADATA, Standalone databases,OGG,K8S,Jenkins,Docker,Gitlab,Ansible
Parexel International August 2018 –July 2021
Senior Database Administrator
Responsibilities:
Quarterly patching activity end-to-end for Standalone and Data Guard databases.
Resolving Gap Issues on Physical and logical standby issues.
Deploying code changes on UAT and Prod databases by following process thoroughly.
Creation of Standby databases for DR Testing.
DBA level performance tuning, monitoring plan changes and using SPM to fix plan change.
Used AWR, explain plan for performance related issues.
Moving data across UAT and PROD using Expdp,Impdp,Sqlldr.
Configuring databases in OEM and setting metrics for day to day operations.
Using QRADAR tool (IBM Product) to audit databases and monitor unwanted activities on databases
Handling user related issues like logins, tablespace issues. Working on House keeping issues related to Databases.
Creation and configurations of Oracle DB instances in AWS RDS .
Creation of S3 Bucket and managing its policies . Using buckets to save some critical gold copies .
Monitoring of resources and applications by using AWS cloud watch with alarms to monitor different metric like LOAD and CPU.
Creating VPCs,private and public subnets,security groups and network access etc.
Experience inconfiguring Disaster recovery databases using Data guard, replication using Golden Gate
Performing Shift lead activities like distributing, managing tickets.
Installing & Configuring of GoldenGate
Configuring GoldenGate for initial load and change synchronization.Performance tuning in GoldenGate
Configuring GoldenGate for DDL replication.Creating new extract, replicat and data pump process according to client requirement.
Monitoring bi directional and uni-directional replication in GoldenGate
Debugging of Oracle GoldenGate processes.
Proactively fixing bugs on Prod and UAT with the issues happening on the DEV databases.
On-call weekend Support
Creating EC2 machines,VPC,SUBNETS,IGW using infrastructure as Code (Terraform)
Configuring cloud machines using configuration management tool like Ansible, installation required packages,creating user and giving permissions
Environment: Oracle 11g/12c, RAC,DATAGUARD,OGG,Ansible,Terraform
Johnson Controls Inc March 2017– July 2018
Senior Oracle DBA
Responsibilities:
Performing Server Space and Database Space Analysis as a part of Continuous Improvements and accordingly doing capacity planning, thereby reducing number of tickets for given quarter to 50%.
Tuning of RMAN Backups to reduce load on servers and decrease time of backups.
Doing Database health check and fixing the issues accordingly.
Working on RAC-One node, Oracle restart environment.Supporting 400 plus production, and test databases. Applying bundle patches and PSU patches, upgrading databases.
Agent Installations on Server and Adding targets in OEM and creating rule sets for Alerts
Creating RAC-one node Databases and maintaining and supporting them.
Clean up of unnecessary alerts from OEM thus leading better utilization of resources.
Resolving Issues being faced by users, right from tablespace issues to tuning issues.
Managing the complete offshore team from operations of point of View. Handling the Escalation and Weekly calls.
Environment: Oracle 11g/12c, RAC,DATAGUARD,OGG,Rac One-Node, DataPump, RMAN
British Petroleum Jan 2016 to March 2017
Lead Oracle DBA
Responsibilities:
Implemented Partition strategy in projects where tables size where more than 50 GB and number of records were more than 10 million.
Developed and implemented a comprehensive Disaster Recovery Plan for the Oracle Databases at the division
Solving critical issues raising SR and continuous following up with Oracle support.
Resolve database performance issue using Active workload repository (AWR) report and Active Session History (ASH) report.
Performing database monitoring using OEM, shell scripts, and resolving reporting issues on replicate databases as reported by Reporting Management system.
Provides database support by coding utilities, responding to user questions, and resolving problems.
Taking care of application releases end to end from database point of view.
Monitor and analyze database activity to proactively identify and prevent potential Incidents and recommend performance improvements.
Space management and capacity planning for future requirements.
ASM instance installation & configuration.
Sizing tablespace and undo segments.
Used Oracle Export & Import utilities to upgrade and copy database.
Monitor all development / testing / Production databases.
Apple Inc March 2013 – Dec 2015
Senior Oracle DBA
Responsibilities:
Managing huge number of databases (4000+) having applications - iTunes, iCloud, iMessage, Siri, GameCenter and FaceTime.
Implement and administer data guard in 10g and 11gR2,
Troubleshooting DG environment issues, Resolving Gap between Primary and standby databases.
Managing failover, switchover and observer activities and Performing DR activities
Developed and implemented a comprehensive Disaster Recovery Plan for the Oracle Databases at the division
Database refresh from production to test/dev environments. Cloning of database using Rman to stimulate the issues being faced in Production.
Creating Oracle SR and uploading trace files to resolve the issues..
Applying patches.
Database User Management. Resolving issues faced by user .
Production Support for 24 X 7
Scheduling crons and archival management
Performing lead activity in shift
Processing tickets – Espresso Ticketing tool.
One waySchema and table level replication Using Goldengate
Environment: RMAN, Oracle, OEM, RAC, ASM, EXADATA,OGG,DataGuard
Nov 2009 – Mar 2013
GE Enery,Transportation,Power
Oracle Database Administrator
Responsibilities:
Installation and configurations of RAC Database.
Converting Non RAC database to RAC database.
Upgradation of RAC Database.
Adding and deletion of nodes in RAC
Creating the database manually
Monitoring different tablespaces like user, undo, temporary tablespaces
Troubleshoot and resolve database and/or application problems encountered by end users.
Transported the tablespace from production database and plugged-in it in development database
Database link were created to access the remote database
Monitoring unwanted sessions and killing them if needed
Used different v$views to study the database activities
Password file was created for network authentication of the administrator using orapwd
Created new user accounts, profiles, roles and assigned them to different users
Enable Auditing option to check suspicious database activity
Renaming RAC/non-RAC databases using NID utility as per application requirement.
Created and managed different kinds of Tablespaces,space issues,extent and storage parameters
Performing Database Reorganization regularly to remove Row migrations and Fragmentation
Performed different File recoveries in the database,Monitoring alert log file
Refreshing and cloning of databases per customer requirements using RMAN, Data Pump, and hot backup scripts.
Taking Differential backups of the database using RECOVERY MANAGER(RMAN) regularly on to the disk
Moving data between database using utilities like Export/Import, SQL*Loader logminer,Data Pumps
Performed cloning of a database to generate reports.
Providing Technical Support to Developers.
Performed installation of Oracle 9i/10g/11g software on various platform
Installing and Configuring Oracle-Enterprise Manager (OEM) for monitoring database proactively.
Evaluate the performance of SQL statement using utilities like TKPROF, auto trace and Explain Plan
Provide on-call support in adherence to specific business and customer Service Level Agreements
vertical Communications Jan 2008 – Dec 2008
QA Engineer
Responsibilities:
Preparing single image and flashing on phones.
Upgrade of wave servers.
Integration testing of vertical sip phones.
Preparing user guides to configure phone.
Bug fixing of minor ones.
Preparing Documents for code Review meetings.
Taking up QMS activities for CMMI appraisal.
Testing LCD interface.
Education& Certifications:
Bachelor of Technology (B. Tech) – JNT University Hyderabad, Telangana – 2007
Oracle Certified Professional (OCP)
Contact this candidate