SYED FAROOK SYED

Cloud Administration:
● Deploying and managing virtual machines, containers, and other cloud resources.
● Configuring networking, storage, and databases as per requirements.
● Monitoring for security breaches and addressing vulnerabilities.
● Monitoring system performance, identifying bottlenecks, and optimizing cloud resources for cost and performance efficiency.
● Setting up monitoring tools and alerts to ensure system health.
● Establishing backup and recovery strategies to safeguard data and ensure business continuity.
● Testing and validating disaster recovery plans.
● Managing user access and permissions to cloud resources.
● Setting up identity and access management (IAM) policies.
● Developing automation scripts or using configuration management tools for tasks like provisioning, configuration, and orchestration.
● Implementing Infrastructure as Code (IaC) practices.
● Monitoring and controlling cloud costs, optimizing resource usage, and recommending cost-saving strategies.
● Collaborating with teams to understand their requirements and providing technical guidance.
● Maintaining documentation for configurations, processes, and troubleshooting guides.
● Resolving technical issues, performing root cause analysis, and providing support for cloud-related incidents.
● Collaborating with support teams for complex issues.
● Ensuring compliance with industry standards and regulatory requirements.
● Implementing governance policies and best practices.
● Managing upgrades, patches, and maintenance schedules for cloud services and infrastructure.

Database Maintenance:
● Database Backup and Recovery.
● Security of Database System .
● Installation of MSSQL SERVER CLUSTERS.
● Installation of MSSQL Server 2005, 2008 & 2012 server
● Applying service packs and hot fixes.
● Monitoring MSSQL Server for Database space usage.
● Migration of standalone MSSQL Servers and distributors to different hosts
● Creation and maintenance of SSIS Packages.

High availability concepts:
● Building Mirrored databases with Transactional Replication.
● Maintained databases that are mirrored along with replication
● Failover of Mirrored databases that support replication by setting up alias in distributor
● Configuration and Troubleshooting issues in Replication
● Installation of MSSQL Clusters.
● Configuration and troubleshooting of Always on Availability groups.

Performance tuning:
● Setting up basic level of performance tuning with the help of DMV’s.
● Setting up proper index to improve query performance.
● Improving the sql server by performing proper defragmentation of data and update statistics.
● Trouble shooting in blocking issues by setting up proper isolation levels based on locking made by the queries.
● Troubleshooting and fixing deadlock issues.
● Fixing slow running queries using Database tuning advisor.