Soumya Rani

About Soumya Rani

With over 4+ years of experience, Expertise in Oracle DBA administration, Hadoop…

Experience

1. Database Administrator

   TIAA

   Dec 2023 — Present · Mumbai, IN

   Oracle:• Monitoring and troubleshooting OEM 12/13C alerts.• Administering Exadata machines, raising SRs, and coordinating patching with Oracle.• Monitoring and troubleshooting daily backups and exports.• Performing DB installation, upgrades, patching, and restoration.• Performance monitoring, tuning, and optimization.• Implementing TDE encryption on 11g and 12c databases (both prod and non-prod).• Managing Data Guard databases, performing switchover and failover via SQL and DGMGRL.• Managing tablespaces (adding, resizing, and removing data files).• Cloning and restoring databases with Delphix.• Automating tasks with shell scripting.• Monitoring long-running queries, blocking, and locking sessions to resolve performance issues.• User administration, including creation, deletion, password management, and locking.• Resolving production alerts from the Operations Command Centre.• Proactively administering and troubleshooting databases.• Refreshing schemas/tables from production using export/import utilities.Hadoop (CDH/CDP):• Managing Hadoop production and non-production clusters.• Handling user management and permission issues.• Performance tuning and optimizing long-running jobs.• Migrating production databases to DR clusters, coordinating with the app team for permissions and scripts.AWS Cloud:• Managing EC2 instances, performing health checks, and restarting instances on failure.• Deploying Redshift, Aurora DB, and DynamoDB via Terraform and Ansible.• Performing cluster checks, deploying NAS mount points from on-prem to cloud, and fixing permission issues.• Deploying Autosys and Electric Flow agents, managing tasks for app teams.• Working with DynamoDB, Neptune, Aurora, and RDS Oracle for diverse projects.• Automating provisioning of DynamoDB, Neptune, and Lambda using Terraform.• Developing Python Lambda scripts for cloud automations.• Working with AWS services including S3, IAM, Lambda, EC2, VPC, Redshift, RDS, Aurora, and DynamoDB.