Samir Kumar Sahu

• Migration of on-premise Mysql/PostgreSQL/Oracle databases to AWS RDS, EC2 and AWS Aurora
• Automation of RDS/Aurora deployments using Cloudformation /Terraform and health check of databases through Shell/Python scripting,
• Driving cost optimization initiative for RDS/Aurora/EC2 instances along with DMS
• Upgrade of RDS MySQL Instances to 8032
• Oracle Payments database migration to RDS Postgres

• Completed upgrade of all RDS/Aurora Postgres clusters from 10.21 to 12.12 version
• POC for migrating RDS core database of 9TB to Aurora Postgres for enabling encryption
• Deployment of Aurora/RDS Postgres using Terraform/Buildkite
• Configuring Debezium Connectors for replication to Amazon Kinesis and Kafka
• Provided on-call 24*7 support for all databases
• Used Datadog metrics to monitor databases and infrastructure performance.

23andMe is a personal genomics and biotechnology company serving across multiple countries

• Completed migration of on-premise PostgreSQL/MySQL databases to AWS RDS
• Working with Engineering teams to provision new RDS/Aurora instances for MYSQL/PostgreSQL using Cloud Formation/Terraform
• Launching DMS instances and establishing replication across databases including Redshift
• Completed POC for Snowflake to compare with Redshift for analytics processing
• Migration of Oracle EE on EC2 to SE RDS Oracle to reduce licensing cost
• Decommission of Oracle Goldengate and convert all replication to use DMS
• Supporting Redash deployment for dashboard/charts building for analytics teams
• Launch EC2 instances using CF for data engineering teams usage as ETL instances
• Provided on-call 24*7 support for all databases
• Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.

• Design/maintain databases being highly available and performant
• Administer & manage Oracle 10g/11g/12c databases on Linux/Solaris
• Configured Goldengate replication for several environments and fine tune some of the existing setup
• Dataguard switchover testing during data center maintenance or as per request
• Mentor the team with new features of Exadata/Goldengate
• Migration of basicfile LOBs to Securefile LOBs to improve performance
• Fixing materialized view refresh issues and improve performance
• Oncall alert reduction close to 70% over a period of 6 months
• Preparing documentation for the best practices and the known issues to reduce downtime/maintenance windows
• Setup master-master and master-slave replication using GTID option MySql
• Troubleshooting Performance for mysql queries and replication lag

• Sell/Buy/Rent houses in the US through Hubzu.com which is part of Altisource
• Hubzu.com is a real estate portal where customers in US buy/sell homes online and is quite a successful model over there
• It has sold more than 100k houses till now
• Maintenance of all Perf/QA databases
• Perform database health checks and take corrective/preventive action
• Setting up EC2 database instances on Amazon AWS
• Configuring Shareplex replication on Amazon AWS
• Database Refresh/Cloning to Perf/QA environment
• Troubleshooting and root cause analysis for performance issues on production
• Working closely with application team for new deployments
• Removal of all Bitmap indexes from critical Oracle environment
• Mysql database maintenance including master replica configuration

• Maintenance of all Prod/Perf/QA databases
• Perform database health checks and take corrective/preventive action
• Configure & automated scripts(shell and SQL) for alert monitoring, standby lag, Goldengate monitoring, and performing backup
• Oracle Clusterware and database upgrades from 10g/11gR1 to 11gR2
• Configuring Standby databases and enabling Data Guard
• Troubleshooting and root cause analysis
• Installation/Monitoring Goldengate used for replication
• Analyze database and query performance issues using standard monitoring tools
• Best practices documentation for Oracle RAC for all databases
• Setup Amazon EC2 instances for 12c databases for new applications