Home

VANI CHAPPIDI - Oracle DBA

[email protected]

Location: New York City, New York, USA

Relocation: YES

Visa: H1B

Vani ______________________________________________________________________________________________________________ Professional Summary Senior Oracle Database Administrator/Oracle EBusiness Suite Application admin with (11) years of experience in database administration, design, development, replication, performance tuning, and high availability solutions. Exceptional and proven database management skills with experience in managing Oracle builds, upgrades/migrations, database security, disaster recovery, patch management and Super Cluster/Exadata in a large complex Linux environment Worked under RAC environment and standalone databases, R12apps databases with Multitenant architecture, MOM (Merchandising Operations Management) Retail Merchandising database applications RMS1 RMS2. Expertise in database design, architecture, installation, configuration, upgrades, replication, cloning, backup/recovery, performance tuning and database security. Experience with Oracle Super Cluster/Exadata, database sizing and capacity planning. Performed PL/SQL development, Shell scripting and Performance tuning. Experience working with VMware and Oracle Virtual Machine (VM). Experience with RMAN database backups, ASM storage. Experience with AWS database administration. Experience in developing end- to-end Oracle RAC solutions, single-instance (ASM) builds, configuring OEM and Data Guard. Good experience in modifying Database configurations including standalone, RAC and Multitenant Architecture Profound experience in Patching Database Patching using Opatch, Application patching using ADOP utilities, Patches such as Generic data fix patches and one-off patches and CPU patches Expertise in Patch impact analysis. Configuring the network environment to enable clients to connect to database. Worked with tools like SSH SFTP for data transfer. Expert in managing Oracle Audit and security Administration. Worked with configuring Oracle Certificates and Wallet configurations. Experience in handling user management in oracle databases, under E-Business suite and users related to single sign on as well. Profound experience in taking Planned and scheduled Logical backups using Datapump expdp, impdp monitoring and taking RMAN Backups as and when required. Good experience in working with AD-Utilities. Ensure system integrity, efficiency and performance through management of core system resources (CPU/Memory/IO Performance) using Oracle Cloud Infrastructure. Configured the on-premises using CI/CD pipelines, supported in establishing appropriate business metrics to track success for CI/CD capability and share with broader organization to driver further adoption for CI/CD. Managing and provisioning of resources in cloud like CPU , VMs , bouncing of instances In OCI. Migrated the data from legacy environment to OCI, made changes to data by removing redundant data as per the application team requirements. Experienced with OEM versions like 12c,13c etc., Have good knowledge in performing various deployments in production and nonproduction including R12.1, R12.2 and Cloud databases as well. Creating Standalone databases using DBCA, setting up the SSO integrated with oracle E-Business suite, Experience in troubleshooting integrated OID environments. Good knowledge in handling specific SSO user related issues and SSO environment configuration problems. Worked on purging the audit tables, Concurrent Audit programs, Troubleshooting Concurrent programs. Managing /troubleshooting various kinds of workflow mailer services in EBS and applying the suggested solutions given by Oracle Product Support., Monitoring and handling the failed scheduled backups, scheduled jobs proactively in critical Business period Knowledge on performance tuning, have good knowledge in SQL tuning. Provided the support during Disaster recovery activities. Provided 24x7 Remote / on-call production, non-production support Achievements Certified Oracle Cloud Infrastructure Architect Professional -2019 Certified Oracle Cloud Infrastructure Architect Associate -2019 Certified Oracle Autonomous Database specialist -2019 Certified Oracle Cloud Foundation -2020 Working with Python to automate daily jobs Qualification Bachelors of Technology in computer science engineering from SRI KRISHNADEVARAYA UNIVERSITY College of engineering with 76% result. Technical Skills Operating System: Unix, Linux X86-64 Bit, IBM AIX, Solaris Tools OEM, DSPAM, OASIS, SQL developer, TOAD, WINSCP, Service now, Service Manager, Tiger VNC ,Microsoft Active Directory Database: Oracle 11.2.0.4, Oracle E Business Suite 12.2.3 Oracle 12c (12.1.0.1), Oracle Cloud Infrastructure, Oracle Autonomous Database, Oracle 19c Language SQL, learning Python ,Shell Scripting RDBMS ORACLE 11g (11.2.0.4), Oracle 12c, Oracle 19c, Oracle 21c Professional Experience IBM (July 2022 June 2023 ) Role: Sr Oracle DBA Project Description: Kroger: The Kroger Company is an American retail company that operates (either directly or through its subsidiaries) supermarkets and multi-department stores throughout the United States. Responsibilities: Support and maintenance of Oracle retail Databases and also on RMS (Retail Merchandising Systems), Oracle standalone database and also Oracle E-Business suite applications Experience in working with instances configured with RAC and ASM and standalone databases. Supporting daily activities in SSO configured environment s as well Patching the environments with quarterly CPU patches. Supports Cloning the environments from higher to lower versions Maintenance activities such as deployments and password management activities Daily activities include Restores, logical backups and RMAN cloning and data migrations, deployments. Managing the space utilization/capacity planning in servers by cleaning unused data.etc., Participating in upgrade activities. Expert in working with OEM. Working in 24/7 model supporting Priority issues in timely manner without any SLA breach. Performance tuning - SGA, init parameters, slow database response, re-size redo logs, ADDM and AWR reports. Worked with Oracle Wallets and security and Certificates. Worked on Auditing and Database security. Research and review database migration from AIX/Windows to Linux (BlueBird). Built DR systems using Active Data Guard. Implemented different configurations - 2-node RAC (Primary) to Single-instance (Standby), Single-instance (ASM/Primary) to Single-instance (ASM/Standby), Single-instance (non-ASM/Primary) to Single-instance (non-ASM/Standby), one primary (PROD) to more than one standby (Reporting and DR). Environment: Oracle 12c/19c databases, Exadata, ExaCC and ExaCC-Autonomos, OCI Web Console, OEM 13c,Oracle RAC, ASM, RMS, Retail databases, AWS, AZURE, Linux, Salaries, IBM AIX Tools: Data Guard, ASM, TOAD, SQL Developer, RMAN. IBM AT&T, Dallas, Texas (June 2021- July 2022) Role: Sr Oracle DBA Responsibilities: Migrating the data from 11.2.0.4 Solaris environment to Azure cloud in Linux machine having Oracle 19c Database. Configured database backups Worked on activities such as logical backups on daily basis as per business requirement. Configured Oracle 19C databases Merging two different databases from on Prem environment to single database in Azure. Configuring and loading the on Prem data to cloud. Data guard connectivity, setup in Azure primary and Standby databases. Proactively worked on password management activities, Audit configuration and maintenance activities. Participated in designing higher level architecture during the cloud release of AT&T BCI 6900 DB applications. Applied CPU patches as recommended by Oracle. Database application Transition to Client has given successfully with Documentation. Identifying bottleneck SQL in production databases proactively based on Database reports (AWR, ADDM) considering various statistics for SQL and providing tuning suggestions proactively. Coordinating with application teams during release cycles to identify and tune SQL queries using hints to use optimal plan, query rewriting, PL/SQL performance code design review and tuning suggestions. Database Backup and Disaster Recovery for Oracle databases. Database management by creating schemas, tablespaces, partitions, indexes and coding in PL/SQL packages, procedures, functions and triggers. Environment: Oracle 11g/12c,/19c RAC, OEM 12c/13c, AIX, Linux, Windows. Tools: Data Guard, ASM, TOAD, SQL Developer, RMAN,Expdp,Impdp , Azure , scp. ORACLE, Austin, Texas (April-2019 to JUN-2021) Role: Sr Oracle Database Administrator Environment: Oracle11.2.0.4, Oracle 12c, EBS version 12.2.4, EBS version 12.1.3,12.2.6, Oracle Cloud Infrastructure, Oracle autonomous Database, Oracle OTO instances. Azure , AWS. Project description ORACLE MANAGED CLOUD SERVICES. we support more than 400 Plus customers across the globe. Few activities include CPU Bursting, 12C Multitenant Architecture, INIT parameter changes, Most kinds of patching (DB, RAC, CPU, EBS Application patching, GDF patches) Responsibilities: Responsibilities included developing and supporting end-to-end Oracle RAC and data guard solutions in VMware and Linux environment. POC for Oracle requirements and support issues. Experience with Oracle Retail databases. Merchandising databases. OTO instances. Retail databases cloning and capacity planning and scheduling the cleanup jobs. Updated RMAN backups. worked with OCI configured database environments. Configured data guard for CMC database and supported HA. Supported the E-Business suite application DBA activities like concurrent request management and Patching, troubleshooting and resolve the daily issues. Patching different environments using ADOP, OPatch utilities (CPU and Bug fix patches). Managing the OCI instances and migrating the legacy environments to OCI. Assisted technical leaders in supporting production/development/test/lab environment. Worked with developers/testers to troubleshoot day-to-day issues like tablespace management, user creation, application database connectivity, and ORA- errors. Attended NoSQL Couchbase presentations and deployed VMs for MongoDB and MySQL. Created NoSQL MongoDB database for device management. Performance tuning - SGA, init parameters, slow database response, AWR, ADDM reports. Researched and provided information on Oracle 12c multi-tenant architecture, licensing for diagnostic and tuning pack, and security patches. Environment: Oracle 11g/12c,/19c RAC, Exadata, Oracle 21C, OEM 12c/13c, Oracle RMS,AIP,RDF retail databases AIX, Solaris, Linux. Tools: Data Guard, ASM, TOAD, SQL Developer, RMAN, Expdp, Impdp, ATOM, CMP, AD utilities. International SOS, London, UK (June 2018- March 2019) Role: Oracle Database Administrator Project description: International SOS is the world's largest medical and travel security services firm, which count nearly two-thirds of the Fortune Global 500 companies as clients International SOS specializes in medical assistance, travel security advice, information, emergencyservices, healthcare, evacuation and repatriation services. The company was founded in 1985 to provide medical, travel security advice and assistance to organizations with people living and travelling abroad. International SOS operates from over 1,000 locations in 90 countries and take around 5 million assistance calls every year. Responsibilities: Worked as apps DBA version 12.2.4 in a multi-tier SSO integrated environment Worked on CPU patching Working with ADOP patching. Worked on concurrent manager issues. Working on SSO configured user related issues. Working with onsite teams, problem management, change management, managing deadlines effectively Performing Pre and post clone activities, handling performance issues on concurrent requests. Managed routine DBA responsibilities such as tablespace creation, user creation, setting up audit trail, and trail cleanup Setup routine scripts for environment monitoring, audit trail maintenance, and cleanup of log files Resolved problems in connectivity issues, SQL-Net interfaces, errors, and troubleshooting Contributed to ongoing shell script based monitoring and improved functionality by creating and streamlining new script and code. Environment: Oracle11.2.0.4, Oracle 12c, EBS version 12.2.3, Microsoft Active Directory. Tools: ACLs, SSH keys, SQL Developer, shell scripts, DSPAM, TOAD, Putty, OEM SHELL AMS TRADING/ROYAL DUTCH (April 2013 -May 2018) Project Description: The objective of this project is to meet the business requirements of Shell in everyday Commodity trading and risk management (CTRM). in all its Upstream, Midstream, Downstream Applications to Function smoothly. Shell Trading and Supply supports the Shell businesses by trading natural gas, electrical power, crude oil, refined products, chemical feedstock s and environmental products. Shell Trading is one of the largest and most experienced energy merchants in the world. Responsibilities: Involved in user management. Involved in backup and recovery tasks. Involved in performing the health checks according to the business requirements. Involved in Inspecting filesystem growth, monitoring table spaces Involved in performing Disaster Recovery Working beyond regular hours based on business demands. Provided 24x7 on-call production and non-prod support. Managing daily and weekly, monthly audit reports. To give privileges to access the Database objects to the application users and performed various deployments. Worked on patching. Driving meetings, taking targets and working with Team and Application users when situation at risk. Environment: Oracle RAC, Oracle 12c, Oracle 11g, Linux, Solaries, IBM AIX Tools: ACLs, SSH keys, SQL Developer, shell scripts, DSPAM, TOAD, Putty, OEM Keywords: continuous integration continuous deployment database active directory procedural language