Amazon AWS Solution architect and MySQL DBA on Linux Servers (Redhat, Centos, Ubuntu and Debian) and Scripting in Python and Bash. Work with multiple Cloud services which includes Amazon AWS, Digital Ocean & google Cloud
Cloud (Amazon AWS and Tata Insta Compute)
1. Managing the infrastructure of application and Database on Cloud
2. VPC environment setup
3. Auto-scaling of Instances
4. Manage Security groups for different server along with ELB settings.
5. Writing scripts using AWS CLI and SDK ( Python) to manage automate snapshot backups.
6. Cost Allocation tagging setup and evaluate the costs of AWS resources project wise.
7. Database Disaster Recovery Automation with Two Aws Account
8. Saat and Dast application testing.
MySQL
1. Upgrading and Patching on different versions.
2. Master-Slave, Master-Master Replication setups.
3. Query Optimisation
4. Performance Tuning (SQL Tuning , Indexing ,Partitioning)
5. Establish and maintain sound backup and recovery policies and procedures.
6. Implement and maintain database security (create and maintain users and roles, assign privileges)
7. Work as part of a team and provide 7×24 supports when required.
8. Do general technical trouble shooting and give consultation to development teams.
9. Database tuning and performance monitoring. ```