Aurora 1x to Aurora 2x upgrade with minimal downtime of around 1 minute (During cname changes only).

Expensive Query optimization.

Mysql 5.5 EC2 to Aurora2x migration/upgrade.

Good Understanding of AWS RDS, EC2, VPC, subnet, security group, RDS mysql, RDS Aurora, auto-scaling and different services, did the benchmarking (using mysqlslap, tpcc benchmarking).

Involved in migrating multiple databases from DC to Aurora including 16TB of database. (Tried different options DMS, mysqldump, Mydumper/myloader and Aurora restore from s3)

POC on terraform for AWS infrastructure.

Automation of aurora latest snapshot restore using Python script.

Extensive use of aws cli command for selecting/updating the different attributes of cluster/instances.

Cloud watch alarm setup via AWSCLI commands.

Aurora version upgrade across the board from 1.17.2 to 1.17.7.

Migrated many mysql/mariadb databases to Aurora.

Troubleshoot based on Aurora provided enhanced monitoring graphs and Datadog graphs.

Performance/Query optimization improvement by introducing required indexes.

AWS RDS, EC2, VPC, subnet, security group and different services, explored the RDS mysql and RDS Aurora and did the benchmarking (using slap, tpcc benchmarking).

Responsible for installations of Mysql 5.5 and 5.6 manually and with recipes.

Creation of Chef recipe as per the customization for user, privileges, crontab entries and directory structure.

Upgrade the database from 5.5 to 5.6.

Converted databases from MyISAM format to Innodb storage engine.

MySQL database backup and recovery strategies and Replication and synchronization.

Mongo dB chef recipe for installing slave master and registering slaves with replica set.

Worked on different monitoring solutions Zenoss, Zabbix etc.

Migrate 11g to 12c Database, Upgrade 11.2 Rac to 12c RAC -- Configure Containers, Implement Audit Vault and new database security features using DB vault.

Upgrade Weblogic to 12c -- Configure WLS Cluster, deploy Code, Maintain performance and best practices, monitor in Grid 12c.

Migration of Oracle Application (Including databases) from RHEL4 to RHEL5 without reinstalling the DB/CRS and automation (Since we need to migrate around 15 Oracle Application and 15 third party databases).

Setup and configure Universal content manager ,Webcenter with Fusion middleware , OHS and Web cache.

Setup Mobile Web servers for inventory.

Make recommendations to include table level partitioning where it would improve performance.

Oracle Lifecycle Management (Oracle 12c & Enterprise Manager 12c) Agile Product Lifecycle Management Suite.

Deployment of patches through Oracle 11g Grid Control console.

OEM 12 C implementation from the scratch to monitor EBS 11.5.10.2 (Cloning/Backup etc.)

Oracle Parallel Query Optimization and Performance Tuning.

Performance tuning exercises utilizing Oracle 11gR2 Indexing strategies (Automatic Database Diagnostic Monitor).

Performance tuning on queries that were poorly performing to identify ways to improve response time and throughput via Parallel Query and Table/Index Partition.

Validation of Database Backup and Recovery and Disaster Recovery Design and Implementation and Planning.

Created documentations for MySQL 5.6 databases i.e. Backup & Recovery procedures, Maintenance procedures, Replication procedures, Performance & Tuning procedures.

Responsible for performance/tuning of all MySQL Databases.

Integrated MySQL with Oracle Enterprise Manager

Experience on LAMP stack , PHP portal , apache

ERP RHE6 upgrade with Data Center move , including VLAN/security zone/subnet work done with Netops

Oversight upgrade for audit integration with ERP.

Kronos Time card application upgrade , support and monitoring.