Team Atmecs

Database Administration SQL Server ATMECS – Content Team Challenges: Limited documentation Competing priorities Limited alert setup for database functions Application dependency on lower functions Solution Approach: SQL Server Provisioning SQL Server Upgrade SQL Server Monitoring to keep alive(24*7) Disk Spaces, CPU and Memory verification Database Backups and Recovery Database refresh from higher to lower environment Database Patching Database User Management Database Indexes Debugging Application related DB issues Achieve SLAs ATMECS Contribution: Implemented a robust monitoring system to monitor SQL Services status and CPU, Memory and Disk level thresholds Placed a PowerShell script to monitor and report all the error events in production error logs Automated the process to perform DB refresh from higher to lower environments Automated the process to rebuild index offline/online on periodic basis Placed scripts to generate various types of application reports Developed jobs for Index Optimization Developed scripts to auto failover the SQL Instances Database Administration – SQL Server

Infrastructure Support – Linux Administration ATMECS – Content Team Challenges: Limited documentation Varied flavors and versions across the enterprise Space issues due to log files Elevated access for developers leading to infrastructure issues Solution Approach: Implementing the RFCs Managing the user global access through Third party AD environment Solarwinds, Linux Configuration Veritas Volume Manager Administration Server Patching and year end reboots Managing Servers through VMWare VSphere Environment ATMECS Contribution: Implementation of log rotation on multiple servers to save Disk space and which in turn helped in reducing Incident Volumes Automated Daily routine tasks to reduce 40% of the tickets Automated JBoss services Implementing ELK-stack infra in the client environment for Centralized log and Log analysis Infrastructure Support – Linux Administration

Infrastructure Support – MQ Administration ATMECS – Content Team Challenges: Limited documentation Limited alert setup for MQ issues Complicated setup for DB replication Solution Approach: Monitoring queues, channels and queue manager statistics using MQ explorer, IR360 and manually Providing the levels of access to users/applications for MQ objects such as queues, channels and Queue managers etc Creating the MQ point to point setup Creating client server architecture by creating server connection channels, client connection channels and tables ATMECS Contribution: Created alerts in all environments in case of any MQ queue manager goes down. Setup a completely new MQ queue Capture/Replication architecture on Production DB servers. Setup queue depth alerts based on thresholds Setup re-processing of dead letter queue messages by using dead letter handler Infrastructure Support – MQ Administration

Infrastructure Support – Network Administration ATMECS – Content Team Challenges: Limited or no documentation Certificate monitoring issues Complicated and manual workload for normal tasks Limited monitoring capability Solution Approach: Solarwinds, Smokeping and MRTG Monitoring NAT and Access Policy changes on Firewall Creating IPSEC tunnel on routers between Data Center and AWS VPC Creating and Managing BGP between Office and Data Center Installation of new hardware and RMA processing iOS upgrade on all Routers to the stable version based on security recommendations ATMECS Contribution: Migrated a dozen offices and three data centers firewall platforms to Palo Alto from legacy Cisco/Juniper devices, including full Palo Alto next-gen security suite implementation, all managed from Panorama Securely connected multiple AWS and Azure cloud environments into multiple data centers Implemented and configured a third party tool “OXIDISED” to take regular configuration backups from all the network devices Deployed multiple Juniper Virtual Chassis, Virtual Chassis Fabric and Qfabric data center LAN deployments Infrastructure Support – Network Administration

Infrastructure Support – Office365 Administration ATMECS – Content Team Challenges: Limited documentation Phased migration from on-prem to hybrid and then to cloud Mailbox sizes during migration to cloud 3rd party add-on integration failures during migration Solution Approach: Managing mailbox databases to accumulate storage by moving mailboxes when required Installing update rollups and security updates for CAS, HUB, UM and mailbox servers Rebooting Exchange servers to ensure equal system resource allocation for all the databases Monitoring and verifying replication health and status for the mailbox servers in DAG using exchange management shell Configured accepted domains, send connectors for the hybrid mail flow Configured directory sync in staging mode Planning mailbox migrations in phases considering various departments Performing mailbox moves to office 365 and completing the move requests as scheduled Configuring transport rules on office 365 to improve the tenant Microsoft Score Manage recipients, Groups, resource mailboxes, shared mailboxes and active sync devices Setup conditional access for Office 365 apps and Intune policies to manage ActiveSync devices Enable auto expand archive quotas, archive mailboxes and Set up retention tags and retention policies ATMECS Contribution: Suggested and implemented disabling email forwarding option from the office 365 outlook web app options to improve security Outlook settings such as safe senders list, auto download pictures for safe senders using GPO to increase usability Infrastructure Support – Office365 Administration

Infrastructure Support – Sharepoint Administration ATMECS – Content Team Challenges: Limited documentation Multiple versions across applications including out-of-support ones Lack of high availability Lots of custom workflows and customization requirements Solution Approach: Day to day Activities, User Management Scheduled backups Moving Applications to different environments(DEV, QA, UAT & PROD) Implement High availability (Database level) Monitoring Server health Verifying Memory & CPU utilization Configured Remote BLOB Storage (RBS) Identifying Server patches and testing on DEV -Environment Deploying WSPs in all environments(DEV, QA, UAT & PROD) Configuring Search Application and Crawl configurations Identifying Application/Server/search/Crawl issues ATMECS Contribution: Wrote the reusable PowerShell scripts Consultancy on developing multiple custom work-flows Resolved long-standing Enterprise search issues Provided recommendations for Patch installation Completed feasibility study based on moving existing applications to AWS and Azure and provided recommendations Infrastructure Support – Sharepoint Administration

Infrastructure Support – Storage Administration ATMECS – Content Team Challenges: Limited documentation Lots of redundant backups being performed Setting up of appliance on AWS Issues with deduplication ratios due to DB compressed backups NetApp capacity issues due to skewed loads Shared folder issues due to user error Solution Approach: Storage team advised the Customer about the Volume movement feature and implementing to the environment after Customer approval. We will start planning to migrate volumes where more high I/O operations and more Storage Utilization. Storage Team will start migrating the volumes to other nodes after validating space and CPU utilization. During Production volume migration, Volume move will initially migrate the source data to the destination storage and pass it under cutover phase. We start communicating with Customer for the data cutover during Scheduled downtime to the dedicated Storage. ATMECS Contribution: SQL Server database of a particular application was protected by livevault backup solution and it costs 1500$ monthly per TB. To reduce the cost effect, we implemented NetBackup backup protection for these servers. Since these servers are hosted on AWS cloud, we built NetBackup Master server with S3 bucket storage unit on AWS to achieve better performance with minimum cost effect. In future, we are looking to add more clients under this AWS master server, which application server are in AWS platform for better server management. Infrastructure Support Storage Administration

Infrastructure Support – Telecom Administration ATMECS – Content Team Challenges: Limited or no documentation Migration from Avaya to Cisco Integration of the additional departments to the environment Limited monitoring capability Solution Approach: Migration from Avaya telephony system to Cisco MACD (Move, add, change and delete) Troubleshooting of IP phone registration issues, softphone issues & call routing Issues Monitoring call signaling protocols on Voice Gateways like MGCP, SIP Troubleshooting media resource issues in transcoder, MOH, conference bridges, IPT voice quality issues between and within locations Upgrading, adding licenses and troubleshooting all aspects of CUCM along with intimate usage of the tools CUCM offers (RTMT, DNA)Manual CUCM Backup if required. ATMECS Contribution: Integrated the alternate monitoring tool (RTMT) to keep track of VoIP activity including all the UC application Infrastructure Support Telecom Administration

Infrastructure Support – Virtualization ATMECS – Content Team Challenges: Limited documentation Application dependency on lower versions Lack of automation for basic tasks Limited monitoring capability Solution Approach: Creation of new VDI’s, installing Citrix applications and assigning them to users as per the service desk request. Monitoring Citrix internal and external environment using Citrix director and assisting Service Desk and NOC people for basic troubleshooting. Handling issues related to VDI and applications connectivity. Working on Citrix printing issues in various environments. Resolving complex issues in NetScaler, Citrix controller and its components to reach SLA. Reclaiming VDI’s which are not in use and decommissioning them with Service desk approval. Troubleshooting slowness/connectivity issues for the users. Resolving profile corruption issues and giving access to the shared folders/paths. Organizing and maintaining environment with zero downtimes and doing daily health checks on the vcenter about the resources utilizations and taking actions against the alarms and alerts. Deploying and configuring the VM’s with given time lines and putting them on the basis of resources availability. Creating / configuring / mounting and unmounts the data stores if required. Upgrading and patching the hosts with the latest releases before creating the run books for the release notes and effects on the environment. Preparing new host profiles and duplicates for the troubleshooting / resolving and compliance check for the sub tasks, Device Configurations, PCI slots and issues with vmbha’s and nics. Creating of new clusters and placing new hosts into the clusters with the vDS / NFS and iSCSI networks mappings with the provided networks. Validating the hardware and configurations of the hosts before putting them into the clusters and doing the network configurations such as Host Vlan, Mgmt. Network / vMotion / NFS / iSCSI and FC. ATMECS Contribution: Successfully prepared and implemented POC on Xen Desktop 7.15 to upgrade the Citrix Infrastructure. Automated health check and scheduled rebooting. Automated Citrix password expiry notification using PowerShell. Provided and implemented valuable solutions/ideas to improve operational efficiencies of Citrix environment. Resolved, hosted, and shared server hung issues by coordinating with Citrix and Microsoft vendors. Migration of applications from presentation server 4.5 to XenApp 7.6. Documented Citrix Infrastructure with time to time updates. Infrastructure Support Virtualization

Infrastructure Support – Windows Administration ATMECS – Content Team Challenges: Limited documentation Limited capability for security monitoring and logging Heavy reliance on business owners for information on servers Lack of automation for basic tasks Limited monitoring capability Solution Approach: Managing users and servers with their security and group level Managing DNS internal and external for all domains DNS records creation and deletion as per request Creating, managing, and altering GPO Certificate management for DC Patch management Troubleshooting Group policy issues Managing windows platform issues on multiple applications Managing sites and services Managing 1000+ windows servers related to OS, performance, disk related issues DHCP management DHCP scopes, VLANs Managing production incidents for all Windows infrastructure issues Managing LDIF files based on requirement of developers ATMECS Contribution: Automated account expiry notification to group of consultants using PowerShell script and Windows task scheduler Infrastructure Support Windows Administration