Mahmood Nadeem

Experience

• 

  McCreade Software (Asia) Pvt Ltd

  May 1998 - Jun 1999

  System Administrator

  McCreade Software, a wholly owned subsidiary of McCreade Systems LLC, NJ involved in implementing ERP Solutions to their Clients in USA. My role includes maintenance of database, support the developers, upgradation etc.

• 

  Florind Shoes Pvt Ltd

  Aug 1999 - Dec 2005

  Systems Manager

  Florind Shoes is a part of KAR Group. The group has six units currently engaged in activities ranging from Leather processing to producing Finished Leather products. The Group supplies products to clientele like Florsheim, Cole Haan, Nike, Weyco, Hush Puppies and Deichmann.Implementation of Ramco e.Applications comprising of modules (GL, AP, AR, PP, SOM, POM, PPM, Audit, EXIM etc)Implementation of Wireless Network through Radio modemsTroubleshooting problems in Multiserver setup and maintenance of SQL Server and OS Security across domainWork with end users to define, implement, and maintain their reporting requirementsCustomization of the Financial ReportsDatabase Backup, Restore, Performance Tuning etc.Provided technical support to internal developers. Show less

• 

  Firstsource Solutions Ltd

  Sept 2006 - Jul 2008

  Sr. Executive - Technology

  My responsibilities involved in implementing Peoplesoft project.Installation of SQL Server 2005, Configuration of Active-Passive clustering on a two node servers.Installation of PeopleSoft Components in DatabaseInstallation of Application Server and Creation of Multiple nodes for load balancingCreation of domain for Process SchedulerInstallation of Webserver and Configuring Webserver for FailoverIntegration of PeopleSoft System with Firstsource LDAP Server on domain levelManaged the Products and development databases including performance tuning, capacity planning, SQL Server Clustering, database security configuration and database continuity.Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL CodePerformed DBA duties including database backups, restores, performance tuning and capacity analysisCreation of COP and reconfiguring the application to redirect to the new database on Virtual InfrastructureCreation and configuration of Additional domain in Appserver and Webserver for COP instance to point to new COP databaseSMTP configuration in Appserver configuration file to enable mail transmissionTroubleshooting problems pertaining to appserver, webserver, process scheduler and databaseEnvironment : Microsoft SQL Server 2005 Enterprise (64 bit) / Windows Enterprise Server 2003 (64 bit) / IBM Websphere 5.1 / BEA Tuxedo 8.1 / Peopletools 8.48ICICI OneSource LtdSQL Server DBA Show less

• 

  Firstsource

  Sept 2006 - Jul 2008

  SQL DBA

  Worked as SQL DBA cum Peoplesoft DBA

• 

  HCL Comnet Systems and Services Limited

  Jul 2008 - May 2011

  SQL DBA

  SQL DBA

• 

  HCLTech

  Jul 2008 - May 2011

  Sr

  Providing best practices knowledge of customer business processes in relate to SQL Server databasesResponsible for maintaining & monitoring SQL Server System and Databases.Align with proper standard process compliance including ITILParticipate in and contribute to Release activities including spec reviewsResponsible for Installations, Upgradations, Patching of SQL ServerTo resolve and rectify all Production Issues within SLAsMaintain Backup and Recovery Plans for all DatabasesMonitoring Jobs, Error Logs, Server Space, Health of Databases & Servers.Responsible for Troubleshooting Operating System with respect to SQL Server.Implement Rollouts and Changes to Database by following specific Standards and processes.Replication setup, configuration and troubleshooting in Production Servers.Database Mirroring setup, configuration, testing in Production Servers.Troubleshooting of Cluster servers.Knowledge of DTS / SSIS.Supporting various client applications related to database.Managing the tool like Remedy for incidents, change requests etc.Generating reports using Idera SQL Compliance ManagerDatabase Migration tasks based on the compatibility of the applicationCapacity planning for all the critical production serversPerformance monitoring using profiler and Windows Performance monitor Log shipping setup, configuration and testing for the failoverUser access rights, roles management Show less

• 

  ABCO Advisory Services India Pvt. Ltd

  May 2011 - Apr 2013

  DBA

  Providing support for databases related to multiple products in a healthcare domainImplemented High availability solution for disaster recoveryPerformance tuning and optimization of various queries in assistance with the development teammplemented ticketing systemDatabase archival process Installation of Oracle for various testing of the product across different flavour of databasesUser management and access rightsInstallation and configuration of database, associated database tools and performance monitoringUpgradation of database from SQL Server 2005 to SQL Server 2008Estimated Disk storage requirements for database software, database files and administration needsImplemented and managed database clustering, failover as per business requirementDeveloped, tested and implemented a robust database backup and recovery strategy Database recoveries as per requirementParticipated in design, testing and implementing a disaster recovery planInstallation of backup tools in a clustered environmentMonitoring of database activities which includes database status, logs, space utilization, locks and long transactions etc.Suggested application level tuning changes for code, queries and SQL Objects which may not be performing upto the optimum database standardsImplemented Active-Passive ClusterImplemented service account for SQL Server servicesMonitoring of database performance using performance monitor, sql profilerManaged security by defining roles and permission which are controlled through a windows accountConfiguration of backup schedule as per the business requirementSetting up of database maintenance jobs like shrink, index and update statistics jobsIsolating the data and log files in the server to have a better performance Changing the compatibility mode from old to new in SQL 2008Handling of users queries ranging from database connectivity, data loading, data migration, database rename, performance issues etc Show less

• 

  Advisory Board

  May 2011 - Mar 2013

  Database Administrator

  SPOC for all the database related activities

• 

  Trimble Inc.

  Apr 2013 - Jan 2016

  Database Architect

   Planning and implementation of Backup and recovery Strategy, physical backup using hot/cold Monitoring Alert log entries, verify listeners are running Cloning the database using RMAN and user managed backups Installing and maintaining databases Administration of the database including performance monitoring and tuning Taking part in the preparation and execution of technical tests Creating backup copies of data Identifying and escalating immediately any risks to the database service Implementation of HA / DR Deployment of third party tools for proactive monitoring and alerting Provided High Availability using Mirroring, 2-node Active/Passive Clustering Managed the entire database environments (Dev, QA, Beta, Rel, Prod and DR  Troubleshoot databases and custom application issues Show less

• 

  Tata Consultancy Services

  May 2016 - May 2017

  Database Administrator

  My Role includes Design, Implement and test solutions for High availability, failover and Disaster recovery using Alwayson and SAN ReplicationSetup, deploy, administer and monitor multiple SQL Server databases in a high availability production environmentSQL Server ConsolidationBuild Active/Passive ClusterImplement and support for Database backup and recovery solutions

• 

  Medusind Solutions India Pvt. Ltd.

  May 2017 - Apr 2023

  Deputy Manager - Database
• 

  Alpha Data

  Apr 2023 - now

  Database Administrator