Sep 2023 – Present · 2 yrs 8 mos

• Server Monitoring: Regularly check server performance, including CPU, memory, disk space, and network utilization. Monitor system logs for errors and anomalies.
• Automating the task using shell scripting, python, Ansible.
• Software Updates: Install operating system updates, security patches, and software upgrades as needed.
• Hardware Management: Ensure server hardware is functioning optimally. This may involve hardware repairs, upgrades, or replacements.
• Backup and Recovery: Implement and oversee regular backup schedules for critical data and server configurations. Test and verify backups to ensure data recoverability.
• Database Maintenance: Perform routine database maintenance tasks, such as optimizing queries, updating statistics, and reorganizing indexes.
• Backup and Restore: Schedule and manage database backups and perform periodic restore tests to ensure data integrity.
• Security Management: Implement and enforce database security measures, including user access controls, encryption, and authentication protocols.
• Database Performance Tuning: Monitor database performance metrics, identify bottlenecks, and optimize query performance.
• Security Updates: Stay current with security threats and apply patches and updates to mitigate vulnerabilities.
• Security Auditing: Regularly review server and database logs for security breaches or unauthorized access.
• User Accounts: Create, modify, and delete user accounts as needed. Manage access permissions and roles.
• User Support: Provide technical support to end-users encountering server or database-related issues.
• Incident Response: Respond to server or database incidents promptly. Investigate and resolve issues to minimize downtime.
• Problem Solving: Analyze complex server and database problems and implement solutions.
• Documentation: Maintain up-to-date documentation of server and database configurations, procedures, and policies. This documentation is crucial for knowledge sharing and troubleshooting.

Feb 2022 – Aug 2023 · 1 yr 6 mos

• As part of involvement in the monthly patching activity Place the servers on and out of the maintenance mode as per the requirement within the approved window.
• Take server snapshots of the VMs before any upgrade or change of the server on a particular node. Placing the files for the file servers as per the need.
• Monitor the server's state every day at a particular time.
• Monitor the temperature of the particular data center servers and create tickets for the above threshold limit for the mentioned servers.
• Involve teams in case of a large outage and decide the priority of the incident. Involve the next level team for potential P1 and try to find out the RCA as soon as possible and after resolution of the issue send the resolution information for the affected team.
• Restart the servers as per the daily check process. Start and stop the services of the server as per the given process Runbook.
• Need to make sure the uptime and response time of the client websites using client specific tool (Dynatrace), if any problem is identified for any host location of the website need to fix as per the Runbook if required and needs to involve the next-level team as per the issue.
• Need to make sure all the network connections of the different locations are working fine, if any issue is noticed in SolarWinds, involve the respective team as per the process.
• Performing deployments of the different teams using the client-specific tools within the approved window.
• Emailing the service account owners in case of too many failed logins in the last 24 hours.