RAKESH DANGETI
- Oracle DBA & Exadata Admin
- New York City, NY
- Member Since Apr 26, 2023
Candidates About
Rakesh Dangeti
A hands-on ORACLE DBA/EXADATA Database Machine Administrator seeking a challenging position that can utilize my expertise in a complex, technically challenging and growth oriented organization. An innovative and creative problem solver with a great attitude and agility for learning new technologies. Ability to scale up as the demand grows with an exceptional ability to focus on resolving challenges.
Executive Profile
l A highly motivated and result focused ORACLE DBA/DMA with more than 10 years of experience in database administration including more than 6 years on Oracle Engineered Systems primarily focusing on Exadata, ZFS & ZDLRA. I have a strong passion for learning and improving my troubleshooting skills. Very proficient in performing under demanding and diverse environments.
l Currently working with Kaiser Permanente as Lead Admin with responsibilities including that of a Delivery Lead, also handling the operational aspects of the project along with the Technical work as an Individual contributor.
l A committed professional with proven expertise in Oracle Database Administration combined with experience in Installation, Upgrade, Monitoring, Performance Tuning, Backup and Recovery procedures on Linux/Unix and Windows environments.
l Hands on expertise in complete Administration and Maintenance of Exadata Machines with different configurations like X2-2,X2-8,X3-2,X4-2,X5,X6,X7 Quarter/Half/Full/Elastic Racks.
l Hands on exposure to Exalogic & Super Cluster.
l Hands on expertise in configuring and maintaining Data Guard and Real Application Clusters, ASM.
l Developed proficiency in planning backup strategies and gained great experience in Recovery of databases using RMAN and User managed recovery techniques.
l A technically adept and diligent professional possessing excellent communication, presentation and learning skills with a sharp analytical mind-set.
l Configured the Physical Standby databases for several production databases along with Dataguard Broker configuration and performed switchovers during the DR Testing in environments with multiple standby databases.
l Expertise in concepts of distributing the available system resources appropriately among user groups using DRM (Database Resource Manager) and IORM on Exadata.
l Incident/Problem Management: Handle escalation tickets within the norms specified in the SLA.
l Service Delivery: Knowledge management, Reporting and Documentation, Periodic reviews and reporting with Technical Manager and Vendor co-ordination.
l Provided mentoring and guidance to the juniors in the team and prepared Standard operating procedures and documentation for the day to day activities in Database Administration and Database Machine Administration.
l Migrated Databases from Non Exadata to Exadata and AWS platforms.
Current Focus
l Oracle Database Administration. RAC and stand alone.
l Exadata Database Machine Administration.
l Implementation of Exadata features like smart scan, smart Flash Cache, HCC, etc.
l ESS, Bundle patching and DB Upgrades.
l ZDLRA, ZFS & Oracle Super Cluster Administration.
l Physical and Logical Database Design
l Oracle 9i , 10g, 11g and 12c
l OEM 12c / 13c cloud control
l Red Hat Linux, Oracle Enterprise Linux
l Real Application Clusters & ASM.
l Automation of Database refreshes.
l Configure Console Machine with OS and DB parameters
l Standby Database (Data Guard and DGMGRL) Setup
l Database Cloning and Migration.
l Optimal Flexible Architecture (OFA)
l Advanced File System Management and DBFS, ACFS.
l Oracle Streams
l Client - Server Configuration
Technical Skills
l OS: UNIX, Red Hat Linux, Solaris, WINDOWS 2000/XP/NT
l RDBMS: Oracle 9i, 10g, 11g, 12c
l DBA Tools: Oracle Enterprise manager, SQL*LOADER, Export/Import, iSQL* Plus, TOAD
, DB Artisan, SQL Developer, OEM 11g Grid control & 12c/13c Cloud control, ASMCMD, ACFS, IORM.
l Backup Tools: RMAN , shell scripts.
l Languages: SQL
Trainings & Courses
l Completed Oracle 9i Enterprise DBA from SQL Star International Ltd. (Oracle Authorized Education Center)
l Completed Oracle 9i DBA - OCA (Oracle Certified Associate)
l Completed training on Oracle 10g New Features for Administrators from SQL Star International Ltd.
l Oracle Exadata Administration.
Educational Qualification
l B. E. (Mechanical) from Chaitanya Bharathi Institute of Technology, Osmania University, Hyderabad. India. [2005]
Projects
ð kaiser permanente, usa.
Oracle DBA & Exadata Admin (Contractor through Cognizant) [May 2016 – Till Date]
Project Description: Infrastructure Management Group manages KPs IT infrastructure and is primarily responsible for conducting and overseeing business specific projects and developing work plans to meet business priorities and organizational goals. As a Lead admin, my job was to make sure all the project deliverables are met.
Accomplishments:
l Participation and key role in the hardware planning & deployment of Engineered systems right from the purchase phase through the Production Go-Live.
l Assisting the hardware and network consults in preparation for the new hardware deployments.
l Preparing and reviewing the OEDAs & checkip output to make sure business understands the configurations and also to make sure Oracle has got all they need to proceed with the installs.
l Assisting Oracle ACS with the software installs and troubleshooting any issues they might run in to.
l Coordinating the Platinum implementations by closely working with the Oracle teams to have the monitoring and ASR setup.
l Quarterly Full stack patching on the Engineered systems - Exadata and ZDLRA.
l Infiniband Switch upgrades, ES1 switch upgrades.
l Good understanding of the network configurations.
l Patching the ZFS Storage appliance.
l System administration, monitoring and maintenance of the engineered systems.
l Collaborate with technical and project team leaders to resolve system problems and application-specific issues.
l Plan and perform complex system configuration.
l Lead hardware and software changes into environments and one or more additional IT production environments by performing impact analyses of system changes.
l Inter racking multiple engineered systems through the Infiniband network fabric.
l Storage expansions, Memory expansions and upgrades on the rack configurations (like Eighth rack to quarter, Quarter to Half)
l Grid Infrastructure Upgrades.
l ASM Management, Diskgroup redundancy changes, Diskgroup resizing, etc.
l Regularly reviewing the exachk reports and remediation of any critical alerts.
l Exachk automation.
l Change and Incident Management – Reporting to the customers.
ð Computer sciences corporation (csc)
Exadata Delivery Lead (Exadata DBA) [Sept 2014 to March 2016]
Project Description: As part of the Leveraged DBA Support Team, the customer’s mission critical databases which were residing on Exadata and also other platforms were maintained. This also included several migration projects along with the day to day maintenance and proactive maintenance to meet customer’s needs.
Worked in the role of a Tech Lead / Delivery Lead in a team of about 30 DBAs managing the mission critical Exadata production machines of the customer. Supported the Exadata machines and the hosted databases of various applications belonging to the customer AMP, Australia. I was the Point of contact for any technical and operational issues around the maintenance of the Exa platrorms.
Clientele: AMP, Australia.
Accomplishments:
l Managed the Client’s Exadata X2-2, X3-2,X4 and X5 machines with different configurations like quarter/half/full racks.
l Managed/Applied Bundle and ESS Patches on Exadata Machines.
l Advised, provided guidance and developed Disaster Recovery strategies for these Database machines and also for other day to day maintenance activities.
l Supported other projects including database migrations to Exadata.
l Successfully implemented HCC (Hybrid Columnar Compression) which is an Exadata specific feature that contributed to saving the disk space for the customer for some of their Archival data as part of a Migration Project.
l Key role in planning and executing the DR Testing for the DR configured environments on Exadata which gave the portfolios, the confidence on the current Disaster Recovery setup
l Successfully setup the DRs for the several environments as part of the Major patching due to requirement for key databases to remain operational at all times even during the patching window
l Played a lead role in managing AMP’s Exadata Environments and also streamlining the technical processes.
l Automated the database refresh process which contributed to saving a lot of man hours and also ruling out any human errors during the process.
l Key role in the database migrations to AWS.
l Applied Exadata Storage patch 12c to X4-2 full RACK Exadata machine
l Upgraded DBs from 11.2.0.1 to 11.2.0.2, 11.2.0.2 to 11.2.0.3 and 11.2.0.3 to 11.2.0.4 and 12.1.0.2 on Oracle Exadata Machines (8 – node RAC cluster).
l Advised, provided guidance and developed Disaster Recovery strategies for these Database machines
l Migrated databases from Non Exadata to Exadata and AWS platforms.
l Experience in managing Exadata x2-2, x3-2 and x2-8 machines with different configurations like quarter/half/full racks., Exalogic and Oracle Super Cluster T5-8.
ð ORACLE Corporation
Senior Consultant (Exadata DBA) [Aug 2011 to Sept 2014]
Project Description: Exadata CoE was a group of DBAs and System Administrators who managed the Engineered systems of a number of clients based out of USA and Australia. The Engineered systems included not only Exadata but also Exalogic, Oracle Super Cluster, ZFS.
And as one of the Tech Lead I was responsible for managing and administering the end to end activities on these machines.
Clientele:
· Sears, USA.
· Cardinal Health, USA.
· Nike, USA.
· Monsanto, USA.
· Farmacos, Mexico.
· P&G, USA.
· JCREW, USA.
· American Airlines, USA.
· National Australia Bank, Australia.
· Westpac, Australia.
Accomplishments:
l Worked as one of the Tech Leads in a team of about 50 DBAs who manage the mission critical Exadata production machines of several customers.
l Experience in managing Exadata x2-2, x3-2 and x2-8 machines with different configurations like quarter/half/full racks., Exalogic and Oracle Super Cluster T5-8.
l Experience in applying Bundle and ESS Patches on Exadata Machines
l Software and firmware maintenance of the Database servers, Exadata storage servers, InfiniBand switches in the Exadata machine including upgrades and patching
l Advised, provided guidance and developed Disaster Recovery strategies for these Database machines
l Working exposure to maintenance of Exalogic and Oracle Super Cluster.
l Experience includes database migration to Exadata Machines using Golden Gate Tool.
l Experience includes managing RAC databases
l Experience in RAC installation and patch apply/rolling upgrade.
l Experience in managing CRS resources
l Experience in managing ASM instances
l Experience in OEM Grid Control installation and Configuration.
l Experience in estimation of storage capacity for new databases.
l Experience in Installation and configuration of Oracle Server Software (9i/10g/11g) on Linux/Windows.
l Hands on experience in upgrading databases to latest versions.
l Hands on experience in database migrations.
l Hands on experience in creation/cloning of Oracle databases.
l Hands on experience in managing standby databases using Data Guard/Active Data Guard.
l Experience with automation of database backups using RMAN/exp/expdp/Flashback.
l Hands on experience in restore/recovery strategies using RMAN/imp/impdp/Flashback.
l Hands on experience in refreshing QA/Dev databases using RMAN/IMPORT/Transportable Tablespaces.
l Hands on experience in monitoring/troubleshooting performance issues using trace events.
l Hands on experience in troubleshooting the performance issues using AWR/ADDM/SQL Analyzer and Access Advisors.
l Experience as On-Call DBA support for production environments.
l Worked as Team Lead and aligned project to Operation Maturity Model Framework.
l Experience in providing drill down reports to the management.
l Always ensure project deliverables as per timeline and meet client expectations.
l Able to motivate the team in automation of the repeated tasks.
ð INFOSYS TECHNOLOGIES LTD.
Tech Lead (Oracle DBA) [May 2008 to May 2011]
Worked for the division called Infrastructure Management Services (IMS) as production DBA providing support 24X7 supporting monitoring and maintenance of about 60 production databases and about 200 test and development databases.
Clientele: Nordstrom, USA.
Accomplishments:
l Worked for the division called Infrastructure Management Services (IMS) as production DBA providing support 24X7.
l Database monitoring and maintenance of about 60 production databases and about 200 test and development databases.
l Incident/Problem Management: Handle escalation tickets within the specified SLAs.
l Service Delivery: Knowledge management, reporting and documentation, Periodic reviews and reporting with Technical Manager and Vendor co-ordination.
l Backup & Recovery Management: Ensure backups and backup reports are completed
l Configured and maintained Oracle Streams for keeping certain databases in sync.
l Hands on experience in working on Oracle Enterprise Manager Grid control and configuring/maintaining Real Application Clusters.
l Strategically planned and executed Logical / Physical design, performed capacity planning, Storage Allocation, Backup & Recovery, Space Monitoring. Maintained Standby Database in remote location for Disaster Recovery.
l Configured Recovery Catalogs for backup and recovery optimization.
l Pinpointed DB issues using various diagnostic tools like STATSPACK and dynamic performance Views.
l Performed database refreshes from production to stage and QA databases.
l Tuned application sql / lock contention /deadlocks / index usage etc., Monitored object growth and configure/modify object storage for better performance.
l Streamlined automatic backup and recovery procedures including logical backup (Export/Import), Physical backup (cold/hot).
ð<span style="font:7pt 'Time