Shaickmohammed Rizwan

Experience

• 

  CSS Corp

  Aug 2007 - Aug 2010

  Role : Sybase DBA Support, RDBMS : ASE 12.x/150.x, OS : HP-Unix/Windows.Activities Performed : - Extending data, log and user segments- Investigating Connectivity errors- Dump and load of databases, Troubleshooting for Database Objects- User administration using stored procedures- Determining cause of slow response time, Interface file Updates- Analyzing and monitoring system performances- Investigating the cause for job failure, Corrective action on the same- Investigating the Common Replication Issues- Escalating replication issues to L2.- Killing of blocked or Hung Processes- Thread Down, Rep Agent Down.- Data server / backup server/ replication server down.- Basic rep server troubleshooting.- Implementing dbccdb across the entire environment.- Running DBCC commands to check Database Consistency.- Preparing checklist consisting of available free space in file system.- Preparing checklist on available free space of Databases using DBArtision-Embarcadero tool. - Developing procedure and process documents.- Generating weekly and monthly operations report with the occurred events and incidents. Show less - Worked in Remote infrastructure management environment.- Responsible to ensure 99 % uptime for the e-commerce website under SLA.- Worked with a team size of 7 to ensure 7x24 supports for mission critical system.- Monitoring and managing around 90+ Servers running in Linux OS with more than 150 e-commerce sites which are configured with various services like Jboss, Apache, cron jobs for a leading e-commerce through monitoring application such Gomez, Alchemy eye, NagiOS. - Performing rolling restart of Jboss instances after SLA based validation.- Responsible to monitor Website availability status through various monitoring tool like Alchemy eye, Gomez and Dotcom.- Responsible for bouncing the jboss instances, when the instance reach the critical state due to high load.- Enabling and disabling ports while performing instance bounce using CITRIX Netscaller Hardware load balancer sharing the load of 150 e-commerce sites.- Necessary to provide value add and proactive maintenance to the client.- Responsible to do the task like thread dump collection, rolling restart and bleeding session for the site maintenance.- Responsible for the deployment of atg e-commerce suite application in case of any customization update on the application. - Responsible to provide support for high availability and load balancing using citric Netscaller. - Responsible to provide root cause analysis to the client according to the issue’s SLA.- Responsible to clone and test the application environment in provided test MI-labs. - Provide documentation for all server changes, installations, and upgrades to ensure accuracy according to the company standards.- Developing procedural Knowledge base on performing resolutionary tasks and auditing it on regular basis.- Performing process and quality audit on the tickets handled by engineers based on SLA and OLA. Show less Job description: * Involved in configuration of wired and wireless routers and adapters. * Thorough understanding of customer requirements & providing solutions on various networking environments. Network planning, implementation & operation of data networks consisting mainly of (SOHO) Routers, switches and other wireless devices. * Involved in handling technical support calls. * Performed product testing for newly launched Linksys draft N and all wired and wireless products * Involved in product testing for Linksys specialty products like video cameras, media adapters, wired and wireless Print servers, Range ex-panders and Gaming adapters. * Involved in designing, setting up and maintenance of technology and products practice lab. * Involved in configuration and troubleshooting of access points, bridges and switches. * Testing the new released products on various performance and stability grounds and formulating a report for a beta release. * Prepare worksheets on various infrastructures that persist in various system environments of customers as part of the knowledge sharing across TAC sites. * Involve in work product enhancement reviews, project monitoring reviews, project performance analysis, etc. Show less

  • Sr. Systems Engineer - Sybase DBA Support for Tommy Hilfiger

    Mar 2009 - Aug 2010

  • Systems Engineer - NOC - ATG an independent Internet technology company specializing in eCommerce

    Apr 2008 - Mar 2010

  • Support Engineer - Linksys a division of Cisco

    Aug 2007 - Mar 2008
• 

  CSS Corp

  Oct 2010 - Aug 2019

  - Handling a team of 13 involved in Data warehouse support for a leading US based telecom giant.- Built training plan and Operation manual through client knowledge transfer.- Maintaining Stake holders register through a authenticated PMO(Lotus Quickr)- Have presented QBR and HBR to clients, projecting the scope activities and its trend.- Prepared skill-set documents targeting clients to increase the scope of operation.- Responsible for scheduling shift and making sure 100% operational coverage. - Building team skill-set as per operational requirements by deploying adhoc training.- Involved in Knowledge transition with new roll-outs from staging. - Developed Casestudies on solutions and interacting with Sales team.- Developing video knowledge base training enhancing KEDB.- Responsible for maintaining Knowledge Base and keeping up-to-date with the latest Operational procedures and processes.- Performing SWOT analysis on half yearly basis.- Building career progression for engineers.- Tracking engineer’s performance through assigned KPI and assigning KRA and calibrating on quarterly basis. Show less Leading a Remote Data warehouse support Operations team : - Monitoring and managing ETL task through Informatica PowerCenter monitor and managing it through Informatica Manager.- Aborting long running sessions, worklets and sessions based on clients OLA.- Getting session logs from P.Centre monitor and escalating to SME's.- Running failed sql queries from session logs through third party SQL tools like Tere data SQL assistant.- Identifying process id of work flow and killing through based on clients OLA.- Recovery of Unix ETL script by removing character width exceeded data or null values from source table as per the design of target table structure and re-running the queries through nzsql.- Using re-usable transformation to client specified destination.- Involved in creation of sessions, worklets and workflows and scheduled in Workflow manager.- Implementing Mapplets on client specified source and targets.- Implementing stored procedure transformation in the existing workflow on client request.- Implementing email task to workflows for notifying success and failure. - Simulated recurring ETL Unix job issues for training purpose.- Monitoring of Netezza performance server. - Checking for long running queries for its status through GUI and CLI - Checking the availability of SPA and SPU - Monitoring Database size threshold Show less

  • Project Manager

    Apr 2019 - Aug 2019

  • Team Manager - Data warehouse operations for eCommerce Analytics Platform

    Apr 2015 - Mar 2019

  • Team Lead - Data warehouse operations for ATT digital experience

    Apr 2012 - Apr 2015

  • Escalation Lead(Operations) - Remote Data warehouse support Operations for ATT digital experience

    Oct 2010 - Mar 2012
• 

  AT&T

  Aug 2019 - now

  • Sr. Technical Specialist

    Jul 2022 - now

  • Technical Specialist

    Aug 2019 - Jul 2022