• Proficient in SQL Database Administration on production database of highly critical and large application databases.
• Installation, configuration and upgradation of SQL Server 2005/2008/2008R2/2012/2014. Upgradation either using in-place or side-by-side methods.
• Worked on Amazon Web Services ( EC2, ELB, VPC, S3, CloudFront, IAM, RDS, Route 53, CloudWatch, SNS,).
• Setup/Managing VPC, Subnets; make the connection between different zones; Blocking suspicious ip/subnet via ACL.
• Setup/Managing CDN on Amazon CloudFront ( Origin Path: Server / S3) to improve site
• Create/Managing buckets on S3 (CLI) and store db and logs backup, upload images for CDN serve.
• Setup/Managing Databases on Amazon RDS. Monitoring servers through Amazon CloudWatch, SNS.
• Creating/Managing DNS records on Amazon Route 53 and go-daddy panel.
• Creating/Managing AMI/Snapshots/Volumes, Upgrade/downgrade AWS resources (CPU, Memory, EBS)
• Creating AWS Instances and Resources Bills.
• Installing, configuration and managing SQL Server 2000/2005/2008/2008R2/2012/2014 fail-over clustering.
• Installing, upgrading and applying the latest service packs/hot fixes.
• Migration/Moving database/files and servers between different platforms/locations and setting up test, QA and production database environments.
• Migration/Moving Database from on-premises to AWS By Backup-Restore methodology.
• Setting up processes for regular backups and restore methods, and ensuring the processes are followed.