Data Center Disaster Recovery
Resume:
Thulasi Nelluri
Sr. Oracle DBA / Migration specialist
****************@*****.***
Experience Summary
10+ years of experience in Cloud, database, Infra Solution Design, Pre-Sales, and customer handling.
Certified in Oracle latest versions of OCI, OCI-AI,12c multitenant administrative.
Experience as an Oracle Database Administrator across various versions like 9i, 10g, 11g, 12c, 19c and 23ai, in UNIX-flavored environments (RedHat Linux, Sun Solaris, AIX, SuSe Linux, Windows).
Full cycle implementation of multi-node Oracle RAC 11g/12c/18c/19c setups for production and dev environments.
Migrating experience of db versions from 12c to 19c and 19c to 23ai to Exadata and OCI cloud environments.
Experience in administrating the MSSQL databases part of day to day activities
Participation in cloud on-prem migrations from loose gear databases to Exadata.
Solution designing expertise for Oracle infrastructure and architectural problems.
Expertise in proposals creation, Customer Presentations, Cloud Migrations, Disaster Recovery, and Solution Designing with a focus on customer pain areas.
Expertise in access and security implementations in solution design.
Actively playing the admin role on PostgreSQL database and Azure.
Hands-on experience with Multitenant databases (CDB, PDB).
Hands-on experience with Exadata and Database consolidation.
Managing Data consistency and Data quality checks during migrations of massive databases.
Proficient in Oracle ASM and related general ASM concepts.
Data Backup/Recovery using RMAN and Logical backup.
Experience with patching procedures on RAC/Non-RAC nodes, including applying SPU/PSUs.
Experience in handling upgrades of Multi-terabyte Databases on Oracle 11gR2, 12c, and 19c, and troubleshooting post-upgrade issues.
Setup/Monitoring of Oracle databases using Oracle Enterprise Manager (OEM 12c/13c).
Hands-on experience with Oracle Golden Gate 11g/12c/19c installation, configuration, maintenance, and troubleshooting.
Comprehensive understanding of System/Storage/Database/Network concepts from a Database Administration perspective.
Experience with Linux, SUN Solaris, and IBM AIX.
Performance tuning through rebuilding indexes, managing blocking sessions, SQL Query Tuning, finding long-running queries, deadlock situations, and chained-rows resolution.
Experience in managing large terabyte-sized databases.
Participation in DR Drill activities like Switch over & Switch back.
UNIX shell scripts for hot backups, SQL*Loader, export and import of database.
Experience in writing the PYTHON scripts to build the database and monitoring purpose.
Can write scripts in ANSIBLE too for the enhanced work experience.
Setup Uni-directional GoldenGate setup
Worked on database security and Fine Grain Auditing.
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).
Cloned databases using RMAN duplicate and used Data Pump for object level refreshes.
Hands on experience in Hot/Cold Backup, Recovery Cloning of databases using RMAN with TSM Backup.
Experience in configuring Backups on ZDLRA.
Experience with setting up and managing standby database using Data Guard
Intensively used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases
Migrate on-premises Oracle databases to OCI using tools such as Oracle Data Pump, RMAN, and Oracle GoldenGate.
Architect high-availability and disaster-recovery solutions using OCI services like Autonomous Database, Exadata, Data Guard, and RAC (Real Application Clusters).
Good knowledge of Flashback Technology, Flash recovery Area, Automatic Storage management (ASM)
Expert in encryption for databases using Wallet Manager, TDE, Data in Transit.
Database replication using snapshot, materialized views and advance replication methods like Goldengate.
Experience in installing Oracle APEX and Oracle REST Data Services (ORDS) and WebLogic as per the application requirement.
Designed and deployed high-availability architectures using EC2, Auto Scaling, and Load Balancers.
Extensive coordination with offshore team.
Excellent Experience as Production DBA Provided 24x7 on call support.
Experience with Agile development methodologies, including tools like Jira, Confluence, or similar project management software.
Technical Skills:
Oracle Database Versions: Oracle 10g, 11g, 12c, 19c
Cloud Platforms: Oracle Cloud, AWS, Azure
Oracle Technologies: Oracle RAC (Real Application Clusters), Oracle ASM, Oracle Data Guard, Oracle GoldenGate, Oracle Enterprise Manager (OEM 12c/13c), Oracle Exadata,MS SQL
Database Tools: RMAN, EXP/IMP, Data Pump, GoldenGate
Operating Systems: Linux (RedHat, SUSe), Sun Solaris, AIX, Windows
Backup & Recovery: RMAN, Logical Backups, Full Database Data Export/Import
Database Migration: Manual Method, Homegrown Scripts, Goldengate Setup, Legacy to Exadata and Cloud Migrations
Disaster Recovery: DataGuard Setup, Switchover/Failover, High Availability Configurations
Performance Tuning: Index Rebuilding, Query Optimization, Deadlock Resolution, Chained-Row Management, Long-Running Queries
Storage & System Concepts: System/Storage/Database/Network Concepts
Database Consolidation: Exadata, Multi-Tenant Database (CDB/PDB), stand alone,RAC
Security: Database Security, Role & Privilege Management, Security Patches & Enhancements
Database Administration: Installation, Configuration, Upgrades, Patching, Capacity Planning, Memory Tuning
Monitoring & Troubleshooting: Database Health Checks, Session Blocking, SQL Query Tuning, Performance Issues
Scripting: Shell Scripting for Automated Jobs, Scheduling with Crontab/Grid (OEM 12c), Python script for Build database
Ticketing Tools: ServiceNow, SM9
Database Size Management: Managing Large Terabyte Databases, Data Consistency Checks Pre/Post Migration
Other Tools: Commvault, Net Backup, Assyst Tool
Professional Experience:
Company - Prodes E&T
Client- Paypal Inc
Oracle DBA / Migration specialist
03/10/2019 -till date
Responsibilities:
Migrating databases from one data center to another from 11g to 12c and 19c using manual methods and homegrown scripts.
Analyze and provide various migration solutions based on application compatibility.
Estimate the cost for various flavors of Cloud and DB solutions.
Implement various enhanced security features as per regional standards for cloud databases.
Migrating databases from legacy systems to Exadata and cloud using GoldenGate setup for data synchronization.
Creating standby databases for high availability in new data centers for disaster recovery.
Moving data from one database to another using expdp/impdp and RMAN backup tools.
Upgrading and applying security patches to databases before releasing to production.
Performing data validation checks to ensure data synchronization before and after migration.
Setting up Goldengate for the data SYNC with the prod until new db goes live
Creating empty CDB/PDB for the data Migration using TTS
Putdown the Python script to create CDB/PDB creation of DB to avoid the manual work
19c Grid installations and Oracle 19c software installation for the DataGuard setup
Enabling wallet and TDE encryption for the security policies
Migrating loose gear database to Exadata machines on prem using RMAN copy
Creating SQL Profiles, Users, tablespaces, Synonyms, Triggers part of validations if any missing during migrations.
Troubleshooting on Standby sync issues.
Renaming PDB/DB name as per the standards post migration.
Environment: Oracle 19c,12c,11g, Linux, Goldengate, Cloud, Exadata
Client - Oxy Petroleum
Company - HCL Technologies
Oracle DBA
14/06/2018 – 10/09/2019
Responsibilities:
Upgraded hundreds of databases from 10g to 11g using manual methods and DBUA.
Performing Logical backups using EXP/IMP and Data Pump. Importing the full database data and making it usable.
Creating and scheduling RMAN backups using Commvault.
Creating & Configuring the DataGuard setup for disaster recovery along with DG Broker. Tested for Switchover, Failover, and activating the Standby to Primary Database. Working on DataGuard SYNC activities (archive gap).
Taking Export/Import backups at different database levels and in different database environments.
Database Upgradation & patching in Non-Production and Production environments.
• Application and Database memory tuning as per requirements. Capacity planning to minimize database downtime.
Installing and creating standalone databases and configuring them in OEM.
Experience with the ServiceNow ticketing tool for receiving tickets from customers.
Worked on various db’s of MSSQL for upgrading,patching, User creations etc.
Environment: Oracle 12c,11g, Linux, AIX, ServiceNow
Client - Kaiser Permanente
Company - Cognizant
Oracle DBA
13/09/2014 – 10/06/2018
Responsibilities:
Installation of Oracle 11g software on SuSe boxes and creation of databases. Implementation and maintenance of database security (creation and maintaining users, assigning roles & privileges).
Performing Logical backups using EXP/IMP and Data Pump. Importing full database data and making it usable.
Creating and scheduling RMAN backups using NetBackup and Datto tools. Checking disk space for Archive and other Oracle-related file systems, and monitoring Table space size issues.
Attended various TDA meetings to get approval for proposals and plan the environment.
Creating & Configuring the DataGuard setup for disaster recovery with DG Broker, and testing for Switchover, Failover, and Activating Standby to Primary Database. Working on DataGuard SYNC activities (archive gap).
Taking Export/Import backups at different database levels and environments.
Database Upgradation & Patching in Non-Production and Production environments.
Reorganization of tables, fragmented table spaces, and databases using Export/Import tools and frequent rebuilding of fragmented indexes.
Monitoring database health checks in both Non-Production and Production environments, and addressing issues identified in health checks. Preparation of shell scripts for automating jobs.
Application and Database memory tuning per requirement, Capacity planning, and minimizing database downtime.
installing Oracle APEX and Oracle REST Data Services (ORDS) as per the requirement.
Environment: Oracle 11g,12c, SUSE Linux, Assyst Tool
Clinet – Cargill/ Merck
Company - Mphasis
Oracle DBA
27/01/2014 – 10/09/2014
Responsibilities:
Participating in DR Test activities like Switchover and Switch back using normal methods and through OEM.
Scheduling jobs in crontab and Grid (OEM 12c).
Taking Backups and performing Recoveries using the user-managed technique, i.e., RMAN Utility.
Performing Logical backups using EXP/IMP and Data Pump.
Configuring & maintaining Standby databases for High Availability.
Configured Data Guard (Physical Standby database) for the production database and tested for Switchover, Failover, and activating the Standby to Primary Database.
Performing day-to-day DBA activities, including daily health checks, database backups, troubleshooting, analyzing CPU load, and monitoring performance-affected areas.
Working on Change Management Requests using the SM9 Tool.
Capacity Planning and monitoring database growth based on periodic reports.
Creating standby databases in Exadata servers and performing switch over from Unix servers to Exadata.
Solving tickets related to user issues/auto-generated tickets.
Timely resolution of critical production issues.
Application and SQL tuning as required.
Schema refresh activities from Prod to Dev, Test databases.
Environment: Oracle 10g,11g,12c,19c, Exadata, Unix
Education:
Master of Computer Applications from Osmania University in the year
BSc (Computers) from Kakatiya University
Certifications:
Oracle Database 12c Administrator Certified Associate
Oracle Cloud Infrastructure 2023 AI Certified Foundations Associate
Oracle Cloud Infrastructure 2024 Certified Foundations Associate
Oracle Cloud Infrastructure 2023 Certified Multicloud Architect Associate
Oracle Cloud Infrastructure Foundations 2021 Certified Associate
Contact this candidate