Ramesh Jadda Email & Phone Number

Dubai, Ae

Bengaluru, Karnataka, India

Bangalore

Bangalore

Certified AWS Solution Architect.Technical: Expertise in performing logical backups using Export and Import, Data pump Utilities. Performing physical backups (Online, Offline) database backup. Schema decommission planning and implementation. Installing/Creating new databases. Patching (CPU, PSU) the databases. Switchover of standby to primary and primary to standby database. AWS (Amazon web services):EC2, VPC, IAM, S3, CLOUD FRONT, CLOUD WATCH, CLOUD FORMATION,GLACIER, RDS CONFIG, ROUTE 53, SNS, SQS, BASIC CONCEPT OF ELASTICATCHE Utilized Cloud Watch to monitor resources such as EC2, CPU memory, Amazon RDS DB services, Dynamo DB tables, EBS volumes; to set alarms for notification or automated actions; and to monitor logs for a better understanding and operation of the system. Utilize Amazon Glacier for archiving data. Setup and attached EBS volumes to Ec2 instances. Setup and configured EIP to Ec2 instances. Setup and managed security groups, VPC’ specific to environment. Setup and managed backup and recovery using snapshot. Created AMI Images of critical Ec2 Instances as backup. Managed and created user accounts, shared folders, Printing Services, Providing day-to-day user support, Log management, reporting, applying Group policy restrictions, etc. Provide highly durable and available data by using S3 data store. Utilize Amazon Glacier for archiving data. Infra-structure development on AWS using various services like EC2, S3, RDS, Route53, Cloud Font, Cloud Watch, IAM, VPC etc. EC2 Instances, Auto Scaling, Elastic Load Balance and AMIS. Utilize EBS to store persistent data and mitigate failure by using snapshots. Attaching or Detaching EBS volume to AWS EC2 instance. Configured Cloud watch alerts. Managing Security for EC2 Instances and VPC. Cloud Front setup for Low latency for fast loading website/web contents experience. Hands on experience on VPC, Subnets, and Route tables etc. Create and configure S3 bucket with restricted policies.

Bengaluru Area, India

Have Worked with CGI as Oracle Database Administrator.Technical: Analysis and recommendations on databases health. Strong on oracle database architecture. Managing Production and Test Databases in 24x7 environments. Expertise in performing logical backups using Export and Import, Data pump Utilities. Performing physical backups (Online, Offline) database backup. Experience on database cloning using RMAN. Knowledge on RAC and having 1.5 Years Exp. on RAC Knowledge on ASM Implemented Redefining Tables. Configured and Maintaining DATAGAURD (Physical Standby). TKPROF Knowledge on Golden Gate Managing and controlling user’s accounts, limiting privileges/access to database, granting roles, profiles, monitoring user’s activity, allocating users to resource consumer group Rebuilded Standby until SCN using incremental backup from Primary. Patching (CPU, PSU) the databases. Performance tuning of Sql Queries. Checking for sql plan, etc. Import and export of databases objects Re-organization at the DB level. Schema decommission planning and implementation. Enabling and maintaining Audit at database level, user level and Object level. Worked on shell scripting needed for DB health report and monitoring. Troubleshooting through hotline calls, 24/7 production support. Switchover of standby to primary and primary to standby database. Took part in the upgrade project (10.2.0.5 to 11.2.0.4) Took part in the upgrade project (11.2.0.3 to 11.2.0.4) Re-building Standby database. Basic knowledge of 12c. Knowledge of RMAN. Oracle Binaries cloning. Installing/Creating new databases. Monitoring backups of the database on a regular basis and work with backup team. Identify Business Critical alerts from all production databases and find a root cause and solution. Knowledge on Dataguard. Orachk, TFA, OSWatcher, RDA, Tmpwatch, DB VerifyConfiguring and managing different states and modes of database like ARCHIVE & NOARCHIVE log mode.